4. Geospatial Data Types : Two-dimensional Data Types : PolyhedralSurface Data Type
 
Share this page                  
PolyhedralSurface Data Type
A PolyhedralSurface consists of two or more faces that join among a common line.
Examples:
Without specifying SRID:
CREATE TABLE areas (name VARCHAR(30), face POLYHEDRALSURFACE);
With specifying SRID:
CREATE TABLE areas (name VARCHAR(30), face POLYHEDRALSURFACE SRID 4326);
Show two faces with one joining side:
CREATE TABLE areas (id INT, face POLYHEDRALSURFACE);
INSERT INTO areas (id, face) VALUES (1, GeomFromText('POLYHEDRALSURFACE(((0 0, 0 10, 10 10, 10 0, 0 0)), ((0 0, 0 10, -10 10, -10 0, 0 0))) '));