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 Arena+ "Europe in Grey" investigation 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 a dataset of built expansion in Europe and a few datasets used in the Arena investigation. They’ll be guided through writing queries to reproduce some of the investigation’s results, answering questions like: Which European country has lost the greatest proportion of its wild areas since 2018? Which protected areas have had the most building on them?
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.
