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.

• English
• Japanese
• Chinese (Simplified)
• Spanish

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.

• Spatial SQL

  • 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!

• Crunchy Data Interactive PostGIS Learning Portal