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.