I have this apparently complex problem for solving in ArcGIS:
Practically, I need to get the number of all yellow polygons that fall within both the green polygons and the red polygons. I need this for each red polygon.
In other words, I need an attribute column attached to every red polygon that holds the count of yellow polygons contained within the green ones.
I can only think of Spatial Join, but I find it very cumbersome to pass the count of yellow blocks from green polygons to red ones.
Are you aware of any other straighforward tools?