Data

Data Collection and Data Platform

Transport in Figures

Transport in Figures is an annual report compiled by DIW Berlin on behalf of the German Federal Ministry of Transport and Digital Infrastructure (BMVI). The compendium presents statistical data on numerous aspects of the German transport sector. The annually updated edition is published in the fall and can be ordered through BMVI.

The following information and yearly statistics are included:

    Transport in its institutional framework:

    • Gross fixed capital formation
    • Gross and net fixed assets
    • Employees, receipts, gross value added
    • Characteristic figures of all transport sectors


    Transport in functional categories:

    • Population, employees, private households
    • Modal split of employees and pupils
    • Length of the infrastructure, road land
    • Rate of motorization, road traffic flow
    • Expenses for traffic, net position on transport
    • Motor vehicles - fleet, registrations, mileage, driving licences
    • Fleet of civil planes and bycicles
    • Road accidents, killed and injured persons, accident causes
    • Cross border traffic, transit, road haulage by countries
    • Seaborne traffic
    • Passenger traffic, volume and performance
    • Public and private transport, traffic purposes and non-motorized traffic
    • Freight transport, volume and performance
    • Cargo rates, consumer price indices, development of costs
    • Motor vehicle expenditures of private households, cost-of-living index
    • Energy consumption and environmental pollution datas


    International indicators of transportation

    Contact Transport in Figures

    OPSD

    In connection with quantiative modeling, various types of energy market data are collected and maintained in the department. In doing so, we increasingly follow an open-source approach, for example in the context of the Open Power System Data project.

    Open Power System Data provides a free-of-charge platform for open data dedicated to electricity system researchers. Its aim is to collect, check, process, document, and publish data that are publicly available but currently inconvenient to use. The platform primarily provides information on installed generation capacity, power plants, and time series of electricity consumption as well as wind and solar generation in Europe. The platform was initially developed by a consortium consisting of DIW Berlin, Europa-Universität Flensburg, TU Berlin, and neon Neue Energieökonomik in a research project funded by the German Federal Ministry for Economic Affairs and Energy.

    Website

    OPSD platform

    In 2017, Open Power System Data won Schleswig-Holstein's "Open Science Award" and the "Germany - Land of Ideas" award.

    logo_land_der_ideen_2017.jpg

    Selected graphs

    Using OPSD data, we illustrate the development of the average daily residual load in Germany between 2010 and 2018. We subtract hourly electricity generation of wind and solar power plants from total load and calculate a daily average over the whole year. The resulting curve shows the load that has to be served by other power plants. It can be seen how the expansion of wind and solar power reduces this residual load over time.

    And here is an alternative graph that only shows daily averages for the month of July between 2010 and 2018. Here, the impact of solar energy at daytime is particulary strong. Such graphs are also referred to as "duck curves" in the literature - although often focussing on decentral solar PV. This graph, in contrast, covers also utility-scale solar PV and wind power.

    We also use the data platform for our own research activities. Papers that draw on OPSD data include:

    Contact OPSD