topic Re: How to create a feature layer view of current features based on start and end time attribute fields in ArcGIS Online Questions

How to create a feature layer view of current features based on start and end time attribute fields

ElizabethHale1 — Mon, 17 Jan 2022 07:16:10 GMT

I have a hosted feature layer in ArcGIS Online of features with a start time field and an end time field. How do I create a feature layer view that filters for current features based on start and end time? In other words, when features pass their end time they expire and drop out of the feature layer view. Alternately, when features pass their start time they become included in the feature layer view.

Re: How to create a feature layer view of current features based on start and end time attribute fields

StuartMoore — Mon, 17 Jan 2022 09:55:41 GMT

i dont know how to do it in a view but we have a set of maps showing features based on a survey to and survey from dates

using the Arcgis online assistant (https://ago-assistant.esri.com/ )you can manually edit the feature service filters, i'll see if i can find the original post about it....

StuartMoore_0-1642413297001.png

Stu

Re: How to create a feature layer view of current features based on start and end time attribute fields

StuartMoore — Mon, 17 Jan 2022 09:57:15 GMT

this is the original post: https://community.esri.com/t5/arcgis-online-documents/dynamic-date-filter/ta-p/920367

Stu

Re: How to create a feature layer view of current features based on start and end time attribute fields

DallasCrow — Tue, 18 Jan 2022 22:13:38 GMT

Hey Elizabeth,

You might be able to use a combination of "in the last..." conditions to make this kind of dynamic filter. I attached an example image - this displays features that have started in the last 100 years, but not ended in the last 100 years.

Re: How to create a feature layer view of current features based on start and end time attribute fields

Stefan_Thorn — Wed, 19 Jan 2022 10:51:01 GMT

Hi @ElizabethHale1 ,

No need to make a view.

When you create an instant app with slider from your webmap, it is possible to have this behavior. Be aware of the second interval length, there you can set the time steps within the total time duration.

Stefan_Thorn_0-1642589287712.png

Re: How to create a feature layer view of current features based on start and end time attribute fields

ElizabethHale1 — Sat, 22 Jan 2022 19:29:09 GMT

Thanks Dallas! A simple solution that I missed because I was thinking about the filtering logic in a very particular way. In concept this filter should work. But what actually happens with a filter based on in the last/not in the last 100 years is that it creates a data error in the hosted feature layer view. No features in the data table and a warning "this layer did not draw completely" in the visualization. Ugh.

DidNotDraw.JPG

Troubleshooting this further I discovered the magic number is 68. Filtering for greater than 68 years breaks the view. Totally inane. But at least 68 or less works. I'd prefer to not have to specify a limit at all (filter based on before/after now), but at least something finally works!

Filter.JPG

Re: How to create a feature layer view of current features based on start and end time attribute fields

DallasCrow — Mon, 24 Jan 2022 19:57:44 GMT

Glad to help! Strange that it bugs out past 68 years - I wonder if it's an issue with the filter or something related to the dates in the feature layer? Either way it's great that you got it working.

Re: How to create a feature layer view of current features based on start and end time attribute fields

LiamHarrington-Missin — Fri, 08 Sep 2023 10:28:16 GMT

Wow! This dynamic filtering logic breaks my head. I don't think I would have come up with it without this post and the discovery of 68 is a great trial and error find. Thanks for the solution.