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

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.