AnsweredAssumed Answered

Differences in coords for point between REST and SQL Server

Question asked by endlessdsire on Oct 8, 2018
Latest reply on Oct 10, 2018 by JSnyder-esristaff

Hello everybody,

 

I am having some issue when i try to get the X, Y from a SHAPE saved in a sql server database.

For example, in the rest service, in a layer of points i have the following data saved for a point:

 

REST SERVICE:

# records: 1

 

OBJECTID: 41602
Point:
X: -7932483.373700001 
Y: -3897037.876665604 

 

If i try to get the same point (oid 41602) from a SQL Database using this sentence:

SELECT SHAPE.STY AS LAT, SHAPE.STX AS LON FROM MYTABLE
WHERE OBJECTID = 41602

 

I got this result

 

How u can see, the X coord is the same, but the Y coor is not.

Why am i getting this difference? How can i fix it to get the same as the REST service but in my sql server?

 

Thanks in advice!

 

 

 

Outcomes