I have two types of areas, one with smaller divisions and one with bigger divisions, and the bigger divisions completely follow the boundaries of the smaller ones.
I want to calculate the mean of the values from the smaller divisions to the bigger ones.
I have tried all the geometric predicates in Join attributes by location summary and all the other ones except for intersect return no geometry at all(or very few geometries), even when I do different combinations.
Intersect does return geometry but it calculates the mean for neighbouring areas as well, which I dont want.
See screenshots. Yes I could delete these manually but I would like to understand why it does this, because this isnt the first time this happens.
Is there a way of setting it up so it only calculates the mean for those areas that comepletely overlap with my smaller areas?