Welcome to 3DCityDB v5 Upgrade Scripts

"3DCityDB v5 Upgrade Scripts" (based on CityGML 3.0) created to provide a seamless upgrade solution for 3DCityDB v4 (based on CityGML 2.0 Encoding Standard) database instances. By this tool, users can easily upgrade their 3DCityDB v4 instances without any data loss and also they can keep to use the former tools by simulating old database structure.

Note, that 3DCityDB v5 is work in progress. We are still experimenting and make smaller changes to the relational schema while working on the implementation of the import/export tool and the upgrade scripts.

Key Features

  • No data loss at any moment
  • Tables in former databse structure can be simulated
  • All upgrade progress can be reverted

Upgrade Steps

  • (Command 1) Creating tables by considering new conceptual models.
  • (Command 2) Filling new tables with existing data on CityDB v4
  • (Command 3 or 5) Creating Views, which represent the data same as 3DCityDB v4, but collect the data from new tables.
  • (Command 4 or 6) These views or materialized views can be renamed as old tables at any moment.

install_script_at_start.png