AnsweredAssumed Answered

Return Lat Long from SQL Spatial Geometry Type Query

Question asked by amgreiner on Feb 26, 2015
Latest reply on Feb 27, 2015 by amgreiner

I'm trying to use a SQL query to get the Lat Long of points in a point layer in our geodatabase.  The  STAsText method will return the XY as shown below, but I'd like to get the lat long instead.  Is there a method that can do this or is there a conversion I could use in SQL to convert the XY from STAsText?

 

Here is the query to get the XY:

select SHAPE, [SHAPE].STAsText() XY

from featureclass

 

Any help would be greatly appreciated. Thanks!

Outcomes