The video recording link for this lecture is:
Video Link
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.