loading
Documents

Research.Publish.Connect.

Paper

Authors: Theresa Meyer and Ansgar Brunn

Affiliation: University of Applied Sciences Wuerzburg-Schweinfurt, Roentgenring 8, Wuerzburg and Germany

ISBN: 978-989-758-371-1

Keyword(s): 3D Point Clouds, Point Cloud Tiling, Geodatabase, GIS, 3D Applications.

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 cl oud 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. (More)

PDF ImageFull Text

Download
Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 18.232.99.123

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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

@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},
}

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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.