Select to view content in your preferred language

Populate a value in one feature class from value in another feature class using SearchCursor

808
1
07-28-2017 12:26 PM
Brian_McLeer
Frequent Contributor

I have two feature classes:

   COH_Address (points)

   TAXLOTS_NOAT (polygons)

I am trying to find the best code for using a cursor to run through TAXLOTS_NOAT, grab the value for TLNO, and populate the field TLNO_GIS in the COH_Address feature class the TAXLOTS_NOAT feature class field TLNO.

import arcpy
# Local variables:
COH_Address = "C:\\Users\\mclbr\\Desktop\\AddressTest.gdb\\Places\\COH_Address"
TAXLOTS_NOAT = "C:\\Users\\mclbr\\Desktop\\AddressTest.gdb\\TAXLOTS_NOAT"
arcpy.MakeFeatureLayer_management(TAXLOTS_NOAT, "TAXLOTS_NOAT")  
rows = arcpy.SearchCursor("TAXLOTS_NOAT", "", "", "TLNO", "")
arcpy.MakeFeatureLayer_management(COH_Address, "COH_Address")  
for row in rows:  
    arcpy.SelectLayerByLocation_management("COH_Address", "HAVE_THEIR_CENTER_IN", "TAXLOTS_NOAT", "", "NEW_SELECTION")  
    arcpy.CalculateField_management("COH_Address", "TLNO_GIS", "%(row.TLNO)", "PYTHON")
Brian
0 Kudos
1 Reply
ClintonDow1
Frequent Contributor

Looks like you're on the right track, however I think its over complicated a little doing a spatial join for each row. Instead you can use Geometry Objects and their spatial operations. It is easier to work with the more modern arcpy.da.SearchCursor and UpdateCursor when you want to access the geometry of your feature classes. Here is an example of using this method:

from arcpy.da import SearchCursor
from arcpy.da import UpdateCursor

COH_ADDRESS = "C:\\Users\\mclbr\\Desktop\\AddressTest.gdb\\Places\\COH_Address"
TAXLOTS_NOAT = "C:\\Users\\mclbr\\Desktop\\AddressTest.gdb\\TAXLOTS_NOAT"

arcpy.AddField_management(COH_ADDRESS, 'TLNO', 'TEXT')

# SHAPE@XY gives us the centroid
coh_fields = ['SHAPE@XY', 'TLNO']
# SHAPE@ gives us the Geometry object
taxlots_fields = ['SHAPE@', 'TLNO']

# using a list allows us to loop over the cursor multiple times
coh_list = [i for i in UpdateCursor(COH_ADDRESS, coh_fields)]
taxlots = SearchCursor(TAXLOTS_NOAT, taxlots_fields)

# for each taxlot
for taxlot in taxlots:
    # Find coh rows with no TLNO and centroids within taxlot
    # [i for i in coh_cursor if not i[1]] is a list comprehension which 
    # returns only coh_list rows with TLNO = None, to reduce the amount of
    # compares per iteration as the values are set.
    for coh_address in [i for i in coh_list if not i[1]]: 
        # if so, update that row with the TLNO from taxlot
        if coh_address[0].within(taxlot[0]):
            coh_address[1] = taxlot[1]
            coh_address.updateRow()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
0 Kudos