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!

ARC geometries give error in CDO_CS.TRANSFORM

_jumSep 21 2015 — edited Sep 22 2015

Seems that SDO_CS has problems in transforming ARC geometries:

--LINE geometrie works fine

SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(geom,0.01) val

       ,SDO_CS.TRANSFORM(geom,4326) trafo

FROM

(SELECT sdo_geometry

(2002, 25832, NULL,

   sdo_elem_info_array (1,2,1),

   sdo_ordinate_array(

   500014,5650010,

   500010,5650014,

   500006,5650010)

   ) geom

FROM dual);

TRUE

MDSYS.SDO_GEOMETRY(2002,4326,NULL,

  MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1),

  MDSYS.SDO_ORDINATE_ARRAY(

    9.0001995237432,51.0016646160954,

    9.00014251706963,51.0017005861695,

    9.00008551017565,51.0016646162345))

--ARC geometrie gives ERROR

SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(geom,0.01) val

       ,SDO_CS.TRANSFORM(geom,4326) trafo

FROM

(SELECT sdo_geometry

(2002, 25832, NULL,

   sdo_elem_info_array (1,2,2),

   sdo_ordinate_array(

   500014,5650010,

   500010,5650014,

   500006,5650010)

   ) geom

FROM dual);

ORA-13285

Geometry coordinate transformation error

Cause: A coordinate pair was out of valid range for a conversion/projection.

Action: Check that data to be transformed is consistent with the desired conversion/projection.

The range of coordinates are valid IMO. This bug (?) exists in ORACLE 11.2.0.3  and 12.1.0.1.

This post has been answered by _jum on Sep 22 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2015
Added on Sep 21 2015
3 comments
991 views