Latest Contributions by 2Quiker

Adding the print statement give the following error. print (search_feats[upd_row[0]]) error KeyError: <PointGeometry object at 0x3900e790[0x3900e620]> ... View more

apologizes for the delay response, I got busy with something else. The print(search_feats), prints {u'Ros': ()} I have attached the data I am working with, if it helps. I changed the parcel data to City limits to help with the size of the up loaded file. I need to update the pointLayer = EMS points2 SiteCity field with the Parcels =  CityLimits1 SiteCity field       pointLayer = 'EMS_Points2' city = 'CityLimits1' sjpoints = "In_memory\sjpoints" ptCount = int(arcpy.GetCount_management(pointLayer).getOutput(0)) dsc = arcpy.Describe(pointLayer) selection_set = dsc.FIDSet if len(selection_set) == 0: print "There are no features selected" elif ptCount >= 1: #Run the Spatial Join tool, using the defaults for the join operation and join type arcpy.SpatialJoin_analysis(pointLayer, city, sjpoints) search_feats ={f[0]:(f[0]) for f in arcpy.da.SearchCursor(sjpoints,'SiteCity_1')} print(search_feats) ## with arcpy.da.UpdateCursor(pointLayer,["SHAPE@","SiteCity"]) as upd_cur: ## for upd_row in upd_cur: ## try: ## if search_feats[upd_row[0]][1] == "Sea": ## upd_row[1] = "Seattle" ## elif search_feats[upd_row[0]][1] == "Spo": ## upd_row[1] = "Spokane" ## elif search_feats[upd_row[0]][1] == "Tac": ## upd_row[1] = "Tacoma" ## upd_cur.updateRow(upd_row) ## except: ## continue place_dict = {"Sea":"Seattle", "Spo":"Spokane", "Ros":"Roslyn"} with arcpy.da.UpdateCursor(pointLayer,["SHAPE@","SiteCity"]) as upd_cur: for upd_row in upd_cur: try: upd_row[1] = place_dict.get(search_feats[upd_row[0]][1], upd_row[1]) upd_cur.updateRow(upd_row) except: continue     ... View more

i have tried the following and get this error. Runtime error SyntaxError: can't assign to operator (<string>, line 35) Not sure what that means but one thing I did find out about that field is that there is domains to that field.   pointLayer = 'EMS' parcel = 'Ass_Parcels' ptCount = int(arcpy.GetCount_management(pointLayer).getOutput(0)) dsc = arcpy.Describe(pointLayer) selection_set = dsc.FIDSet if len(selection_set) == 0: print "There are no features selected" elif ptCount >= 1: arcpy.SpatialJoin_analysis(pointLayer, parcel, sjpoints) search_feats ={f[0]:(f[1:]) for f in arcpy.da.SearchCursor(sjpoints,'SiteCity_1')} print(search_feats) ## with arcpy.da.UpdateCursor(pointLayer,["SHAPE@","SiteCity"]) as upd_cur: ## for upd_row in upd_cur: ## try: ## if search_feats[upd_row[0]][1] == "Sea": ## upd_row[1] = "Seattle" ## elif search_feats[upd_row[0]][1] == "Spo": ## upd_row[1] = "Spokane" ## elif search_feats[upd_row[0]][1] == "Tac": ## upd_row[1] = "Tacoma" ## upd_cur.updateRow(upd_row) ## except: ## continue place_dict = {"Sea":"Seattle", "Spo":"Spokane", "Tac":"Tacoma"} with arcpy.da.UpdateCursor(pointLayer,["SHAPE@","SiteCity"]) as upd_cur: for upd_row in upd_cur: try: upd_row[1] = place_dict.get(search_feats[upd_row[0]][1], upd_row[1]) upd_cur.updateRow(upd_row) except: continue       ... View more

I did catch that after I posted, but I still get the same thing. No errors but nothing is updated. I did look into the field a little and found that the pointLayer "SiteCity" field has domains, not sure if this has any effect or not. ... View more

Try remove the "r" from r"\city of westervill.mdb" and r"\westerville.gdb". Are both the mdb and gdb in the same folder "c:\esritraining\mapscripting? Include arcpy.env.workspace   I have always done something like this.   mxd = arcpy.mapping.MapDocument("CURRENT")#mxd = arcpy.mapping.MapDocument(mxd) mxd.findAndReplaceWorkspacePaths(r"Database Connections\Connection to OLD_sqlexpress.sde", r"Database Connections\Connection to New_sqlexpress.sde") #Database Servers\***.gds for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == "CITY_LIMITS": lyr.replaceDataSource(r"C:\Users\***\AppData\Roaming\ESRI\Desktop10.7\ArcCatalog\***.gds", "SDE_WORKSPACE", "***.DBO.City_Limits","") print "Successfully updated CITY_lIMITS data sources"   https://desktop.arcgis.com/en/arcmap/10.6/analyze/arcpy-mapping/updatingandfixingdatasources.htm     ... View more

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

This did technically work but only if I add the Table path to the code, Table = "C:\temp\temp.gdb\table" with arcpy.da.SearchCursor(Table,['ParcelNum1','Permit_Count','PermitNum']) as cursor: Does not work with the Add Field output "TableTest6". with arcpy.da.SearchCursor("TableTest6",['ParcelNum1','Permit_Count','PermitNum']) as cursor: ... View more

Thank you for the replay, the example table I posted was incorrect and I have corrected it. I have verified that the fields are in the table and the code. The fields are  'PermitNum','ParcelNum1' & 'Permits". I have struggled with calculate fields calculations so I apologize if I am not understanding correctly. I have re-validated the entire model and re-ran it. This is in ArcCatolog and not in ArcMap or Pro. I have the following based on comments but I am still getting the error.   def update(): 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])) if key in dict1t: x = ",".join(dict1[key]) return x     Error: ERROR 000539: Error running expression: update() Traceback (most recent call last): File "<expression>", line 1, in <module> File "<string>", line 3, in update RuntimeError: cannot open 'TableTest6' Failed to execute (Calculate Field (5)). ... View more

I have re-validated and re-ran the model. What do you mean by re-run the tool(s) that generated the input, example ? ... View more

Thanks for the response Jake but I was trying to this in Model Build with Calculate field. ... View more

If I wanted to update another field (3rd) from that same table how would I do that?       sourceFC = "C:/Temp/Temp.gdb/Table1" where_clause = "MU LIKE '%TZ%'" search_feats ={f[0]:(f[1:]} for f in arcpy.da.SearchCursor(sourceFC,["OBJECTID",'MU', 'KL'],where_clause)} #searchVals = set(search_feats) #print(search_feats) with arcpy.da.UpdateCursor(sourceFC,["OBJECTID","MU_update", "KL_update"]) as upd_cur: for upd_row in upd_cur: try: upd_row[1] = search_feats[upd_row[0]] upd_row[2] = search_feats[upd_row[0]][2] ???? upd_cur.updateRow(upd_row) except: continue       ... View more