Was this helpful?
CurvePolygonZ and CurvePolygonM Data Types
CurvePolygonZ and CurvePolygonM have the same properties as CurvePolygon but with one additional ordinate.
Examples:
Without specifying SRID:
CREATE TABLE cpolys1 (name VARCHAR(30), cpoly CURVEPOLYGONZ);
CREATE TABLE cpolys2 (name VARCHAR(30), cpoly CURVEPOLYGONM);
With specifying SRID:
CREATE TABLE cpolys1 (name VARCHAR(30), cpoly CURVEPOLYGONZ SRID 4326);
CREATE TABLE cpolys2 (name VARCHAR(30), cpoly CURVEPOLYGONM SRID 4326);
Show a line followed by an arc:
CREATE TABLE cpolys1 (id INT, cpoly CURVEPOLYGONZ);
CREATE TABLE cpolys2 (id INT, cpoly CURVEPOLYGONM);
INSERT INTO cpolys1 (id, cpoly) VALUES (1, GeomZFromText('CURVEPOLYGONZ((4 0 0, 4 -4 0, 0 -4 0, 0 0 0), CIRCULARSTRINGZ(0 0 1, 2 2 2, 4 0 0))'));
INSERT INTO cpolys2 (id, cpoly) VALUES (1, GeomMFromText('CURVEPOLYGONM((4 0 0, 4 -4 0, 0 -4 0, 0 0 0), CIRCULARSTRINGM(0 0 1, 2 2 2, 4 0 0))'));
Last modified date: 11/09/2022