How to find latitude and longitude for large self crossing polygons

(Doc ID 2115095.1)

Last updated on OCTOBER 31, 2016

Applies to:

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

Goal

When validating polygons with SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT function, the result comes with edges and rings.
How are these results translated into latitude and longitude instead?

Sample output:

select * from
(Select rowid SDO_ROWID,
SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(face,sdo_dim_array(sdo_dim_element('x',-180,180,.05),sdo_dim_element('y',-90,90,.05))) result
FROM sdo_face ) s
where result <> 'TRUE';

13349 [Element ] [Ring ][Edge ][Edge ]
13349 [Element ] [Ring ][Edge ][Edge ]
13349 [Element ] [Ring ][Edge ][Edge ]
13366 [Element ] [Ring ]
13349 [Element ] [Ring ][Edge ][Edge ]
13349 [Element ] [Ring ][Edge ][Edge ]
13349 [Element ] [Ring ][Edge ][Edge ]
 

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