nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Search and Update Cursors

WilsonIonara

I need to use search and update cursors to get the values from one feature class to another. Before this code worked because I had only one record to be updated, but now I may have more than one. How can I change it to let it update many records? Thanks

    countycode = tuple(arcpy.da.SearchCursor("Countieslayer", "FIPS_TXT"))[0][0]     urows = arcpy.da.UpdateCursor("Stewardship", "County")     for urow in urows:         urow[0] = countycode         urows.updateRow(urow)

Find more posts tagged with

Accepted answers

WilsonIonara

This worked, I just had to create temporary layers, instead of feature classes

# Create new field mappings and addd both feature classes  fieldmappings = arcpy.FieldMappings() fieldmappings.addTable(Input_Polygons) fieldmappings.addTable(Counties)  # create output feature for spatial join outstewardshipcounties = os.path.join(arcpy.env.scratchGDB, "StewardshipCounties")  #run spatial joint tool  arcpy.SpatialJoin_analysis(Input_Polygons, Counties, outstewardshipcounties , "#", "#", fieldmappings, "HAVE_THEIR_CENTER_IN")  #create dictionary  path_dict = { } rows = arcpy.SearchCursor(outstewardshipcounties) for row in rows:     keyrow = row.getValue("ObjectID")     valrow = row.getValue("FIPS_TXT")     path_dict[keyrow] = valrow  urows = arcpy.UpdateCursor(Input_Polygons) for urow in urows:     upkey = urow.getValue("ObjectID")     if upkey in path_dict:         urow.setValue("County", path_dict[upkey])         urows.updateRow(urow) del row, rows, urow, urows

All comments

WilsonIonara

This worked, I just had to create temporary layers, instead of feature classes

# Create new field mappings and addd both feature classes  fieldmappings = arcpy.FieldMappings() fieldmappings.addTable(Input_Polygons) fieldmappings.addTable(Counties)  # create output feature for spatial join outstewardshipcounties = os.path.join(arcpy.env.scratchGDB, "StewardshipCounties")  #run spatial joint tool  arcpy.SpatialJoin_analysis(Input_Polygons, Counties, outstewardshipcounties , "#", "#", fieldmappings, "HAVE_THEIR_CENTER_IN")  #create dictionary  path_dict = { } rows = arcpy.SearchCursor(outstewardshipcounties) for row in rows:     keyrow = row.getValue("ObjectID")     valrow = row.getValue("FIPS_TXT")     path_dict[keyrow] = valrow  urows = arcpy.UpdateCursor(Input_Polygons) for urow in urows:     upkey = urow.getValue("ObjectID")     if upkey in path_dict:         urow.setValue("County", path_dict[upkey])         urows.updateRow(urow) del row, rows, urow, urows

AliciaMein

I have a use for the update and search cursors.
first question: why are you using the os.path in your script instead of the addjoin management function?
Alicia

WilsonIonara

Add join is to join layers and the os.path.join is just adding the strings to create a layer in that scratch workspace

AliciaMein

I understand the Arcpy module and navigate the help at esri well but is there documentation on the os module?
I will post a new thread for my update and search cursor issue and look forward to seeing a reply from you.
Thanks,
Alicia

WilsonIonara

Here is some info that should help you:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//004000000008000000.htm

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.