Latest Contributions by CCWeedcontrol

Jeffk. Thank you for the reply. I would like to being all values but I didn't want to type them all out in my example. I guess I am not sure how to proceed with the construction of the code as I am not familiar with "keys" on how your example is showing them. Is there a complete example of the process you are describing? ... View more

Unfortunately they are not lined up like on the pictured I attached, I was trying to give an example. I have attached some sample data if anyone is kind enough to help me out as I am not sure how else to accomplish what I need. ... View more

Base on the PermitNum, For example permit 2020-0014 has 7 records in the Par field in the table I need it to transfer the tables Par field records to the feature classes Par field if they don't exits in the feature class, 2020-0013 has 4 permit records in the table I need to only transfer  the two Par records to the feature class since it already the feature class already has two populated. I don't need to transfer ones that already in the feature classes Par field. Hopefully this makes sense.  I can attach some data if that would help? Thank you for responding I am very appreciative.   ... View more

Below is what prints out.   valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)} {'2021-0006': ('2957001100', datetime.datetime(2021, 6, 11, 0, 0), None, None, '', None, 'address', 'Active', 'In Progress', None), '2021-0032': ('2957001100', datetime.datetime(2021, 6, 11, 0, 0), None, 'Preliminary Plat', '', None, 'address', 'Active', 'In Progress', None,), valueDict = {(r[0],r[1]): r for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)} {('2021-0006', '2957001100'): ('2021-0006', '2957001100', datetime.datetime(2021, 6, 11, 0, 0), None, None, '', None, 'address', 'Active', 'In Progress', None), ('2021-0032', '2957001100'): ('2021-0032', '2957001100', datetime.datetime(2021, 6, 11, 0, 0), None, 'Preliminary Plat', '', None, 'address', 'Active', 'In Progress', None), ... View more

ok, based on what you are describing I think that is my problem. I guess I am not sure how to iterating loop over the vale sets that match. Do you have an example? ... View more

PermitNum should be the unique identifier but as you can see PermitNum has duplicates because I don't have no other Unique Identifier. ... View more

I thought that's what line 9 was doing? My unique identifers are PermtNum and Par fields, the Apps field is just a date field. Unless I am not understanding the dictionary correctly...? valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)} ... View more

my indentation on line 8 was incorrect.   with arcpy.da.UpdateCursor(fc, flds) as upd_cur: for upd_row in upd_cur: if upd_row[0] in search_feats.keys(): if upd_row[1] in ("", ' ', None): upd_row[1] = search_feats[upd_row[0]][1] if upd_row[2] in ("", ' ', None): upd_row[2] = search_feats[upd_row[0]][0] upd_cur.updateRow(upd_row) ... View more

Thank you I appreciate the replay. I do have something similar with a arcpy.da.UpdateCurosr. I was trying to see how it would be done with a dictionary key.   I was think of adding another "if" but I am not 100% sure if I am understand the dictionary keys right.     with arcpy.da.UpdateCursor(fc1,flds) as upd_cur: for upd_row in upd_cur: if upd_row[0] in search_feats.keys(): if upd_row[1] == None: upd_row[1] = search_feats[upd_row[0]][1] if upd_row[2] == None: upd_row[2] = search_feats[upd_row[0]][0] upd_cur.updateRow(upd_row)     ... View more

Hopefully this helps someone, not sure if this is the best way but was the only thing I can find. Code below line 8 is by JoshuaBixby.     Casenum = arcpy.GetParameterAsText(1) Splt = str(Casenum.split(";")) arcpy.AddMessage("Case ={0}".format(Splt)) SP = "SUBJECT" arcpy.SelectLayerByLocation_management(SP, "INTERSECT", SP, "", "NEW_SELECTION") if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0: arcpy.CalculateField_management(SP, "PermitNo", '"' + Casenum +'"', "PYTHON_9.3") split_fld = "PermitNo" # Field to split split_delim = ";"# Delimeter for splitting field sys_flds = [ 'OIDFieldName', 'globalIDFieldName', 'ShapeFieldName', 'areaFieldName', 'lengthFieldName' ] desc = arcpy.Describe(SP) sys_fld_names = [ name for name in (getattr(desc, fld, '') for fld in sys_flds) if name ] usr_fld_names = [ fld.name for fld in desc.fields if fld.name not in [split_fld] + sys_fld_names ] cur_flds = ["SHAPE@", split_fld] + usr_fld_names with arcpy.da.Editor(desc.path) as edit: with arcpy.da.UpdateCursor(SP, cur_flds) as ucur: with arcpy.da.InsertCursor(SP, cur_flds) as icur: for row in ucur: shape = row.pop(0) split = row.pop(0).split(split_delim) for i in split[1:]: icur.insertRow([shape, i] + row) ucur.updateRow([shape, split[0]] + row)       ... View more

I currently coping and pasting features and I haven't been able to find any examples or ideas o how I can accomplish this so any help would be very appreciated.    ... View more

I have this but how do I split the GetParameter into two if two parameters(GetParameterAsText(2))  are given and apply one to each Pin?  lyr = arcpy.mapping.ListLayers(mxd, "TAXLOTS")[0] #Parcel numbers values = arcpy.GetParameterAsText(0) fieldName = "PIN" values = values.split(";") # split values into list values = ["'{0}'".format(v) for v in values] # add single quotes whereClause = "{0} IN ({1})".format(fieldName, ",".join(values)) arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", whereClause) #selects the parcel numbers and creates Subject property if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0: arcpy.Select_analysis("TAXLOTS", "SUBJECT") arcpy.SelectLayerByAttribute_management("TAXLOTS", "CLEAR_SELECTION") #AddsPermitNumber Casenum = arcpy.GetParameterAsText(2) SP = "SUBJECT" arcpy.SelectLayerByLocation_management(SP, "INTERSECT", SP, "", "NEW_SELECTION") if int(arcpy.GetCount_management("TAXLOTS").getOutput(0)) > 0: arcpy.CalculateField_management(SP, "PermitNo", '"' +Casenum+'"', "PYTHON_9.3") #"!{0}!".format(values) args = [arcpy.GetParameterAsText(1)for i in range(arcpy.GetArgumentCount())] #pCount = arcpy.GetArgumentCount(1) if args == 2: # dsc = arcpy.Describe(SP) fields = dsc.fields #out_fields = [dsc.OIDFieldName] fieldnames = [field.name for field in fields] #lstFields = [field.name for field in fields] with arcpy.da.SearchCursor(SP,fieldnames) as sCur: with arcpy.da.InsertCursor(SP,fieldnames) as iCur: for row in sCur: iCur.insertRow(row) else: pass    I get the following   Pin Permit No 12345 MC2021-0002;CD2021-0005 12346 MC2021-0002;CD2021-0005   But need Pin Permit No 12345 MC2021-0002 12346 CD2021-0005 ... View more