I've written a code that selects attributes one by one. As each attribute is selected a select by location is performed to identify how many records in the select by location file intersect with the selected record from the select by attributes query. The number of records that intersect the selected attribute are recorded to the attribute table. The script works if the field to be updated is hardcodded into the script. I want to be able to pick what field gets to be updated each time the script is run. Is this possible?
import arcpy, os arcpy.env.workspace = "C:/Temp" #arcpy.GetParameterAsText(0) arcpy.env.overwriteOutput = True outputWorkspace = "C:/Temp/Scratch" #arcpy.GetParameterAsText(1) def outName(input,post="_Output"): """Returns output name.""" outName=os.path.basename(input).split(".")+post return outName Attribute = "Parcel_Test.shp" #arcpy.GetParameterAsText(2) Location = "Test_Wetlands.shp" #arcpy.GetParameterAsText(3) #Get Count of the number of records for the file needing to be updated. #This count will be automatically plugged into a range value needed to write results from the analysis to the output shapefile. RangeCount = int(arcpy.GetCount_management(Attribute).getOutput(0)) print "There are", RangeCount, "records that need to be updated" arcpy.AddMessage("There are "+str(RangeCount)+" that need to be updated\n") #Create Features Layers from Feature Classes AttributeFL=outName(Attribute,"_Layer") LocationFL=outName(Location,"_Layer") arcpy.MakeFeatureLayer_management(Attribute,AttributeFL) arcpy.MakeFeatureLayer_management(Location, LocationFL) #Begin Update print "\nUpdating file with the number of records that intersect with each attribute" arcpy.AddMessage("Updating file with the number of records that intersect with each attribute\n") for attribute in range(0,RangeCount): FID = "FID=%s" % (attribute) arcpy.SelectLayerByAttribute_management(AttributeFL,"NEW_SELECTION",FID) arcpy.SelectLayerByLocation_management(LocationFL,"INTERSECT",AttributeFL) LocationCount = int(arcpy.GetCount_management(LocationFL).getOutput(0)) arcpy.AddMessage(str(FID)+" has "+str(LocationCount)+" records that intersect with it.") print str(FID), "has", LocationCount, "records that intersect with it." #Update the three_mi field uc=arcpy.UpdateCursor(AttributeFL) for line in uc: line.count = LocationCount uc.updateRow(line) #Actually changes the table values to buffer count del line del uc arcpy.SelectLayerByAttribute_management(AttributeFL,"CLEAR_SELECTION") arcpy.AddMessage(Attribute+" has been updated\n") print Attribute, "has been updated\n"