Building Geographical APIs with Open Data, PostgreSQL & PostGIS
summary
Building dozens of geographic APIs from open data sources (GeoRisques, IGN, INSEE, etc.) using PostgreSQL and PostGIS. It explains how the teams processed and understood open data, stored and queried spatial data in PostgreSQL/PostGIS, designed and documented the APIs, implemented testing (unit tests, Testcontainers, end-to-end), and worked on performance and optimizations.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 1:03Project goals
- 23:53Open data sources
- 53:40Geographic formats
- 1:12:27Coordinate systems
- 1:33:52PostgreSQL & PostGIS basics
- 1:47:31PostGIS queries
- 2:06:41Optimizing spatial queries
- 2:24:48Simplifying contours
- 2:33:52Bulk geodata insertion
- 2:41:50API design
related talks
21mThe Open Source Geospatial Community, PostGIS, & Postgres
26mBuilding Geospatial GraphQL APIs By Leveraging GraphQL Database Integrations
19mThe Power of GeoDjango
46mGetting Down To Earth: Geospatial Analysis With Rails
53mSpatial Programming for the Rubyist
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
29mGeospatial Validations Using FastAPI and PostGIS
30mGeospatial analysis made easy with PostGIS and Geoalchemy