4. Geospatial Data Types : Four-dimensional Data Types : CircularStringZM Data Type
 
Share this page                  
CircularStringZM Data Type
CircularStringZM has the same properties as CircularString but with two additional ordinates. In the WKT of CircularStringZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
Examples:
Without specifying SRID:
CREATE TABLE arcs (name VARCHAR(30), arc CIRCULARSTRINGZM);
With specifying SRID:
CREATE TABLE arcs (name VARCHAR(30), arc CIRCULARSTRINGZM SRID 4326);
Show a circle (1), arc (2), and a straight line (3):
CREATE TABLE arcs (id INT, arc CIRCULARSTRINGZM);
INSERT INTO arcs (id, arc) VALUES (1, GeomFromText('CIRCULARSTRINGZM(0 0 0 1, 3 3 3 1, 0 0 0 1)'));
INSERT INTO arcs (id, arc) VALUES (2, GeomFromText('CIRCULARSTRINGZM(0 0 0 2, 2 2 0 2, 4 0 0 2)'));
INSERT INTO arcs (id, arc) VALUES (3, GeomFromText('CIRCULARSTRINGZM(0 0 0 3, 2 2 2 3, 4 4 4 3)'));