Converts the Berlin Verkehrsunfallstatistik PDFs to GeoJSON
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
csvs
data
geo
.gitignore
Makefile
README.md
collect_streets.py
download.sh
generate.py
parser.py
requirements.txt
run_parser.sh

README.md

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