Geometry validation with ST_Geometry Functions

Question

Hello all,

I'm writing a SQL on an Oracle database using "ST_Intersects" function. But I get an error which is not important anymore. Because I solved it with deleting some data.

However, I would like to know if there is a validation function for geometry columns in st_geometry functions. Just like  PostGIS's ST_IsValid

Tevfik_ÇağrıDural1 · Answer

Hello Asrujit,

Thank you for your response. I forgot to mention that SDE version I'm working on is 10.3.1. Besides all the tables were created and edited through ArcMap or applications built with ArcGIS API. However, I still had a problem with it.

Asrujit_SenGupta · Answer

Check if the below info helps:

ST_IsValid

A geometry inserted into an Oracle database using the spatial type (an ST_Geometry column) will always be valid because ArcSDE always validates this type of spatial data before accepting it. Other DBMS vendors may not validate the input, but require the application to do so.

Geometry validation—Help | ArcGIS Desktop