Data joins

Data joins serve an important function in any database. It often means that we can join data with a common identifier, extending the original data. In this section, we will create a simple table and join it to the Canada_Provinces Shapefile that we have just created.

Using the data on the corresponding Wikipedia pages for each of the three provinces that we have captured, I have created the following .csv file:

Create a simple .csv file to join to our Canadian provinces data

Here, I have kept the ID the same as the one we created in our Shapefile. I have saved this .csv file in the same place as my Canada_Provinces.shp. Create this ...

Get Learn QGIS - Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.