3D Point Clouds in PostgreSQL/PostGIS for Applications in GIS and Geodesy

Theresa Meyer, Ansgar Brunn

2019

Abstract

Besides the common approach of an exclusively file based management of 3D point clouds, meanwhile it is possible to store and process this special type of massive geodata within spatial database systems. Users benefit from the general advantages of database solutions and especially from the potentials of a combined analysis of original 3D point clouds, 2D rasters, 3D voxel stacks and 2D and 3D vector data in order to gain valuable geoinformation. This paper describes the integration of 3D point clouds into an open source PostgreSQL/PostGIS database using the Pointcloud extension and functions of the Point Data Abstraction Library (PDAL). The focus is on performing three-dimensional spatial queries and the evaluation of different tiling methods for the organization of 3D point clouds into table rows, regarding memory space, performance of spatial queries and effects on interactions between point clouds and other GIS features within the database. A new approach for an optimized point cloud tiling, considering the individual geometric characteristic of a 3D point cloud, is presented. The results show that an individually selected storage structure for a point cloud is crucial for low memory consumption and high-performance 3D queries in PostGIS applications, taking account of its three-dimensional spatial extent and point density.

Paper Citation

in Harvard Style

Meyer T. and Brunn A. (2019). 3D Point Clouds in PostgreSQL/PostGIS for Applications in GIS and Geodesy.In Proceedings of the 5th International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM, ISBN 978-989-758-371-1, pages 154-163. DOI: 10.5220/0007840901540163

in Bibtex Style

@conference{gistam19,
author={Theresa Meyer and Ansgar Brunn},
title={3D Point Clouds in PostgreSQL/PostGIS for Applications in GIS and Geodesy},
booktitle={Proceedings of the 5th International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,},
year={2019},
pages={154-163},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0007840901540163},
isbn={978-989-758-371-1},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 5th International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,
TI - 3D Point Clouds in PostgreSQL/PostGIS for Applications in GIS and Geodesy
SN - 978-989-758-371-1
AU - Meyer T.
AU - Brunn A.
PY - 2019
SP - 154
EP - 163
DO - 10.5220/0007840901540163