I have a table of bus stops with scores for each one and want to average the scores for the block group (polygon) that the stops are in. For example, if block group A has 3 bus stops with scores of 2, 3, and 4, I want the block group score to be 3.
I am unsure whether I need to do some kind of spatial join to connect the point(s) to the polygon. When I tried previously, the polygon layer attribute table would show that it had multiple joins, but it would only show one of the bus stop coordinates.
Thank you in advance, I appreciate any help!!!
Solved! Go to Solution.
The spatial join tool has a merge rule that allows you to join all the values into a single field when the join count > 1. You can have it concatenate them with a delimiter, or, in your situation, there is a Mean option that will average them for you.
R_
The spatial join tool has a merge rule that allows you to join all the values into a single field when the join count > 1. You can have it concatenate them with a delimiter, or, in your situation, there is a Mean option that will average them for you.
R_
Thank you so much! This worked perfectly.