March 2018
Beginner to intermediate
584 pages
14h 31m
English
book
PostGIS Cookbook - Second Edition
by Stephen Vincent Mather, Pedro Wightman, Bborie Park, Thomas Kraft, Mayra Zurbarán, Paolo Corti
Content preview from PostGIS Cookbook - Second Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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.5D
- 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 – DSM creation