Further Development of a QGIS Plugin for the CityGML 3D City Database

Master thesis (2023)

Authors

T. Mbwanda Architecture and the Built Environment

Contributors

G. Agugiaro Urban Data Science - Architecture and the Built Environment (mentor)
C.A. León Sánchez Urban Data Science - Architecture and the Built Environment (mentor)
Faculty
Architecture and the Built Environment, Architecture and the Built Environment
Copyright: © 2023 Tendai Mbwanda
More Info
expand_more

Published Date

20-06-2023

Language

English

Reuse Rights

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.

Faculty

Architecture and the Built Environment

Abstract

Diversity in the use cases of semantic 3D city models today is unprecedented. A key enabler for this is the CityGML standard developed by the OGC to facilitate storing and exchanging these city models. Nevertheless, CityGML only provides object definitions which cater for a wide range of applications, making necessary the need to attach additional semantic information specific to each domain. For this reason, CityGML was designed with generic components that allow it to be extended. Alternatively, an extensibility mechanism that strengthens semantic interoperability in data exchange is the ADE. An example is the Energy ADE which augments CityGML for Urban Energy Modelling at single-building and city-wide scales. Base CityGML datasets are commonly encoded using the XML, though there are other encodings based on the JSON and SQL. The latter encoding is favourable for its associated benefits that come from the underlying DBMS. The 3DCityDB , upon which this thesis is based, is one such encoding that is open source and developed for PostgreSQL and Oracle. It has a complex structure which makes it difficult for users without extensive knowledge of CityGML, databases and SQL to access data. Hence, the 3DCityDB-Tools plugin was developed to simplify user interaction with the 3DCityDB using QGIS. However, encoding an extended CityGML dataset in the 3DCityDB adds greater complexity to a system that is already complex. In addition, 3DCityDB-Tools currently has no support for ADEs. On this backdrop, this research was initiated to investigate the extent to which ADE support can be introduced to the 3DCityDB-Tools plugin. Its server-and-client-side components are further developed to have extended layers that interact with data in 3DCityDB tables, can be managed from the GUI in QGIS and whose attributes are editable. This was achieved in an incremental and iterative process while maintaining the current architecture and user experience of the plugin. Areas identified for future development relate to the underlying database encoding of CityGML and capabilities not yet supported.