Microsoft SQL Server and Azure SQL Database Spatial (JDBC) Quick Facts
Format Type Identifier |
MSSQL_JDBC_SPATIAL MSSQL_JDBC_AZURE_SPATIAL |
Reader/Writer |
MSSQL_JDBC_SPATIAL: Both MSSQL_JDBC_AZURE_SPATIAL: Reader |
Licensing Level |
Professional and above |
Dependencies | None |
Dataset Type |
Database name |
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_type |
Microsoft SQL Server and Azure SQL Database Spatial (JDBC) Geometry Support
Geometry |
Supported? |
aggregate |
no |
circles |
no |
circular arc |
no |
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 |
yes |