Regarding the Repair Geometry (Data Management) GP tool:
It looks like ESRI’s native SDE.St_Geometry spatial type is not supported by that tool. Only these spatial types are supported:
Could support for SDE.St_Geometry (in Oracle) be added?
We have real-world cases where SDE.St_Geometry (Oracle 18c) features have invalid geometry. But we don’t have a way to find and fix those issues.
Related: Find & repair problem ST_GEOMETRY rows — "Shape integrity error"
ST_GEOMETRY is not supposed to accept invalid geometry, so there isn't any way to repair it once in place. You really ought to bring your dataset to the attention of Esri Tech Support.
You need to provide an Oracle Data Pump Export to Esri Technical Support.
How to Move the Oracle Enterprise Geodatabase with the Oracle Data Pump Utility
Other Options to Validate your Featureclass Geometries.
1. Geodatabase TOPOLOGY
Create topology rules such as points must not overlap to check your data.
An overview of topology in ArcGIS—ArcMap | Documentation
Topology in ArcGIS—ArcGIS Pro | Documentation
2. ArcGIS Data Reviewer Extension
If you have the "ArcGIS Data Reviewer Extension" ArcMap or Pro then use the Reviewer Check Geometry Tool.
ArcGIS Data Reviewer checks—ArcGIS Pro | Documentation - "Check Geometry"
Checks in Data Reviewer—ArcMap | Documentation (arcgis.com) - "Invalid Geometry Check"
3. ArcGIS Data Interoperability Extension or FME Workbench
you can use Model Builder in ArcMap or Pro with the ArcGIS Data Interoperability Extension functions to check the geometry, the same can be done with FME Workbench.
What is the Data Interoperability extension?—ArcMap | Documentation (arcgis.com)
ArcGIS Data Interoperability extension for Desktop—ArcGIS Pro | Documentation
4. ST_GEOMETRY FUNCTIONS
ST_GEOMETRY ST_ISSIMPLE function
ST_IsSimple—ArcMap | Documentation (arcgis.com)
ST_GEOMETRY ST_ISEMPTY function
ST_IsEmpty—ArcMap | Documentation (arcgis.com)
For ArcGIS Pro
Databases and ST_Geometry—ArcGIS Pro | Documentation
stgeometry_reference.pdf (arcgis.com)
You must configure the oracle extproc.ora to access the ST_GEOMETRY library to be able to use ST_GEOMETRY functions in SQL statements.
Configure the extproc to access ST_Geometry in Oracle—ArcMap | Documentation (arcgis.com)
Configure extproc to access ST_Geometry in Oracle—ArcGIS Pro | Documentation
I hope this helps.
We have this issue too.. we have Self intersecting polygons in an ST_Geometry SDE feature class (this isn't the first time this has happened). But I can't even CHECK for errors using ArcGIS Pro. This is a major limitation of ArcGIS Pro for troubleshooting data issues. It would be an absolute dream if I could repair the geometry too in SDE.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.