6.9.8. Joining statistical information to attribute table

Now we will do a table join to connect the calculated statistical information directly to the colony_locations.shp shapefile based on the unique identifier in both the statistics table and the attribute table of the colony locations layer. By doing this, statistical information will be directly linked to the colony locations attribute table. This allows for the symbolisation and visualisation of statistical information on the map based on the geographic location of the colonies. For example, in section 6.10.4. we will symbolize each colony based on its statistical properties.

  1. Right-click on the colony locations layer in the TOC.
  2. Select Joins and Relates.
  3. Click Join.
  4. Select the option to Join attributes from a table (Fig. 56).
  5. Choose the FID as the fields on which to base the join with the stats211 table.
  6. Keep all records.
  7. Click OK.
  8. Open the Attribute table for buffer2000.shp and scroll over to the right. You will see the values from the stats211 table have been added to the end. Since we are only interested in the MEAN, turn off the other fields (right-click column name > Turn field off). For table organisation purposes, other fields can also be turned off (this is not permanent – to undo go to Table Options (top left corner of table) and Turn all fields on).
  9. To distinguish this MEAN column (211) from the other 2 other mean value columns (312 and 313), which we will add in the next steps, let’s rename the column (Right-click column name > properties).
  10. In the Alias field, change the name to “211MEAN”.
  11. Click OK.
  12. Repeat 60-70 for the 312 and 313 statistics tables.

Fig. 56. The Join Data dialog box.