PostGIS

ST_Extrude
Prev	7.21. SFCGAL Functions	Next

ST_Extrude

7.21. SFCGAL Functions

Name

ST_Extrude — Extrude a surface to a related volume

geometry +`*`+ST_Extrude*(`geometry `geom, float x, float y, float z`)`;

Availability: 2.1.0

check This method needs SFCGAL backend.

check This function supports 3d and will not drop the z-index.

check This function supports Polyhedral surfaces.

check This function supports Triangles and Triangulated Irregular Network Surfaces (TIN).

3D images were generated using PostGIS ST_AsX3D and rendering in HTML using X3Dom HTML Javascript rendering library.

SELECT ST_Buffer(ST_GeomFromText('POINT(100 90)'),
  50, 'quad_segs=2'),0,0,30);

st_extrude01

Original octagon formed from buffering point

ST_Extrude(ST_Buffer(ST_GeomFromText('POINT(100 90)'),
 50, 'quad_segs=2'),0,0,30);

st_extrude02

Hexagon extruded 30 units along Z produces a PolyhedralSurfaceZ

SELECT ST_GeomFromText('LINESTRING(50 50, 100 90, 95 150)')

st_extrude03

Original linestring

SELECT ST_Extrude(
 ST_GeomFromText('LINESTRING(50 50, 100 90, 95 150)'),0,0,10));

st_extrude04

LineString Extruded along Z produces a PolyhedralSurfaceZ