Hi everyone,
I have a rather complicated task which I would love your input on. It consists of several tasks/ issues. Overall, the data look similar to this (beware: these data are fake and i only an example):
| ID |
Event_time |
Event_east |
Event_north |
Poi_east |
Poi_north |
Notify_time |
Pos_east |
Pos_north |
Pos_time1 |
Pos_east1 |
Pos_north1 |
Pos_time2 |
Pos_east2 |
Pos_north2 |
Pos_time3 |
Pos_east3 |
Pos_north3 |
| 1 |
11Feb2021:18:08:02 |
12.134963 |
55.461058 |
12.451788 |
55.421875 |
2021-02-11T18:09:55.000+01:00 |
12.124598 |
55.457985 |
2021-02-11T18:10:55.000+01:00 |
12.561334 |
55.876498 |
2021-02-11T18:11:55.000+01:00 |
12.457935 |
55.215469 |
2021-02-11T18:10:57.000+01:00 |
12.457896 |
55.897569 |
| 2 |
12Feb2021:16:12:00 |
12.457965 |
55.589512 |
12.021369 |
55.021369 |
2021-02-12T16:12:55.000+01:00 |
12.146026 |
55.012459 |
2021-02-12T16:12:56.000+01:00 |
12.012459 |
55.124598 |
2021-02-12T16:12:57.000+01:00 |
12.215498 |
55.124023 |
2021-02-12T16:12:58.000+01:00 |
12.459065 |
55.213026 |
This is just an example. I have several GPS- and time stamps (up to e.g. Pos_time60 and Pos_east60 etc). The different positions (pos_eastn and pos_northn may represent a biker).
I want to:
1) Calculate the true-line distance from pos_east and pos_north (e.g. a bikers starting position) to event_east and event_north (the event). As I have several GPS stamps from 'the biker' (up to >60) I believe it could be done by straight-line calculation from pos_east to pos_east1 to pos_east2 to pos_eastn.... to event_east (the event). However, some of the last GPS-stamps from 'the biker' may be relatively close to the event GPS position. Therefore, the first position of 'the biker' within 25 meters from event_east and event_north should be used as the final position (if it makes any sense).
2) I want to calculate the travel time of 'the biker' from notify_time until the first position within 25 meters from the event_east and event_north. The variable pos_timen represents the time 'the biker' was at pos_eastn and pos_northn.
3) Some 'bikers' travels via poi_east and poi_north before going to event_east and event_north. I want to first calculate the distance from pos_east and pos_north to poi_east and poi_north (again via pos_eastn and pos_northn - and also with the first GPS-stamp within 25 meters from poi_east and poi_north) and secondly the distance from poi_east and poi_north till event_east and event_north (again via pos_eastn and pos_northn - and also with the first GPS-stamp within 25 meters from poi_east and poi_north).
4) As in task 2, I want to calculate the traveltime of 'the biker' from the original position (pos_east and pos_north) until 25 meters within the poi_east and poi_north and again from poi-coordinates until within 25 meters from the event-coordinates.
Sorry for all the text! It is rather complicated! I hope it makes sense.
Thanks in advance!
All best
MM
