Skip to Content

Convert X and Y cordinates to Lat and Long in Postgre Sql

I have one table where we have X and Y co-ordinates , we need to convert those X and Y co-ordinates to Latitude and Longitude.

In Postgre sql or SAP BO webi report.

Is there any way for this

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 07 at 08:01 PM

    I think we need more details.
    What are the x and y coordinates representing?
    Are you thinking of a flat map of a globe that has latitude and longitude lines drawn on it,
    and trying to determine the latitude and longitude values from x / y coordinates from the bottom left
    corner of the map? It will depend on the type of projection the map was drawn on and the scale....

    http://3.bp.blogspot.com/-CVvpw0zAGgE/T7XWsW6mUKI/AAAAAAAAAC4/7HkFi7adSfg/s1600/Map%2BProjections.jpg

    Some examples would be helpful.

    Add comment
    10|10000 characters needed characters exceeded