Join attribute data in QGIS

Say you have some spatial data and some non-spatial data that you want to join together. Follow the steps below to create the join in QGIS.

Step-by-step guide

1. Identify the join field in both sets of data
2. Run QGIS
3. Load your spatial data. In this example we're using a postgis table containing some address point data. We load the data by selecting the PostGIS icon and identifying the database and the table name. Selecting 'Add' loads the data into QGIS. The identifier in our case is the UPRN.
   
4. Load the non-spatial data. In our case the non-spatial data is in a csv file. 
   
5. Open the Properties dialog of your spatial layer and select Joins.
6. Create a new Join by selecting the '+' button and identify the non-spatial layer and the fields that are going to form the join. 
   
7. Now use the identify tool on the layer and you'll see that the additional fields held in the non-spatial layer are now displayed. 
   
8. Make a cup of tea.

Related articles