topic Re: Spatio-temporal data store hosted feature layer - Create view with topfilter to return latest observation for each TRACKID in Publishing and Managing Services Questions

Spatio-temporal data store hosted feature layer - Create view with topfilter to return latest observation for each TRACKID

egamble — Tue, 05 Dec 2023 20:17:58 GMT

I'd like to build a view layer that returns the newest observation for each trackid in a hosted spatiotemporal feature layer.

I can achieve the desired result using a GET query on my https://webadaptor/adaptor/rest/services/Hosted/<FeatureServiceName>/FeatureServer/0/queryTopFeatures endpoint adding a topFilter={ "orderByFields":"retrievaltime DESC", "groupByFields":"equipment_name", "topCount":1} parameter.

I see in ArcGIS Online you can define a feature layer view with a top filter. It does not appear that I have this option in ArcGIS Enterprise, or at least not for a Spatiotemporal DS Feature Layer.

Anyone have any ideas for generating the above view? I'm looking to save the overhead of a second feature layer fed by Geoevent "Update Feature".

Re: Spatio-temporal data store hosted feature layer - Create view with topfilter to return latest observation for each TRACKID

clt_cabq — Tue, 05 Dec 2023 20:59:38 GMT

Doesn't tracker show the last known location as a layer to achieve this already? or do you have a different use case?

Location Tracking

Re: Spatio-temporal data store hosted feature layer - Create view with topfilter to return latest observation for each TRACKID

egamble — Tue, 05 Dec 2023 22:16:36 GMT

Unfortunately the source data is not users' mobile devices - it's high frequency Geoevent data, around 20 million events per day inbound to the datastore. As far as I can tell from location tracking docs there's no way to patch in geoevent data.