My Oracle Support Banner

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

Last updated on NOVEMBER 27, 2019

Applies to:

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


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

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)
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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.