Arcpy update NULL values in point table by copying value from nearest line table

JohnConnor01

Hello,

I have a feature class which is represented as lines (power lines). I have another feature class that are points (lights) that are on top of/intersecting with the line. 

• The light table has NULL values for year_installed
• For the light that the power line is on top of/intersecting with, I want to copy the nearest power lines year_installed value into the lights field where the lights year_installed value is NULL.

 

I need to do this in Arcpy. I believe I need to use either a Spatial Join or Transfer Attributes. Can anyone help me get started or advise what Arcpy tool I need to use? I really appreciate the help.

-JC from Boston

JohannesLindner

# load the power lines (geometry and year_installed)
power_lines = [row for row in arcpy.da.SearchCursor("path:/to/powerlines", ["SHAPE@", "year_installed"])]

# open an UpdateCursor on the lights with NULL values
with arcpy.da.UpdateCursor("path:/to/lights", ["SHAPE@", "year_installed"], "year_installed IS NULL") as cursor:
    for shp, year in cursor:
        # sort the power lines by distance to shp
        power_lines.sort(key=lambda pl: pl[0].distanceTo(shp))
        # use the closest power line's year value
        cursor.updateRow([shp, power_lines[0][1]])