|
Format Type Identifier |
MSSQL_SPATIAL MSSQL_AZURE_SPATIAL |
|
Reader/Writer |
Both |
|
Licensing Level |
Reading: Professional Writing: Database Edition |
|
Dependencies |
SQL Native Client 2008 or 2012. For Bulk Insert mode; .NET Framework v4; Microsoft System CLR Types for SQL Server 2012 (installed with FME in most cases) |
|
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 |
| Geometry Support | ||||
| Geometry | Supported? |
|
Geometry | Supported? |
| aggregate | yes |
|
point | yes |
| circles | no |
|
polygon |
yes |
| circular arc | yes |
|
raster | no |
| donut polygon | yes |
|
solid | no |
| elliptical arc | no |
|
surface | no |
| ellipses | no |
|
text | no |
| line |
yes |
|
z values | Reader: yes Writer: yes (except for SQL Server 2008 non-bulk mode) |
| none | yes |
|
||