Latest Contributions by 2Quiker

‎10-09-2020

OK, I think what is hold me up is that there are some 'Nulls' in field2.

‎10-09-2020

This is what I've got, I posted the wrong one at first. I get no errors but field1 row doesn't get populated with field2 is field1 row is blank. flds = ['field1','field2'] search_feats = {f[0]:f[1] for f in arcpy.da.SearchCursor(fc1,flds)} with arcpy.da.UpdateCursor(fc1,flds) as upd_cur: for upd_row in upd_cur: if upd_row[1] == None: upd_row[1] = search_feats[upd_row[0]] upd_cur.updateRow(upd_row) else: pass del upd_cur ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎10-09-2020

That was my initial thought and makes sense but if Field1 is unique pass field2 and field3 to updatecursor and update field1 with field2 if filed1 is blank? I am still trying to make sense of Dictionary keys and how to loop through them.

‎10-09-2020

Joe, thanks for the response. I see but after using your code and implementing my data and running the code field1 is not being populated with field2 if the fied1 rows are blank. The error I was getting was with my code was; Traceback (most recent call last): File "D:\GIS Folder Scripts\UpdateFiledBlanks.py", line 10, in <module> upd_row[0] = search_feats[upd_row[1]] #FIELD_2 KeyError: 'Final Plat'

‎10-09-2020

I can do it with a basic arcpy.da.UpdateCurosr but I am trying to figure out how to use arcpy.da.UpdateCurosr with dictionary key. I am trying to populate Field1 if the row is blank but if not then continue on to the next row. I have the following but I get error, upd_row[0] = search_feats[upd_row[1]] #FIELD_2 KeyError: 'Blah Text' >>> ‍‍‍ flds = ['Field1','Field'] search_feats = {f[0]:f[1:] for f in arcpy.da.SearchCursor(fc1, flds)} with arcpy.da.UpdateCursor(fc1, flds) as upd_cur: for upd_row in upd_cur: #if upd_row[0] is None: if upd_row[0] != None: #if upd_row[0] in ("", ' ', None): upd_row[0] = search_feats[upd_row[1]] #FIELD1 upd_cur.updateRow(upd_row) del upd_cur‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎10-08-2020

It would be in a geodatabase, I exported it out of the geodatabase for testing sorry about the confusion . If a P_ID has no record in field1 I would like it to populate field1 with what is in field two if there is something in field2. There will be some that don't have anything in field1 and field2 and if that is the case just pass on that records. Field1 and Field2 shouldn't have more than one value.

‎10-07-2020

Thank you for the response, with the change you provided it looks like it skipped the ones with the same P_ID that had at least one blank/null in Field1 but joined the ones with the same P_ID that had Field1 populated for all those records. Also I just noticed that some Duplicate P_ID don't have anything in Field1 and if that is the case I would like Field1 populated with Field2, for example WI2018-0137. I have attached the data to reference. I really appreciate you help.

‎10-05-2020

Sorry, they are Null. Correct - If CP0001 has a value of 'Conditional' can there only be 'Blank' or other 'Conditional' values in Field2 for CP001? Correct - Can Field2 have multiple non-empty/blank/null values for a given value of Field1? There are some that are not duplicates, like below. ObjectID Field1 Field 2 --> ObjectID Field1 Field2 01 CP0001 Conditional --> 1 CP0001 Conditional 02 CP0001 Conditional 03 CP0001 Null 04 CP0001 Null 05 CP0003 New ---> 5 CP00003 New 06 CP0009 Old --> 7 CP20009 Old 07 CP0011 AD Decision --> 8 CP0011 AD Decision 08 CP0011 Null 09 CP0011 Null

‎10-05-2020

I have the following code that was provided by bixb0012 , thank you for the merge code. I need to be able to keep a certain fields attributes/ or transfer them once the merge is done. With the following code some merged features have info in the Field2 but some doesn't. I would like to merge the features that have the same attribute from Field1 but keep/add what is in Field 2 to the new merged Field2. Original features Merged Features ObjectID Field1 Field 2 --> ObjectID Field1 Field2 01 CP0001 Conditional --> 1 CP0001 Conditional 02 CP0001 'Blank' 03 CP0001 'Blank' 04 CP0001 'Blank' 01 CP0014 Relocation --> 2 CP0014 Relocation 02 CP0014 'Blank' 03 CP0014 'Blank' 04 CP0014 'Blank' from arcpy import da from itertools import groupby from operator import itemgetter from functools import reduce fc = # path to feature class or table case_fields = ["field1", "field2"] # field(s) to group records for merging sort_field, sort_order = "OBJECTID", "ASC" shape_field = "SHAPE@" fields = case_fields + [sort_field, shape_field] sql_orderby = "ORDER BY {}, {} {}".format(", ".join(case_fields), sort_field, sort_order) kwargs = {"in_table":fc, "field_names":fields, "sql_clause":(None, sql_orderby)} with da.UpdateCursor(**kwargs) as ucur, da.SearchCursor(**kwargs) as scur: case_func = itemgetter(*range(len(case_fields))) ugroupby, sgroupby = groupby(ucur, case_func), groupby(scur, case_func) for (ukey,ugroup),(skey,sgroup) in zip(ugroupby,sgroupby): poly = reduce(arcpy.Geometry.union, (row[-1] for row in sgroup)) row = next(ugroup) ucur.updateRow(row[:-1] + [poly]) for row in ugroup: ucur.deleteRow()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎10-01-2020

