Mapping the Census with PostGIS, Python, and...
summary
Builds an interactive map service that lets non‑GIS users combine ABS census fields on the fly using SQL/expressions, Postgres/PostGIS and Python to render vector tiles from 2011/2016 data (400 tables, ~57,000 variables). Tiles generate in under 0.5s and support national down to mesh‑block detail (~50 houses). The stack uses SQLAlchemy and PostGIS tile functions, runs on a $5 DigitalOcean droplet, has ~30 active users, and is open source and reproducible.
AI-written summary · about
chapters (8)
- 0:00Introduction to census mapping
- 1:49Challenges with raw census data
- 3:34Introducing Exalt Maps concept
- 6:01Community impact and transparency
- 8:53Vector tiles for dynamic data
- 12:01On-the-fly vector tile generation
- 13:26Simplifying spatial tech stack
- 14:09Closing and future plans
related talks
30mGeospatial analysis made easy with PostGIS and Geoalchemy
19mThe Power of GeoDjango
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS
22mMaps with Django (and PostGIS)
05mSpatial Mapping in Python with GeoPandas and OpenStreetMap
21mThe Open Source Geospatial Community, PostGIS, & Postgres
26mWho Said Wrangling Geospatial Data at Scale was Easy?
24mGeo+Django: Geo beyond the Django