Was this helpful?
CompoundCurveZ and CompoundCurveM Data Types
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, GeomZFromText('COMPOUNDCURVEZ(CIRCULARSTRINGZ(0 0 0, 2 2 0, 4 0 0), (4 0 0, 0 0 5))'));
INSERT INTO curves2 (id, curve) VALUES (1, GeomMFromText('COMPOUNDCURVEM(CIRCULARSTRINGM(0 0 0, 2 2 0, 4 0 0), (4 0 1, 0 0 1))'));
Last modified date: 11/09/2022