Skip to Content
0

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

May 03 at 06:09 AM

23

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bret Halford
May 07 at 08:01 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded