Geospatial Validations Using FastAPI and PostGIS

on YouTube ↗29m

" summary

Concrete patterns for validating geodata on the backend using FastAPI + PostGIS and existing Python ORMs: load shapefiles with shape2pgsql, store geometries in PostGIS, run ST_Intersects/ST_Distance and SRID checks via SQLAlchemy + GeoAlchemy2, and enforce checks either as Pydantic validators or endpoint dependencies. The demo app returns 422 for bad points and correct neighborhoods for good ones, with code and slides linked in the repo.

AI-written summary · about

" chapters (9)

1. 0:00Introduction to geospatial data
2. 1:07Understanding spatial concepts
3. 5:01Getting started with PostGIS
4. 7:10Core PostGIS functions
5. 12:11Validating geospatial data
6. 14:07Implementing geospatial queries
7. 17:02FastAPI integration
8. 20:17Live demo and validation
9. 22:52Questions and answers

" related talks

• 30mSpatial data and GeoDjangoBruno Renié · EuroPython 2011
• 30mGeospatial analysis made easy with PostGIS and GeoalchemyNicolas Pierre, Ioana Gherman · PyData Warsaw 2019
• 19mThe Power of GeoDjangoAnna Kiefer · DjangoCon US 2018
• 02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGISG. Soldera, S.Prunier · Devoxx France 2022
• 24mAdding Geo into your DjangoCorryn Smith · DjangoCon US 2015
• 46mGetting Down To Earth: Geospatial Analysis With RailsDaniel Azuma · RailsConf 2012
• 29mLearning FastAPI on hard-mode: getting out lots of the hardest (aw yeah, geo) data fastElena Williams · PyCon AU 2023
• 26mBuilding Geospatial GraphQL APIs By Leveraging GraphQL Database IntegrationsWilliam Lyon · GraphQLConf 2023