Need to Convert Geometry (Easting/ Northing / Height) to Long / Lat RRS feed

  • Question

  • Hi,

    I have a requirement to convert the Geometry (Easting/ Northing / Height) to Long / Lat using a SQL Server Function. Can this be achieved ? 

    Any help would be really appreciated. 


    Thank you... MOMEN

    Sunday, October 20, 2019 6:26 AM


All replies

  • Hi Momen Azmath,

    Please check whether below links could help you.

    Converting a geometry polygon (eastings/northings) to geography polygon (lat/long)

    Can Lat/Long be stored in SqlGeometry for conversion to SqlGeography????

    Hope this could help you.

    Best regards,

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by Momen Azmath Thursday, October 24, 2019 11:05 AM
    Monday, October 21, 2019 2:23 AM
  • And how does your source data look like?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, October 21, 2019 7:56 AM
  • Thanks Much Cathy.

    This gave me a lot of information which I was needing. But having issue while converting the LineString. Works fine for both Polygon and Point. Any thoughts would be helpful.  

    Thank you... MOMEN

    Tuesday, October 22, 2019 4:39 AM
  • Hi Olaf,

    My Data is in Easting, Norting, Height in a Table and I also have a Geometry Converted column also in it. 

    Thank you... MOMEN

    Tuesday, October 22, 2019 4:42 AM