2011

■ The following geometry types:
■ Polygons: polygon, multi-polygon, curve polygon, multi-curve polygon,
circular arc segment
■ Points: point, multi-point
■ Rings: ring, linear ring
■ Line strings: line string, line string segment, multi-line string, curve
string, multi-curve string
■ Multi-geometry
Restrictions of SQL Server Schemas
When you create a SQL Server schema, the following restrictions apply:
■ A
feature class (page 2063) must define or inherit at least one identity property
(page 2071).
■ Identity properties cannot be nullable.
■ Read-only identity properties must be auto-generated.
■ A feature class can have multiple geometric properties. Although it is not
mandatory, having a main geometry as an attribute of the feature class
can help you to identify which geometry property to use as the default for
queries and rendering. Both HasMeasure and HasElevation are supported.
■ The maximum length of a string is 8000 characters.
■ For decimal properties, the precision must be between 1 and 38, inclusive,
and the scale must be between 0 and 38, inclusive.
See also:
■
Overview of Geospatial Data (page 551)
■ Setting Up Database Users (page 584)
■ Creating a Data Store (page 586)
■ Bringing In Features from SQL Server (page 323)
■ Styling Features (page 639)
■ Creating a Join (page 509)
560 | Chapter 4 Managing Data