/verkehrsunfallstatistik

Converts the Berlin Verkehrsunfallstatistik PDFs to GeoJSON

Primary LanguagePython

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