Was this helpful?
MultiPolygonZM Data Type
MultiPolygonZM has the same properties as MultiPolygon but with two additional ordinates. In the WKT of MultiPolygonZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
Examples:
Without specifying SRID:
CREATE TABLE parks (name VARCHAR(30), park MULTIPOLYGONZM);
With specifying SRID:
CREATE TABLE parks (name VARCHAR(30), park MULTIPOLYGONZM SRID 4326);
Group several parcels of land into a MultiPolygonZM representing all the pieces of a park:
CREATE TABLE parks (id INTEGER PRIMARY KEY, polygon MULTIPOLYGONZM);
INSERT INTO parks (id, polygon) VALUES (1, GEOMZMFROMTEXT('MULTIPOLYGONZM(((0 0 0 1, 10 10 1 1, 0 10 0 1, 0 0 0 1)), ((0 0 0 2, 10 10 1 2, 10 0 2 2, 0 0 0 2)))'));
Last modified date: 12/14/2023