CircularStringZ and CircularStringM Data Types

Share this page

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, GeomFromText('CIRCULARSTRINGZ(0 0 0, 3 3 3, 0 0 0)'));

INSERT INTO arcs1 (id, arc) VALUES (2, GeomFromText('CIRCULARSTRINGZ(0 0 0, 2 2 0, 4 0 0)'));

INSERT INTO arcs1 (id, arc) VALUES (3, GeomFromText('CIRCULARSTRINGZ(0 0 0, 2 2 2, 4 4 4)'));

INSERT INTO arcs2 (id, arc) VALUES (1, GeomFromText('CIRCULARSTRINGM(0 0 0, 3 3 3, 0 0 0)'));

INSERT INTO arcs2 (id, arc) VALUES (2, GeomFromText('CIRCULARSTRINGM(0 0 0, 2 2 0, 4 0 0)'));

INSERT INTO arcs2 (id, arc) VALUES (3, GeomFromText('CIRCULARSTRINGM(0 0 0, 2 2 2, 4 4 4)'));