The Open Source Geospatial Community, PostGIS, & Postgres
summary
PostGIS originates in 2001 origin as a Postgres extension and claims to make spatial data “not special” by exposing geometry, geography, raster and topology types plus extensions like postgis_raster, postgis_sfcgal and postgis_topology. It drives real tools — QGIS, GeoServer, MapServer, GRASS — and powers OpenStreetMap tile generation after a MySQL→Postgres migration. Spatial queries use the KNN operator <->; pgRouting, MobilityDB and ogr_fdw add routing, temporal and FDW capabilities.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 1:26What is PostGIS?
- 2:33Spatial Standards & SQL
- 3:48History of Relational vs. Spatial
- 5:33PostGIS wasn't only spatial extension
- 6:27PostGIS's desktop tool friends
- 7:25What makes up PostGIS?
- 8:57OpenStreetMap project
- 11:31Example PostGIS queries
- 12:14PostGIS raises the bar for RDBMS
- 14:12Flat, round, matrix, relational
- 17:51Related Postgres extensions
related talks
53mThis Is PostGIS
47mPostGIS and pgRouting: Extensions for spatial data in PostgreSQL
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS
40mGIS capability of PostgreSql using POSTGIS & OSM DATA
54mGeoDjango
19mThe Power of GeoDjango
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
14m10 Things I've Learnt About PostGIS