4. Geospatial Data Types : Four-dimensional Data Types : PolyhedralSurfaceZM Data Type
 
Share this page                  
PolyhedralSurfaceZM Data Type
PolyhedralSurfaceZM has the same properties as PolyhedralSurface but with two additional ordinates. In the WKT of PolyhedralSurfaceZM the first ordinate is X, the second is Y, the third is Z, and the fourth is M.
Examples:
Without specifying SRID:
CREATE TABLE areas (name VARCHAR(30), face POLYHEDRALSURFACEZM);
With specifying SRID:
CREATE TABLE areas (name VARCHAR(30), face POLYHEDRALSURFACEZM SRID 4326);
Show two three dimensional faces with one joining side:
CREATE TABLE areas (id INT, face POLYHEDRALSURFACEZM);
INSERT INTO areas (id, face) VALUES (1, GeomFromText('POLYHEDRALSURFACEZM(((0 0 0 2, 0 10 0 2, 10 10 0 2, 10 0 0 2, 0 0 0 2)), ((0 0 0 1, 0 10 0 1, 0 10 10 1, 0 10 10 1, 0 0 0 1))) '));