4. Geospatial Data Types : Four-dimensional Data Types : CurvePolygonZM Data Type
 
Share this page                  
CurvePolygonZM Data Type
CurvePolygonZM has the same properties as CurvePolygon but with two additional ordinates. In the WKT of CurvePolygonZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
Examples:
Without specifying SRID:
CREATE TABLE cpolys (name VARCHAR(30), cpoly CURVEPOLYGONZM);
With specifying SRID:
CREATE TABLE cpolys (name VARCHAR(30), cpoly CURVEPOLYGONZM SRID 4326);
Show a line followed by an arc:
CREATE TABLE cpolys (id INT, cpoly CURVEPOLYGONZM);
INSERT INTO cpolys (id, cpoly) VALUES (1, GeomFromText('CURVEPOLYGONZM((4 0 0 1, 4 -4 0 1, 0 -4 0 1, 0 0 0 1), CIRCULARSTRINGZM(0 0 0 1, 2 2 2 1, 4 0 0 1))'));