topic Re: Coordinate Sys vs spatial Data Type in Data Management Questions

Coordinate Sys vs spatial Data Type

HaniuHokkaido — Fri, 12 Sep 2014 09:04:37 GMT

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

Re: Coordinate Sys vs spatial Data Type

George_Thompson — Fri, 12 Sep 2014 11:47:21 GMT

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

Re: Coordinate Sys vs spatial Data Type

HaniuHokkaido — Tue, 16 Sep 2014 01:16:56 GMT

Allright George.. thanks.