Latest Contributions by JayJohnsonWashoeCounty

Yes, you can do this via a custom Expression in Symbology. In the webmap, open symbology for the layer, in the attribute to symbolize, scroll all the way to the bottom of the list and create a custom expression.  The custom expression could be something like this: // Symbolize by Expired var age var Expired // Difference between feature attribute and today age = DateDiff(Now(),$feature.ExpirationDate,'days') //Is it expired or not? Expired = iif(age<0, 'Not Expired','Expired') //Sybolize on this value return Expired That should get you close to a solution. Jay ... View more

I agree that Experience Builder seems generally slower to load than Web App Builder apps.  Initial load is slow and then navigating between pages within ExpBuilder is also noticeably slow. Jay ... View more

Hey Derek. Let me expand on this a bit.  Our COVID data gets updated once per day, at some random time each afternoon.  If I use the "Last 7 Days" selector, I get some variable number of results in my list, depending on the TIME OF DAY that each daily update occurred.   Example 1:  The current time is 3:30 PM.  If data has already been uploaded today AND if 7 days ago the data was uploaded at 6:00 pm, the "Last 7 Days" Selector will return 8 values.   Example 2:  The current time is 3:30 PM.  If data HAS NOT been uploaded for today AND if 7 days ago the data was uploaded at noon, the "Last 7 Days" Selector will return 6 values. Both of these results are technically correct, but it feels unpredictable to the users in the context of "what does the pattern of new COVID cases over the last 7 days look like?".  I think the disconnect here is that we humans often think of days more like integers (i.e. the most recent 7 calendar days for which we have data), while the Date Selector is more analogous to decimals (what data exists within the last 168 consecutive hours).   What I'm asking is whether there is a style of selector that can consistently return a list of the last 7 daily values, or 30 daily values, etc.   Thanks, Jay ... View more

The only way I can see to do this would be to add the first layer to your map and configure the popup as desired.  Then COPY that layer - now you have two layers with the same popup configuration, but both pointing to the same data layer.  Next use the Attribute Assistant ArcGIS Online Assistant  to Update the URL of the second layer to point to a different data source. Using the same popup configuration for different layers assumes that those layers have the same fields. Jay ... View more

Paul, It does rather boggle the mind that a dataset that is the backbone of so much of our modern world's commerce and communication infrastructure is so piecemeal.  Our Dispatch Center ended up getting spreadsheets from various contractors for each of the major telco carriers, which I've brought into GIS for our analysis purposes.  And yes, dealing with this data is just as problematic as you might expect (horrendous field names, no standard schema, and generally bewildering IDs).  Fortunately our project doesn't require parcel level accuracy, but I do like your idea of a LIDAR analysis to validate location data... Jay ... View more

Thanks Jianxia.  Yes, documenting the URL pattern was exactly what I was looking for. I'll try to work with what you have above to see if I can get where I need to be. From within my Experience, I click on a specific feature and the webmap pans to that feature.  The URL in the browser becomes this: https://experience.arcgis.com/experience/2fe9e44b691a4e32a9f0b84df16531c0?data_id=dataSource_3-ElectionGeography_795a03f022d2420ca49bf52b79aa80b5_5103_3112_2857_6478_6139%3A397  The first part is my ExpBuilder app URL and the hosted layer that contains the feature I've clicked on: https://experience.arcgis.com/experience/2fe9e44b691a4e32a9f0b84df16531c0?data_id=dataSource_3-ElectionGeography_795a03f022d2420ca49bf52b79aa80b5 But AFTER that, there is a mysterious string of numbers that I can't interpret:  _5103_3112_2857_6478_6139%3A397 It does not appear that those numbers are a straight-forward reference to the selected feature. Jay ... View more

Typically this would happen if you have fields which appear blank, but are actually either NULL or contain a non-visible character (like a space).  Try adding to your filter to exclude NULLS and " " and see if that helps. Jay ... View more

Elyse, The answer depends on how your input data is set up.  What fields do you have in your data?  Do you want indicators for "today", or a trend chart for all dates? We've ended up pre-processing our COVID data in order to get a data structure that is easy to work with in AGOL. The main table we are hosting in AGOL looks like this: https://services.arcgis.com/iCGWaR7ZHc5saRIl/arcgis/rest/services/CasesTable_public/FeatureServer/layers  I think the main thing is you are going to want a row for each day and columns for any variables you want to graph or have indicators for.  You can see that we are pre-populating a TotalCases and NewCases (and many other variables) for each day, which makes it easy to produce serial charts. Our COVID dashboard started out modestly, but as you can see has gotten more and more packed with info as time has gone on... Washoe County NV COVID-19 Dashboard  Bottom line - you can do a LOT with Dashboard, but you have to get the data set up in the right way first. Jay ... View more

Great!  Nice solve with Cell Statistics.   ... View more

Good idea Jim, but that setting was already enabled.  The recent MXDs showed up just fine in 10.7, prior to my upgrade to 10.8. ... View more

This is actually pretty slick in ModelBuilder. Put in a "Calculate Value" like this, with the expression = time.strftime("%Y%m%d") and the output name "Today" (output name can be whatever you like). I make the "Today" output a precondition to something early in the model, so I know it will run before the model gets to the point where I need it. Next, name your final model outputs something like this c:\temp\OutputOne%Today%   The %Today% will grab the value from your Calculate Value operation and make it part of the filename. Jay ... View more