~/talk

GeoDjango at City Scale: Spatial Data for Urban Systems

Talkat DjangoCon US 2026 · 2026-08-24..08-28· [databases]
slides:none on file

GeoDjango plus PostGIS stores city entities as Point, LineString, and Polygon fields and uses spatial indexes to cut a sample query from 3410 ms to 6.2 ms. The demo models buildings, transit stops, roads, districts and finds buildings >500 meters from chargers by unioning charger 500 m buffers and subtracting that footprint to count gaps. Recommendations include EXPLAIN ANALYZE to verify indexes, partitioning or time/geography sharding for sensors, paging/map-bounds queries, simplified geometries and serving results as GeoJSON for live dashboards.

AI-written summary · about

  1. 0:00Introduction and speaker intro
  2. 2:07Why spatial data matters
  3. 3:58GeoDjango and PostGIS overview
  4. 6:25Spatial indexes and geometry types
  5. 9:20Modeling EV charger gaps
  6. 12:20Solving urban infrastructure questions
  7. 14:30District-level dashboard queries
  8. 17:26Scaling GeoDjango for cities
  9. 20:45Handling live spatial data
  10. 23:42Impact and real-world applications
  11. 24:46Key takeaways and next steps
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.