Chapter 7. Into the Nth Dimension

In this chapter, we will cover:

• Importing LiDAR data

• Performing 3D queries on a LiDAR point cloud

• Constructing and serving buildings 2.5 D

• Using ST_Extrude to extrude building footprints

• Creating arbitrary 3D objects for PostGIS

• Exporting models as X3D for the Web

• Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D

• UAV photogrammetry in PostGIS – point cloud

• UAV photogrammetry in PostGIS – orthorectification

• UAV photogrammetry in PostGIS – DSM creation