ST Geometry : how to check for invalid geometry? and how to repair?

MichalGasparovic — Thu, 21 Oct 2010 09:29:48 GMT

ArcSDE 9.3.1 SP1
ArcGIS Server 9.3.1 SP1
Web Application .NET Web ADF 9.3.1 SP1

Hi everyone, we have an application with the web adf editor so users can create the polygon features. I have noticed that this control (web adf editor) allows user to insert self intersecting features (!), so after a while, my ST_FUNCTIONs will throw an error saying "Error coverting shape into rectangle".

My question is, is there any tool or st function that will check for invalid geometry of the features stored in the sde geodatabase?? I seem to be unable to locate such tool/function and that's why am I asking.

Thank you very much for your help.

UPDATE:
I was using the following function :
SELECT SO_ID, sde.st_MaxX(sde.st_envelope(SO.shape)) MaxX FROM SO WHERE (some condition here)...
and that one has failed.
If I use the
SELECT SO_ID, sde.st_MaxX(SO.shape) MaxX FROM SO WHERE (some condition here)...
than it works ok...

obviously, there is some trouble with st_envelope ... I've tracked down the 'problematic' record(s), but there is nothing wrong by the first sight. I need to investigate this a bit further.

topic ST Geometry : how to check for invalid geometry? and how to repair? in Data Management Questions

ST Geometry : how to check for invalid geometry? and how to repair?