Hi all,
I have an analysis conundrum and someone out here in the Esri community probably will know! 😊
I need to spatially join many polygons (Join Features, for me the orange polygons in screenshot) to one polygon (Target Features, the black Quarter Sections in my screenshot). I'm using 'Join one to one' for 'Join Operation' and 'Match Option' = 'Intersect'. Using the 'Field Map', I'm concatenating several fields together so I get all of the polygon attributes into each square.


Here's my problem with the output:
it double counts the orange polygons. For example, in the screenshot, A, B, and C polygons will be in the bottom square but also in the top square. I would like them to only be in the square where they have the largest overlap. And before you say use the Match Option = 'Largest overlap', it doesn't work. I thought it would though.

So then we tried Intersect first and then spatial join. But this splits polygon A, B and C into multiple fragments within the one square. So when I do the spatial join I get a join count of 35, when I want it to be 6!
Does anyone have any advice for this scenario?
Thank you!
A