Identifying properties of adjacent linear events

[doronwen]

I'm trying to identify properties of adjacent linear events but I don't know which tool or combination of tools I should be using.

Example: Route name 001 has 3 sections: A, B, and C.
For each section, I want to find the neighboring sections. 
Section A has Section B near it.
Section B has Section A and C near it.
Section C has Section B near.

All the linear events are abut to each since they are linear referenced.
For my end results, I'd like to keep the same number or records in my attribute table, but to add one or two new fields to the attribute table the will specify which sections are near that record.

This is just an example of out route, but I have over 200 routes when each route has multiple sections. 

Some tools that might be part of the solution? I'm not sure.
Feature vertices to points (begin and end points), select by location, intersect.|

[DavidPike]

A Spatial Join to itself and a field mapping merge rule of JOIN

pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/spatial-join.htm

https://community.esri.com/t5/geoprocessing-documents/spatial-join-s-hidden-trick-on-how-to-transfer...

[doronwen]

I've done the spatial join, but I'm not following how this "mapping merge rule of JOIN" works.

If we take the example I provide above, after I do the spatial join with a 1 foot buffer, and then out of the result I select the "Section B" segment, I see 3 records:

Route 001 Section B
Route 001 Section A
Route 001 Section C

It sill gives me 3 separate records. I'm looking for one record that show the two adjacent records in it.

It look like spatial join is part of the solution, but I sill missing something to get me to the end results.

[DavidPike · Accepted solution]

Looks like you're using One to Many which would give you that kind of output.

You want to use One to One with the merge rule - so it gives you a single record with a field containing the delimited features it shares the topological relationship you've chosen (intersects or within x distance I guess).  

It's all in the thread comments.
https://community.esri.com/t5/geoprocessing-documents/spatial-join-s-hidden-trick-on-how-to-transfer...

[doronwen]

If I do one-to-one I get only one of the topological relationships - most of my segments have two segments one either side of them.

[doronwen]

I take it back, that worked:

1. Special Join, one-to-one
2. Intersect with a 1-foot buffer
3. Under fields, I added a new field under "Output Fields"
4. Under Source, Merge Rule is "Join"
5. Join Delimiter is "," (comma)
6. Properties - as is (text)

Just need to do some data clean-up and I'm good.

Thanks David