Latest Contributions by KyleWikstrom

‎06-30-2021

Hey Chris, An additional follow up that I wanted to put here for documentation purposes and for others is that regarding the next pickup date for Independence Day. Since Independence Days is on a Sunday this year, the observed holiday date will be 7/5. Pickup districts with Monday pickup service were still displaying Monday 7/5 as the next pickup date even though the next pickup date is actually Thursday 7/8. To adjust for this, I made the following update to line 30 of the expression that you posted. "Next Day of Week - 4": [[-1,5,1],[7,5],[1,9,1]], I simply changed the date of Independence Day to 7/5 so that the Arcade expression will return the actual next pickup date. This case brings to light the difference in how holidays are handled and how observed holidays are handled. For now, I have updated line 30, and added a commented out note that states why Independence Day is 7/5 and when it should be changed back to 7/4.

‎06-24-2021

Hi again, Chris, An update regarding holiday pickup dates from the county local government that is using this. If the next scheduled pickup is a holiday, then the next scheduled pickup will be the Thursday of the same week. No regular services are provided on Thursdays, so the county does not outline how to handle next pickup dates if it is a Thursday. I apologize for not having this information before. The local government is VERY happy to have the My Trash Services solution, and wants to make sure it is accurate for its residents. The app usage spikes during holidays and that is when it is most important to have the correct information. Thanks for all of your help on this one, and will be happy to share the application when completed! Will actually be expanding the My Trash Services solution into a fully comprehensive Hub initiative!

‎06-23-2021

Hi Chris, This is great! Thank you for your work on this. It is greatly appreciated! In the event that the Next Pickup Date is Christmas, which would mean the Next Pickup Date is scheduled for New Years Day which is also a 'no service' holiday, the Next Pickup Date would be the next regular pickup date in January. Simply put, there would be no pickup service the week of Christmas and New Years IF the Next Pickup Date falls on either of those days.

‎06-18-2021

Thanks, Scott! Hey Chris! Yes, that is correct. For this year, Labor Day is on Monday 9/6 and the next pickup day will be Thursday 9/9. The pattern for those three holidays is that if the next pickup day is a holiday, then the holiday pick up date will be the Thursday immediately following the original day. For Thanksgiving, Christmas, and New Year's, you are also correct - there will be no scheduled pick up that week and normal pickup will resume the following week. Almost like a hybrid of 'Next Scheduled Pickup' and a new or modified nextPickupHoliday that considers a dictionary of specific holidays with their respective designated pickup dates.

‎06-17-2021

