Energieschaufenster Berlin-Brandenburg - An application for presentations for the Brandenburg Technical University Cottbus.

The Task

Where, when and how do fluctuations occur between regenerative power generation and power consumption in the Berlin/Brandenburg region? How do weather and other events affect the generation and load situation in the region?

The project "SMART Capital Region" of the BTU Cottbus and its project partners addresses these and other questions. With the interactive application "Energy Shop Window Berlin-Brandenburg" it aims to illustrate influencing factors, dependencies and effects of very different events and occurrences in the power grids for differently qualified target groups.

In a dynamic web application, which can be presented primarily in the premises of the BTU Cottbus visitor centre, the changing "producer - load - situation" in the power supply network of the Berlin/Brandenburg area should be presented interactively.

Our Approach

The core element of the desired presentation application is an interactive map on which concrete moments of load and regenerative production in the region and its sub-regions can be displayed with the aid of various view options, settings and filters. For this purpose, the map accesses the historical data of the network operators, which are automatically fed into the system via a daily import.

Depending on the settings, you can make visible on the map:

  • Where how much is generated, where there is a high load, where there is a low load.

  • How different events and states affect generation and load. For example, the failure of one or more conventional power plants, high generation with low consumption at the weekend or meteorological events such as storms, calm or the "Bavarian sky" with lots of sunshine and clouds.

  • How renewable energies operate at different voltage levels in the distribution and transmission grid.

Utilization and power flow on the various network levels on a freely selectable day.
Effects of a registered meteorological event on capacity utilization and power flow.
History view of the power flows of a selected region on a specific day at a specific time.

Selected Features

  • Timeframe: The application offers the possibility to play back all events and states over a freely selectable period. During playback, all displayed data is updated in real time.

  • Chart view: An optional chart view shows - depending on the time - the curve of the measurement data.

  • Filters and view options: Various view settings (e.g. 2D/3D) and filter options (e.g. regional filtering by network operator) can be used to illustrate possible relationships.

  • Scenarios: All settings can be saved as scenarios and are available with a single click during a presentation.

  • Geodata: All map views (Berlin-Brandenburg, transmission network, distribution network, substations, etc.) are based on georeferenced data. Thus all data points have clear coordinates - an extension of the map views (e.g. by further lines) is possible without problems. In the application, the map views are displayed as SVG graphics.

  • Print function: Each view can be printed as JPG using the print function. The current view is created on the server in a print-optimized way and then offered for download.

For a first impression we have summarized the functions of the application here in a screencast (YouTube)​​​​​​​

Project details

  • URL:
  • Customer: Brandenburg University of Technology Cottbus Senftenberg
  • Branch: Universität
  • Realisation: 4 Months, 2016, Extensions 2018
  • Technology: D3.js Javascript library, responsive CSS framework "Amtrack" (in-house development), PHP framework Symfony, Qgis Geoinformationssystem, Gulp and Sass as development standards
  • Work: Conception, UI design, frontend and backend programming, training