Home » Server Options » Spatial » Coordinate (X,Y) from RT90 to SWERF99 or WGS84 system. (Oracle 10g)
Coordinate (X,Y) from RT90 to SWERF99 or WGS84 system. [message #647722] Sat, 06 February 2016 05:56 Go to next message
s4.ora
Messages: 63
Registered: March 2010
Member
Hi All,

I am looking for some Oracle utility / function that can be used to convert a Coordinate (X,Y) from RT90 to corresponding SWERF99 or WGS84 system.

There are plenty of Java functions for this, but we specifically require Oracle based functions / utilities for this.

If anyone is aware of the same, kindly share the same with me.

Thank you
Re: Coordinate (X,Y) from RT90 to SWERF99 or WGS84 system. [message #647751 is a reply to message #647722] Sat, 06 February 2016 21:53 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8751
Registered: November 2002
Location: California, USA
Senior Member
I believe you can do this using Oracle's SDO_CS.TRANSFORM function. Please click on the link below for a section of the online documentation that has syntax, explanation, references, and examples.

http://docs.oracle.com/database/121/SPATL/sdo_cs_ref.htm#SPATL1075
Re: Coordinate (X,Y) from RT90 to SWERF99 or WGS84 system. [message #647788 is a reply to message #647722] Mon, 08 February 2016 02:03 Go to previous message
_jum
Messages: 522
Registered: February 2008
Senior Member
@Barbara is right.

This query transforms the center coordinates of Sweden from RT90 (3021) to WGS84 (4326).
--https://epsg.io/3021

SELECT 
 sdo_cs.transform(
   sdo_geometry(2001, 3021, sdo_point_type(1567816.58, 6878649.00,0), NULL, NULL), 
   4326) trc
  FROM dual;


TRC                                               
--------------------------------------------------
(2001,4326,(17.1034248136736,62.016329035878,0),,)                                           
                                                                                
1 row selected.

Previous Topic: ORA-22804
Next Topic: Import Shape in Oracle Locator
Goto Forum:
  


Current Time: Thu Nov 23 10:57:09 CST 2017

Total time taken to generate the page: 0.01916 seconds