§ 03Thoughts: essays, updates, notes
Recent thoughts.
Short pieces on tools, pipelines, spatial methods and the occasional rant.
Loading…
Featured · EXPLANATION
EXPLANATION2026-05
Estimating Italian postcode boundaries with OSM and Voronoi diagrams
Four attempts at the same problem: centroid assignment, OSM address Voronoi, kNN outlier removal, and island consolidation. The fourth worked. Calibrated on Dutch and Danish authoritative data; applied to 4,209 Italian CAP polygons.
Read the piece →02
2026-06
When do metro openings capitalise into rents? Not when you think.Across seven European cities the price step shows up at maturity, two or more years after opening, not at announcement or delivery. A staggered DiD result that held every leave-one-city-out check.
RESEARCH
03
2026-04
The case against dashboardsWhy opinionated internal tools outperform generic dashboards for real estate teams, with five examples from the past year.
THOUGHT
04
2026-03
Why we switched to H3 for real-estate geoindexingTrading quadkeys for hexagons: what changed in query latency, cache hit-rate, and analyst ergonomics.
EXPLANATION
05
2026-01
PostGIS vs DuckDB for analyst queriesWhen each wins, and how we route analyst notebooks to the right backend without them noticing.
EXPLANATION
06
2025-11
Replacing three paid isochrone vendorsHow we built a sub-200ms in-house isochrone API on OSRM + GTFS and retired three recurring contracts.
EXPLANATION