Greetings, all! I am configuring the My Trash Services solution deployed from the ArcGIS Solutions App, and specifically configuring the Next Pickup Arcade expression for the Pickup [polygon] layers. The expression includes a variable for nextPickupHoliday where I can configure "Next Weekday", "Next Day", or "Next Scheduled Pickup", and the returned value will be the next weekday, next day, or next scheduled pickup day, respectively. I am seeking help to update the expression to accommodate the following scenario: If the pickup day is Memorial Day, then the next pickup day will be the following Thursday. If the pickup day is Independence Day, then the next pickup day will be the following Thursday. If the pickup day is Labor Day, then the next pickup day will be the following Thursday. If the pickup day is Thanksgiving, then there will be no pickup day that week. If the pickup day is Christmas, then there will be no pickup day that week. If thee pickup day is New Years Day, then there will be no pickup that week. So, two scenarios to this special case: (1) if the pickup day is on a specific holiday, then the next pickup day will be on a specific day of the week during that week, and (2) if the pickup day is on a specific holiday, then there will be no pickup day during that week. Since the Solutions experience updates and can change, I have included the Arcade expression below that I am using. /*If pickup occurs weekly, specify 1. If every other week specify 2, etc.*/ var pickupWeekInterval = 1; /*Specify a date in the past in which pickup occurred. This is used in the case where pickup doesn't occur every week to determine the weeks where pickup is occurring.*/ var firstPickupWeek = Date('2017-01-01'); /*If the pickup service isn't available year-round specify the first and last day of the season that pickup will occur, [[Start Month, Start Day], [[End Month, End Day]]*/ var openSeason = [[1,1],[12,31]] //Specify any holidays where pickup will not occur, [Month, Day] var holidays = [[1,1],[7,4],[12,25]] /*Specify any variable holidays where pickup will not occur, [Occurrence, Month, Day of the Week (Sunday = 0, Saturday = 6)] These are holidays that don't fall on the same date every year, i.e. Memorial Day, Labor Day, Thanksgiving [-1,5,1] corresponds to Memorial Day -> Last occurrence in May of a Monday [1,9,1] corresponds to Labor Day -> 1st occurrence in September of a Monday [4,11,4] corresponds to Thanksgiving -> 4th occurrence in November of a Thursday*/ var variableHolidays = [[-1,5,1],[1,9,1],[4,11,4]]; /*Specify if the next scheduled pickup day falls on a holiday, when will the next actual pickup be. "Next Weekday" - The pickup will occur on the next weekday after the holiday "Next Day" - The pickup will occur on the next day after the holiday "Next Scheduled Pickup" - The pickup will occur on the next scheduled day after the holiday*/ var nextPickupHoliday = "Next Weekday"; var pickupDays = []; var pickupDaysFields = [$feature.SUNDAY, $feature.MONDAY, $feature.TUESDAY, $feature.WEDNESDAY, $feature.THURSDAY, $feature.FRIDAY, $feature.SATURDAY] for (var k in pickupDaysFields) { if (pickupDaysFields[k] == 'Yes') { pickupDays[Count(pickupDays)] = k; } } if (Count(pickupDays) == 0) return; function calcRelativeHoliday(week, month, day, year) { var holiday; if (week < 0){ var lastDay = DateAdd(Date(year, month + 1, 1), -1, 'days'); var dayOfWeek = Weekday(lastDay); var dayDiff = day - dayOfWeek; if (dayDiff > 0) dayDiff -= 7; holiday = DateAdd(lastDay, dayDiff + ((week + 1) * 7), 'days'); } else{ var firstDay = Date(year, month, 1); var dayOfWeek = Weekday(firstDay); var dayDiff = day - dayOfWeek; if (dayDiff < 0) dayDiff += 7; holiday = DateAdd(firstDay, dayDiff + ((week - 1) * 7), 'days'); } return holiday; } function getNextPickupDay(fromDate) { var currentDay = Weekday(fromDate); var pickupOffset = 0; if (pickupWeekInterval > 1){ var weekDif = DateDiff(DateAdd(fromDate, 0 - currentDay, 'days'), DateAdd(firstPickupWeek, 0 - Weekday(firstPickupWeek), 'days'), 'days') / 7; weekDif = weekDif % pickupWeekInterval; if (weekDif > 0) pickupOffset = pickupWeekInterval - weekDif; } var difDays; var nextPickupDay; if (pickupOffset > 0) { nextPickupDay = pickupDays[0]; difDays = nextPickupDay - currentDay; difDays += (7 * pickupOffset); } else { for(var k in pickupDays) { if (pickupDays[k] >= currentDay) { nextPickupDay = pickupDays[k]; break; } } if (IsEmpty(nextPickupDay)) nextPickupDay = pickupDays[0]; difDays = nextPickupDay - currentDay; if (nextPickupDay < currentDay) difDays += (7 * pickupWeekInterval); } return DateAdd(fromDate, difDays, 'days'); } function getHolidays(fromDate) { var holidayDates = []; for (var k in holidays) { var holiday = Date(Year(fromDate), holidays[k][0] -1, holidays[k][1]); if (holiday < fromDate) holiday = Date(Year(fromDate) + 1, holidays[k][0] -1, holidays[k][1]); holidayDates[k] = holiday; } for (var k in variableHolidays) { var x = variableHolidays[k]; var holiday = calcRelativeHoliday(x[0], x[1]-1, x[2], Year(fromDate)); if (holiday < fromDate) holiday = calcRelativeHoliday(x[0], x[1]-1, x[2], Year(fromDate) + 1); holidayDates[Count(holidayDates)] = holiday; } return holidayDates; } function validateSeasonPickup(pickupDate) { var startSeasonMonth = openSeason[0][0]-1; var startSeasonDay = openSeason[0][1]; var endSeasonMonth = openSeason[1][0]-1; var endSeasonDay = openSeason[1][1]; if (Date(Year(pickupDate), startSeasonMonth, startSeasonDay) > Date(Year(pickupDate), endSeasonMonth, endSeasonDay)) { if (pickupDate < Date(Year(pickupDate), startSeasonMonth, startSeasonDay) && pickupDate > Date(Year(pickupDate) - 1, endSeasonMonth, endSeasonDay)) pickupDate = getNextPickupDay(Date(Year(pickupDate), startSeasonMonth, startSeasonDay)) } else { if (pickupDate < Date(Year(pickupDate), startSeasonMonth, startSeasonDay)) pickupDate = getNextPickupDay(Date(Year(pickupDate), startSeasonMonth, startSeasonDay)); else if (pickupDate > Date(Year(pickupDate), endSeasonMonth, endSeasonDay)) pickupDate = getNextPickupDay(Date(Year(pickupDate) + 1, startSeasonMonth, startSeasonDay)); } return pickupDate; } function validateHolidayPickup(pickupDate, holidayDates) { for(var k in holidayDates) { if (pickupDate == holidayDates[k]) { if (nextPickupHoliday == "Next Scheduled Pickup") { pickupDate = getNextPickupDay(DateAdd(pickupDate, 1, 'days')); } else if (nextPickupHoliday == "Next Day") { pickupDate = DateAdd(pickupDate, 1, 'days'); } else if (nextPickupHoliday == "Next Weekday") { var currentDay = Weekday(pickupDate); if (currentDay > 4) { pickupDate = DateAdd(pickupDate, 8 - currentDay, 'days'); } else { pickupDate = DateAdd(pickupDate, 1, 'days'); } } break; } } return pickupDate } var nextPickup = getNextPickupDay(Today()); nextPickup = validateSeasonPickup(nextPickup); nextPickup = validateHolidayPickup(nextPickup, getHolidays(nextPickup)); return Text(nextPickup, 'dddd, MMMM D'); I genuinely appreciate any help and suggestions for best or better practices when working with expressions. Thanks all! @ScottOppmann

