ODIS Card Game: Open Data Top Trumps

The Open Data Supertrumpf card game transforms the diverse data of our capital Berlin into an exciting competition! In this game, it's not about horsepower or classic vehicle attributes, but rather about the unique characteristics of Berlin's districts and admin areas.

Each card represents one of the 58 admin areas, and open datasets allow for comparisons across different categories. For example, the 'airquality' category lets players explore where they can breathe fresh air in Berlin, the comparison in the 'number of fast food stalls lets you know where the most döner and currywurst options are likely found, and the category 'female street names' highlights the presence and recognition of significant women in Berlin, or the lack thereof.

The card game is fully based on Open Data. This repository contains all the python scripts for processing the data so that we could use them for the game. Go to scripts to learn about the data processing for the 6 categories, as well as information on the population and admin areas featured on each card:

• admin areas
• Population
• female street names
• solar potential
• airquality NO2
• degree of soil sealing
• fast food stalls
• response time fire brigade

Find the script createMaps.ipynb in maps to see how we created the maps for each admin area using the datawrapper API.

For more information about the game visit our Website.

Prerequisites

Ensure that the following prerequisites are met to run the scripts in this repository:

• Python 3.x
• Jupyter Notebook
• Required Python libraries: pandas, geopandas, matplotlib, shapely.geometry, datawrapper, os, json, time, copy, math, requests

Data

These are the sources of all used datasets. We downloaded the data in September 2024 and used it for our analyses.

• Admin Areas 2021: GDI Berlin

• Population 2024: Statistik Berlin Brandenburg

• Trade data 2024: IHK Berlin

• Female and male street names 2023: EqualStreetNames Project

• Response time fire brigade 2024: Berliner Feuerwehr (data downloaded from the map "Eintreffzeiten in den Prognoseräumen")

• Solar potential 2024: GDI Berlin

• Airquality 2024: INWT Statistics GmbH, on behalf of the Senate Department for Mobility, Transport, Climate Protection and the Environment. The airquality project is funded by the German Federal Ministry for Digital and Transport Affairs. (link will follow)

• Soil Sealing Area 2021: Umweltatlas

Contributing

Before you create a pull request, write an issue so we can discuss your changes.

Contributors

Thanks goes to these wonderful people (emoji key):

ckeuss 💻 🤔

Hans Hack 💻 🤔

anna 🤔 🎨

lisa-stubert 📖 🤔

This project follows the all-contributors specification. Contributions of any kind welcome!

Content Licensing

Texts and content available as CC BY.

Credits

Made by

A project by

Supported by