Converting Geometry(spatial) To Longitude And Latitude

I've uploaded .SHP files to my table in sql and I got geometry column with data. I can see points on 'Spatial results' tab in sql server and that's all fine. When I run this line

Solution 1:

I have developed a library in .NET to be called from transact sql Converts WGS84/UTM coordinates to Latitude and Longitude

You can download it from github:

https://github.com/j-v-garcia/UTM2LATITUDE

usage:

SELECT dbo.UTM2LATITUDE(723399.51,4373328.5,'S',30) AS Latitude, dbo.UTM2LONGITUDE(723399.51,4373328.5,'S',30) AS Longitude

result:

39,4805657453054    -0,402592727245112

<paramname="XUTM">pos UTM X</param><paramname="YUTM">pos UTM Y</param><paramname="LatBand">Latitude band grid zone designation letter (see http://www.dmap.co.uk/utmworld.htm) </param><paramname="LongBand">Longitude band grid zone designation number (see http://www.dmap.co.uk/utmworld.htm) </param>