AnsweredAssumed Answered

Get self-intersecting features from oracle spatial

Question asked by modybsystematics-co-il-esridist Employee on Jan 19, 2015



We have a polygon table in Oracle spatial (SDO). Some of the features are not drawn and we get the message that they self-intersect.

When we use SDE_GEOM.validate_geometry(shape,0.2)='TRUE' we get a list of all the invalid geometries.

We would like to see these invalid geometries after all.

Is there any way to do it?

Is there a command in Oracle that will fix them?

Is it possible to export it to shape file where self-intersecting is fine?

Is it possible to translate it to lines that can have self-intersecting ?

Any other solutions?