Hi Folk,
I am using SDO_UTIL.RECTIFY_GEOMETRY ( https://docs.oracle.com/database/121/SPATL/sdo_util-rectify_geometry.htm#SPATL1243 ) util function.
Here i having some clarification regarding the behaviour of the util that oracle stated.
Input geometry in WKT : 'LINESTRING (1 1 0, 1 1 5, 1 1 10, 2 2 1, 1 1 2, 1 1 05, 0.49 0.49 20, 1.5 1.6 2, 3 3 23, 4 4 10, 1 1 200, 1 1 0, 1 1 0)'
tolerance : 0.5
Oracle Result 'LINESTRING (1 1 0, 2 2 1, 1 1 2, 0.49 0.49 20, 1.5 1.6 2, 3 3 23, 4 4 10, 1 1 0)';
CASE #1
Red Marked Text
In this case vertices 2 2 1 and 1.5 1.6 2 both should be similar within the tolerance, then why do rectify geometry util didn't rectified it by removing the vertices ??
CASE #2
Cyan Marked Text
In this case, why do the vertices 1 1 2 has been showed in the result, since it has the similar upcoming vertices present in the input as 1 1 200 and 1 1 0 ?