Adding Intersecting (Start and End) Road Names to Road Segments within Road Feature Class

ChrisSpadi

Greetings, 

I am going to start fresh. I had chased down a few old posts relating to this topic but they all didn't produce the desire result.

Starting Data

• Feature Class (Road network of street segments with the following fields: NAME_ALF (Street segment name), BegLocation (Segment Start, intersecting road), EndLocation (Segment End, intersecting Road)

What I would like

 Thanks for any suggestions or pointing me to the best practice for this.

 

 

 

JohannesLindner

For Field Calculation:

// change the first line depending on field
var p = Geometry($feature).paths[0][0]  // BegLocation
var p = Geometry($feature).paths[-1][-1]  // EndLocation

var streets_at_point = Intersects($featureset, p)
var this_street = $feature.NAME_ALF
var other_streets = Filter(streets_at_point, "NAME_ALF<> @this_street")
var street_names = []
for(var os in other_streets) {
    Push(street_names, os.NAME_ALF)
}
return Concatenate(Distinct(street_names), ", ")

 

 

For Attribute Rule:

// Calculation Attribute Rule
// triggers: Insert, Update,
// field: empty

var p_start = Geometry($feature).paths[0][0]
var p_end = Geometry($feature).paths[-1][-1]
var this_street = $feature.NAME_ALF

var streets_start = Intersects($featureset, p_start)
var other_streets = Filter(streets_start, "NAME_ALF<> @this_street")
var start_names = []
for(var os in other_streets) {
    Push(start_names, os.NAME_ALF)
}

var streets_end = Intersects($featureset, p_end)
var other_streets = Filter(streets_end, "NAME_ALF<> @this_street")
var end_names = []
for(var os in other_streets) {
    Push(end_names, os.NAME_ALF)
}

return {
    result: {
        attributes: {
            BegLocation: Concatenate(Distinct(start_names), ", "),
            EndLocation: Concatenate(Distinct(end_names), ", ")
        }
    }
}