GeometryCollectionZM Data Type
GeometryCollectionZM has the same properties as GeometryCollection with the exception that GeomtryCollectionZM can only contain geometries with ZM ordinates. In the WKT of GeometryCollectionZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
Examples:
Without specifying SRID:
CREATE TABLE mishmash (name VARCHAR(30), path GEOMETRYCOLLECTIONZM);
With specifying SRID:
CREATE TABLE mishmash (name VARCHAR(30), path GEOMETRYCOLLECTIONZM SRID 4326);
Geometry collections can mix singular ZM types:
CREATE TABLE collections (id INTEGER PRIMARY KEY, collection GEOMETRYCOLLECTIONZ);
INSERT INTO collections (id, collection) VALUES (1, GEOMZMFROMTEXT('GEOMETRYCOLLECTIONZM( POLYGONZM ((0 0 5 1, 10 10 10 1, 0 10 0 1, 0 0 5 1)), POLYGONZM ((0 0 0 2, 10 10 10 2, 10 0 5 2, 0 0 0 2)))'));
INSERT INTO collections (id, collection) VALUES (2, GEOMZMFROMTEXT('GEOMETRYCOLLECTIONZM( POLYGONZM ((0 0 5 1, 10 10 10 1, 0 10 0 1, 0 0 5 1)), POINTZM (50 50 25 2))'));
Last modified date: 01/30/2023