The generated geometry from SDO_BUFFER does not validate (Doc ID 1444542.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms


The generated geometry from SDO_BUFFER does not validate, generating error:

SELECT sdo_geom.validate_geometry_with_context (
SDO_GEOM.SDO_BUFFER (GEOMETRIA,0.01, 1E-9), 1E-9)
from POLA_ZAGOSPODAROWANIA;

SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(SDO_GEOM.SDO_BUFFER(GEOMETRIA,0.01,1E-9)
--------------------------------------------------------------------------------
13349 [Element <1>] [Ring <1>][Edge <9>][Edge <10>]


ORA-13349: polygon boundary crosses itself
Cause: The boundary of a polygon intersects itself.
Action: Correct the geometric definition of the object.

Metadata used:

SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180, 180, .000000001), SDO_DIM_ELEMENT('X',-90, 90, .000000001))

The original geometry validates fine. The error is with the SDO_BUFFER output geometry

Cause

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