Was this helpful?
MultiCurveZ and MultiCurveM Data Types
A MultiCurveZ can contain between 1 to N curves of the types LinestringZ, CircularStringZ, and CompoundCurveZ, with any combination of these types.
A MultiCurveM can contain between 1 to N curves of the types LinestringM, CircularStringM, and CompoundCurveM, with any combination of these types.
Examples:
Without specifying SRID:
CREATE TABLE curves1 (name VARCHAR(30), mcurve MULTICURVEZ);
CREATE TABLE curves2 (name VARCHAR(30), mcurve MULTICURVEM);
With specifying SRID:
CREATE TABLE curves1 (name VARCHAR(30), mcurve MULTICURVEZ SRID 4326);
CREATE TABLE curves2 (name VARCHAR(30), mcurve MULTICURVEM SRID 4326);
Show a collection of curves that may or may not be related:
CREATE TABLE curves1 (id INT, mcurve MULTICURVEZ);
CREATE TABLE curves2 (id INT, mcurve MULTICURVEM);
 
INSERT INTO curves1 (id, mcurve) VALUES (1, GeomZFromText('MULTICURVEZ((0 0 0, 10 10 10, 20 0 5), CIRCULARSTRINGZ(-5 -5 0, 2 2 0, -1 -1 0))'));
 
INSERT INTO curves2 (id, mcurve) VALUES (1, GeomMFromText('MULTICURVEM((0 0 0, 10 10 0, 20 0 0), CIRCULARSTRINGM(-5 -5 1, 2 2 1, -1 -1 1))'));
Last modified date: 01/30/2023