Beuth Hochschule für Technik Berlin

Management and Analytics on Geotemporal Data (MAGDa)

Traffic Heatmap Service

Our Heatmap application aggregates GPS signals send by taxi cabs in the city of Dresden in a rectagular grid. The user can choose between displaying an aggregation of the number of signals and the average speed with different at different scale. The application should help drivers and companies to plan their daily trips by providing an interactive web map visualization which is easy to read and to use. Within the ExCELL project we will extend this solution to a web service where a user can create his own heatmaps selecting different data sources, hot spot analysis methods and display forms. Computation is done by Apache Spark and Apache Impala.


Route Blocker

Dresden Route Blocker is a web map application to demonstrate which alternative routes taxi cabs would take in case of sudden block events on certain streets. The data represents historic Floating Car Data (FCD) from a taxi company of Dresden. The origin and destination of single trips were used to feed a routing engine (Graphhopper). The retrieved track is animated using the D3.js library. If a user clicks into the map a route blocking service from the ExCELL plattform is called which also triggers a rerouting of all currently running trips. If a road intersects a route of a taxi, the user will see, that the car will take another way to drive around the blocked network element.

With this interactive component the user understands, how the ExCELL plattform enables for smart mobility and transportation management in real-time.

Click here to learn more about the app.


The Stauatlas is a web application that visualizes the traffic at road sensors in the city of Dresden. Therefore, we applied data from the year 2014 and analyzed the maximum speed at road segments to recognize traffic jams. If the average speed at a specific sensor is below a certain threshold, our Stauatlas shows an orange or red colored scale. With the help of the Stauatlas, city planners and commuters have an application to find areas and roads with a high traffic volume. In the future, we want to use live streaming data to feed into our Stauatlas ETL pipeline. Additionally, we are planning to implement our Stauatlas in other cities.

You can test the Stauatlas here.

Stand: 10.08.17Seite ausdrucken Zum Seitenanfang