AnsweredAssumed Answered

How do I create a cross street reference map of 911 centerlines?

Question asked by ljackson_gis on Jun 7, 2016

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 NoHigh House NoPre DIRStreet NameStreet TypePost DIR Grid PGrid FGrid AGrid OLatitudeLongitudeLow Cross StreetHigh Cross Street

              

52005399N67THAVEWE00B100B100B100B10.000.005258
54005799N67THAVEWO00N1
00B1
00N1
00B1
00N1
00B1
00N1
00B1
0.000.005258
58006399N67THAVEW00B100B100B100B10.000.005864

 

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.

Outcomes