PolyhedralSurfaceZ and PolyhedralSurfaceM Data Types
PolyhedralSurfaceZ and PolyhedralSurfaceM have the same properties as PolyhedralSurface but with one additional ordinate.
Examples:
Without specifying SRID:
CREATE TABLE areas1 (name VARCHAR(30), face POLYHEDRALSURFACEZ);
CREATE TABLE areas2 (name VARCHAR(30), face POLYHEDRALSURFACEM);
With specifying SRID:
CREATE TABLE areas1 (name VARCHAR(30), face POLYHEDRALSURFACEZ SRID 4326);
CREATE TABLE areas2 (name VARCHAR(30), face POLYHEDRALSURFACEM SRID 4326);
Show two three dimensional faces with one joining side:
CREATE TABLE areas1 (id INT, face POLYHEDRALSURFACEZ);
INSERT INTO areas1 (id, face) VALUES (1, GeomFromText('POLYHEDRALSURFACEZ(((0 0 0, 0 10 0, 10 10 0, 10 0 0, 0 0 0)), ((0 0 0, 0 10 0, 0 10 10, 0 10 10, 0 0 0))) '));
Show two 2-dimensional faces with one joining side:
CREATE TABLE areas2 (id INT, face POLYHEDRALSURFACEM);
INSERT INTO areas2 (id, face) VALUES (1, GeomFromText('POLYHEDRALSURFACEM(((0 0 0, 0 10 0, 10 10 0, 10 0 0, 0 0 0)), ((0 0 1, 0 10 1, -10 10 1, -10 0 1, 0 0 1))) '));