Solving a Secure Geocoding Problem (That Hardly Anybody Has)
summary
Desktop GUI that geocodes patient addresses entirely on the local machine using shell, Docker, Postgres/PostGIS and Python, pulls county line files into a Docker-hosted database, runs PostGIS geocoding locally, and can attach census-tract social determinants and export CSV or shapefile with optional jitter. The prototype geocodes 3,000 patient addresses with 85% success from the Python pipeline plus another 5% recovered by an R fallback. It produces usable outputs but packaging into a clickable executable currently requires launching from a terminal.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 0:46Why build a secure codefree geocoder
- 6:42Building understanding with tools
- 10:55New tools together
- 14:39Demos
- 18:02Conclusion
related talks
53mBreakout Session
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
19mThe Power of GeoDjango
30mGeospatial analysis made easy with PostGIS and Geoalchemy
28mA pythonista’s pipeline for large scale geospatial analytics
16mMapping the Census with PostGIS, Python, and...
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS
46mGetting Down To Earth: Geospatial Analysis With Rails