Was this helpful?
MultiCurveZM Data Type
A MultiCurveZM can contain between 1 to N curves of the types LinestringZM, CircularStringZM, and CompoundCurveZM, with any combination of these types. In the WKT of MultiCurveZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
Examples:
Without specifying SRID:
CREATE TABLE curves (name VARCHAR(30), mcurve MULTICURVEZM);
With specifying SRID:
CREATE TABLE curves (name VARCHAR(30), mcurve MULTICURVEZM SRID 4326);
Show a collection of curves that may or may not be related:
CREATE TABLE curves (id INT, mcurve MULTICURVEZM);
INSERT INTO curves (id, mcurve) VALUES (1, GeomZMFromText('MULTICURVEZM((0 0 0 1, 10 10 10 1, 20 0 5 1), CIRCULARSTRINGZM(-5 -5 0 2, 2 2 0 2, -1 -1 0 2))'));
Last modified date: 11/28/2023