GIS capability of PostgreSql using POSTGIS & OSM DATA
summary
Loads India OSM PBF from Geofabrik, clips to Bangalore with osmium, imports into PostgreSQL using osm2pgsql and enables PostGIS plus S2 and hstore; queries show exact use of ST_Area, ST_Length, ST_Buffer, ST_Contains/ST_Intersection and ST_Value (raster elevation) to produce ward counts, schools-per-ward and road-lengths, and a pgRouting demo running Dijkstra for shortest paths. QGIS visualizes 1/3/5/10 km buffers; ST_Subdivide is offered as a ST_Subdivide performance tip to speed large polygons. pgRouting Dijkstra and QGIS visualization demos run end-to-end.
AI-written summary · about
chapters (22)
- 0:00Introduction to talk
- 1:50Michelin Mapping Factory overview
- 4:01Understanding GIS and spatial data
- 6:52What is PostGIS and its role
- 8:59OpenStreetMap data explained
- 10:44Loading OSM data into PostGIS
- 13:32Exploring PostGIS data structure
- 15:22Basic PostGIS functions for area
- 16:25Finding administrative boundaries
- 17:33Counting points in polygons
- 18:37Calculating geometry lengths
- 19:40Creating buffers around points
- 20:23Finding nearby points of interest
- 21:32Using raster data for elevation
- 22:40QGIS demo for data visualization
- 25:10POI mapping and proximity analysis
- 28:05PG Routing for shortest path
- 30:56Routing algorithm demonstration
- 31:40Applications of GIS with PostGIS
- 33:04Michelin's digital services overview
- 34:06Geocontextualization platform explained
- 37:16Optimizing large polygon queries
related talks
47mPostGIS and pgRouting: Extensions for spatial data in PostgreSQL
21mThe Open Source Geospatial Community, PostGIS, & Postgres
37mProcessing Open Street Map Data with Python and PostgreSQL
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
19mThe Power of GeoDjango
46mGetting Down To Earth: Geospatial Analysis With Rails
14m10 Things I've Learnt About PostGIS
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS