Waterways from OpenStreetMap as SVG
Published:
Rivers and streams create organic, recognizable shapes that work well as design elements. Here I extract the waterway network around Offenbach am Main from OpenStreetMap and export it as a clean SVG.
Blog posts
2025
70 Years of Temperature Data in Offenbach
Published:
Almost 70 years of temperature data from Offenbach (1957–2025), based on over 20,000 daily measurements from the German Weather Service (DWD).
Isochrone Maps with Python
Published:
Isochrone maps show areas reachable within a given travel time from a starting point. This project combines OSRM travel time calculations with satellite-derived elevation data to produce maps that show both accessibility and topography.
Bundestagswahl 2025: Offenbach by Wahlbezirk
Published:
Offenbach has voted. Here’s how the 79 polling districts (Wahlbezirke) went, mapped by Zweitstimme (second vote) winner. The 24 postal voting districts are excluded.
2024
All Roads Lead to Offenbach
Published:
10,000 randomly placed points across Europe, each routed to Offenbach am Main via OSRM.
2023
Vehicle Fleet by Fuel Type in Offenbach
Published:
Four views of the vehicle fleet in registration district Offenbach am Main (Stadt, 06413), based on data from the Kraftfahrt-Bundesamt (KBA).
Bicycle Counter at the Harbor: A Year in Rides
Published:
The bike path along Offenbach’s harbor has a bicycle counter. This calendar heatmap shows the daily count for all of 2022.
Surface Temperature of Offenbach from Landsat Satellite Data
Published:
Surface temperature maps of Offenbach derived from Landsat satellite imagery between 2017 and 2022. The first image shows the highest recorded temperature in that period (in the Waldhof industrial area). The second shows the lowest – the roof of a company specializing in cooling and climate technology. Make of that what you will.
Public Transit from Offenbach to Frankfurt Hauptbahnhof
Published:
How long does it take from your front door to Frankfurt Hauptbahnhof by public transit? This map color-codes the travel time from every building in Offenbach to Frankfurt Hbf.
How Long by Bike to the Wilhelmsplatz?
Published:
Local bike isochrone map centered on the Wilhelmsplatz in Offenbach. Color steps are 2-minute intervals – yellow means you’re within two minutes of the market square, darker colors mean longer rides.
PM10 on Silvester: 2022 Update
Published:
Update to the earlier PM10 comparison, now covering five years (2018–2022) of hourly fine particulate matter readings from the Untere Grenzstraße station in Offenbach.
2022
Bike Isochrone Map: Cycling Times from Offenbach to Every Municipality in Germany
Published:
A companion piece to the car isochrone map. This time: cycling routes from Offenbach to every municipality in Germany, calculated with OSRM. Travel times are in hours, color-coded.
Animating Traffic Flow in Offenbach with HERE Data
Published:
An animation of relative traffic volume on Offenbach’s main roads throughout the day. Yellow = high traffic, blue = low traffic, white = no data available. The traffic data was collected from the HERE Traffic API over several weeks.
Flight Movements Over Offenbach
Published:
About 3,700 recorded flight movements over Offenbach am Main in one week (March 22–29). Red lines are low-altitude flights (around 4,000 ft / 1.2 km), blue lines are at cruise altitude (35,000–40,000 ft / 10–12 km).
Offenbach Nationalities 2000–2017: A Bar Chart Race
Published:
An animated bar chart race showing how the nationality composition of Offenbach am Main shifted between 2000 and 2017. The data comes from the city’s statistical yearbooks (Statistische Jahrbücher), showing the top 10 nationalities per year by total population (men + women).
Every Street in Offenbach by Bike
Published:
New year’s resolution: more exercise? The idea here is a single bike route that covers every street in Offenbach at least once while keeping redundant riding to a minimum. This is the Chinese Postman Problem.
PM10 on New Year’s Eve: The Fireworks Ban in the Data
Published:
Average hourly PM10 concentrations at the Untere Grenzstraße monitoring station in Offenbach, measured across three consecutive New Year’s Eves (2018, 2019, 2020).
2021
Weather Heatmaps from the Wetterpark Offenbach
Published:
Four heatmaps covering a full year of weather data from the Wetterpark in Offenbach am Main (2020). Each cell is one day, each column is one month.
2018
Install neo4j on Ubuntu 14.04 VPS
Published:
A short note on installing the neo4j graph database on a Ubuntu 14.04 virtual private server (VPS).
2017
Detailed Netflix Categories
Published:
I’ll just leave that here…
This is a list for a detailed category search on Netflix. Just click an ID to look up movies of a particular category or append the ID to the following URL:
https://www.netflix.com/browse/genre/
Raspberry Pi Sous-Vide Cooker
Published:
** Things you need:**
- Raspberry Pi (obviously, have a RaspPi 3B here, standard Raspbian OS)
- GPIO T-Cobbler & breadboard (e.g. this one)
- Solid State Relay AC DC 3-32V to 24-480V (like this)
- Thermo sensor (like this)
- Immersion heater (with enough power) (here)
- Small aquarium pump (optional)
- A big box or a pan. (I have the SAMLA box from IKEA, 65 liter)
- 1 Transistor
- 4.7kΩ Resistor
- Some jumper wires
- (Soldering bolt & tin solder)
Filter Local BLAST database
Published:
There is not much to say about this one. Just a note for later use.
Setup gitlab-ce 9.0 on a vServer running Ubuntu 14.04 with Plesk 12
Published:
Recently, I had some struggle to get a GitLab instance running on my virtual server. Since I have no or minimal knowledge of configuring a server, Plesk seem to help a lot. Nevertheless, there are some differences between installing GitLab on a Plesk server and installing it on a raw apache setup. Following steps seem to work: