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:
In this blog post I will post a visualization of my trips between 2015 and 2018 mainly in germany. Further it contains the Java code that I used to convert the proprietary JSON format used by the google maps timeline for locations logs into a csv file.