conversion srid problem
584071Jun 20 2007 — edited Jun 20 2007Hello,
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