Hi, i have timestamped gps records in a database of several devices.
Those records are filtered in order to established a relationship with an area.
How can i retrieve time spent on a specific area ?
Thanks
Page 1 / 1
Use a statistics calculator to find the min and max time for each area, then a date time calculator to work out the difference between min and max
thanks @egomm for your answer
i made a test with your proposal but it can't detect when a device go on other area and come back on the first area. i explain with an example :
idtimedeviceplace
12019-01-01 10:001PLACE 1
22019-01-01 10:01
1PLACE 1
32019-01-01 10:02
1PLACE 2
42019-01-01 10:03
1PLACE 2
52019-01-01 10:04
1PLACE 1
62019-01-01 10:05
1
PLACE 172019-01-01 10:06
1PLACE 3
i would like to have 4 results
in PLACE 1 from 2019-01-01 10:00 to 2019-01-01 10:01
in PLACE 2 form 2019-01-01 10:02 to 2019-01-01 10:03
in PLACE 1 from 2019-01-01 10:04 to 2019-01-01 10:05
in PLACE 3 from 2019-01-01 to 10:06 2019-01-01 10:06
but with your proposal i ve got only 3 results
in PLACE 1 from 2019-01-01 10:00 to 2019-01-01 10:05
in PLACE 2 form 2019-01-01 10:02 to 2019-01-01 10:03
in PLACE 3 from 2019-01-01 to 10:06 2019-01-01 10:06
thanks @egomm for your answer
i made a test with your proposal but it can't detect when a device go on other area and come back on the first area. i explain with an example :
idtimedeviceplace
12019-01-01 10:001PLACE 1
22019-01-01 10:01
1PLACE 1
32019-01-01 10:02
1PLACE 2
42019-01-01 10:03
1PLACE 2
52019-01-01 10:04
1PLACE 1
62019-01-01 10:05
1
PLACE 172019-01-01 10:06
1PLACE 3
i would like to have 4 results
in PLACE 1 from 2019-01-01 10:00 to 2019-01-01 10:01
in PLACE 2 form 2019-01-01 10:02 to 2019-01-01 10:03
in PLACE 1 from 2019-01-01 10:04 to 2019-01-01 10:05
in PLACE 3 from 2019-01-01 to 10:06 2019-01-01 10:06
but with your proposal i ve got only 3 results
in PLACE 1 from 2019-01-01 10:00 to 2019-01-01 10:05
in PLACE 2 form 2019-01-01 10:02 to 2019-01-01 10:03
in PLACE 3 from 2019-01-01 to 10:06 2019-01-01 10:06
In that case, you need to create groupings to use in the statistics calculator. Adjacent attribute handling in the attribute creator will allow you to assign a group, e.g.
time_on_area.fmwt