Into the Nth Dimension - PostGIS - page 354

shp2pgsql -s 3734 -d -i -I -W LATIN1 -g
the_geom building_footprints
chp07.building_footprints | psql -U me -d
postgis_cookbook
CREATE TABLE chp07.build_footprints_threed AS
SELECT gid, height,
chp07.threeDbuilding(the_geom, height) AS
the_geom FROM chp07.building_footprints;
Theresultantoutputgivesusanice,extrudedsetofbuildingfootprints,asshownin
the following image:
The Generating detailed building footprints from LiDAR recipein Chapter4 , Working
with Vector Data - Advanced Recipes ,explorestheextractionofbuildingfootprints
fromLiDAR.Acompleteworkflowcouldbeenvisioned,whichextractsbuildingfoot-
prints from LiDAR and then reconstructs polygon geometries using the current re-
cipe,thusconvertingpointcloudstosurfaces,combiningthecurrentrecipewiththe
one referenced above.