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.
In this blog post I will tell a small data story about farmland prices based on data of 2016. The data is mainly given by Statisches Bundesamt and Bundesanstalt für Geowissenschaften und Rohstoffe and the visualizations are made with the awesome open source library kepler.gl created by Shan He and her data visualization team at Uber.
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[…]