I have two polygon layers. The first one contains the different “local districts” within a city, and the second one is the “greenery in different land use types”.
An important distinction to make, is that, it is not guaranteed that a particular greenery area, will always fit in a given district (i.e. a greenery area can be shared between 2+ adjacent districts).
When I join the “greenery in land use types” layer to the “districts” one, and I try ask to calculate the sum of my attributes, I get the greenery area sum for each district, I get double counting/summing on the "shared" areas.
Is there any way to consider the whole amount of greenery area that falls in each district, but to ignore the section of greenery that falls in another district?