Running Every Street in Paris with Python and PostGIS
summary
Claim: run every street in Paris and track coverage automatically. Extracts OpenStreetMap with osmnx, shapely, geopandas, PostGIS, cleans and dissolves edges into ~5,400 streets, imports GPX runs, densifies tracks, map matches by nearest-street projection, and upserts covered segments into PostGIS. Deployed server receives Strava webhooks and updates progress, currently 5,400 streets, 60% covered. Notes: Chinese postman routing proved hard, GPS error and intersection ambiguity remain, Viterbi/HMM is proposed for better matching.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 1:28Motivation
- 3:33Chinese postman problem
- 4:55GIS and spatial data basics
- 7:23PostGIS and PostgreSQL
- 8:06OpenStreetMap street networks
- 10:16Cleaning street data
- 12:22Inserting street data
- 12:45Processing GPX files
- 13:49Interpolating GPS data
- 14:30Map matching runs
- 16:15Visualizing coverage
- 18:00Updating progress
- 19:47Results and reflections
- 20:30Future work
- 21:55Q&A
related talks
41mHow to GIS with Python
37mProcessing Open Street Map Data with Python and PostgreSQL
25mUsing Python to Unlock Insights from OpenStreetMap Data at Scale
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
05mPostGIS & the Hard Rock Café collection
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS
26mBUILD YOUR OWN ELECTRIC VEHICLE CHARGING MAP WITH PostGIS
46mGetting Down To Earth: Geospatial Analysis With Rails