Joining attribute data between related tables using QGIS

Our post today will show you how to join the data from a CSV spreadsheet table to that of the attributes table of a layer on a map using QGIS. To create a join of both tables, an identical field must exist between them, in other words, a relationship must exist between them.

Tables are a very important form of storage in  GIS. Attribute (that is descriptive) data on a spatial object are usually kept in tabular form.

Below is a snippet of a table containing results of a building survey done on these points in the Ibadan municipality. the table is stored in comma seperated values .csv format.

Building_Repair_Survey_001

Secondly, let us look below at a registered image of Ibadan municipality where we can clearly see our points (red dots) stored as a layer. We intend to join the attribute data which are results of the survey in the table above with the attribute table of the point layer on the map.

.f

 

Click on the link  Joining tables and follow the steps on how to join data from different but related tables.

Hope you are practicing already. Feel free to send us your feedback.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s