–Mom, can we have G**gle Maps? –We have G**gle Maps at home
summary
Claim: avoid paid map APIs by importing OpenStreetMap dumps into PostgreSQL + PostGIS and running geospatial queries yourself. Tools demonstrated: pgmflex to ingest Planet PBF (full-planet load ~1.5 days), Nominatim and Photon for geocoding, Docker for loading, Leaflet/QGIS/Mapnik for display. Examples: ST_Contains for “is this point inside Chicago”, K-nearest searches, distance-based deduping using a 100 m threshold, and incremental OSM updates that make refreshes far faster than reloading the whole planet.
AI-written summary · about
chapters (14)
- 0:00Introduction and speaker intro
- 2:31What this talk covers
- 6:32How GIS works with databases
- 9:41Obtaining geographic data
- 15:33PostGIS and OpenStreetMap integration
- 19:27Why avoid external map APIs
- 20:29Downloading and ingesting OSM data
- 23:47Geocoding with Nominatim
- 26:38Photon for fuzzy searches
- 28:26Spatial queries in PostGIS
- 31:17Joins and real-world use cases
- 34:52Displaying maps with Leaflet
- 35:35Closing and contact info
- 36:05Q&A session
related talks
40mGIS capability of PostgreSql using POSTGIS & OSM DATA
16mSelf hosted GIS with open geo data - Real-world experience
37mProcessing Open Street Map Data with Python and PostgreSQL
21mThe Open Source Geospatial Community, PostGIS, & Postgres
46mGetting Down To Earth: Geospatial Analysis With Rails
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS
30mGeospatial analysis made easy with PostGIS and Geoalchemy
26mBuilding Geospatial GraphQL APIs By Leveraging GraphQL Database Integrations