Latest Contributions by DominicRoberge2

Try this var treepoints= FeatureSetByName($map, "new_tree_points") var numberoftrees= Count(Contains($feature,treepoints)) return numberoftrees           ... View more

Hey Alfons below is a piece of code that is similar that what you are trying to achieve. 1) Make sure you are using the FIELD Name and not the aliases 2) make you your formula returns valid values (no division /0...) That should works! Good luck!   arcpy.MakeFeatureLayer_management(sdeFCT, MFL,"TOTPOP10 >0 and ALAND10 >0") print(arcpy.GetCount_management(MFL)) expression = '("ALAND10"/"TOTPOP10") > 1000' print(expression) arcpy.SelectLayerByAttribute_management(MFL, 'NEW_SELECTION', where_clause=expression) if int(arcpy.GetCount_management(MFL)[0]) > 0: print("delete records") ##arcpy.DeleteFeatures_management(sdeFCT) else: print("good to go")   ... View more

Hi Matt in Fields Maps app, under your profile, make sure auto-Sync is turn on. Perhaps that will help ... View more

I see well if you don't have that many hasted feature layers, you can always set the refresh interval on the hosted Feature Layer page (under Visualization) . Click 3little dots, select refresh interval, set interval, then Save Layer.    ... View more

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