This repo contains Bußgelddaten (Data of parking fines) for Cologne, Germany.
The data was downloaded here: 2020, 2021.
The parking fine codes can be translated to useful names using the tatbestandskatalog.pdf (Download link).
There are a few Bash and Elixir scripts in this repo. Here is what they do and how to use them:
This script combines all monthly datasets into a single Komplett_YEAR.csv per year.
You can run it by first making it executable with
chmod 755 ./Scripts/combine_files.sh
and then running the script with:
cd Scripts
./combine_files.sh
You can easily import the data into a local Postgres database using Mix.Tasks.ImportData.
First, make sure that you have a Postgres instance running and it is available at http://localhost:5432.
Next, set up the Phoenix application:
cd app
mix deps.get
mix ecto.setup
This will fetch the dependencies and set up a local bussgelder_dev database.
Now, you can import the data with:
mix import_data bussgelder ../Daten/2020/Komplett_2020.csv
mix import_data bussgelder ../Daten/2021/Komplett_2021.csv
This will import all data into the database and create indices for all columns.
You can also import all locations with their latitude and longitude with:
mix import_data orte ../Daten/Alle-Orte-mit-Lat-Long.csv