topic Re: Arcpy update NULL values in point table by copying value from nearest line table in Python Questions

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

JohnConnor01 — Tue, 03 May 2022 21:48:56 GMT

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

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

BlakeTerhune — Tue, 03 May 2022 22:42:38 GMT

How do you want it to resolve ties if the point is snapped to the intersection of two different lines?

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

JohannesLindner — Wed, 04 May 2022 06:59:05 GMT

# 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]])

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

JohnConnor01 — Wed, 04 May 2022 13:59:41 GMT

Thanks for this.. I think this will give me a good starting point!