Bicycle Counter at the Harbor: A Year in Rides

The bike path along Offenbach’s harbor has a bicycle counter. This calendar heatmap shows the daily count for all of 2022.

Peak day: 4,746 cyclists on a sunny Sunday in May (15.05.22). Lowest: 142 on December 19th – a cold, rainy Monday. Summer vs. winter is obvious, but the week-level patterns are interesting too: weekends consistently outperform weekdays, and a few rainy summer days drop below their surrounding weeks.

Data source

The data comes from the eco-counter API (Hafen Messstation, id 300023687). The counter distinguishes inbound and outbound directions across four channels. All public bicycle counting stations in Hesse are available via raddaten-hessen.de.

import requests
import pandas as pd
import seaborn as sns

# eco-counter API for the Hafen station
station_id = 300023687
flow_id = 353306686

# Fetch daily counts, pivot into calendar form, plot as heatmap
sns.heatmap(pivot, annot=True, fmt='d', cmap='YlOrRd')