3DCityDB - a 3D geodatabase solution for the management, analysis, and visualization of semantic 3D city models based on CityGML

Over the last decade, more and more cities and even countries worldwide are creating semantic 3D city models of their physical environment based on the international CityGML standard issued by the Open Geospatial Consortium (OGC). CityGML is an open data model and XML-based data exchange format describing the most relevant urban and landscape objects along with their spatial and non-spatial attributes, relations, and their complex hierarchical structures in five levels of detail. 3D city models, which are structured according to CityGML, are often used for various complex GIS simulation and analysis tasks, which go far beyond pure 3D visualization. Due to the large size and complexity of the sometimes country-wide 3D geospatial data, the GIS software vendors and service providers face many challenges when building 3D spatial data infrastructures for realizing the efficient storage, analysis, management, interaction, and visualization of the 3D city models based on the CityGML standard. Hence, there has been strong demand for an open and comprehensive software solution that can provide full support of the aforementioned functionalities. The ‘3D City Database’ (3DCityDB) is a free 3D geo-database solution for CityGML-based 3D city models. 3DCityDB has been developed as an Open Source and platform-independent software suite to facilitate the development and deployment of 3D city model applications. The 3DCityDB software package consists of a database schema for spatially enhanced relational database management systems (ORACLE Spatial or PostgreSQL/PostGIS) with a set of database procedures and software tools allowing to import, manage, analyze, visualize, and export virtual 3D city models according to the CityGML standard. Within this paper, the software suite is illustrated and explained in detail with respect to the related technical implementations and the underlying conceptual software design. Moreover, the utilization of 3DCityDB in different projects and practical application fields are also presented in this paper.

[1]  Steven K. Feiner,et al.  Computer graphics: principles and practice (2nd ed.) , 1990 .

[2]  Ralph Johnson,et al.  design patterns elements of reusable object oriented software , 2019 .

[3]  Wolfgang Keller.  Mapping Objects to Tables A Pattern Language , 1997 .

[4]  M. Carter.  Computer graphics: Principles and practice , 1997 .

[5]  Thomas Ertl,et al.  Computer Graphics - Principles and Practice, 3rd Edition , 2014 .

[6]  Daniela Florescu,et al.  Storing and Querying XML Data using an RDMBS , 1999, IEEE Data Eng. Bull..

[7]  Vishu Krishnamurthy,et al.  Performance Challenges in Object-Relational DBMSs , 1999, IEEE Data Eng. Bull..

[8]  Jun Li,et al.  GML Storage: A Spatial Database Approach , 2004, ER.

[9]  Thomas H. Kolbe,et al.  Spatio-semantic coherence in the integration of 3D city models , 2007 .

[10]  Thomas H. Kolbe,et al.  Representing and Exchanging 3D City Models with CityGML , 2009 .

[11]  Thomas H. Kolbe,et al.  Making interoperability persistent : A 3D geo database based on CityGML , 2009 .

[12]  Il-Yeol Song,et al.  Relational versus non-relational database systems for data warehousing , 2010, DOLAP '10.

[13]  Thomas H. Kolbe,et al.  Value-added Services for 3D City Models using Cloud Computing , 2012 .

[14]  Karl-Heinz Häfele,et al.  OGC City Geography Markup Language (CityGML) Encoding Standard , 2012 .

[15]  Hugo Ledoux,et al.  On the Validation of Solids Represented with the International Standards for Geographic Information , 2013, Comput. Aided Civ. Infrastructure Eng..

[16]  Volker Coors,et al.  Geometric-Semantical Consistency Validation of CityGML Models , 2013 .

[17]  Thomas Becker,et al.  Semantic 3D modeling of multi-utility networks in cities for analysis and 3D visualization , 2013 .

[18]  Sisi Zlatanova,et al.  Establishing a national standard for 3D topographic data compliant to CityGML , 2013, Int. J. Geogr. Inf. Sci..

[19]  Thomas H. Kolbe,et al.  Cloud-basierter 3D-Webclient zur kollaborativen Planung energetischer Maßnahmen am Beispiel von Berlin und London , 2014 .

[20]  Jie Cao,et al.  NOSQL based 3d city model management system , 2014 .

[21]  Yasin N. Silva,et al.  Similarity join for big geographic data , 2014 .

[22]  Carlos Eduardo S. Pires,et al.  NoSQL Geographic Databases: An Overview , 2014 .

[23]  Filip Biljecki,et al.  Applications of 3D City Models: State of the Art Review , 2015, ISPRS Int. J. Geo Inf..

[24]  Volker Coors,et al.  An integration of urban spatial data with energy simulation to produce X3D city models: the case of Landkreis Ludwigsburg , 2015, Web3D.

[25]  T. Kolbe,et al.  CityGML goes to Broadway , 2015 .

[26]  Moritz Lauster,et al.  Genesis of the CityGML Energy ADE , 2015 .

[27]  M. Kada,et al.  Potential of Graph Databases in Representing and Enriching Standardized Geodata , 2016 .

[28]  Thomas H. Kolbe,et al.  Extending Semantic 3D City Models by Supply and Disposal Networks for Analysing the Urban Supply Situation , 2016 .

[29]  Alexander Simons,et al.  Multimodal Location Based Services - Semantic 3D City Data as Virtual and Augmented Reality , 2016, LBS.

[30]  T. H. Kolbe,et al.  INTEGRATING DYNAMIC DATA AND SENSORS WITH SEMANTIC 3D CITY MODELSIN THE CONTEXT OF SMART CITIES , 2016 .

[31]  Filip Biljecki,et al.  Proposal for a new LOD and multi-representation concept for CityGML , 2016 .

[32]  Claus Nagel,et al.  Using glTF for streaming CityGML 3D city models , 2016, Web3D.

[33]  P. Tymków,et al.  3D GIS for flood modelling in river valleys , 2016 .

[34]  G. Agugiaro,et al.  FIRST STEPS TOWARDS AN INTEGRATED CITYGML-BASED 3D MODEL OF VIENNA , 2016 .

[35]  Andreas Donaubauer,et al.  Integrating and Managing the Information for Smart Sustainable Districts - The Smart District Data Infrastructure (SDDI) , 2017 .

[36]  Thomas H. Kolbe,et al.  Solar Potential Analysis and Integration of the Time-Dependent Simulation Results for Semantic 3d City Models Using Dynamizers , 2017 .

[37]  Sabine Koch,et al.  Representation of CityGML Instance Models in BaseX , 2017 .

[38]  Thomas H. Kolbe,et al.  Future City Pilot 1 Engineering Report , 2017 .

[39]  Thomas H. Kolbe,et al.  Spatio-Semantic Comparison of Large 3D City Models in CityGML Using a Graph Database , 2017 .

[40]  A. Konde,et al.  Web enabled spatio-temporal semantic analysis of traffic noise using CityGML , 2017 .

[41]  Y. Ghassoun,et al.  Comparison of 2D & 3D Parameter-Based Models in Urban Fine Dust Distribution Modelling , 2017 .

[42]  T. H. Kolbe,et al.  CITYGML AND THE STREETS OF NEW YORK -A PROPOSAL FOR DETAILED STREET SPACE MODELLING , 2017 .

[43]  Thomas H. Kolbe,et al.  Dynamically Extending Spatial Databases to support CityGML Application Domain Extensions using Graph Transformations , 2017 .

[44]  Thomas H. Kolbe,et al.  Applications of 3D City Models for a Better Understanding of the Built Environment , 2018 .

[45]  Jörg Blankenbach,et al.  CityGML goes mobile: application of large 3D CityGML models on smartphones , 2019, Int. J. Digit. Earth.