|
Format Type Identifier |
MSSQL_SPATIAL MSSQL_AZURE_SPATIAL |
|
Reader/Writer |
Both |
|
Licensing Level |
Reading: Professional Writing: Database Edition |
|
Dependencies |
Microsoft SQL Server 2012 (or 2008) Native Client. Microsoft System CLR Types for SQL Server 2012 (installed with FME except in silent installs). Microsoft .NET Framework v4.5.2. |
|
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 and Azure SQL Database 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) |