Populate Endpoints of Line With a Field Value from Nearby Feature Class

AKRRMapGuy

We have a network of lines that we need to assign 2 values from the closest points in a point Feature Class.

The line segments need the values from the closest points to the beginning and end of the line assigned to their respective field in the line FC. They are Mileposts, and we need to get the Milepost value in the 'MpFrom' and 'MPTo' fields in the Line. The lines are not always drawn in a low to high orientation.

My hang up is I can't find a an arcpy tool or Arcade function that selects the point closest to the line endpoint(s).

Does this functionality really not exist? Arcade would make it easy to bring the value across from the point to the line if I could just select it based on spatial relationship to the endpoint.

DavidPike

Well as long as you get the correct marker values into 2 fields irrespective of them being mixed up/wrong way around, and assuming that the 'to' will be the highest value marker, then it shouldn't be that hard to sort out.

I'd create 2 additional final fields and field calculate the highest and lowest values into those respective fields.

The answer is pretty recent here:

https://community.esri.com/t5/arcgis-pro-questions/how-do-i-add-a-field-for-the-predominant-geologic/m-p/1579879#M92410

for the 'final' from field (lowest).  Ensure you past the following into the 'Code Block' at the bottom of the Field Calculator window.

 

 

 

def minValue(*args):
    filtered = [arg for arg in args if arg is not None]
    return (min(filtered)) if filtered else None

 

 

 

then above the Code Block you will have something that looks like <fieldname being calculated> =
in the box below that enter (obviously replace with your fieldnames:

minValue(!yourField1!, !yourField2! )

 

For your final 'to' field (highest)

 

 

 

def maxValue(*args):
    filtered = [arg for arg in args if arg is not None]
    return (max(filtered)) if filtered else None

 

 

 

then above the Code Block you will have something that looks like <fieldname being calculated> =
in the box below that enter (obviously replace with your fieldnames:

maxValue(!yourField1!, !yourField2! )