OraFAQ Forum: Spatial » Coordinate (X,Y) from RT90 to SWERF99 or WGS84 system.

Home » Server Options » Spatial » Coordinate (X,Y) from RT90 to SWERF99 or WGS84 system. (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Coordinate (X,Y) from RT90 to SWERF99 or WGS84 system. [message #647722]

Sat, 06 February 2016 05:56

s4.ora
Messages: 71
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

Report message to a moderator

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

Barbara Boehmer
Messages: 9101
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

Report message to a moderator

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

_jum
Messages: 577
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 20:11:45 CST 2024