Parser for Berlin's yearly accident reports

Some accident reports of Berlin contain tables with rough locations of all accidents of certain types (e.g. involving bikes or pedestrians). This repository contains code to extract this data and geocode it.

The following make targets are available for bike accidents (pattern match with year):

• make data/accidents_points_%.geojson
• make data/accidents_streets_%.geojson

Prerequisites

• Python3
• Java to run Tabula on the command line
• GDAL with ogr2ogr
• Some shell utilities make, wget, perl
• PostgreSQL server with PostGIS enabled database, configure in Makefile

Resulting Data

• csvs/ - tables from PDFs
• data/ - geocoded and augmented data

Map / Visualization

• Map of data for 2018
• Map of data for 2017
• Map of data for 2016
• Map of data for 2015