Microsoft Azure SQL Database Feature Representation

Features are written to the database table with the same name as their feature type, and include geometry and attributes.

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.