Select to view content in your preferred language

SDE Fail to show oracle feature

3234
11
07-04-2012 11:27 PM
ArySucaya
Emerging Contributor
Heloo,

I have a simple parcel polygon in oracle spatial 11.2.0.0. The WKT is:

POLYGON ((100.378750779898 -0.310282546668259, 100.378772459506 -0.310271543916926, 100.378838852504 -0.310235840196097, 100.378845732154 -0.310224416657996, 100.378844002915 -0.31020930373441, 100.37871739762 -0.309977750136478, 100.378616547328 -0.310045414011517, 100.378548060368 -0.309924611880424, 100.378750779898 -0.310282546668259))

When i validate geometry, oracle said it is TRUE. However, arcgis server with direct sde connection can't render it. There are some record have the same problem as this, since oracle always said it true but sde can read this geometry, it become difficult to find the problematic record. I have to use a another software to show all record first and try a manual search to the problematic feature. Any idea how to solve this?
0 Kudos
11 Replies
VinceAngelo
Esri Esteemed Contributor
The western edge crosses itself at all scales:

[ATTACH=CONFIG]16152[/ATTACH]
To be valid in a topological engine, this would have to be a two-part polygon, with part 1 stopping
at vertex B before moving back east toward C, and then a part 2 composed of A,B,D,A.

- V
0 Kudos
ArySucaya
Emerging Contributor
yeah, look like this annoying problem specific to esri product. I check again some others software none face the same issue. Extra creative job to convert a straight line into a jagged line could be the culprit. Thank you
0 Kudos