Select to view content in your preferred language

Using multiple points to symbolize polygons?

505
2
Jump to solution
03-19-2024 03:59 PM
rmi
by
New Contributor

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.

rmi_0-1710889003043.png

Thank you in advance, I appreciate any help!!!

0 Kudos
1 Solution

Accepted Solutions
RhettZufelt
MVP Notable Contributor

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_

View solution in original post

2 Replies
RhettZufelt
MVP Notable Contributor

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_

rmi
by
New Contributor

Thank you so much! This worked perfectly.

0 Kudos