Geometry validation with ST_Geometry Functions

08-03-2017 01:27 AM
New Contributor III

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 

0 Kudos
2 Replies
MVP Regular Contributor

Check if the below info helps:


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 

New Contributor III

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. 

0 Kudos