Working with geospatial datasets is often critical to investigations dealing with where things are located, where an event occurred, land ownership, and the environment.
In this workshop, participants will learn the basics of using
PostGIS to query and join geospatial datasets using the Guardian's
Cost of the Crown series as a case study.
We’ll run through a brief overview of PostGIS, the spatial data types, indexes, and functions it adds to Postgres, and a few of its strengths and weaknesses as a tool.
Participants will connect to an existing database containing the data used in the investigation. They'll be guided through writing queries to reproduce the investigation's results.
To take part in this workshop, participants should feel comfortable writing basic SQL queries. Participants should bring their laptops with either
DBeaver or their favorite SQL client tool installed.
