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