How to convert a 3D (SRID 4327) Geometry to 2D (SRID 8307) ?
269171May 25 2010 — edited May 26 2010Hi All,
The following query :
SELECT SDO_CS.TRANSFORM(
SDO_GEOMETRY(3003, 4327, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1),
SDO_ORDINATE_ARRAY(13.3465731, 52.5307672, 0, 13.3465913, 52.5307209, 0,
13.3465913, 52.5307209, 36.72, 13.3465731, 52.5307672, 36.72, 13.3465731, 52.5307672, 0)),
8307
)
FROM DUAL;
fails wit hthis error message:
ORA-13199: Dimensionalities of source and target differ.
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_CS", line 2847
What is the best strategy to do this conversion ?
As far as I can see the SDO_CS.MAKE_2D function just changes the Dimensionality and the SRID.
Thanks,
Ronan