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.