Blog-Beiträge

2025

Waterways from OpenStreetMap as SVG

1 Minuten Lesezeit

Veröffentlicht:

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.

70 Years of Temperature Data in Offenbach

1 Minuten Lesezeit

Veröffentlicht:

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

3 Minuten Lesezeit

Veröffentlicht:

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

1 Minuten Lesezeit

Veröffentlicht:

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

1 Minuten Lesezeit

Veröffentlicht:

10,000 randomly placed points across Europe, each routed to Offenbach am Main via OSRM.

2023

Vehicle Fleet by Fuel Type in Offenbach

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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?

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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.

2022

Animating Traffic Flow in Offenbach with HERE Data

1 Minuten Lesezeit

Veröffentlicht:

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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

A short note on installing the neo4j graph database on a Ubuntu 14.04 virtual private server (VPS).

2017

Detailed Netflix Categories

6 Minuten Lesezeit

Veröffentlicht:

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

3 Minuten Lesezeit

Veröffentlicht:

** 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

weniger als 1 Minuten Lesezeit

Veröffentlicht:

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

2 Minuten Lesezeit

Veröffentlicht:

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: