Latest Contributions by CCWeedcontrol

I tried you function but I couldn't get it to work right. pre-logic script code:   def mark_records(records): result = [] for rec in records: # Check if the 9th character (index is an alphabetic character if rec[8].isalpha() or rec[8].isspace(): # Mark as ok result.append({"Rec": rec, "Mark": "ok"}) elif rec[8].isdigit(): # Mark as Not ok result.append({"Rec": rec, "Mark": "Not ok"}) else: # If neither alphabetic nor digit nor space, mark as Invalid result.append({"Rec": rec, "Mark": "Invalid"}) return result Field = (!rec!)   ... View more

oh I see, line 9  (row[0])[8].isnumeric. Thanks for the help. ... View more

This worked in Arcmap, but how can run it outside. I tired the following but I get "Parameters are not valid." or with updatecursor?   import arcpy inTable = "fc" fieldName = "rec" expression = "digitron(rec)" codeblock = """ def digitron(rec): try: if rec[8].isnumeric(): return 'Not OK' else: return 'OK' except: return 'Some error' """ arcpy.management.CalculateField(inTable, fieldName, expression, "PYTHON3", codeblock)   ... View more

No worries, I really appreciate you trying to help. ... View more

I was able to solve the empty geometry, by adding ['Shape@'] in the field names. I also included the sql_clause you had. Based on I am seeing and the print out, the script is just adding all the features from sourcFC and not acutally comparing and inserting the missing ones. Would it be best to compare two or three fields, if so how?   dsc = arcpy.Describe(targetFC) fields = dsc.fields out_fields = ['OID@', 'Duplicate', 'GlobalID'] fieldnames = [field.name if field.name != 'Shape' else 'SHAPE@' for field in fields if field.name not in out_fields] #print(out_fields) #print(fieldnames) keepList = [] # Switched from fc1 to targetFC # You want to check the final product first with arcpy.da.SearchCursor(targetFC, ['SHAPE@'] + fieldnames, sql_clause = (None, "ORDER BY PermitNum")) as cursor: for row in cursor: keepList.append(row) #Appended row, not row[0]. #Otherwise they might not check for the same thing print("Keeplist length: ", len(keepList)) del cursor #list of values from fc1 to inject into targetFC ids = [] #Check for missing values comparing by row in total. with arcpy.da.SearchCursor(fc1, ['SHAPE@'] + fieldnames, sql_clause = (None, "ORDER BY PermitNum")) as cursor: for row in cursor: if row not in keepList: ids.append(row) print("ids: ", ids, len(ids)) del cursor #import all fields #create insert cursor variable with arcpy.da.InsertCursor(targetFC, ['SHAPE@'] + fieldnames) as insCursor: for rows in ids: insCursor.insertRow(rows)     ... View more

Oh wow. I looked back at my original data and there no empty geometry. I think I might have shared one (targetFC),that must have corrupted after testing, my apologies.  I have attached a copy of the original data(targetFC), with the unnecessary fields removed. I verified there were no empty geometry, again my apologies. After verifying that both dataset had no empty geometry and verified with the code you attached. 0 Break 0   I ran the code below, but it created empty geometry on the target feature class. It appears to that the empty geometry ones are the missing ones that are being inserted into the targetFC.   dsc = arcpy.Describe(targetFC) fields = dsc.fields out_fields = ['OID@', 'Shape_Leng', 'Shape_Area', 'Duplicate', 'GlobalID'] fieldnames = [field.name if field.name != 'Shape' else 'SHAPE@' for field in fields if field.name not in out_fields] #print(out_fields) #print(fieldnames) keepList = [] # Switched from fc1 to targetFC # You want to check the final product first with arcpy.da.SearchCursor(targetFC, fieldnames) as cursor: for row in cursor: keepList.append(row) #Appended row, not row[0]. #Otherwise they might not check for the same thing print("Keeplist length: ", len(keepList)) del cursor #list of values from fc1 to inject into targetFC ids = [] #Check for missing values comparing by row in total. with arcpy.da.SearchCursor(fc1, fieldnames) as cursor: for row in cursor: if row not in keepList: ids.append(row) print("ids: ", ids, len(ids)) del cursor #import all fields #create insert cursor variable with arcpy.da.InsertCursor(targetFC,fieldnames) as insCursor: for rows in ids: insCursor.insertRow(rows) print ('Done', arcpy.management.GetCount(targetFC))   ... View more

