ORA-13356 Geometry From Sdo_geom.Sdo_concavehull Results Invalid (Doc ID 1441306.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 10.2.0.2 to 11.2.0.3 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

Geometry from SDO_GEOM.SDO_CONCAVEHULL results invalid


insert into result_concave_hull
select 'NOK', sdo_geom.sdo_concavehull(geom_multipoint, 0.05)
from sr_concave_hull where status='OK';

commit;

spool val.txt
DROP TABLE val_results;
CREATE TABLE val_results (sdo_rowid ROWID, result varchar2(1000));
CALL SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT('RESULT_CONCAVE_HULL','GEOMETRY','VAL_RESULTS');
col result format a40
SELECT * from val_results;
spool of

SDO_ROWID RESULT
------------------ ----------------------------------------
Rows Processed <2>
AAASkjAAEAAAAPfAAB 13356 [Element <1>] [Coordinate <169>][R
ing <1>]

13356, 00000, "adjacent points in a geometry are redundant"
// *Cause: There are repeated points in the sequence of coordinates.
// *Action: Remove the redundant point.

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