How to find latitude and longitude for large self crossing polygons (Doc ID 2115095.1)

Last updated on APRIL 12, 2022

Applies to:

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

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