Frequently asked question
Why can't a feature class be created using the SQL Server geography spatial type with a projected coordinate system?
Answer
The Microsoft SQL Server geography spatial type is a geodetic type that uses latitude/longitude measurements; it does not support projected coordinate systems.Therefore, when creating a feature class using the SQL Server geography spatial type and a projected coordinate system, an error message similar to one of the following will be returned:
• "Failed to create feature class. The given coordinate references are incompatible."
• "Failed to create feature class. The dataset is not supported at the workspace level."
• "Failed to create feature class. The dataset is not supported at the workspace level."
To successfully create the feature class, chose one of the options below:
• Use a supported geographic coordinate system, such as WGS84.
• Use SQL Server geometry or SDEBINARY storage and choose a projected coordinate system.
• Use SQL Server geometry or SDEBINARY storage and choose a projected coordinate system.
Note:
Data stored in the SQL Server geography type must use one of the spatial reference systems defined in SQL Server. To see a list of supported spatial reference systems, query the SQL Server sys.spatial_reference_systems catalog view.
Article ID:000011051
Software:
- Legacy Products
- ArcMap
Get help from ArcGIS experts
Download the Esri Support App
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback