Using field values to update a field using a search and update cursor

Question

I am trying to update a field using the arcpy.da.Update cursor where I can use two field values from a select by location result to populate a new field. It seems like a spatial join route may be the best approach here. With this code, I am now receiving an error of 'tuple' object has no attribute 'GEN_UNITS' for the 'result = joinsubrow.GEN_UNITS/joinsubrow.LINES' line. Do I need to search out these field values separately in separate search cursors? What would be the best route here? Thanks in advance! import arcpy from arcpy import env arcpy.env.OverwriteOutput = True defaultGdbPath = 'C:\Topo_Check_Tess_V5.gdb' subLayer='C:\Topo_Check_Tess_V5.gdb\Subs' transLayer='C:\Topo_Check_Tess_V5.gdb\TLines' ppLayer='C:\Topo_Check_Tess_V5.gdb\PPs' arcpy.AddField_management(subLayer, "GU_Count", "SHORT", "", "", "", "", "NULLABLE", "NON_REQUIRED", "") GUCountField = "GU_Count" #Make feature layer arcpy.MakeFeatureLayer_management(ppLayer, "ppLayerGU") #Make feature layer arcpy.MakeFeatureLayer_management(transLayer, "transLayerGU") pp_trans_GUJoin ='C:\Topo_Check_Tess_V5.gdb\pp_trans_GU_SpatialJoin' SubLayer_pp_trans_GUJoin ='C:\Topo_Check_Tess_V5.gdb\SubLayer_pp_trans_GUSpatialJoin' #spatial join of feature layers arcpy.SpatialJoin_analysis ("transLayerGU", "ppLayerGU", pp_trans_GUJoin,'JOIN_ONE_TO_ONE', 'KEEP_ALL', '#', 'WITHIN_A_DISTANCE', .000002) #Make feature layer arcpy.MakeFeatureLayer_management(subLayer, "SubLayer_Layer") #spatial join of feature layers arcpy.SpatialJoin_analysis ("SubLayer_Layer", "ppLayerGU", SubLayer_pp_trans_GUJoin, 'JOIN_ONE_TO_ONE', 'KEEP_ALL', '#','WITHIN_A_DISTANCE', .000002) #Make feature layer arcpy.MakeFeatureLayer_management(SubLayer_pp_trans_GUJoin, "JoinLayer") LINE_Fields = ['LINES','GEN_UNITS'] with arcpy.da.UpdateCursor (subLayer, [GUCountField, "SHAPE@"]) as GUCalcCursor: for subrow in GUCalcCursor: arcpy.SelectLayerByLocation_management("JoinLayer",'WITHIN_A_DISTANCE', subrow[1], .000002, "NEW_SELECTION") with arcpy.da.SearchCursor("JoinLayer", LINE_Fields) as JoinLayerCursor: for joinsubrow in JoinLayerCursor: result = joinsubrow.GEN_UNITS/joinsubrow.LINES subrow[0] = result GUCountField.updateRow(subrow)

TessOldemeyer · Answer

Thanks! Just saw this! Looks like that worked.

TessOldemeyer · Answer

Thanks! That was definitely a huge part of the problem. I have attached the newest rendition. It is still probably full of quirks, but seems to be getting somewhere. It is currently getting stuck on line 66 with an AttributeError: 'str' object has no attribute 'updateRow'. import arcpy from arcpy import env arcpy.env.OverwriteOutput = True defaultGdbPath = 'C:\Topo_Check_Tess_V5.gdb' subLayer='C:\Topo_Check_Tess_V5.gdb\Subs' transLayer='C:\Topo_Check_Tess_V5.gdb\TLines' ppLayer='C:\Topo_Check_Tess_V5.gdb\PP' arcpy.AddField_management(subLayer, "GU_Count", "SHORT", "", "", "", "", "NULLABLE", "NON_REQUIRED", "") GUCountField = "GU_Count" #Make feature layer arcpy.MakeFeatureLayer_management(ppLayer, "ppLayerGU") #Make feature layer arcpy.MakeFeatureLayer_management(transLayer, "transLayerGU") pp_trans_GUJoin ='C:\Topo_Check_Tess_V5.gdb\pp_trans_GU_SpatialJoin' SubLayer_pp_trans_GUJoin = 'C:\Topo_Check_Tess_V5.gdb\SubLayer_pp_trans_GUSpatialJoin' #spatial join of feature layers arcpy.SpatialJoin_analysis ("transLayerGU", "ppLayerGU", pp_trans_GUJoin, 'JOIN_ONE_TO_ONE', 'KEEP_ALL', '#', 'WITHIN_A_DISTANCE', .000002) #Make feature layer arcpy.MakeFeatureLayer_management(subLayer, "SubLayer_Layer") #spatial join of feature layers arcpy.SpatialJoin_analysis ("SubLayer_Layer", "ppLayerGU", SubLayer_pp_trans_GUJoin, 'JOIN_ONE_TO_ONE', 'KEEP_ALL', '#', 'WITHIN_A_DISTANCE', .000002) #Make feature layer arcpy.MakeFeatureLayer_management(SubLayer_pp_trans_GUJoin, "JoinLayer") with arcpy.da.UpdateCursor (subLayer, [GUCountField, "SHAPE@"]) as GUCalcCursor: for subrow in GUCalcCursor: arcpy.SelectLayerByLocation_management("JoinLayer", 'WITHIN_A_DISTANCE', subrow[1], .000002, "NEW_SELECTION") if int(arcpy.GetCount_management(in_rows="JoinLayer").getOutput(0))==1: with arcpy.da.SearchCursor("JoinLayer",['LINES','GEN_UNITS']) as JoinLayerCursor: for joinsubrow in JoinLayerCursor: GEN_UNITS = joinsubrow[1] LINES = joinsubrow[0] print GEN_UNITS print LINES if joinsubrow[1] > 0: result = GEN_UNITS/LINES else: result = 0 print result subrow[0] = result GUCountField.updateRow(subrow)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

DarrenWiens2 · Answer

Also, once you get to it, the final line should be: GUCalcCursor.updateRow(subrow)‍