Hello!

I have a street layer that I am wanting to have 2 fields for cross streets at the beginning and the end of the line feature. I can create intersection points with no problems but we have the need to get the intersecting roads for each line in the same database.

Example.

I have a line for "8th Street" from "Main St" to "Meridian St". I would like "Main St" in field1 "Cross Street A" and "Meridian St" in field2 "Cross Street B".

Any suggestions?

Thank you so much!

Paul

Do your lines split at every intersection? Do they end exactly on an intersection point when they are supposed to terminate at an intersection or are they poorly controlled for topology?

Anyway, if the line ends match with the intersection location you can do the following. Calculate the concatenation of the intersection and line end XY values into their own text fields. Separate the coordinates with a delimiter such as a semi-colon or enclosed in brackets. I avoid using comma delimiters due to possible issues when using some tools. Then you can do separate joins for each line end field to match the intersection field and transfer the intersection names to the line.

A calculation I use for my California State Plane US Feet projection is:

Parser: Python

Show Codeblock: Checked

Pre-logic Script Code:

Expression for intersection point: Output(!Shape.CENTROID!)

Expression for Line From End point: Output(!Shape.FIRSTPOINT!)

Expression for Line To End point: Output(!Shape.LASTPOINT!)

This produces a text value representing the coordinate that can be joined that looks like: "{6258470.7700}{2243243.1950}"