nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Add To and From Intersecting Streets to Attribute table of Streets

PaulMcBride

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

Find more posts tagged with

Accepted answers

RichardFairhurst

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:

def Output(FirstPoint):
  FPX = round(float(FirstPoint.X), 4)
  FPY = round(float(FirstPoint.Y), 4)
  return "{%(FX)012.4f}{%(FY)012.4f}" % {'FX': FPX, 'FY': FPY}

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}"

All comments

PaulMcBride

Thank you all for the help. I found a pdf documenting directions to follow. It is titled, "Finding Street Segments" and it piggy backs off of this article.

Thanks for the help!!!

RichardFairhurst

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?

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

Parser: Python

Show Codeblock: Checked

Pre-logic Script Code:

def Output(FirstPoint):
  FPX = round(float(FirstPoint.X), 4)
  FPY = round(float(FirstPoint.Y), 4)
  return "{%(FX)012.4f}{%(FY)012.4f}" % {'FX': FPX, 'FY': FPY}

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}"

DanPatterson_Retired

Not sure what you mean by get back into, but if you are referring to the attributes, an attribute or spatial join might be the way to go or a relate if it is a many to one, or perhaps an intersect Intersect—Help | ArcGIS for Desktop depending on the desired tabular output needed.

PaulMcBride

I have used this tool and the intersections are great, but I need to get those point features back into my line segment. Any thoughts?

DanPatterson_Retired

This issue has raised its head occasionally

More adventures in overlay: creating a street intersection list | ArcGIS Blog

arcgis desktop - Populate cross street name at intersections - Geographic Information Systems Stack Exchange

And there others..

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.