I have some regions that I have defined and all the public transit in the State, shown here:
The blue blobs are the regions, points are the bus/tram stops, and the lines are the routes.
I want to calculate how many other regions each region can access. The way I could think to do it is to spatial join the regions to the routes and then spatial join the routes to the region and getting a sum of the join count, but this would lead to the same regions being counted.
So that doesn't work. Then I thought maybe I could use a field calculation to calculate the reachable regions. So I was able to join the
"Trip_Id" number, to the stop points. But I still have the same problem with duplicates inflating the connectivity count.
Does anyone have any ideas to solve this problem?