4. Geospatial Data Types : Four-dimensional Data Types : TINZM Data Type
 
Share this page                  
TINZM Data Type
TINZM has the same properties as TIN but with two additional ordinates. In the WKT of TINZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
Examples:
Without specifying SRID:
CREATE TABLE tins (name VARCHAR(30), t TINZM);
With specifying SRID:
CREATE TABLE tins (name VARCHAR(30), t TINZM SRID 4326);
Show a line followed by an arc:
CREATE TABLE tins (id INT, t TINZM);
INSERT INTO tins (id, t) VALUES (1, GeomFromText('TINZM(((0 0 0 2, 5 5 0 2, 10 0 0 2, 0 0 0 2), (5 5 0 1, 10 0 0 1, 15 5 1 1, 5 5 0 1)))'));