I have these in a file geodatabase, and I removed all the none important fields. Thanks I really appreciate your help. ... View more

I wasn't sure if you meant, if in the script or the layers, I removed the GlobalID from both feature classes and I am still getting doubles. Would you like me to share some of the data? ... View more

I was running this outside Pro and thought maybe that was why I was getting different results but no. I put the info in Pro and ran the code.   Here are my results   I thought maybe I had something wrong in the code, so I copied the code you posted and ran it.   aprx = arcpy.mp.ArcGISProject("CURRENT") mp = aprx.activeMap fc1 = mp.listLayers("Source")[0] # Copy in the Edit GDB, contains 25096 records targetFC = mp.listLayers("target")[0] #Copy in the Published GDB, contains 11396 records dsc = arcpy.Describe(targetFC) fields = dsc.fields out_fields = [dsc.OIDFieldName, dsc.lengthFieldName, dsc.areaFieldName, 'Field1','Field2', 'Field3'] fieldnames = [field.name if field.name != 'Shape' else 'SHAPE@' for field in fields if field.name not in out_fields] #print(out_fields) #print(fieldnames) keepList = [] # Switched from fc1 to targetFC # You want to check the final product first with arcpy.da.SearchCursor(targetFC, fieldnames) as cursor: for row in cursor: keepList.append(row) #Appended row, not row[0]. #Otherwise they might not check for the same thing print("Keeplist length: ", len(keepList)) del cursor #list of values from fc1 to inject into targetFC ids = [] #Check for missing values comparing by row in total. with arcpy.da.SearchCursor(fc1, fieldnames) as cursor: for row in cursor: if row not in keepList: ids.append(row) print("ids: ", ids, len(ids)) del cursor #import all fields #create insert cursor variable with arcpy.da.InsertCursor(targetFC,fieldnames) as insCursor: for rows in ids: insCursor.insertRow(rows) print ('Done', arcpy.management.GetCount(targetFC)) ... View more

The current codes insert all the features in fc1 into the targetFc, at least for me. It doesn't appear to only insert the missing ones. If I run the code again, it just adds the total number of features in fc1again. I appreciate your input. ... View more

I made the following changes. line 24  was if row[0] not in keepList: should be; if row not in keepList: Line 32 was InsertCursor .insertRow(rows) Should have been insCursor.insertRow(rows)     fc1 = "lyTB" targetFC = "lyA_2" dsc = arcpy.Describe(targetFC) fields = dsc.fields out_fields = [dsc.OIDFieldName, dsc.lengthFieldName, dsc.areaFieldName, 'Field1','Field2', 'Field3'] fieldnames = [field.name if field.name != 'Shape' else 'SHAPE@' for field in fields if field.name not in out_fields] keepList = [] with arcpy.da.SearchCursor(fc1, fieldnames) as cursor: for row in cursor: keepList.append(row[0]) #print(keepList) del cursor #list of values from fc1 to inject into targetFC ids = [] with arcpy.da.SearchCursor(fc1, fieldnames) as cursor: for row in cursor: #print (row) if row not in keepList: ids.append(row) del cursor #import all fields #create insert cursor variable with arcpy.da.InsertCursor(targetFC,fieldnames) as insCursor: for rows in ids: insCursor.insertRow(rows) print ('Done')   How can I check using two other fields other than just the OID?   ... View more

I guess I mixed up append and merge. Append will append all feature in one layer to the other making duplicates, which is what I am trying to avoid. ... View more

That was the issue, for some reason I thought I need the "search_feats" on line 16. ... View more