MultiPointZ and MultiPointM Data Types
MultiPointZ and MultiPointM have the same properties as MultiPoint but with one additional ordinate.
Examples:
Without specifying SRID
CREATE TABLE trees1 (name VARCHAR(30), tree MULTIPOINTZ);
CREATE TABLE trees2 (name VARCHAR(30), tree MULTIPOINTM);
With specifying SRID
CREATE TABLE trees1 (name VARCHAR(30), tree MULTIPOINTZ SRID 4326);
CREATE TABLE trees2 (name VARCHAR(30), tree MULTIPOINTM SRID 4326);
Use collection of PointZ to track trees:
CREATE TABLE trees1 (id INTEGER PRIMARY KEY, tree MULTIPOINTZ NOT NULL);
INSERT INTO trees1 (id, tree) VALUES (1, GEOMZFROMTEXT('MULTIPOINTZ(0 0 0, 0 1 1, 2 2 1, 5 0 2, 3 2 0)'));
Use collection of PointM to track trees and their height in meters:
CREATE TABLE trees2 (id INTEGER PRIMARY KEY, tree MULTIPOINTM NOT NULL);
INSERT INTO trees2 (id, tree) VALUES (1, GEOMMFROMTEXT('MULTIPOINTM(0 0 15, 0 1 16.5, 2 2 20.95, 5 0 20.11, 3 2 45.66)'));
Last modified date: 01/30/2023