Microsoft SQL Server Feature Representation
Features are written to the database table with the same name as their feature type, and include geometry as well as attributes as defined on the feature type.
| Geometry Type | Description |
|---|---|
| mssql_spatial_none | no geometry |
| mssql_spatial_point | point |
| mssql_spatial_multipoint | collection of points |
| mssql_spatial_linestring | straight line |
| mssql_spatial_multilinestring | collection of straight lines |
| mssql_spatial_circularstring | path consisting of one or more circular arcs |
| mssql_spatial_compoundcurve | path consisting of straight lines and/or circular arcs |
| mssql_spatial_polygon | polygon bounded by straight lines |
| mssql_spatial_multipolygon | collection of polygons bounded by straight lines |
| mssql_spatial_curvepolygon | polygon bounded by a combination of straight lines and/or circular arcs |
| mssql_spatial_geometrycollection | collection of geometries, each of which can be any supported type, including other geometry collections |
Geometries may be 2D (X/Y), 3D (X/Y/Z), 2D + measures (X/Y/M), or 3D + measures (X/Y/Z/M).
Coordsys Traits
If there are multiple spatial columns, they will be read as a Multiple Geometry with named parts, with a Coordsys trait set on each part. The Coordsys traits on the named parts of the first feature will be used to choose SRIDs when a writer is creating a table with multiple spatial columns.