Using Foreign Data Wrapper in PostgreSQL to Expose Point Clouds on File System
M. Deng (TU Delft - Architecture and the Built Environment)
M. Meijers – Mentor (TU Delft - GIS Technologie)
P.J.M. Oosterom – Mentor (TU Delft - GIS Technologie)
More Info
expand_more
Other than for strictly personal use, it is not permitted to download, forward or distribute the text or part of it, without the consent of the author(s) and/or copyright holder(s), unless the work is under an open content license such as Creative Commons.
Abstract
This research is aimed to answer the main research question: to what extent we can use LiDAR point clouds directly in the PostgreSQL by means of FDW, and thus a FDW supporting the Point Cloud Data Management System is implemented. Then, the range and performance of its functionality are evaluated. The results shows this FDW solution is feasible while the querying time is relevant to the number of returned points. The benefit and problem of this FDW are analyzed.