This content has been marked as final.
Show 5 replies

1. Re: CONVERTING X,Y TO LATITUDE,LONGITUDE VICE VERSA
damorgan Jan 31, 2010 7:42 AM (in response to X7C7)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
Rajesh Chamarthi Jan 31, 2010 6:16 PM (in response to X7C7)That would depend on what coordinate 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
X7C7 Feb 1, 2010 2:58 AM (in response to Rajesh Chamarthi)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
BluShadow Feb 1, 2010 3:10 AM (in response to X7C7)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
BluShadow Feb 1, 2010 3:13 AM (in response to X7C7)Perhaps one place that could help you is the Ordnance Survey site...
http://www.ordnancesurvey.co.uk/oswebsite/gps/information/coordinatesystemsinfo/guidecontents/index.html