I need to create a map that identifies the low and high cross streets of a given road name.
For instance, I have W 100thSt N that is in two cities. I need to know what streets in each city cross that particular section of the road based on its assigned address ranges.
Here's the information I would expect to see in the tabular layout:
Low House No | High House No | Pre DIR | Street Name | Street Type | Post DIR | | Grid P | Grid F | Grid A | Grid O | Latitude | Longitude | Low Cross Street | High Cross Street |
5200 | 5399 | N | 67TH | AVE | W | E | 00B1 | 00B1 | 00B1 | 00B1 | 0.00 | 0.00 | 52 | 58 |
5400 | 5799 | N | 67TH | AVE | W | O | 00N1 00B1 | 00N1 00B1 | 00N1 00B1 | 00N1 00B1 | 0.00 | 0.00 | 52 | 58 |
5800 | 6399 | N | 67TH | AVE | W | | 00B1 | 00B1 | 00B1 | 00B1 | 0.00 | 0.00 | 58 | 64 |
The road centerlines have been dissolved by name, intersection points created and spatially joined with the data. While that gives me some information, it does not create the tabular layout like above and that is my objective.
Any ideas as to how I could do this without manually examining every single street and intersection?
Thanks for any help or direction you can provide.