topic Get self-intersecting features from oracle spatial in Data Management Questions https://community.esri.com/t5/data-management-questions/get-self-intersecting-features-from-oracle-spatial/m-p/640467#M36217 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hello<BR />all</P><P></P><P style="text-align: left;">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.</P><P style="text-align: left;">When we use SDE_GEOM.validate_geometry(shape,0.2)='TRUE' we get a list of all the invalid geometries.</P><P style="text-align: left;">We would like to see these invalid geometries after all.</P><P style="text-align: left;">Is there any way to do it?</P><P style="text-align: left;">Is there a command in Oracle that will fix them?</P><P style="text-align: left;">Is it possible to export it to shape file where self-intersecting is fine?</P><P style="text-align: left;">Is it possible to translate it to lines that can have self-intersecting ?</P><P style="text-align: left;">Any other solutions?</P><P></P><P style="text-align: left;">Thanks</P></BODY></HTML> Tue, 20 Jan 2015 05:52:51 GMT ModyBuchbinder 2015-01-20T05:52:51Z Get self-intersecting features from oracle spatial https://community.esri.com/t5/data-management-questions/get-self-intersecting-features-from-oracle-spatial/m-p/640467#M36217 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hello<BR />all</P><P></P><P style="text-align: left;">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.</P><P style="text-align: left;">When we use SDE_GEOM.validate_geometry(shape,0.2)='TRUE' we get a list of all the invalid geometries.</P><P style="text-align: left;">We would like to see these invalid geometries after all.</P><P style="text-align: left;">Is there any way to do it?</P><P style="text-align: left;">Is there a command in Oracle that will fix them?</P><P style="text-align: left;">Is it possible to export it to shape file where self-intersecting is fine?</P><P style="text-align: left;">Is it possible to translate it to lines that can have self-intersecting ?</P><P style="text-align: left;">Any other solutions?</P><P></P><P style="text-align: left;">Thanks</P></BODY></HTML> Tue, 20 Jan 2015 05:52:51 GMT https://community.esri.com/t5/data-management-questions/get-self-intersecting-features-from-oracle-spatial/m-p/640467#M36217 ModyBuchbinder 2015-01-20T05:52:51Z