I have two shapefiles. One of them is residential area and the other one is a polygon shapefile which has the population field.
Now I want to do Join attribute by location (summary) analysis but in some areas my second shapefile intersects two polygons from the residential areas shapefile and gives the population to both the residential areas.
I thought maybe it is better the residential area with the larger area have the population.
I have no idea how can I do that. How can I do this?
In this picture the purple is residential area and the black grid is my second shapefile which has the population field. As you can see, some of the grid intersects two different residential area.