Tutorial
summary
Promise: a hands‑on PostGIS setup that actually imports shapefiles, fixes bad geometries, runs spatial queries and serves map tiles. Installs a Vagrant geostack and AmigoCloud, uses PostGIS and ogr2ogr, notes SRIDs 4326 and 3857, shows ST_MakeValid and ST_Buffer, transforms and unions segments (17 road segments → unioned buffer) to find 11 manholes from 253 manholes and 251 roads, renders tiles with Mapnik + TileStash, and the demos and VM build complete and serve tiles.
AI-written summary · about
chapters (23)
- 0:00Introduction
- 1:20What is PostGIS
- 2:11PostGIS History
- 6:27Geometry
- 8:30Coordinate Systems
- 10:47Helpful Questions
- 13:35How many people want AmigoCloud
- 14:02Virtual Machine Setup
- 20:37QGIS
- 27:57Geodatabases
- 28:47Wheres the beginning
- 31:27Why not use ESRI
- 35:47Java Topology Suite
- 37:42Creating a Project
- 38:42AmigoCloud Demo
- 39:57Vagrant Demo
- 41:37GeoData Demo
- 42:22Postgs Full Version
- 43:12Advanced Query
- 45:07Geo Data
- 48:37State City Data
- 48:52AmigoCloud
- 55:57Importing Data
related talks
46mGetting Down To Earth: Geospatial Analysis With Rails
19mThe Power of GeoDjango
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
21mThe Open Source Geospatial Community, PostGIS, & Postgres
40mGIS capability of PostgreSql using POSTGIS & OSM DATA
29mGeospatial Validations Using FastAPI and PostGIS
24mAdding Geo into your Django
02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGIS