Latest Contributions by 2Quiker

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   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(fc_dest, 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)   ... View more

I have a model that I would like to use the the following code to update a field "Permits" based on how many text occurrences are in "ParcelNum1" field based on the "PermitNum" field. I get the following error and need help figuring out what the issues is and all fields are text fields. I need this in model builder. Example OBJECTID PermitNum ParcelNum1 Permits 1 aa1123 12345 12345, 12346 2 aa1123 12346   3 BB3361 67891 67891, 67892, 37893 4 BB3361 67892   5 BB3361 67893   6 UU9832 11123 11123 7 PP2225 6989 6988, 6989 8 PP2225 6988   Pre-Logic Script code:             dict1 = dict() with arcpy.da.SearchCursor('TableTest6',['ParcelNum1','Permit_Count','PermitNum']) as cursor: for row in cursor: if row[0] not in (None, "", " "): dict1.setdefault(row[0],[]).append(str(row[2])) def concat(nf): x = None if nf in dict1t: x = ",".join(dict1[nf]) return x             Permits = conact(!ParcelNum1! )   Error. ERROR 000539: Runtime error Traceback (most recent call last): File "<string>", line 2, in <module> RuntimeError: cannot open 'TableTest6' Failed to execute (Calculate Field (4)). ... View more