Latest Contributions by erica_poisson

Hi - I'd like to create a Flow that sends an email (or even better, an SMS) when a hosted feature layer has not been updated in more than 30 minutes. I am currently looking at the ArcGIS "Get data from feature layer", but do not see any easy way to pull the last updated date associated with the layer.  Is this possible, and if yes, how would I do this? Thank you! ... View more

Hi - I am posting this here because I'd submitted a ticket to Esri Technical Support and they did not get around to testing my case until after Daylight Savings Time. This issue self resolved once DST was passed, however I strongly feel as if this is a bug and wanted to bring it to the community/Survey123 team's attention. Please see below for details - these details were relevant before 3/10/24 when scheduling an appointment for a date after DST. I am happy to provide more details if anyone is interested.  I have a Survey123 form which has been in use for about 5 years now. We use a series of calculations with date and time to schedule appointments. We are having issues with the Survey123 field app, version 3.19.120, installed on Windows desktops where any appointment made AFTER Daylight Savings Time results in an incorrect appointment end time. I have attached a copy of the XLSForm here and a Word document with some screen captures showing this example (please note this XLSForm contains a series of pulldata calculations which reference a protected hosted feature layer, so these will not work, however this will not impact testing the issue below). Steps to reproduce this issue: Select appointment start date/time AFTER 3/10/24. Adjust appointment start time so that it starts at an interval of 20 (e.g. 0800, 0820, 0840). Click "off" to close time adjustment for appointment start time. Appointment End time adjusts but is 1 hour off (too long). Each appointment was exactly 1 hour off (too long) in the end time. ... View more

Hi -  I'm sure someone on here has asked this and received an answer, but I can't find it.  I have a data expression being used within a table element of a dashboard. I'd ideally like the user be able to make a selection (polygon) in the dashboard's map and then have the table be filter spatially based on the selection in the map using layer actions.  This code works great with a category selector, but not with my configured layer actions (it returns no data). I suspect my geometry is not being included in the Push and final FeatureSet (starts at lines 108 to end). Any suggestions on how to correct this? // custom memorize function to increase performance of featureset function Memorize(fs) { var temp_dict = { fields: Schema(fs)['fields'], geometryType: Schema(fs).geometryType, features: [] } for (var f in fs) { var attrs = {} for (var attr in f) { attrs[attr] = Iif(TypeOf(f[attr]) == 'Date', Number(f[attr]), f[attr]) } Push( temp_dict['features'], {attributes: attrs, geometry: Geometry(f)} ) } return FeatureSet(Text(temp_dict)) } // variable to define the portal URL var portal = Portal("https://mass-eoeea.maps.arcgis.com"); //Quabbin and Ware Encroachments var qEncroach = FeatureSetByPortalItem(portal,"1234abc",0,['Date_Found', 'Type', 'Encroachment_Priority', 'Description'],true); //Wachusett and Sudbury Encroachments var wEncroach = FeatureSetByPortalItem(portal,"5678def",0,['Date_Found', 'Type', 'Encroachment_Priority', 'Description'],true); // Create a FeatureSet with all encroachments from Quabbin, Ware and Wachusett var int_dict = { fields: [ {'name': 'type', 'type': 'esriFieldTypeString'}, {'name': 'edate', 'type': 'esriFieldTypeDate'}, {'name': 'priority', 'type': 'esriFieldTypeString'}, {'name': 'descript', 'type': 'esriFieldTypeString'}], geometryType: 'esriGeometryPoint', "spatialReference": { "wkid": 102100, "latestWkid": 3857 }, 'features':[], }; // Fill intermediate FeatureSet with encroachment info var i = 0; for (var f in qEncroach) { int_dict.features[i] = { attributes: { 'type': f["Type"], 'edate': DateDiff(f["Date_Found"], Date(1970, 0, 1, 0, 0, 0), "milliseconds"), 'priority': f["Encroachment_Priority"], 'descript': f["Description"], }, geometry: Geometry(f), } i++; }; for (var g in wEncroach) { int_dict.features[i] = { attributes: { 'type': g["Type"], 'edate': DateDiff(g["Date_Found"], Date(1970, 0, 1, 0, 0, 0), "milliseconds"), 'priority': g["Encroachment_Priority"], 'descript': g["Description"], }, geometry: Geometry(g), } i++; }; Console(Text(int_dict)); var encroach_set = Memorize(FeatureSet(Text(int_dict))) // Basins var basins = Memorize(FeatureSetByPortalItem(portal, "987406d7d0614370b6493dfe58c9e62c", 0, ['District', 'Subbasin_Name'], true)) // create final featureset var finalDict = { fields: [ {name: "Encroach_Type", type: "esriFieldTypeString"}, {name: "Encroach_Date", type: "esriFieldTypeDate"}, {name: "Encroach_Priority", type: "esriFieldTypeString"}, {name: "Encroach_Description", type: "esriFieldTypeString"}, {name: "SubbasinName", type: "esriFieldTypeString"}, {name: "DistrictName", type: "esriFieldTypeString"}, ], geometryType:"esriGeometryPoint", "spatialReference": { "wkid":102100, "latestWkid":3857 }, features: [], } // intersect CMRs with basins to determine which basin each occured in for(var e in encroach_set) { var i_basin = First(Intersects(e, basins)) var i_basin_name = Iif(i_basin == null, "No basin", i_basin.Subbasin_Name) var i_basin_district = Iif(i_basin == null, "No district", i_basin.District) //add to array Push(finalDict['features'], {attributes:{ Encroach_Type: e['type'], Encroach_Date: e['edate'], Encroach_Priority: e['priority'], Encroach_Description: e['descript'], SubbasinName: i_basin_name, DistrictName: i_basin_district, }}) } Console(Text(finalDict)); return FeatureSet(Text(finalDict))   ... View more

