Title
cjdb: A Simple, Fast, and Lean Database Solution for the CityGML Data Model
Author
Powałka, Leon (Student TU Delft)
Poon, Chris (Student TU Delft)
Xia, Yitong (Student TU Delft)
Meines, Siebren (Student TU Delft)
Yan, Lan (Student TU Delft)
Cai, Yuduan (Student TU Delft)
Stavropoulou, G. (TU Delft Urban Data Science)
Dukai, B. (3DGI)
Ledoux, H. (TU Delft Urban Data Science)
Contributor
Kolbe, Thomas H. (editor)
Donaubauer, Andreas (editor)
Beil, Christof (editor)
Date
2024
Abstract
When it comes to storing 3D city models in a database, the implementation of the CityGML data model can be quite demanding and often results in complicated schemas. As an example, 3DCityDB, a widely used solution, depends on a schema having 66 tables, mapping closely the CityGML architecture. In this paper, we propose an alternative (called ‘cjdb’) for storing CityGML models efficiently in PostgreSQL with a much simpler table structure and data model design (only 3 tables are necessary). This is achieved by storing the attributes and geometries of the objects directly in JSON. In the case of the geometries we thus adopt the Simple Feature paradigm and we use the structure of CityJSON. We compare our solution against 3DCityDB with large real-world 3D city models, and we find that cjdb has significantly lower demands in storage space (around a factor of 10), allows for faster import/export of data, and has a comparable data retrieval speed with some queries being faster and some slower. The accompanying software (importer and exporter) is available at https://github.com/cityjson/cjdb/ under a permissive open-source license.
Subject
CityGML
3DCityDB
3D modelling
DBMS
CityJSON
To reference this document use:
http://resolver.tudelft.nl/uuid:2caaaa11-b205-4021-8f34-c6d5ad8f38a7
DOI
https://doi.org/10.1007/978-3-031-43699-4_47
Publisher
Springer, Cham
Embargo date
2024-08-21
ISBN
978-3-031-43698-7
Source
Recent Advances in 3D Geoinformation Science: Proceedings of the 18th 3D GeoInfo Conference
Event
18th 3D Geoinfo Conference, 2023-09-12 → 2023-09-14, Technical University of Munich, Munich, Germany
Series
Lecture Notes in Geoinformation and Cartography, 1863-2246
Bibliographical note
Green Open Access added to TU Delft Institutional Repository 'You share, we take care!' - Taverne project https://www.openaccess.nl/en/you-share-we-take-care Otherwise as indicated in the copyright section: the publisher is the copyright holder of this work and the author uses the Dutch legislation to make this work public.
Part of collection
Institutional Repository
Document type
conference paper
Rights
© 2024 Leon Powałka, Chris Poon, Yitong Xia, Siebren Meines, Lan Yan, Yuduan Cai, G. Stavropoulou, B. Dukai, H. Ledoux