MultiLinestringZ and MultiLinestringM Data Types
MultiLinestringZ and MultiLinestringM have the same properties as MultiLinestring but with one additional ordinate.
Examples:
Without specifying SRID
CREATE TABLE paths (name VARCHAR(30), path MULTILINESTRINGZ);
CREATE TABLE roads (name VARCHAR(30), road MULTILINESTRINGM);
With specifying SRID
CREATE TABLE paths (name VARCHAR(30), path MULTILINESTRINGZ SRID 4326);
CREATE TABLE roads (name VARCHAR(30), road MULTILINESTRINGM SRID 4326);
Use collection of LineStringZ to track related paths:
CREATE TABLE paths (id INTEGER PRIMARY KEY, path MULTILINESTRINGZ NOT NULL);
INSERT INTO paths (id,path) VALUES (1, GEOMFROMTEXT('MULTILINESTRINGZ((0 0 0, 5 5 1, 0 5 2, 2 6 3), (2 6 3, 10 11 2, 8 15 1, 9 17 0), (2 6 3, 2 1 4, 3 -5 6, 4 -10 7))'));
Use collection of LineStringM to track related roads:
CREATE TABLE roads (id INTEGER PRIMARY KEY, road MULTILINESTRINGM NOT NULL);
INSERT INTO roads (id, road) VALUES (1, GEOMFROMTEXT('MULTILINESTRINGM((0 0 0, 5 5 1, 0 5 2, 2 6 3), (2 6 3, 10 11 4, 8 15 5, 9 17 6), (2 6 3, 2 1 4, 3 -5 5, 4 -10 6))'));