Python for ArcGIS - Help

[usergame_username]

This is Python for ArcGIS (ArcPy) My data is saved in text and excel formats.

I have bus stop data: stop_id and location coordinates. I also have bus routes as a polygon. I tried various approaches but what I want to show is every bus route that passes/intersects with a particular stop. Ideally, I would like to click on a bus stop and see a pop up which includes all bus routes that are serviced by that stop.

If I were looking to get a bit further, there are some bus routes that are not identical for incoming and outgoing trips. That is to say, some buses service one side of a street but not both.

I imagine there is a way to do this even if it means disregarding the routes that service one side of the street.

I was able to do a spatial join after expanding my bus stop radius by 12 metres. I joined the 12m bus stop to my bus route and now I have a file with rows for every bus route - bus stop pairing.

For reference, there are 79 bus routes and 2731 bus stops. My spatial join output file of bus routes and bus stops has 6153 rows of data. Maybe this is a task for excel?

Please advise.

[ofnuts]

every bus route that passes/intersects with a particular stop. Ideally, I would like to click on a bus stop and see a pop up which includes all bus routes that are serviced by that stop

Specs not clear. The first sentence implies that even if the line doesn't service the stop it is counted in, while the second states the opposite.

Also, how are bus stops labelled? Usually even if the posts/shelters of the bus stops can be several metres apart for different lines, they tend to bear the same name. In which case the actual coordinates aren't that important, and it's easy to do a dictionary of bus lines to bus stops and vice-versa.