Coordinate Sys vs spatial Data Type

[HaniuHokkaido]

Dear experds,

What is the relation between Coordinate System and spatial Data Type ?

I creates some FCs :

1. Coordinate System : Projected, Config Keyword : Geography. Result: Failed. SQL Native Client 11.0: The multi-part identifier "SHAPE.STSrid" could not be bound"

2. Coordinate : Projected, Keyword : Geometry. Result ; Success

3. Coordinate : Geography, Keyword : Geography. Result ; Success

4. Coordinate : Geography, Keyword : Geometry. Result ; Success

What factor are causing the error ? Which spatial data type should I choose for Projected and Geography coordinate system ?

[SQL Server 2012. Arcgis 10.1]

thanks

[George_Thompson · Accepted solution]

Hi Haniu,

For each of the spatial data type there may be an appropriate coordinate systems to use. Here is a link to the information ArcGIS and Microsoft Spatial types

Usually using the Geometry option is suggested for projected data.

For the Geography option:

From the help -

"You might use the geography storage type with ArcGIS if

• The coordinate system you want to use is defined in the SQL Server data dictionary.
• You don't need to store z- or m-values for features.
• Your data covers large spatial extents and you need to use SQL area and length calculations.The SQL area and length calculations that use Great Elliptic line interpolation can be noticeably different that planar line interpolation over large spatial extents.
• You need to use Great Elliptic line interpolation for SQL spatial queries."

Hopefully this helps.

-George

[HaniuHokkaido]

Allright George.. thanks.