I have a map of the UK which splits the whole country into 1km polygon squares. Each polygon contains data, and I want to try and group the squares into local authority level.
I have tried overlaying a map and using a spatial join, however this has lots of double counting since the squares on the boundary are counted on both sides.
So I was wondering if there was an alternative method for doing this?