PostGIS and pgRouting: Extensions for spatial data in PostgreSQL
summary
PostGIS provides geometry types, spatial indexes and functions like ST_Simplify for reducing polygon complexity; pgRouting adds SQL routing functions (pgr_), including turn-restricted shortest path and A/Dijkstra and a TSP solver. A real project loads a road graph of 11 million rows, supports dynamic per-vehicle cost fields and emergency-mode relaxations, computes isochrones by routing then convex-hull polygons, and meets performance targets of roughly under 1 second for typical queries (long routes under 5s). Indexing and careful input-query limits prove essential for speed.
AI-written summary · about
chapters (10)
- 0:00Introduction to PostGIS
- 3:41PostGIS data types and indexing
- 8:44Common PostGIS functions
- 12:34Simplifying geometries demo
- 16:55Introduction to pgRouting
- 19:50pgRouting algorithms and usage
- 23:29Real-world pgRouting examples
- 32:13pgRouting capabilities summary
- 36:43Advantages of PostGIS and pgRouting
- 37:24Q&A session
related talks
21mThe Open Source Geospatial Community, PostGIS, & Postgres
40mGIS capability of PostgreSql using POSTGIS & OSM DATA
14m10 Things I've Learnt About PostGIS
53mThis Is PostGIS
45mBreakout Session
26mBuilding Geospatial GraphQL APIs By Leveraging GraphQL Database Integrations
21mA Walking Tour of PostgreSQL
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS