How can I select street segments (polylines) based on intersections with others? Then, how would I add a value to its field from an excel table?

Discussion created by JoshALogs9 on Jul 31, 2019

I have a shapefile of city streets polylines and an excel sheet with similar data. I need to select a street segment based on the two segments it intersects. Then I add the value from the "ID" field that corresponds with the excel sheet. Right now, I have to do this manually for thousands of segments by looking at the map and finding the intersecting streets, then copy/paste the ID into the attribute field. Is there a way to automate this process based on segment intersections or endpoints? The segments in the excel sheet and table are not in the same order.

Thank you!



ArcGIS Desktop 10.5.1, Basic