Using a Plugin in QGIS for data analysis in PostGIS

We have been working towards using the enterprise database management system for our data storage and analysis needs. Today we will get a brief introduction to the logic of data stored in Postgres/PostGIS and how analysis can be achieved in the database itself. We will be using two famaliar products (both Canadian) – GDAL/OGR and PostGIS

Download some data from Fileshare

Use the following link to download two datasets from DataBC – Consolidated Cutblocks and Historical Wildfire Perimeters.

https://fileshare.gis.unbc.ca/index.php/s/KWtsoSbFYAKsbTJ

Add a plugin to QGIS

Look for the plugin called PostGIS Geoprocessing Tools. Now see if you can find out where this set of tools is installed from adding the plugin. We will learn a bit more about how QGIS works with plugins.

Using the plugin for analysis

In QGIS, connect to the database you used in the tutorial, or create a new database with PostGIS extensions.

Data loading

Option 1: Load in the two layers you downloaded from fileshare into the database.
NOTE: If we run into download delays we will just add random layers to the database.

Option 2: Create a single polygon that overlaps the features of polygons you have in the database (or you can select one of the features and save it to the database as a new layer)

Data analysis

Using the tools, perform a buffer on the layer that has the digitized or copied polygon.

Using this buffer layer, clip data from another layer in the database.

Review the process/logic