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

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. 

Thanks 

---

Thank you... MOMEN

Answer 1

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,
Cathy 

---

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 [e-mail]

Answer 2

And how does your source data look like?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 3

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

Answer 4

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