I have a query that produces an LRS SDO_GEOMETRY as WKT (Oracle 18c):
select SDO_UTIL.TO_WKTGEOMETRY(SDO_LRS.CONVERT_TO_LRS_GEOM(sdo_geometry('LINESTRING(1 2,3 4)'))) from dual Output: LINESTRING (1.0 2.0 0.0, 3.0 4.0 2.82842712474619) ^
That output isn't quite the format that I need. I need the WKT to indicate that the third dimension is M-values, not imply that the third dimension is Y-values:
LINESTRING M (1.0 2.0 0.0, 3.0 4.0 2.82842712474619) ^
How can I output a LRS SDO_GEOMETRY using the
LINESTRING M format?
MULTILINESTRING M format, if the geometry is multi-part.)