Database Reference
In-Depth Information
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
Introduction
In this chapter, we will delve into the 3D capabilities of PostGIS, focusing on three
basiccategories:howtoget3DdataintoPostGIS,3DanalyseswithinPostGIS,and
ways of serving 3D data out of PostGIS. The chapter will focus on 3D point clouds,
including LiDAR point cloudsandpoint cloudsderivedfrom
Structure from Motion
(
SfM
)techniques.Inaddition,wewillbuildafunctionthatextrudesbuildingfootprints
to3D.Finally,wewillexplorewaysofdistributingthe3DmodelsthroughtheWebas
exported from PostGIS using the X3D standard.
Wewillnotbeaddressingthepointcloudextensioninthischapter,whichenablesthe
useoflargerLiDARandotherpointclouddatainPostgreSQLwithoptionalcapacity
totieintoPostGIS.ForinformationonpointcloudPostgreSQL/PostGISdevelopment,
see Paul Ramsey's tutorial at
http://workshops.boundlessgeo.com/tutorial-lidar/
and
other forthcoming resources at
http://boundlessgeo.com
.
Download the example datasets we have for your use available at
ht-