Hello,
I have a dataset with polygons, they are all individual but contain a "Site ID" which is used to cover all the polygons in say a park/open space etc. This means the same Site ID is frequently used for several polygons.
We have recently completed a survey and I wish to join this data together. The survey data also has the "Site ID" and will match. There can be more than one survey result for each Site ID.
How can I join the polygons to the CSV so that we can see all the surveys for the collective Site ID?
I am thinking I may have to merge all the polygons first so that each Site ID is a group of polygons therefore one record. Then how to join as it will be one to many rather than one to one as there are several surveys per site.
Hopefully I have explained clearly enough?! Thank you.
