3D digital city models, important for urban planning, are currently constructed from massive point clouds obtained through airborne LiDAR (Light Detection and Ranging). They are semantically enriched with information obtained from auxiliary GIS data like Cadastral data which contains information about the boundaries of properties, road networks, rivers, lakes etc. Technical advances in the LiDAR data acquisition systems made possible the rapid acquisition of high resolution topographical information for an entire country. Such data sets are now reaching the trillion points barrier. To cope with this data deluge and provide up-to-date 3D digital city models on demand current geospatial management strategies should be re-thought. This work presents a column-oriented Spatial Database Management System which provides in-situ data access, effective data skipping, efficient spatial operations, and interactive data visualization. Its efficiency and scalability is demonstrated using a dense LiDAR scan of The Netherlands consisting of 640 billion points and the latest Cadastral information, and compared with PostGIS.

Additional Metadata
Stakeholder Monet DB Solutions, Geodan, Netherlands
Persistent URL dx.doi.org/10.1145/2996913.2997005
Conference ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems
Citation
Pereira Goncalves, R.A, van Tilburg, T, Kyzirakos, K, Alvanaki, F, Koutsourakis, P, van Werkhoven, B, & van Hage, W.R. (2016). A spatial column-store to triangulate the Netherlands on the fly. In GIS: Proceedings of the ACM International Symposium on Advances in Geographic Information Systems. doi:10.1145/2996913.2997005