Thanks for sharing Randy, The code worked great for the data I attached but after hours it took me a while to figure out that my original data had fields that quite didn't match the taxlots fields. So it's my fault for not providing the correct data I was trying to cut down the data size and I apologize. For example, the points have fieldA, field1, field2, field3 and the point taxlots have field_A, field_1, field_2, field_3. The code works great if I only need those field but like I mentioned I need something that will also include fields that don't match. So for the fields that don't match I need to transfer field_A --> fieldA field_1 --> field1 field_2 --> field1 field_3 --> field1

‎09-29-2020

Randy, This is very helpful thank you. If you don't mind sharing the spatial join and field mapping code that would be great.

‎09-25-2020

Randy, I have attached the point and taxlots, I would like to update just the selected well points, maybe one or maybe 50, 100+, not all wells need to be updated just missing ones or the ones I select, some parcel may have more than one well. I am not sure if failed attempt to do it is the best and fastest way, maybe spatial join, also some records can have 0 or null, blanks...? The other question is there a way to update the fields on the points from the taxlots if they exist/match without having to type each field out? Thanks for the help Randy!

‎09-23-2020

I am having a hard time looping through the selections, I am not sure how to pass it to the rest of my code. Then again I am not sure my approach is the best...? ptCount = int(arcpy.GetCount_management(ptSelection).getOutput(0)) dsc = arcpy.Describe(ptSelection) selection_set = dsc.FIDSet if len(selection_set) == 0: print "There are no features selected" elif ptCount >= 1: oidList = [] with arcpy.da.SearchCursor(ptSelection, ['SHAPE@','OID@']) as cursor: for row in cursor: oidList.append(row[0]) oid = row[1] arcpy.AddMessage(oid) # does not print anything in window. del cursor for OID in oidList: arcpy.SelectLayerByLocation_management(parcel,"INTERSECT",ptSelection,"OBJECTID = {}".format(str(row[1]))) arcpy.MakeFeatureLayer_management(parcel,"parcel_lyr") ##next??‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎09-11-2020

Sorry about that. How do I get this to work on multiple selected? It works great with one feature selected but not with multiple.

‎09-11-2020

I thought I had pasted the code with the indent and when I pasted the code and without the empty list but I didn't, sorry about that. The code does have the the indent and empty list removed. import arcpy,os arcpy.env.overwriteOutput = True arcpy.env.workspace = r'Database Connections\Connection to blah.sde' ptSelection = "WellPoints" pointLayer = arcpy.env.workspace + os.sep + "WellPoints" parcel = 'WellParcels' ptCount = int(arcpy.GetCount_management(ptSelection).getOutput(0)) dsc = arcpy.Describe(ptSelection) selection_set = dsc.FIDSet if len(selection_set) == 0: print "There are no features selected" elif ptCount >= 1: arcpy.SelectLayerByLocation_management(parcel,"INTERSECT",ptSelection) arcpy.MakeFeatureLayer_management(parcel,"parcel_lyr") fldList = ['WellID', 'dept', 'type', ' Geothermal' 'GeoWaterUs', 'Temp', 'TempDate'] fldDict ={} if int(arcpy.GetCount_management("parcel_lyr").getOutput(0))==1: for parrow in arcpy.da.SearchCursor("parcel_lyr",fldList): for w in range(len(fldList)): fldDict[fldList ]=parrow del parrow targetFields = ['W_ID', 'dept', 'type', ' Geothermal' 'GeoWaterUs', 'Temp', 'TempDate'] with arcpy.da.UpdateCursor(ptSelection, targetFields) as cursor: for row in cursor: row.append(fldDict['WellID'] row.append(fldDict['dep'] row.append(fldDict['type'] row.append(fldDict['Geothermal'] row.append(fldDict['GeoWaterUs'] row.append(fldDict['Temp'] row.append(fldDict['TempDate'] rows.updateRow(row) del row‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Online Status	Offline
Date Last Visited	‎02-12-2026 12:36 PM

My Ideas

Latest Contributions by 2Quiker

Re: Trying to use dictionary key with UpdateCurosor

Re: Trying to use dictionary key with UpdateCurosor

Re: Trying to use dictionary key with UpdateCurosor

Re: Trying to use dictionary key with UpdateCurosor

Trying to use dictionary key with UpdateCurosor

Re: Merge features and keep/transfer attributes

Re: Merge features and keep/transfer attributes

Re: Merge features and keep/transfer attributes

Merge features and keep/transfer attributes

Re: Update attributes of selected

Re: Update attributes of selected

Re: Update attributes of selected

Re: Update attributes of selected

Re: Update attributes of selected

Re: Update attributes of selected

Re: Reording of OBJECTID

Reording of OBJECTID

Re: Remove prefixes

Dictionary upatecursor with domains

Re: ArcGIS Pro List Elments