Microsoft SQL Server Spatial Quick Facts
Format Type Identifier |
MSSQL_SPATIAL |
Reader/Writer |
Both |
Dependencies |
|
Dataset Type |
Database |
Feature Type |
Table name |
Typical File Extensions |
Not applicable |
Automated Translation Support |
Yes |
User-Defined Attributes |
Yes |
Coordinate System Support |
Yes |
Generic Color Support |
No |
Spatial Index |
Yes |
Schema Required |
Yes |
Transaction Support |
Yes |
Encoding Support |
Yes |
Geometry Type |
mssql_spatial_type |
Microsoft SQL Server Spatial Geometry Support
Geometry | Supported? |
aggregate | yes |
circles | no |
circular arc | yes |
donut polygon | yes |
elliptical arc | no |
ellipses | no |
line |
yes |
none | yes |
point | yes |
polygon |
yes |
raster | no |
solid | no |
surface | no |
text | no |
z values | Reader: yes Writer: yes (except for SQL Server 2008 non-bulk mode) |