Was this helpful?
MultiPointZM Data Type
MultiPointZM has the same properties as the MultiPoint data type but with two additional ordinates. In the WKT of MultiPointZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
Examples:
Without specifying SRID:
CREATE TABLE trees (name VARCHAR(30), tree MULTIPOINTZM);
With specifying SRID:
CREATE TABLE trees (name VARCHAR(30), tree MULTIPOINTZM SRID 4326);
Use collection of PointZM to track trees and their height in meters:
CREATE TABLE trees (id INTEGER PRIMARY KEY, tree MULTIPOINTZM NOT NULL);
INSERT INTO trees (id, tree) VALUES (1, GEOMZMFROMTEXT('MULTIPOINTZM(0 0 25 15, 0 1 22 16.5, 2 2 18 20.95, 5 0 18.5 20.11, 3 2 5.5 45.66)'));
Last modified date: 12/14/2023