CurvePolygonZ and CurvePolygonM Data Types

Share this page

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, GeomFromText('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, GeomFromText('CURVEPOLYGONM((4 0 0, 4 -4 0, 0 -4 0, 0 0 0), CIRCULARSTRINGM(0 0 1, 2 2 2, 4 0 0))'));