Microsoft SQL Server Spatial Quick Facts

About Quick Facts Tables

Format Type Identifier

MSSQL_SPATIAL

Reader/Writer

Both

Dependencies

See Product and System Requirements.

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)