TINZ and TINM Data Types
TINZ and TINM have the same properties as TIN but with one additional ordinate. TINZ is more commonly used than TIN.
Examples:
Without specifying SRID:
CREATE TABLE tins1 (name VARCHAR(30), t TINZ);
CREATE TABLE tins2 (name VARCHAR(30), t TINM);
With specifying SRID:
CREATE TABLE tins1 (name VARCHAR(30), t TINZ SRID 4326);
CREATE TABLE tins2 (name VARCHAR(30), t TINM SRID 4326);
Show a line followed by an arc:
CREATE TABLE tins1 (id INT, t TINZ);
CREATE TABLE tins2 (id INT, t TINM);
INSERT INTO tins1 (id, t) VALUES (1, GeomFromText('TINZ(((0 0 0, 5 5 0, 10 0 0, 0 0 0), (5 5 0, 10 0 0, 15 5 1, 5 5 0)))'));
INSERT INTO tins2 (id, t) VALUES (1, GeomFromText('TINM(((0 0 0, 5 5 0, 10 0 0, 0 0 0), (5 5 0, 10 0 0, 15 5 1, 5 5 0)))'));