In order to plan suitable preventative measurements for the German road infrastructure on time regarding the impact of climate change on the condition of infrastructure, an extensive database with all relevant road and bridge data as well as all climatic data is needed. All available data sources are evaluated and fed into this central road database.
Sustainable development and maintenance of traffic infrastructure is a part of every country’s strategic tasks. For this reason, it is important to know, which impact climate change may have on the infrastructure’s condition. With this knowledge, suitable preventive measurements can be planed on time.
An extensive database with all relevant road and bridge data as well as with climatic data is needed to realise the required evaluations. The main goal of the hereby presented research work has been the analysis of the availability of necessary road infrastructure data. All available data sources, first off federal database systems, had been evaluated taking the following criteria under account: actuality, completeness, quality and originality of data. Data Interfaces (possibility for data-import) had also been considered.
Finally, the following database-sources (BASt) had been chosen for road data import:
- IT-ZEB-Server (Network Data, Pavement Condition Data, Road Geometry Data)
- SIB-Bauwerke (Bridge and Tunnel Data Quality of data)
- ZAM (Pavement Construction Data)
- BISSTRA (Traffic Data)
Further, climate data from IEG-files from the Climate Service Center has been adopted.
A new database for the analysis-system has been implemented at the BASt data processing centre. In order to reach the project-goals optimally, the contractor has decided to split the database into two levels: object database and grid database.
The resolution and level of detail of data from the object database is similar to the data from the original data pool. In the grid database object data is aggregated to grid-elements of 10km x 10km because the climate data refers to such a grid. The user can define the aggregation’s formula. All climate data has been directly adopted into the grid database.
Beyond that, an analysis-platform based on this database has been developed. The task of this platform is to prove, that the database-concept is correct and guarantees the required flexibility and sufficient high performance. The following functions are implemented:
- Creation of thematic grid maps
- Presentation of selection-results on grid maps
- Presentation of selection-results on the object map.
The database and the analysis-system had been developed above all as prototypes in order to prove the feasibility of this solution. The system is characterized by high flexibility. Even on the present prototype-stage it can be used for various practical purposes. Thanks to the implemented universal platform, the system is highly extensible. This allows the inclusion of new data-groups and extension for other evaluations.