In QGIS 3.16, I have a layer of polygons corresponding to particular ecological habitat zones. I'd like to perform a series of intersections in order to add information to each polygon as to where it is located, for example: what town it is in, what parcel, what catchment/drainage basin, what protected area (and several more).
The issue is that of course, many of my habitat polygons cross administrative and hydrological borders. So if I intersect my layer1 with a layer containing town borders, the resulting intersection layer will duplicate each cross-border polygon, creating a separate entry for each town that the habitat polygon overlaps.
I'd like to avoid this duplication, or at least come up with a post-intersection trick to collapse the duplicates. What I would want, ideally, would be a way to concatenate multiple towns (or basins, or protected areas) in the same field. For example:
- [Habitat name]-[Town]
- Pond1 - Arlington, Lexington
- Bog1 - Lincoln
- Pond2 - Lincoln, Lexington
I've not found this trick yet.