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!

Transformation problem from srid 4326 to 2056

549796Dec 6 2006 — edited Feb 22 2007

Hi all,

Using Oracle 10.2.0.1.0

I have tried to transform a point from WGS 84 to the Swiss coordinate system srid 2056 " CH1903+ / LV95"

-- From sid 4326 WGS84 to 2056 CH1903+ / LV95
-- Test point Lon +8,51902 Lat +47,38765 [dec deg]
SELECT p.geo.sdo_srid,p.geo.sdo_point.x,p.geo.sdo_point.y
FROM
(select mdsys.sdo_cs.transform(
MDSYS.SDO_GEOMETRY(2001,4326,MDSYS.SDO_POINT_TYPE(8.51902, 47.38765,NULL), NULL,NULL),
2056)
as geo from dual) p;

Result:

GEO.SDO_SRID GEO.SDO_POINT.X GEO.SDO_POINT.Y
------------ --------------- ---------------
2056 ~ ~

Expected coordinates +2681575,20 +1249097,30 [m] (calculated with 3rd party software Transdat)

The reverse transformation returns no result either.

Is this transformation not supported/implemented or what does the output mean?

Best regards
Magnus

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2007

Added on Dec 6 2006

#database-key-features, #spatial

23 comments

2,437 views