Historic Location Data

jcaballero · ‎2023-09-25

Hello,

I'm working with the dynamic source location of users to show their current location. We can display a trend for Latitude, Longitude, and Speed with some of historical data (see picture). How can we make a query to request that information? What is the available table query for this? How can we add this historical data to a user trend?

We want to show in a Map the last 10 location reported by a user in a day and a graphical report for the speed.

Thanks

Related topic

@sbeadle GPS Tracking

sbeadle · ‎2023-10-02

Hi, try the attached demo .sde

There is a Logic program to select locations at interval and add to a Data Table.

See the User Query which selects from that. You can add this to a Map Set.

Note - you should add a regular data purge so that the Data Table does not grow too large and harm performance. Delete records older that 'x' with a Logic program, and then call the Data Table method "PurgeDeletedRecords" (parameter to be 500?) to free the space.

See Answer In Context

sbeadle · ‎2023-10-02

Hi, try the attached demo .sde

There is a Logic program to select locations at interval and add to a Data Table.

See the User Query which selects from that. You can add this to a Map Set.

Note - you should add a regular data purge so that the Data Table does not grow too large and harm performance. Delete records older that 'x' with a Logic program, and then call the Data Table method "PurgeDeletedRecords" (parameter to be 500?) to free the space.

jcaballero · ‎2023-10-31

Thanks @sbeadle!!!

This solution with a data table is very efficient.

Historic Location Data

Historic Location Data

Photos