I have multi-part polyline vertices stored as individual rows in an 18c table. The vertices have M-values:
ASSET_ID PART_NUM VERTEX_NUM X Y M
---------- ---------- ---------- ---------- ---------- ----------
001 1 1 0 5 0
001 1 2 10 10 11.18
001 1 3 30 0 33.54
001 2 1 50 10 33.54
001 2 2 60 10 43.54
I want to convert the vertices to a multi-part SDO_GEOMETRY polyline, with the M-values included.
Is it possible to do that in Oracle?
Thanks.