Hello! So I have run into this problem a few times, and there has to be an easier way than what I am doing.
I create maps that show how many people took a survey in specific locations. So we collect the data by zip code (which is its own problem with GIS but that's not what this post is about), and I often need to convert the frequency by zip code to frequency by county. Zip codes cross counties, so my criteria for being within a county is that the zip code polygon is over 50% within the county, and then I will assign the "frequency" from the zip code to that county.
Right now, I do it all by hand. I look at the frequency field (which I created) and I add up all of them within a county, and then I make a new field for the county layer. Is there an easier way to do this? It's by location, which is what trips me up.
Let me know if you have any advice. I've only been working with GIS for a few months, and I'm trying to learn. I haven't found anything online about this.