MultiLinestringZM Data Type
MultiLinestringZM has the same properties as MultiLinestring but with two additional ordinates. In the WKT of MultiLinestringZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
Examples:
Without specifying SRID
CREATE TABLE roads (name VARCHAR(30), road MULTILINESTRINGZM);
With specifying SRID
CREATE TABLE roads (name VARCHAR(30), road MULTILINESTRINGZM SRID 4326);
Use collection of LineStringZM to track related roads:
CREATE TABLE roads (id INTEGER PRIMARY KEY, road MULTILINESTRINGZM NOT NULL);
INSERT INTO roads (id, road) VALUES (1, GEOMFROMTEXT('MULTILINESTRINGZM((0 0 0 0, 5 5 0 1, 0 5 1 2, 2 6 2 3), (2 6 2 3, 10 11 1 4, 8 15 1 5, 9 17 0 6), (2 6 2 3, 2 1 4 4, 3 -5 6 5, 4 -10 8 6))'));