Repair Geometry GP tool: Support SDE.St_Geometry

[Bud]

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:

• Microsoft SQL Server—Geometry and Geography
• PostgreSQL—PostGIS, Geometry and Geography
• Oracle—SDO_Geometry

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"

[MarceloMarques]

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.

| Marcelo Marques | Principal Product Engineer | Esri |
| OCP - Oracle Certified Professional |

[NinaRihn]

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.