I have a polygon layer of 'flooded buildings' and a polygon layer of 'Census Wards'. I want to join by spatial location, the buildings to the wards, so that I have a count of the flooded buildings in each ward. However, where a building polygon intersects the boundary of 2 wards, Arcmap counts the building twice (once in each ward), so the sum of the join counts is significantly more than the actual total amount of flooded buildings.
Is there anyway to specify that a building can only be assigned to one ward? Or is there any other work-a-round for this problem?