Latest Contributions by ChrisFox

@RobynSnookCCB, the solution is configured with custom filter expression on the layer in the view. This kind of expression can't be configured through the UI. The easiest way to replicate it would be use a tool like ArcGIS Assistant to edit the web map and update the "definitionExpression" of the layer to be something like below. In the example below endtime is the name of a date field in the service. endtime IS NULL OR endtime >= CURRENT_TIMESTAMP   ... View more

The Swap Parity tool like other gp tools honors the selection set on a layer. If you have multiple layers in the map with the same name you are likely selecting the layer with no selection and as a result is running for all roads in the layer. The easiest fix would be to give them unique names. Alternatively, you can drag/drop the layer from the Contents pane into the parameter of the gp tool, this will ensure you are selecting the correct layer from the map. ... View more

@CochranBob, we were able to find the issue. It appears that the logic for Cut changed at 2.9 and rather than returning an empty array when the feature was not cut, it is returning 1 feature, the original geometry. So it is a fairly easy fix, on line 61 rather than checking if their are 0 features in the array, check if there are less than 2 features. See the screenshot below.     ... View more

Hi Kyle, Give the update expression below a shot. In this I updated the holidays variable to be a dictionary, where the key is the what should be down for the holiday and the value is the list of holidays that apply to that option. So you can see, in the code below for the holidays you specified the next pickup will either be the next Thursday, or occur at the Next Schedule Pickup. The only thing this script doesn't account for now is Christmas and New Years are 1 week apart. What is the expectation for these holidays when the pickup date falls on Christmas the Next Scheduled Pickup would be New Years Day. Would you want the next pickup to be a week after New Years then? /*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 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 Day of Week - 4" - The pickup will occur on the next day of the week (Sunday = 0, Saturday = 6) "Next Scheduled Pickup" - The pickup will occur on the next scheduled day after the holiday*/ /*Specify any holidays where pickup will not occur, [Month, Day] 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 holidays = { "Next Weekday": [], "Next Day": [], "Next Day of Week - 4": [[-1,5,1],[7,4],[1,9,1]], "Next Scheduled Pickup": [[1,1],[4,11,4],[12,25]] } 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 dates = []; for (var d in holidays[k]) { if (Count(holidays[k][d]) == 2) { var holiday = Date(Year(fromDate), holidays[k][d][0] -1, holidays[k][d][1]); if (holiday < fromDate) { holiday = Date(Year(fromDate) + 1, holidays[k][d][0] -1, holidays[k][d][1]); } dates[d] = holiday; } else { var x = holidays[k][d]; 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); } dates[d] = holiday; } } holidayDates[k] = dates; } 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) { for (var d in holidayDates[k]) { if (pickupDate == holidayDates[k][d]) { if (k == "Next Scheduled Pickup") { pickupDate = getNextPickupDay(DateAdd(pickupDate, 1, 'days')); } else if (k == "Next Day") { pickupDate = DateAdd(pickupDate, 1, 'days'); } else if (k == "Next Weekday") { var currentDay = Weekday(pickupDate); if (currentDay > 4) { pickupDate = DateAdd(pickupDate, 8 - currentDay, 'days'); } else { pickupDate = DateAdd(pickupDate, 1, 'days'); } } else if (Find('Next Day of Week', k) > -1) { var dayOfWeek = Number(Right(k, 1)); var currentDay = Weekday(pickupDate); if (currentDay > dayOfWeek) { pickupDate = DateAdd(pickupDate, (dayOfWeek + 7) - currentDay, 'days'); } else { pickupDate = DateAdd(pickupDate, dayOfWeek-currentDay, 'days'); } } break; } } } return pickupDate } var nextPickup = getNextPickupDay(Today()); nextPickup = validateSeasonPickup(nextPickup); nextPickup = validateHolidayPickup(nextPickup, getHolidays(nextPickup)); return Text(nextPickup, 'dddd, MMMM D');   ... View more