topic Geometry validation with ST_Geometry Functions in Geodatabase Questions

Geometry validation with ST_Geometry Functions

Tevfik_ÇağrıDural1 — Thu, 03 Aug 2017 08:27:18 GMT

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

Re: Geometry validation with ST_Geometry Functions

Asrujit_SenGupta — Thu, 03 Aug 2017 08:48:13 GMT

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

Re: Geometry validation with ST_Geometry Functions

Tevfik_ÇağrıDural1 — Fri, 04 Aug 2017 07:09:22 GMT

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.