Enable export/download consistently within Dashboards. The example below is specifically when a Data Expression is used with the Table Element of a Dashboard. Data export/download currently works if you are referencing a hosted feature layer as the data source, OR if you use a data expression as the data source and select Table type = Grouped values. Data export/download does not work if you data source is a data expression and you select Table Type = Features.  I've tested this with the same data expression. The data sources used within the expression all have the export capability enabled via the Item Details. Here is the data expression: // custom memorize function to increase performance of featureset function Memorize(fs) { var temp_dict = { fields: Schema(fs)['fields'], geometryType: Schema(fs).geometryType, features: [] } for (var f in fs) { var attrs = {} for (var attr in f) { attrs[attr] = Iif(TypeOf(f[attr]) == 'Date', Number(f[attr]), f[attr]) } Push( temp_dict['features'], {attributes: attrs, geometry: Geometry(f)} ) } return FeatureSet(Text(temp_dict)) } // variable to define the portal URL var portal = Portal("https://mass-eoeea.maps.arcgis.com"); //Quabbin and Ware Encroachments - internally shared layer w/ export enabled var qEncroach = FeatureSetByPortalItem(portal,"1234abc",0,['Date_Found', 'Type', 'Encroachment_Priority', 'Description'],true); //Wachusett and Sudbury Encroachments - internally shared layer w/ export enabled var wEncroach = FeatureSetByPortalItem(portal,"5678def",0,['Date_Found', 'Type', 'Encroachment_Priority', 'Description'],true); // Create a FeatureSet with all encroachments from Quabbin, Ware and Wachusett var int_dict = { fields: [ {'name': 'type', 'type': 'esriFieldTypeString'}, {'name': 'edate', 'type': 'esriFieldTypeDate'}, {'name': 'priority', 'type': 'esriFieldTypeString'}, {'name': 'descript', 'type': 'esriFieldTypeString'}], geometryType: 'esriGeometryPoint', "spatialReference": { "wkid": 102100, "latestWkid": 3857 }, 'features':[], }; // Fill intermediate FeatureSet with encroachment info var i = 0; for (var f in qEncroach) { int_dict.features[i] = { attributes: { 'type': f["Type"], 'edate': DateDiff(f["Date_Found"], Date(1970, 0, 1, 0, 0, 0), "milliseconds"), 'priority': f["Encroachment_Priority"], 'descript': f["Description"], }, geometry: Geometry(f), } i++; }; for (var g in wEncroach) { int_dict.features[i] = { attributes: { 'type': g["Type"], 'edate': DateDiff(g["Date_Found"], Date(1970, 0, 1, 0, 0, 0), "milliseconds"), 'priority': g["Encroachment_Priority"], 'descript': g["Description"], }, geometry: Geometry(g), } i++; }; Console(Text(int_dict)); var encroach_set = Memorize(FeatureSet(Text(int_dict))) // Basins - public layer var basins = Memorize(FeatureSetByPortalItem(portal, "987406d7d0614370b6493dfe58c9e62c", 0, ['District', 'Subbasin_Name'], true)) // create final featureset var finalDict = { fields: [ {name: "Encroach_Type", type: "esriFieldTypeString"}, {name: "Encroach_Date", type: "esriFieldTypeDate"}, {name: "Encroach_Priority", type: "esriFieldTypeString"}, {name: "Encroach_Description", type: "esriFieldTypeString"}, {name: "SubbasinName", type: "esriFieldTypeString"}, {name: "DistrictName", type: "esriFieldTypeString"}, ], geometryType:"esriGeometryPoint", "spatialReference": { "wkid":102100, "latestWkid":3857 }, features: [], } // intersect CMRs with basins to determine which basin each occured in for(var e in encroach_set) { var i_basin = First(Intersects(e, basins)) var i_basin_name = Iif(i_basin == null, "No basin", i_basin.Subbasin_Name) var i_basin_district = Iif(i_basin == null, "No district", i_basin.District) //add to array Push(finalDict['features'], {attributes:{ Encroach_Type: e['type'], Encroach_Date: e['edate'], Encroach_Priority: e['priority'], Encroach_Description: e['descript'], SubbasinName: i_basin_name, DistrictName: i_basin_district, }}) } Console(Text(finalDict)); return FeatureSet(Text(finalDict))   Here are the settings used within the Table Element when download summarized data is an option for me to toggle under "General":   Here are the settings used with a different Table Element when download summarized data is not an option for me to toggle under "General":   Some additional details: I am working in ArcGIS Online and using a data expression to bring two different feature layers together into a new FeatureSet. I need to provide information on individual records, so I can not use Table Type = Grouped Values. Both feature layers referenced in the data expression allow export/download (that was the first thing I checked).  ... View more