5 Replies Latest reply on Feb 1, 2010 9:13 AM by BluShadow

# CONVERTING X,Y TO LATITUDE,LONGITUDE VICE VERSA

hi,

i need formula for converting x,y coordinates to latitude ,longitude and vice versa,

CAN ANYBODY HELP ME IN THIS?
• ###### 1. Re: CONVERTING X,Y TO LATITUDE,LONGITUDE VICE VERSA
No. Because we have no idea what X and Y are nor your Oracle version number.

For all we know X is measured in meters and Y in radians.
• ###### 2. Re: converting x,y to latitude,longitude vice versa
That would depend on what co-ordinate system you use for (x,y). Without knowing that, it would be impossible to come up with the conversion.

http://en.wikipedia.org/wiki/Coordinates_(mathematics)

http://en.wikipedia.org/wiki/List_of_canonical_coordinate_transformations

Please also refrain from using all Caps in your post/subject line.
• ###### 3. Re: converting x,y to latitude,longitude vice versa
hi i need to convert x,y coordinates (WGS84 cooridnate system) into Latitude and Longitude and vice versa

i have download one tool from net, it is giving the following Result

X=675555.07(EASTING) IN METERS
Y=2729694.91(NORTHING) IN METERS

Longitude=40.7349667 in Decimal
Latitude=24.6715992 in Decimal

I NEED FORMULA for converting in ORACLE 10g.
• ###### 4. Re: converting x,y to latitude,longitude vice versa
There is no standard formula for such conversions, as converting from one coordinate system to another is often a complex mathematical formula. What you need to do is track down (via the internet) the mathematical formula you require for your conversion and then apply that formula as SQL or PL/SQL code. You can pretty much do any mathematics in Oracle code, but firstly you need to know the maths required (and so would we if you expect us to help you).
• ###### 5. Re: CONVERTING X,Y TO LATITUDE,LONGITUDE VICE VERSA
Perhaps one place that could help you is the Ordnance Survey site...

http://www.ordnancesurvey.co.uk/oswebsite/gps/information/coordinatesystemsinfo/guidecontents/index.html