Safer Cyling – using car accident data to find safe routes in Koblenz

This blog post will contain a description of the routing algorithm that was implemented on the 23.11. – 25.11.2018 on the debeka hackquarter to find safer cycling routes in Koblenz. It uses Java EE (wildfly), PostgreSQL and pgRouting for the backend. The frontend was implemented using mapbox JS GL. The source can be found on github. The whole coding took around 8 hours for 2 persons. During the presentation the following summary was visualized:

[…]

PostGIS 2.3 parallel performance 2 times faster on PostgreSQL 9.6 on a real live example

This blog post will show an example for the parallel query processing capabilities from PostGIS 2.3 running on PostgeSQL 9.6. It is based on the project Lebensriskoexplorer. The data that I am using are exported from my google location history from 2015. The region data is taken from the Bundesamt für Kartographie und Geodäsie. So overall Read more about PostGIS 2.3 parallel performance 2 times faster on PostgreSQL 9.6 on a real live example[…]