AnsweredAssumed Answered

Is this a bug? GCS NAD 83 in SQL Geography Fails....10.2.2: New feature?

Question asked by tpcolson on Oct 13, 2014
Latest reply on Oct 13, 2014 by tpcolson

I'm getting invalid LAT ranges when using ANY data in Arc SDE, Geography Data Type. Perhaps this is ignorance? To reproduce:

 

  1. Create, in Arc SDE 10.2.2, any SQL version, a polygon feature class with GCS NAD 83 as the coordinate system, Geography as the spatial/storage type.
  2. Load ESRI US States Shapefile into the Feature Class using the Arc Catalog "Load" tool;
  3. Observe how the States can be previewed in the Arc Catalog preview dialogue;
  4. In SSMS, query the table and select "Spatial Results". Note how SSMS shows the US States;
    1. If there was invalid geography, SSMS WOULD NOT show the states!
    2. states.PNG
  5. Add the same data to Arc Map;
    1. states2.PNG
  6. I've tried every sql geography validator there is, and this data passes.  There are no latitude values that fall between -90 and 90. Nor are there null latitude values in these data.
  7. Tried on numerous computers with SQL native client 10 or 11, same error;
  8. Same error on SQL 2008 R2 or 2012 SP2
  9. It seems like ArcMap is pivoting the lat/lon translation? How is this possible?

 

 

Either this is a new "feature" of 10.2.2 or I celebrated Columbus Day way to hard and I'm missing something obnoxiously obvious.

Outcomes