WELCOME
The award winning 3D City Database is a free geo database to store, represent, and manage virtual 3D city models on top of a standard spatial relational database. The database schema implements the CityGML standard with semantically rich and multi-scale urban objects facilitating complex analysis tasks, far beyond visualization. 3DCityDB is in productive and commercial use for more than 14 years in many places around the world. It is also employed in numerous research projects related to 3D city models.
The 3D City Database comes with tools for easy data exchange and coupling with cloud services. The 3D City Database content can be directly exported in KML, COLLADA, and glTF formats for the visualisation in a broad range of applications like Google Earth, ArcGIS, and the WebGL-based Cesium Virtual Globe.
3D City Database
- Spatial relational database schema for semantic 3D city models
- All thematic modules from CityGML 2.0 included
- Five different Levels of Detail (LODs)
- Appearance data (e.g. textures, colors) in addition
to flexible 3D geometries - Supports generic and prototypical 3D objects
- Complex digital terrain models (DTMs)
- Web Feature Service (WFS) interface
- Works with Oracle Spatial 10g, 11g, 12c and 19c (Spatial and Locator), or PostGIS 2.0 or higher
- Docker containers available for quick setup and cloud operation
3D City Database
Importer/Exporter
- Full support for importing/exporting of CityGML 2.0 and 1.0 datasets; support for tiled import/export
- Support for importing/exporting CityJSON datasets
- Export of KML/COLLADA/glTF models to be used with GIS and Digital Globe Browsers like ArcGIS, CesiumJS, Google Earth, or iTowns
- Generic KML information balloons
- Reading/writing CityGML documents of arbitrary file size; gzip & zip compression supported
- Powerful query & filter capabilities
- Multithreaded programming facilitating high-performance processing
- Resolving of forward and backwards XLinks
- XML validation of CityGML documents
- User-defined Coordinate Reference Systems
- Coordinate transformations for CityGML exports
- Export of thematic data to spreadsheets (CSV and Microsoft Excel)
- Batch mode & Graphical User Interface
3DCityDB-
Web-Map-Client
- Extension of the CesiumJS 3D virtual globe by:
- Support for efficient displaying, dynamic loading and unloading of large 3D visualization models in the form of tiled KML/glTF datasets exported from the 3DCityDB using the Importer/Exporter
- Layer management for adding and removing an arbitrary number of data layers like 3D visualization model (KML/glTF), 3DTiles datasets, WMS imagery layer, and Cesium digital terrain model
- 3D visualization models can be linked with Google Spreadsheets or database tables via PostgREST for dynamic querying of thematic data for clicked 3D objects
- Rich interaction with 3D visualization models, e.g. highlighting of 3D objects on mouse-over and mouse click as well as hiding of selected 3D objects
- Toggle shadow casting for 3D objects and terrain
- Explore a selected 3D object from different view perspectives using third-party services like Microsoft Bing Maps oblique view, Google Streetview, and a combined version (DualMaps)
- Save and share 3DCityDB web client projects using scene links (everything is stored in the URL)
PARTNERS
The 3D City Database V4 and its tools have been jointly developed by the following partners:
Funding Support
The project has been financially supported by
- the European Regional Development Fund (ERDF),
- the European Knowledge and Innovation Community on Climate Change and Mitigation (EIT Climate-KIC),
- CADFEM International GmbH,
- and the Government Technology Agency of Singapore (GovTech).