Hello,
I have some problem to select my spatial data (see
504161 ). Sometime I select data and my database connection will be separated (ORA-03113, ORA-03114).
Now I try to analys my data with VALIDATE_GEOMETRY_WITH CONTEXT:
SELECT c.SPA_CODE, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(c.GEOM, 0.5)
FROM protection_area.sk_2006_spa c
WHERE SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(c.GEOM, 0.5)<>'TRUE'
ORDER BY c.SPA_CODE
Here a part of the result:
1 SKCHVU002 13348 [Element <1>] [Ring <2>]
2 SKCHVU003 13349 [Element <1>] [Ring <1>][Edge <5247>][Edge <5252>]
3 SKCHVU004 13367 [Element <5>] [Ring <1>]
4 SKCHVU009 13348 [Element <1>] [Ring <14>]
5 SKCHVU010 13348 [Element <2>] [Ring <1>]
6 SKCHVU013 13348 [Element <1>] [Ring <8>]
7 SKCHVU015 13348 [Element <6>] [Ring <7>]
8 SKCHVU016 13349 [Element <3>] [Ring <1>][Edge <2175>][Edge <2178>]
9 SKCHVU017 13367 [Element <5>] [Ring <2>]
10 SKCHVU018 13349 [Element <9>] [Ring <1>][Edge <5368>][Edge <5370>]
11 SKCHVU019 13348 [Element <14>] [Ring <29>]
12 SKCHVU021 13367 [Element <1>] [Ring <1>]
13 SKCHVU025 13367 [Element <1>] [Ring <13>]
What can I do to avoid this 'errors'?
I already tried this:
UPDATE protection_area.sk_2006_spa c
SET c.GEOM = SDO_UTIL.REMOVE_DUPLICATE_VERTICES(c.geom,0.5)
Any hints?
Thanks,
matthias