Latest Contributions by 2Quiker

My apologizes for number of responses. So field "Year" has just years, 2015,1997, 2022, etc and is a "text" field. It doesn't have month or days When I replace the "%Y" with "%m/%d/%Y" d1 = datetime.strptime(row[0], "%m/%d/%Y").year   I get; ERROR 000539: Traceback (most recent call last): File "<expression>", line 1, in <module> File "<string>", line 11, in calcYear TypeError: strptime() argument 1 must be str, not int Failed to execute   If i use the following from datetime import datetime from datetime import time import datetime def calcYear(): fc = "Lyr" #testdate = '04/25/2015' with arcpy.da.UpdateCursor(fc,['Year','Year1']) as cursor: for row in cursor: if row[0] not in (""," ",None): d1 = datetime.datetime.strptime("{}".format(row[0]),"%Y").year return d1 #formattedTime = datetime.datetime.strptime("{}".format(!Year!), "%Y") #row[1] = d1 #cursor.updateRow(row)   I get Value = 1997 the Field "Year1" doesn't get updated   I tested this in python window import arcpy from datetime import datetime from datetime import time import datetime #def calcYear(): fc = "Lyr" #testdate = '04/25/2015' with arcpy.da.UpdateCursor(fc,['Year','Year1']) as cursor: for row in cursor: if row[0] not in (""," ",None): d1 = datetime.datetime.strptime("{}".format(row[0]),"%Y").year print (d1) #formattedTime = datetime.datetime.strptime("{}".format(!Year!), "%Y") row[1] = d1 cursor.updateRow(row)   I get the year printed 2022 2022 2022 2022 2022 2022 2022 2007 But the field "Year1" doesn't get populated/updated.   ... View more

Thanks fro the replay.   Tried the following but nothing happens, no print, no error.       def calcYear(): fc = "Lyr" #testdate = '04/25/2015' with arcpy.da.UpdateCursor(fc,['Year','Year1']) as cursor: for row in cursor: if row[0] not in (""," ",None): d1 = datetime.strptime(row[0],"%Y").year print(d1) #"{}".formate(d1) row[1] = d1 cursor.updateRow(row)       ... View more

I was trying to so this in the layout view, THANKS FOR THE REPLY. ... View more

Sorry for the late response. I wasn't sure if you meat separate the two into two separate calculate values, how I was suppose to call the first calculate value to the second calculate value. So I figured why the model didn't stop, FLD_ZONE had some empty attributes.   I tried the following it runs but nothing is merged, no errors.     fc = r"C:\Temp\FEMA.gdb\FEMA_TempLyrs def f(fc): case_fields = ["FLD_ZONE",'ZONE_SUBTY'] # 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) with da.UpdateCursor(fc, fields, sql_clause=(None, sql_orderby)) as cur: for row in cur: print (row) if row[0] == None: case_func = itemgetter(*range(len(case_fields))) merged_polys = { key:reduce(arcpy.Geometry.union, (row[-1] for row in group)) for key, group in groupby(cur, case_func) } cur.reset() for key, group in groupby(cur, case_func): row = next(group) cur.updateRow(row[:-1] + [merged_polys[key]]) for row in group: cur.deleteRow() del cur return fc       I also tried separating the operations like you stated but nothing gets merged, with error.   Error: ERROR 000539: Traceback (most recent call last): File "<expression>", line 1, in <module> File "<string>", line 38, in fc1 TypeError: 'NoneType' object is not subscriptable       import sys, arcpy, os from arcpy import env from arcpy import da from itertools import groupby from operator import itemgetter from functools import reduce fc = r"C:\Temp\FEMA.gdb\FEMA_TempLyrs" def f(fc): case_fields = ["FLD_ZONE",'ZONE_SUBTY'] # 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) merged_polys = None with da.SearchCursor(fc, fields, sql_clause=(None, sql_orderby)) as cur: case_func = itemgetter(*range(len(case_fields))) for row in cur: print (row) if row[0] == None: merged_polys = { key:reduce(arcpy.Geometry.union, (row[-1] for row in group)) for key, group in groupby(cur, case_func) } else: pass del cur with da.UpdateCursor(fc, fields, sql_clause=(None, sql_orderby)) as uCur: for key, group in groupby(uCur, case_func): row = next(group) uCur.updateRow(row[:-1] + [merged_polys[key]]) for row in group: uCur.deleteRow() return fc       ... View more

Thanks for the reply, I guess I am not understand how to put the code/model together to work. Is there another way that this can be accomplished? ... View more

man, totally over looked that one. Got it to work with. Thanks for all the help! for row in cursor: print (f'checking: {row[1]}') row[2] = 'PLAT' if row[1] in plats_list else assignName.get(row[1], row[3]) cursor.updateRow(row)     ... View more

