Sdo_Util.Rectify_Geometry and 3D Geometries (Doc ID 1968837.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

 sdo_util.rectify_geometry is not performing properly for the geometry in the test case below.


select
sdo_util.rectify_geometry (MDSYS.SDO_GEOMETRY(3003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(-75.892723,37.153786,0,-75.892563,37.153763,0,-75.892456,37.153687,0,-75.892395,37.153606,0,-75.892372,37.153339,0,-75.892372,37.153019,0,-75.892418,37.152695,0,-75.89254,37.152527,0,-75.892654,37.152481,0,-75.892784,37.1525,0,-75.892921,37.152603,0,-75.892967,37.152878,0,75.892967,37.153172,0,-75.892883,37.153584,0,-75.892723,37.153786,0)),.05)
geom
from dual

The 13th pair of ordinates in the returned geometry for the rectified geometry is 75.892967,37.153172,0 when it should be -75.892967,37.153172,0

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms