4. Geospatial Data Types : Three-dimensional Data Types : GeometryCollectionZ and GeometryCollectionM Data Types
 
Share this page                  
GeometryCollectionZ and GeometryCollectionM Data Types
GeometryCollectionZ and GeometryCollectionM have the same properties as GeometryCollection with the exception that GeometryCollectionZ can only contain geometries with a Z coordinate and GeometryCollectionM can only contain geometries with an M coordinate.
Examples:
Without specifying SRID:
CREATE TABLE mishmash1 (name VARCHAR(30), path GEOMETRYCOLLECTIONZ);
CREATE TABLE mishmash2 (name VARCHAR(30), path GEOMETRYCOLLECTIONM);
With specifying SRID:
CREATE TABLE mishmash1 (name VARCHAR(30), path GEOMETRYCOLLECTIONZ SRID 4326);
CREATE TABLE mishmash2 (name VARCHAR(30), path GEOMETRYCOLLECTIONM SRID 4326);
Geometry collections can mix singular Z types:
CREATE TABLE collections1 (id INTEGER PRIMARY KEY, collection GEOMETRYCOLLECTIONZ);
INSERT INTO collections1 (id, collection) VALUES (1, GEOMFROMTEXT('GEOMETRYCOLLECTIONZ( POLYGONZ ((0 0 5, 10 10 10, 0 10 0, 0 0 5)), POLYGONZ ((0 0 0, 10 10 10, 10 0 5, 0 0 0)))'));
INSERT INTO collections1 (id, collection) VALUES (2, GEOMFROMTEXT('GEOMETRYCOLLECTIONZ( POLYGONZ ((0 0 5, 10 10 10, 0 10 0, 0 0 5)), POINTZ (50 50 25))'));
Geometry collections can mix singular M types:
CREATE TABLE collections2 (id INTEGER PRIMARY KEY, collection GEOMETRYCOLLECTIONZ);
INSERT INTO collections2 (id, collection) VALUES (1, GEOMFROMTEXT('GEOMETRYCOLLECTIONM( POLYGONM ((0 0 5, 10 10 10, 0 10 0, 0 0 5)), POLYGONM ((0 0 0, 10 10 10, 10 0 5, 0 0 0)))'));
INSERT INTO collections2 (id, collection) VALUES (2, GEOMFROMTEXT('GEOMETRYCOLLECTIONM( POLYGONM ((0 0 5, 10 10 10, 0 10 0, 0 0 5)), POINTM (50 50 25))'));