MultiCurveZ and MultiCurveM Data Types

Was this helpful?

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: 11/28/2023