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!