Calculation of distance and traveltime with multiple GPS points

Mikkel_madsen — Wed, 08 Sep 2021 11:18:22 GMT

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

Re: Calculation of distance and traveltime with multiple GPS points

Ksharp — Wed, 08 Sep 2021 12:19:31 GMT

Check GEODIST() Function.

Re: Calculation of distance and traveltime with multiple GPS points

Mikkel_madsen — Thu, 09 Sep 2021 07:30:20 GMT

Hi @Ksharp,

Thanks, I did that prior to my post without any luck.

topic Re: Calculation of distance and traveltime with multiple GPS points in SAS Programming

Calculation of distance and traveltime with multiple GPS points

Re: Calculation of distance and traveltime with multiple GPS points

Re: Calculation of distance and traveltime with multiple GPS points