Jeff, Sorry for the delay. I did remove the "*", after I posted my response but still line 14 won't update the row with the plats_list. Both fields are text fields. I've been trying to figure it out but I can't seem to. Logically line 14 makes sense. Also looking at the data there seems to be some blanks in row 1 "Type" field and if that is the case I would like to update row[2] "Type2" with with field1. Sorry I didn't realize this until I was looking into the Type field to see why line 14 was not being updated. If I can get pasted line 14 not passing the plat_list I can figure out how to update "Type" if "Type" field is empty.   ObjectID Type field1 Type2 1 BP Permit BuildingPermit 2 FEMA   FEMA_LOMARs 3 PLAT - Preliminary Sub PLAT 4 Sub   PLAT 5   Floodway FEMA_Floodway         import arcpy fc = 'C:/Temp/permits.gdb/test' assignName = {"BP" : "BuildingPermit", "FMEA" : "FEMA_LOMAR", 'PLAT': "Sub"} #fields = ["OBJECTID", "Type", "Type2"] #print(assignName) plats_list = ['PLAT - Preliminary' ,'PLAT - Final', 'PLAT - Short'] cursor = arcpy.da.UpdateCursor(fc,["OBJECTID", "Type", "Type2"]) for row in cursor: if row[1] in assignName: print (assignName[row[1]]) row[2] = assignName['PLAT'] if row[1] in plats_list else assignName.get(row[1]) cursor.updateRow(row)         ... View more

Thanks for the reply, really appreciate it. That explains why I didn't find anything about wildcards in Dictionaries. I have added your suggestion but field "Type2" doesn't get populated with "Plat".   import arcpy fc = 'C:/Temp/permits.gdb/test' assignName = {"BP" : "BuildingPermit", "FMEA" : "FEMA_LOMAR", 'PLAT*': "Sub"} #fields = ["OBJECTID", "Type", "Type2"] #print(assignName) plats_list = ['PLAT - Preliminary' ,'PLAT - Final', 'PLAT - Short'] cursor = arcpy.da.UpdateCursor(fc,["OBJECTID", "Type", "Type2"]) for row in cursor: if row[1] in assignName: print (assignName[row[1]]) row[2] = assignName['PLAT'] if row[1] in plats_list else assignName.get(row[1]) cursor.updateRow(row)   ... View more

I was able to get what I need with the following. My only other question is how do I get the counter to on top of the OBJECTID rows? fields = ["OBJECTID", "PN1"] where = "PN1 = ' ' OR PN1 IS NULL" counter = 0 with arcpy.da.SearchCursor(fc, fields, where) as cursor: for row in cursor: if row[1]in ["", " ", None]: counter += 1 print ("OBJECTID {0}".format(row[0]) + "has a NULL value in field") print ("{} {} records have blank/empty or NULL records".format(row[0],counter))   Results; OBJECTID 44has a NULL value in field OBJECTID 47has a NULL value in field OBJECTID 88has a NULL value in field OBJECTID 106has a NULL value in field OBJECTID 108has a NULL value in field OBJECTID 121has a NULL value in field OBJECTID 130has a NULL value in field OBJECTID 182has a NULL value in field OBJECTID 210has a NULL value in field 210 9 records have blank/empty or NULL records   How do i put the "210 9 records have blank/empty or NULL records" on top like so   210 9 records have blank/empty or NULL records. OBJECTID 44has a NULL value in field OBJECTID 47has a NULL value in field OBJECTID 88has a NULL value in field OBJECTID 106has a NULL value in field OBJECTID 108has a NULL value in field OBJECTID 121has a NULL value in field OBJECTID 130has a NULL value in field OBJECTID 182has a NULL value in field OBJECTID 210has a NULL value in field ... View more

I was able to get something printed with the suggestion but it repeats.   fields = ["OBJECTID", "PN1"] for field in fields: where = "PN1 = ' ' OR PlN1 IS NULL" try: with arcpy.da.SearchCursor(fc, fields, where) as cursor: for row in cursor: #print("Null value in row {0}".format(row[0], row[1])) print ("OBJECTID {0}".format(row[0]) + "has a NULL value in field") ## result = arcpy.GetCount_management(fc).getOutput(0) ## print ('{} has {} records'.format(fc, result[0])) except RuntimeError: pass del cursor OBJECTID 44has a NULL value in field OBJECTID 47has a NULL value in field OBJECTID 88has a NULL value in field OBJECTID 106has a NULL value in field OBJECTID 108has a NULL value in field OBJECTID 121has a NULL value in field OBJECTID 130has a NULL value in field OBJECTID 182has a NULL value in field OBJECTID 210has a NULL value in field OBJECTID 44has a NULL value in field OBJECTID 47has a NULL value in field OBJECTID 88has a NULL value in field OBJECTID 106has a NULL value in field OBJECTID 108has a NULL value in field OBJECTID 121has a NULL value in field OBJECTID 130has a NULL value in field OBJECTID 182has a NULL value in field OBJECTID 210has a NULL value in field   ... View more