I have multi-part polylines that have M-values (Oracle 18c; SDO_GEOMETRY). [Screenshot link]
Using SQL, I want to check the polylines for vertices where the M-value does not equal the cumulative length of the line (within a 1-meter tolerance).
Correct:
MULTILINESTRING M ((0 5 0, 10 10 11.18, 30 0 33.54),(50 10 33.54, 60 10 43.54))
Incorrect:
MULTILINESTRING M ((0 5 0, 10 10 10, 30 0 33.54),(50 10 33.54, 60 10 -10000))
How can I perform a check like that using SQL?