Join by Attributes (Part 2): One to Many Joins

Surveys and statistical programs – Documentation: 89-20-00052020013

This document is no longer available. We regret any inconvenience this may have caused. To obtain a copy, please contact us.

Description: Following up from the previous tutorial on one-to-one joins by attributes, today we’ll discuss the second type – the one-to-many join, where there are many rows or features for one corresponding feature geometry. We’ll demonstrate these procedures using the Farm Classified by Total Farm Capital table, which includes the number of farms reporting in six separate capital categories for each corresponding boundary. The table also requires some formatting in an external editor, including extracting the join information which is not unusual for performing joins or integrating Statistics Canada tables with vector data presently.
Notes: This video has been removed from our website. You can find it at publications.gc.ca.
Issue Number: 2020013
Frequency: Occasional
Date modified: