Was this helpful?
MultiPolygonZ and MultiPolygonM Data Types
MultiPolygonZ and MultiPolygonM have the same properties as MultiPolygon but with one additional ordinate.
Examples:
Without specifying SRID:
CREATE TABLE parks1 (name VARCHAR(30), park MULTIPOLYGONZ);
CREATE TABLE parks2 (name VARCHAR(30), park MULTIPOLYGONM);
With specifying SRID:
CREATE TABLE parks1 (name VARCHAR(30), park MULTIPOLYGONZ SRID 4326);
CREATE TABLE parks2 (name VARCHAR(30), park MULTIPOLYGONM SRID 4326);
Group several parcels of land into a MultiPolygonZ representing all the pieces of a park:
CREATE TABLE parks1 (id INTEGER PRIMARY KEY, polygon MULTIPOLYGONZ);
INSERT INTO parks1 (id, polygon) VALUES (1, GEOMZFROMTEXT('MULTIPOLYGONZ(((0 0 0, 10 10 1, 0 10 0, 0 0 0)), ((0 0 0, 10 10 1, 10 0 2, 0 0 0)))'));
Group several parcels of land into a MultiPolygonM representing all the pieces of a park:
CREATE TABLE parks2 (id INTEGER PRIMARY KEY, polygon MULTIPOLYGONM);
INSERT INTO parks2 (id, polygon) VALUES (1, GEOMMFROMTEXT('MULTIPOLYGONM(((0 0 0, 10 10 0, 0 10 0, 0 0 0)), ((0 0 1, 10 10 1, 10 0 1, 0 0 1)))'));
Last modified date: 11/28/2023