ORA-13356 adjacent points in a geometry are redundant.
Hi
when i validate polygon geoemetries in a table using SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT function,
I am getting ORA-13356 for some records.
The error definition gives
ORA-13356 adjacent points in a geometry are redundant
Cause: There are repeated points in the sequence of coordinates.
Action: Remove the redundant point.
But i can't find any redundant coordinates in the data.
I also ran the validation query with very less tolerance as possible(0.000000000000001). But still getting the same result.
Can anyone shed light on this.
Oracle version 9.2
following is the result of validate function and it's data
13356 [Element <1>] [Coordinate <1419>][Ring <1>]
(2003, 8265, (-87.73042896, 41.65380297, ), (1, 1003, 1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ), (-87.93142092, 41.64355098, -87.92165016, 41.64373701, -87.92066088, 41.643756, -87.91189416, 41.64392601, -87.91190892, 41.64352803, -87.911856, 41.641713, -87.91183404, 41.64088401, -87.91179984, 41.63865201, -87.91171092, 41.63668101, -87.91171992, 41.63634603, -87.91166592, 41.63474304, -87.91164288, 41.63448897, -87.91161588, 41.63352498, -87.91160796, 41.63316399, -87.91160688, 41.63312799, -87.91157916, 41.63151996, -87.91149708, 41.62941297, -87.91148916, 41.62893804, -87.91148196, 41.62831902, -87.91148088, 41.628186, -87.91138404, 41.62616802, -87.911361, 41.62547799, -87.911334, 41.62482999, -87.91132788, 41.624415, -87.91127604, 41.623236, -87.91127604, 41.62292397, -87.911262, 41.62269897, -87.91124184, 41.621526, -87.91118208, 41.62061097, -87.91116084, 41.61943098, -87.91116012, 41.619348, -87.91108596, 41.61815604, -87.91096104, 41.61492504, -87.91088688, 41.61149199, -87.91088004, 41.60942397, -87.91079112, 41.60760003, -87.91077096, 41.606208, -87.91072884, 41.60535102, -87.91065396, 41.60255202, -87.91058808, 41.60134602, -87.91055388, 41.60102202, -87.91050996, 41.60072997, -87.910434, 41.60030697, -87.91030296, 41.59777698, -87.91036308, 41.59668798, -87.91057188, 41.59288998, -87.910425, 41.591232, -87.91034508, 41.58875799, -87.91034004, 41.58859698, -87.91024284, 41.58584901))
Thanks
Sathish