Latest Contributions by DominicRobergeIADOT

still don't know where your dict1 is defined but this code will skip the rows with records with arcpy.da.UpdateCursor(fc,['Fielda','COUNT','Field1']) as cursor: for row in cursor: if row[0] not in (None, "", " "): row[2] = ",".join(dict1[row[0]]) cursor.updateRow(row) else: print("All good, nothing to do here") ... View more

Hello could you try to create a hosted feature view in map viewer using the Analysis/Join Features? That way you should have all your data into one layer to use within Dashboard. Hope that works for you        ... View more

hey perhaps your issue is related to this BUG Reference number:- BUG-000144024 Public Status:- New Synopsis:- The arcade expression to count the number of attachments fails to honor in the ArcGIS Field Maps.   I have a similar issue with an Arcade expression, working just fine in a web map but NOT in any of the mobile apps on IOS (Field Maps, Collector, etc.) ... View more

Hello take a look at this older post, that should solve your problem   https://community.esri.com/t5/arcgis-api-for-python-questions/setting-the-refresh-interval-for-a-hosted-feature/td-p/845181 ... View more

Hey Jay you should look at creating a new Data Expression on the Serial Chart settings. You could then create a featureset on the fly , splitting your MONTH/DAY field(s) and get the results you are looking for. (the sample link could give you some good ideas as well)   Hope that can help you. Good luck! // Write an expression that returns a FeatureSet. // Documentation: https://arcg.is/3c419TD // Samples: https://arcg.is/38SEWWz var fs = FeatureSetByPortalItem(Portal('https://arcgis.com/'), 'YOURITEMID', 0, ["CallDateTime","callYear"], false); var drFilter = "callYear in (2020,2021) and Agency in('AFD')" var drSel = Filter(fs,drFilter) //return count(drSel) var combinedDict = { fields: [ { name: "CallDateTime", type: "esriFieldTypeString" }, { name: "callYear", type: "esriFieldTypeString" }, { name: "callDay", type: "esriFieldTypeString" }, { name: "callMonth", type: "esriFieldTypeString" }, { name: "callMonthDay", type: "esriFieldTypeString" }, ], geometryType: "", features: [], }; var i = 0; for (var d in drSel){ combinedDict.features[i] = { attributes: { CallDateTime: d["CallDateTime"], callYear: d["callYear"], callDay: Day(d["CallDateTime"]), callMonth: ISOMonth(d["CallDateTime"]), callMonthDay: ISOMonth(d["CallDateTime"])+'-'+Day(d["CallDateTime"]) }, }; i++; //return d["CallDateTime"] + " " + ISOMonth(d["CallDateTime"]) + " "+ Day(d["CallDateTime"]) } //return combinedDict; return FeatureSet(Text(combinedDict));     ... View more

hummm I am not sure. it's working for me (see image below). Can you try to add a new dynamic txt for the count just for fun.       ... View more

we could replace the first updateCursor with SearchCursor, it's still working for me fields = ['OBJECTID','GROUPT', 'LABELT','SHAPE@X','SHAPE@Y'] where = f"""GROUPT IS NOT NULL AND TRIM(BOTH ' ' FROM GROUPT) <> ''""" print(where) sql_clause = (None, 'ORDER BY GROUPT DESC') i=0 with arcpy.da.SearchCursor(fc, fields, where, sql_clause=sql_clause) as ucurs: ucursSort = sorted(ucurs,key=lambda group : group[4], reverse=True) for group in ucursSort: print(group) current_group = group try: if current_group != previous_group: letter_index = 0 except NameError: letter_index = 0 new_lbl = ascii_uppercase[letter_index] print(new_lbl) #ucursSort.updateRow(group) where2 = f"""OBJECTID = """+str(group[0]) print(where2) with arcpy.da.UpdateCursor(fc, fields, where2) as ucursU: for r in ucursU: print(r) r[2] = new_lbl ucursU.updateRow(r) letter_index += 1 previous_group = current_group print("------------------") ... View more

I did tested it on a point feature class in a file geodatabase and it worked for me ... View more

how about this: Adding the UpdateCursor based on the OBJECTID of your first sorted() fields = ['OBJECTID','GROUPT', 'LABELT','SHAPE@X','SHAPE@Y'] where = f"""GROUPT IS NOT NULL AND TRIM(BOTH ' ' FROM GROUPT) <> ''""" print(where) sql_clause = (None, 'ORDER BY GROUPT DESC') i=0 with arcpy.da.UpdateCursor(fc, fields, where, sql_clause=sql_clause) as ucurs: ucursSort = sorted(ucurs,key=lambda group : group[4], reverse=True) for group in ucursSort: print(group) current_group = group try: if current_group != previous_group: letter_index = 0 except NameError: letter_index = 0 new_lbl = ascii_uppercase[letter_index] print(new_lbl) #ucursSort.updateRow(group) where2 = f"""OBJECTID = """+str(group[0]) print(where2) with arcpy.da.UpdateCursor(fc, fields, where2) as ucursU: for r in ucursU: print(r) r[2] = new_lbl ucursU.updateRow(r) letter_index += 1 previous_group = current_group print("------------------") ... View more

Hi Vince would this work for you. I tested it and seems like the sorted() reverse=true on the SHAPE@Y field will sort from North to South fields = ['OBJECTID','GROUPT', 'LABELT','SHAPE@X','SHAPE@Y'] where = f"""GROUPT IS NOT NULL AND TRIM(BOTH ' ' FROM GROUPT) <> ''""" sql_clause = (None, 'ORDER BY GROUPT DESC') with arcpy.da.UpdateCursor(fc, fields, where, sql_clause=sql_clause) as ucurs: ucursSort = sorted(ucurs,key=lambda group : group[4], reverse=True) for group in ucursSort: print(group) current_group = group try: if current_group != previous_group: letter_index = 0 except NameError: letter_index = 0 new_lbl = ascii_uppercase[letter_index] #ucurs.updateRow([group, new_lbl]) letter_index += 1 previous_group = current_group   ... View more

Hey I am curious, what version of ArcGIS Server are you running? I have a similar issue on one of our server running 10.6.1. Thanks! ... View more

Hi AspenN is your feature layer hosted on an ArcGIS Server or ArcGIS Online? if it's on an ArcGIS Server you could enable WFS from the Server Manager     ... View more

Hello, for me all me SDE connections are in the same folder (workspace) so if you define the workspace, you should get your listing of SDE databases. Worked for me. 🙂 (in Catalog, right click the SDE connection, select properties and look at the path of the "name") import arcpy arcpy.env.workspace = r"C:\Users\USERNAME\AppData\Roaming\ESRI\Desktop10.8\ArcCatalog" # List all file geodatabases in the current workspace workspaces = arcpy.ListWorkspaces("*", "SDE") for workspace in workspaces: print workspace     ... View more