Was this helpful?
CompoundCurveZM Data Type
CompoundCurveZM has the same properties as CompoundCurve but with two additional ordinates. In the WKT of CompoundCurveZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
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 curves (id INT, curve COMPOUNDCURVEZM);
INSERT INTO curves (id, curve) VALUES (1, GeomZMFromText('COMPOUNDCURVEZM(CIRCULARSTRINGZM(0 0 0 1, 2 2 0 1, 4 0 0 1), (4 0 0 1, 0 0 0 1))'));
Last modified date: 11/28/2023