Berlin Bike Theft Dashboard

This project provides an interactive Grafana dashboard on bicycle thefts in Berlin. The data source is the police dataset from the Berlin Open Data Portal, which is updated daily. A sample file for the year 2024 and the dataset description can be found in the assets folder of this repository. The data has been enriched with geographic information about the locations of the thefts.

Links

• Polizei Berlin LKA St 14 – Fahrraddiebstahl in Berlin (Berlin Open Data)
• Senatsverwaltung für Stadtentwicklung, Bauen und Wohnen – Lebensweltlich orientierte Räume (LOR) in Berlin
• Berlins Open Data Informationsstelle (ODIS) – Basisdatensätze von Berlin

How to Use the Dashboard

1. Clone this repository.

2. Start docker on your computer.

3. Run the command docker compose up in the directory of the cloned repository.

4. Access the dashboard at localhost:3000 in your web browser.

Further Ideas

Data Sources:

• Add meteorological data (weather, sunset, sunrise)
• Add information about public holidays
• Add more geographical data (population density)

Dashboard:

• Add trends (WoW, MoM, YoY growth rates)

Other:

• Store passwords in seperate .env file or as docker secrets
• Load dataset for 2024 as fallback if open data portal is not accessible
• Improve data loader (e.g. by using Apache Airflow instead of plain python script)