topic Re: Update Cursor Dictionary in Python Questions

Update Cursor Dictionary

2Quiker — Wed, 27 Apr 2022 22:29:24 GMT

I am trying to pass some attributes from my layer to another but I am having an issue is with passing attributes from field 'Field4', the attributes from the layer sjpoints field 'Field4_1' doesn't match so the fc_dest layer 'Field4' and doesn't get updated.

The issue is FIELD4_1 has abbreviations and fc_dest has domains. How can modify my current code to check that field and if it has certain abbreviations to update with certain text, or would it be best to do a separate updatecursor and if so how can I pass the nest dictionary from the spatial join to update the fc_dest layer?

sjpoints - the spatial join has this

TARGET_FID	FIELD4_1
32145	MH
13245	SFR

fc_dest - I need this

OID	FIELD4
32145	MOBILE HOME
12345	SINGLE FAMILY RES

Re: Update Cursor Dictionary

BlakeTerhune — Wed, 27 Apr 2022 23:05:54 GMT

valueDict is undefined in your code snippet so please update if I'm missing something. If you don't have a coded value domain in the geodatabase for the values in Field4, you'll have to define them in your code. I would suggest a dictionary.

field4_coded_values = { "MH": "MOBILE HOME", "SFR": "SINGLE FAMILY RES", # etc... }

Then look up your abbreviation in the dictionary to get the the full value. Passing the look up value (abbreviation) in as the second argument means that is what will be returned if it doesn't exist.

for updateRow in updateRows: # Look up full text of abbreviation. Return original value if not found. field4 = updateRow[5] field4_out_value = field4_coded_values.get(field4, field4) updateRow[5] = field4_out_value

Re: Update Cursor Dictionary

2Quiker — Fri, 29 Apr 2022 18:16:46 GMT

Thank you and I appreciate the replay.

I guess I am still stuck on if I add this to my current code and if so how or do I completely do a separate updatecursor.

When I posted the ValueDict got cut off.

valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints1, sourceFieldsList)} sourceFieldsList = ['TARGET_FID', poly,'Field1_1','Field2_1','Field3_1','Field4_2','Field4_1','Field5_1','Field6_1'] # define the field list to the original points updateFieldsList = ['OID@', Pnt,'Field1','Field2','Field3','Field4','Field5','Field6'] #Run the Spatial Join tool, using the defaults for the join operation and join type arcpy.SpatialJoin_analysis(ptSelection, parcel, sjpoints) with arcpy.da.UpdateCursor(ptSelection, updateFieldsList) as updateRows: for updateRow in updateRows: # store the Join value of the row being updated in a keyValue variable keyValue = updateRow[0] # verify that the keyValue is in the Dictionary if keyValue in valueDict: # transfer the values stored under the keyValue from the dictionary to the updated fields. for n in range (1,len(sourceFieldsList)): updateRow[n] = valueDict[keyValue][n-1] updateRows.updateRow(updateRow)

Re: Update Cursor Dictionary

BlakeTerhune — Fri, 29 Apr 2022 21:26:20 GMT

Your logic is difficult to follow, but it looks like you're updating everything based on what is in the valueDict so maybe update the abbreviations there. Please rearrange and adjust as necessary.

sourceFieldsList = ['TARGET_FID', poly,'Field1_1','Field2_1','Field3_1','Field4_2','Field4_1','Field5_1','Field6_1'] # define the field list to the original points updateFieldsList = ['OID@', Pnt,'Field1','Field2','Field3','Field4','Field5','Field6'] valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints1, sourceFieldsList)} # Update abbreviation field values to full text description. abbreviation_lookup = { "MH": "MOBILE HOME", "SFR": "SINGLE FAMILY RES", # etc... } for key, rest_of_the_fields in valueDict.items(): # Look up full text of abbreviation. Return original value if not found. # I don't know which index your abbreviation data is at. Maybe it's rest_of_the_fields[6] ? rest_of_the_fields[5] = abbreviation_lookup.get(rest_of_the_fields[5], rest_of_the_fields[5]) # Update the original values. valueDict[key] = rest_of_the_fields # Run the Spatial Join tool, using the defaults for the join operation and join type arcpy.SpatialJoin_analysis(ptSelection, parcel, sjpoints) with arcpy.da.UpdateCursor(ptSelection, updateFieldsList) as updateRows: for updateRow in updateRows: # store the Join value of the row being updated in a keyValue variable keyValue = updateRow[0] # verify that the keyValue is in the Dictionary if keyValue in valueDict: # transfer the values stored under the keyValue from the dictionary to the updated fields. for n in range (1,len(sourceFieldsList)): updateRow[n] = valueDict[keyValue][n-1] updateRows.updateRow(updateRow)