‎12-16-2020

Hi @JamesM , I was very glad to find this content on GeoNet because we are experiencing this challenge at a couple local governments that are using web map Arcade expressions to pass feature point geometry attributes as URL parameters into Survey123 forms. In some cases, staff users are submitting reports using Survey123 for property parcels, and the rounding of the Arcade calculated coordinates from 10-12 digits down to 5 digits in Survey123 is producing an offset of significant consequence when the Survey123 point feature gets misplaced on top of a different property parcel. The workaround is for staff to verify the location of the point in the map before saving the survey and to manually update it. However, if multiple surveys are submitted for a single property where the staff user is manually updating the point location each time, the points are getting scattered across the property parcel over time, and is impacting the perception of data integrity within the department. If you're able to provide some information on where this idea/issue has landed, if it will be updated in an upcoming version, and if you or others have other workarounds to improving the prevision of the mapped point when using URL center paramenters. Thanks, James!

‎12-01-2020

Desire the ability to upload bookmark thumbnails. Exceptionally rare that we and the organizations with whom we work will have a web-hosted image repository. More efficient to be able to upload these thumbnail graphics, and eliminate the requirement to have an image hosting service elsewhere.

‎12-01-2020

It is highly desirable to have the supported capability to configure the hover label of a chart's bars, a pie's slices, and a line graph's plotted points in the popups. The use case is that not all of the data we work with use attribute names in a way that would make them an appropriate label. Instead, there is often an attribute named 'Label', and the attribute value is what the user needs to see when hovering over a chart bar, slice, or plotted point. Specific example: When configuring the My Tax Distribution application, where a table contains records for every parcel, and every record has a set of attributes designed to hold one set of information. Attributes Parcel Number or Name Tax District Name 1 Tax District Amount 1 Tax District Name 2 Tax District Amount 2 The values in the 'Tax District Name 1' will not be identical, and the same is true for the other Tax District Name attributes. Presently, when hovering over a chart bar, pie slice, or plot point, the hover label displays the attribute name, and does not provide complete or the most insightful information about the data or the data value being hovered over. This will be very important for us to take advantage of Map Viewer Beta Chart authoring. Happy to provide more details if needed. Thank you! :)

‎08-06-2020

Adding Median as an additional Statistic Type to the Dashboards Indicator widget would be nice.

‎07-09-2020

This is more clear. Thank you.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by KyleWikstrom

Re: Configuring the Next Pickup Arcade expression in My Trash Services solution

Re: Configuring the Next Pickup Arcade expression in My Trash Services solution

Re: Configuring the Next Pickup Arcade expression in My Trash Services solution

Re: Configuring the Next Pickup Arcade expression in My Trash Services solution

Configuring the Next Pickup Arcade expression in My Trash Services solution

Re: Increase Survey123 accuracy

Bookmark Thumbnail Uploads

Popup Chart Labels

Additional Indicator Statistic Types

Re: StoryMaps Design Navigation Unresponsive