CircularStringZ and CircularStringM Data Types
CircularStringZ and CircularStringM have the same properties as CircularString but with one additional ordinate.
Examples:
Without specifying SRID:
CREATE TABLE arcs1 (name VARCHAR(30), arc CIRCULARSTRINGZ);
CREATE TABLE arcs2 (name VARCHAR(30), arc CIRCULARSTRINGM);
With specifying SRID:
CREATE TABLE arcs1 (name VARCHAR(30), arc CIRCULARSTRINGZ SRID 4326);
CREATE TABLE arcs2 (name VARCHAR(30), arc CIRCULARSTRINGM SRID 4326);
Show a circle (1), arc (2), and a straight line (3):
CREATE TABLE arcs1 (id INT, arc CIRCULARSTRINGZ);
CREATE TABLE arcs2 (id INT, arc CIRCULARSTRINGM);
INSERT INTO arcs1 (id, arc) VALUES (1, GeomZFromText('CIRCULARSTRINGZ(0 0 0, 3 3 3, 0 0 0,
0 0 0)'));
INSERT INTO arcs1 (id, arc) VALUES (2, GeomZFromText('CIRCULARSTRINGZ(0 0 0, 2 2 0, 4 0 0)'));
INSERT INTO arcs1 (id, arc) VALUES (3, GeomZFromText('CIRCULARSTRINGZ(0 0 0, 2 2 2, 4 4 4)'));
INSERT INTO arcs2 (id, arc) VALUES (1, GeomMFromText('CIRCULARSTRINGM(0 0 0, 3 3 3, 0 0 0)'));
INSERT INTO arcs2 (id, arc) VALUES (2, GeomMFromText('CIRCULARSTRINGM(0 0 0, 2 2 0, 4 0 0)'));
INSERT INTO arcs2 (id, arc) VALUES (3, GeomMFromText('CIRCULARSTRINGM(0 0 0, 2 2 2, 4 4 4)'));
Last modified date: 08/14/2024