Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

conversion srid problem

584071Jun 20 2007 — edited Jun 20 2007
Hello,
j have a problem when j try to convert from one srid to another. For example:

j know that the coordinate points of Monte Mario are:
RM40 41° 55’25.51” 12° 27’ 08.04”
ED50 41° 55’31.49” 12° 27’ 10.93”
WGS84 41° 55’27.8” 12° 27’ 07.6”

For Oracle the correct data are:
RM40 41,92375 12,45233
ED50 41,92541 12,45303
WGS84 41,92440 12,45212

Now i try to convert all this geographic srid into the ED50 / UTM 32N projected srid. The result in not what j expect (the same coordinates of the same point or whit little geographic error) but:

RM40 -> UTM32N 4270436.82871 1631238.16858
ED50 -> UTM32N 4270522.570315 1631167.67683
WGS84 -> UTM32N 4270406.637724 1631187.33323

J use this sql for the result from oracle:
SELECT SDO_CS.TRANSFORM(
SDO_GEOMETRY(2001,8291,SDO_POINT_TYPE(41.92375,12.45233,NULL),NULL,NULL),
23032)
FROM dual;

SELECT SDO_CS.TRANSFORM(
SDO_GEOMETRY(2001,4230,SDO_POINT_TYPE(41.92541,12.45303,NULL),NULL,NULL),
23032)
FROM dual;

SELECT SDO_CS.TRANSFORM(
SDO_GEOMETRY(2001,4326,SDO_POINT_TYPE(41.92440,12.45212,NULL),NULL,NULL),
23032)
FROM dual;

are there any problem whit the conversion algorithm??

thank you for your response...

Marco
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2007
Added on Jun 20 2007
4 comments
1,012 views