Training Materials
The “Introduction to PostGIS” workshop is a hands-on step-by-step walk through PostGIS basics. Loading data, creating tables, writing queries, and more.
Welcome to PostGIS workbook, accompanying videos (Quisheng Wu) - spatial data management with PostgreSQL, PostGIS, and Jupyter Python Notebook. This workbook also uses some data from Introduction to PostGIS workshop.
PostGIS Baby Steps, Grace Amondi - training series covering basics of PostGIS, loading data, using pgAdmin4, and querying with QGIS. This training series uses some data from Introduction to PostGIS workshop.
GDAL and OGR are the standard tools for moving vector datasets between PostGIS and other spatial formats.
- The PostGIS manual
documents
shp2pgsqland the graphical shapefile loader. - The GDAL PostgreSQL/PostGIS driver documents PostGIS connection options for GDAL vector tools.
- ogr2ogr converts data between PostGIS and formats such as GeoPackage, Shapefile, GeoJSON, and GML.
- The GDAL SQLite and SpatiaLite driver documents SpatiaLite import and export workflows.
- sqlite_fdw can expose SQLite and SpatiaLite files to PostgreSQL queries when foreign-table access is a better fit than format conversion.
OpenStreetMap data is a common way to explore PostGIS with real roads, buildings, points of interest, and routing networks.
- osm2pgsql imports OpenStreetMap data into PostgreSQL/PostGIS for rendering, analysis, and custom schemas.
- GDAL’s OSM driver can read OpenStreetMap XML and PBF files for smaller imports or ETL workflows.
- Imposm and libosmium are useful for specialized import pipelines and custom processing.
- Switch2OSM explains the broader toolchain for rendering OpenStreetMap data and serving map tiles.
- The OpenStreetMap wiki maintains background material on data access and database schemas.
For a longer worked treatment, see the book Mastering PostGIS and OpenStreetMap.
-
- Matthew Forrest
- English (529 pages)
- PostGIS, PostgreSQL, h3, pgRouting, pySAL
- Released November 2023
-
PostGIS - Tous les ingrédients pour concocter un SIG sur de bonnes bases
- Arthur Bazin
- French (550 pages)
- PostGIS 3.1-3.3 and PostgreSQL 13-15
- Released March 2023
-
Mastering PostGIS and OpenStreetMap
- Ryan Lambert
- English, 4 chapters on pgRouting
- Released Oct 1st, 2022
-
PostGIS In Action, 3rd Edition
- Regina Obe & Leo Hsu
- English (664 pages)
- PostGIS 2.5-3.2, PostgreSQL 11-13
- Released August 2021
-
PostGIS: Análisis Espacial Avanzado, 2nd Revision
- José Carlos Martínez Llario
- Spanish
- PostGIS 3, PostgreSQL 13
- Released Sept 2020
-
PostGIS Cookbook, 2nd Edition
- Paolo Corti, Stephen Vincent Mather & Thomas Kraft
- English
- PostgreSQL 9.6
- Released March 2018
-
GIS Stack Exchange may already have your answer: search before you ask!
These community resources are kept for historical reference. Some use older PostGIS and PostgreSQL versions, so start with the current workshop above for new projects.
- PostGIS Gotchas
- Almost Idiot’s Guide to PostGIS, last updated for PostGIS 2.2