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

525
0
10-21-2010 02:29 AM
MichalGasparovic
New Contributor III
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.
0 Kudos
0 Replies