Qfyilyi

My script supposed to go through all rows in one dataset, fl1:

• select one row at a time,


• based on that selection, select spatially from another dataset, fl2


• if spatially identical records were found, update some columns from fl1 to fl2.

My script only does through one record. What am I missing to get going through every row in fl1? I thought that SearchCursor goes from one row to the next.

with arcpy.da.SearchCursor(fc1, fields1) as search_cur:

    for search_row in search_cur:

        with arcpy.da.UpdateCursor(fc2, fields2) as upd_cur:

            for upd_row in upd_cur:

                # select this record in fc1

                whereClause = "ObjectID_1 = {0}".format(search_row[0])

                #fl1 = rcpy.MakeFeatureLayer_management(fl1, 'fl1') # creating feature layer

                arcpy.SelectLayerByAttribute_management(fl1, "NEW_SELECTION", whereClause)

                # check for spatial intersect

                #fl2 = arcpy.MakeFeatureLayer_management(fl2, 'fl2') # creating feature layer

                arcpy.SelectLayerByLocation_management(fl2, "ARE_IDENTICAL_TO", fl1, "", "NEW_SELECTION")

                # check for selection in fl2

                desc=arcpy.Describe("fl2")

                if not desc.FIDSet:                            

                    # if selection is not empty

                    print search_row[1]

You don't need to use selections in your search cursor, you can grab the geometry of each feature in FC1:

with arcpy.da.SearchCursor(fc1, ["SHAPE@", "MY_DEBUG_FIELD", "SOME_OTHER_FIELD") as search_cur:

    for search_row in search_cur:

        # SHAPE@ is a magic token that gets the geometry of the feature

        geom = search_row[0]

        arcpy.SelectLayerByLocation_management(fl2, "ARE_IDENTICAL_TO", geom, "", "NEW_SELECTION")

        # do what you need to do with the selected feature

        # as suggested above, you could populate a dictionary with changes

        # and then use an UpdateCursor to apply those changes