Add geocoordinates to your addresses in PostgreSQL
summary
Builds Python functions inside PostgreSQL that call OpenStreetMap nominatim and Overpass to resolve addresses extracted from OSM and the German foreign office dataset the pipeline loads ~4,700 embassy/address records runs one lookup every 20 seconds and returns ~3,900 resolved entries with a median error of 1.6 km 3,500 are within 200 m and ~3,000 within 25 m finds ~530 outliers over 200 m and exposes broken source coordinates and missing address fields, so it works but needs local data and curation and uses python untrusted functions to make network calls and Overpass export + JSONB load for bulk import.
AI-written summary · about
chapters (10)
- 0:00Introduction and speaker intro
- 2:14Why geocoordinates matter today
- 5:06OpenStreetMap basics and Nominatim
- 8:01Python function for geocoding
- 11:40Validating embassy data
- 16:17Loading data into PostgreSQL
- 20:13Using Overpass Tool for embassies
- 22:18Verifying OpenStreetMap addresses
- 27:04OpenStreetMap contributions and tips
- 28:30Q&A session
related talks
50mMaking use of OpenStreetMap data with Python
29mWhere have all the post offices gone? Discovering neighborhood facilities with Python and OSM
40mGIS capability of PostgreSql using POSTGIS & OSM DATA
43mLocate all the things
21mActual trees, not b-trees: or how I found PostgreSQL through PostGIS
23mDataEngBytes 2023 - BRI-T1-11 - Lizzie MacNeill
01h 41mOpenStreetWhat? Mapping The World With Open Data
05mPostGIS & the Hard Rock Café collection