CompoundCurveZ and CompoundCurveM Data Types

Share this page

CompoundCurveZ and CompoundCurveM have the same properties as CompoundCurve but with one additional ordinate.

Examples:

Without specifying SRID:

CREATE TABLE curves1 (name VARCHAR(30), curve COMPOUNDCURVEZ);

CREATE TABLE curves2 (name VARCHAR(30), curve COMPOUNDCURVEM);

With specifying SRID:

CREATE TABLE curves1 (name VARCHAR(30), curve COMPOUNDCURVEZ SRID 4326);

CREATE TABLE curves2 (name VARCHAR(30), curve COMPOUNDCURVEM SRID 4326);

Show an arc followed by a line closing the half circle:

CREATE TABLE curves1 (id INT, curve COMPOUNDCURVEZ);

CREATE TABLE curves2 (id INT, curve COMPOUNDCURVEM);

INSERT INTO curves1 (id, curve) VALUES (1, GeomFromText('COMPOUNDCURVEZ(CIRCULARSTRINGZ(0 0 0, 2 2 0, 4 0 0), (4 0 0, 0 0 5))'));

INSERT INTO curves2 (id, curve) VALUES (1, GeomFromText('COMPOUNDCURVEM(CIRCULARSTRINGM(0 0 0, 2 2 0, 4 0 0), (4 0 1, 0 0 1))'));