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, GeomZMFromText('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)))'));
Last modified date: 08/28/2024