Austrian ticket

calculator.js

const fs = require('fs');

// Function to convert degrees to radians
function toRadians(degrees) {
  return degrees * (Math.PI / 180);
}

// Function to calculate the Haversine distance between two points in decimal degrees
function haversineDistance(lat1, lon1, lat2, lon2) {
  const R = 6371e3; // Earth's radius in meters
  const φ1 = toRadians(lat1);
  const φ2 = toRadians(lat2);
  const Δφ = toRadians(lat2 - lat1);
  const Δλ = toRadians(lon2 - lon1);

  const a = Math.sin(Δφ / 2) * Math.sin(Δφ / 2) +
    Math.cos(φ1) * Math.cos(φ2) *
    Math.sin(Δλ / 2) * Math.sin(Δλ / 2);
  const c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1 - a));

  return R * c; // Distance in meters
}

// Read the data from the JSON file
const data = JSON.parse(fs.readFileSync('filteredRecords2.json', 'utf8'));

console.log('|Index| Distance | Speed | Time | Location|');
console.log('|---|---|---|---|---|');
// Calculate distance and speed between each pair of locations
for (let i = 0; i < data.length - 1; i++) {
  const loc1 = data[i];
  const loc2 = data[i + 1];

  const distance = haversineDistance(
    loc1[0][2], loc1[0][3],
    loc2[0][2], loc2[0][3]
  );

  const time1 = (loc1[1][4]);
  const time2 = (loc2[1][4]);
  const timeDiff = (time2 - time1) / 1000; // Time difference in seconds
  const speed = (distance / timeDiff) * 3.6; // Speed in km/h

  console.log(`|${i + 1}| ${distance.toFixed(2)} meters| ${speed.toFixed(2)} km/h| ${timeDiff}s| ${loc1[5]}|`);
}

data_from_android_auto.json

[
  [[null,null,48.207729,16.42936],[null,null,null,null,1723970517558,1723970517558],null,null,0,"August 18, 2024 at 10:41:57 GMT+2",5],[[null,null,48.206346,16.431353],[null,null,null,null,1723970533562,1723970533562],null,null,1,"August 18, 2024 at 10:42:13 GMT+2",353],[[null,null,48.203907,16.434689],[null,null,null,null,1723970561552,1723970561552],null,null,0,"August 18, 2024 at 10:42:41 GMT+2",5],[[null,null,48.203321,16.432276],[null,null,null,null,1723970589570,1723970589570],null,null,0,"August 18, 2024 at 10:43:09 GMT+2",5],[[null,null,48.206808,16.436815],[null,null,null,null,1723970617570,1723970617570],null,null,0,"August 18, 2024 at 10:43:37 GMT+2",5],[[null,null,48.210488,16.442184],[null,null,null,null,1723970645570,1723970645570],null,null,0,"August 18, 2024 at 10:44:05 GMT+2",5],[[null,null,48.214611,16.447071],[null,null,null,null,1723970673560,1723970673560],null,null,0,"August 18, 2024 at 10:44:33 GMT+2",5],[[null,null,48.219985,16.447226],[null,null,null,null,1723970701559,1723970701559],null,null,0,"August 18, 2024 at 10:45:01 GMT+2",5],[[null,null,48.223863,16.448789],[null,null,null,null,1723970735958,1723970735958],null,null,1,"August 18, 2024 at 10:45:35 GMT+2",283],[[null,null,48.230481,16.453106],[null,null,null,null,1723970763572,1723970763572],null,null,0,"August 18, 2024 at 10:46:03 GMT+2",5],[[null,null,48.2344453,16.4555056],[null,null,null,null,1723970787013,1723970787013],null,null,0,"August 18, 2024 at 10:46:27 GMT+2",10],[[null,null,48.238618,16.459136],[null,null,null,null,1723970814563,1723970814563],null,null,0,"August 18, 2024 at 10:46:54 GMT+2",5],[[null,null,48.243239,16.462471],[null,null,null,null,1723970842574,1723970842574],null,null,0,"August 18, 2024 at 10:47:22 GMT+2",5],[[null,null,48.2474,16.467456],[null,null,null,null,1723970870571,1723970870571],null,null,0,"August 18, 2024 at 10:47:50 GMT+2",5],[[null,null,48.252286,16.47212],[null,null,null,null,1723970901551,1723970901551],null,null,1,"August 18, 2024 at 10:48:21 GMT+2",353],[[null,null,48.257319,16.47506],[null,null,null,null,1723970929566,1723970929566],null,null,0,"August 18, 2024 at 10:48:49 GMT+2",5],[[null,null,48.263032,16.475443],[null,null,null,null,1723970957566,1723970957566],null,null,0,"August 18, 2024 at 10:49:17 GMT+2",5],[[null,null,48.267646,16.479127],[null,null,null,null,1723970985562,1723970985562],null,null,0,"August 18, 2024 at 10:49:45 GMT+2",5],[[null,null,48.268106,16.487001],[null,null,null,null,1723971013563,1723971013563],null,null,0,"August 18, 2024 at 10:50:13 GMT+2",5],[[null,null,48.266723,16.495769],[null,null,null,null,1723971041577,1723971041577],null,null,0,"August 18, 2024 at 10:50:41 GMT+2",5],[[null,null,48.269294,16.504856],[null,null,null,null,1723971069564,1723971069564],null,null,0,"August 18, 2024 at 10:51:09 GMT+2",5],[[null,null,48.275567,16.508204],[null,null,null,null,1723971097571,1723971097571],null,null,0,"August 18, 2024 at 10:51:37 GMT+2",5],[[null,null,48.281824,16.511934],[null,null,null,null,1723971125592,1723971125592],null,null,0,"August 18, 2024 at 10:52:05 GMT+2",5],[[null,null,48.288255,16.514616],[null,null,null,null,1723971153573,1723971153573],null,null,0,"August 18, 2024 at 10:52:33 GMT+2",5],[[null,null,48.294647,16.511856],[null,null,null,null,1723971181585,1723971181585],null,null,0,"August 18, 2024 at 10:53:01 GMT+2",5],[[null,null,48.302635,16.509507],[null,null,null,null,1723971209555,1723971209555],null,null,0,"August 18, 2024 at 10:53:29 GMT+2",5],[[null,null,48.310991,16.513446],[null,null,null,null,1723971237568,1723971237568],null,null,0,"August 18, 2024 at 10:53:57 GMT+2",5],[[null,null,48.319537,16.515685],[null,null,null,null,1723971265580,1723971265580],null,null,0,"August 18, 2024 at 10:54:25 GMT+2",5],[[null,null,48.328227,16.516061],[null,null,null,null,1723971293570,1723971293570],null,null,0,"August 18, 2024 at 10:54:53 GMT+2",5],[[null,null,48.335933,16.510557],[null,null,null,null,1723971321557,1723971321557],null,null,0,"August 18, 2024 at 10:55:21 GMT+2",5],[[null,null,48.344395,16.496954],[null,null,null,null,1723971363567,1723971363567],null,null,0,"August 18, 2024 at 10:56:03 GMT+2",5],[[null,null,48.347793,16.488418],[null,null,null,null,1723971391566,1723971391566],null,null,0,"August 18, 2024 at 10:56:31 GMT+2",5],[[null,null,48.352497,16.482964],[null,null,null,null,1723971419555,1723971419555],null,null,0,"August 18, 2024 at 10:56:59 GMT+2",5],[[null,null,48.35959,16.4836241],[null,null,null,null,1723971456194,1723971456194],null,null,1,"August 18, 2024 at 10:57:36 GMT+2",225],[[null,null,48.367448,16.48633],[null,null,null,null,1723971484554,1723971484554],null,null,0,"August 18, 2024 at 10:58:04 GMT+2",5],[[null,null,48.373912,16.488737],[null,null,null,null,1723971512564,1723971512564],null,null,0,"August 18, 2024 at 10:58:32 GMT+2",5],[[null,null,48.380518,16.490746],[null,null,null,null,1723971540560,1723971540560],null,null,0,"August 18, 2024 at 10:59:00 GMT+2",5],[[null,null,48.386582,16.494575],[null,null,null,null,1723971568563,1723971568563],null,null,0,"August 18, 2024 at 10:59:28 GMT+2",5],[[null,null,48.390874,16.502663],[null,null,null,null,1723971596559,1723971596559],null,null,0,"August 18, 2024 at 10:59:56 GMT+2",5],[[null,null,48.395406,16.510314],[null,null,null,null,1723971624565,1723971624565],null,null,0,"August 18, 2024 at 11:00:24 GMT+2",5],[[null,null,48.398814,16.519688],[null,null,null,null,1723971652555,1723971652555],null,null,0,"August 18, 2024 at 11:00:52 GMT+2",5],[[null,null,48.40329,16.530434],[null,null,null,null,1723971680563,1723971680563],null,null,0,"August 18, 2024 at 11:01:20 GMT+2",5],[[null,null,48.410444,16.537505],[null,null,null,null,1723971708565,1723971708565],null,null,0,"August 18, 2024 at 11:01:48 GMT+2",5],[[null,null,48.418443,16.542711],[null,null,null,null,1723971736568,1723971736568],null,null,0,"August 18, 2024 at 11:02:16 GMT+2",5],[[null,null,48.426241,16.547846],[null,null,null,null,1723971764565,1723971764565],null,null,0,"August 18, 2024 at 11:02:44 GMT+2",5],[[null,null,48.433877,16.552852],[null,null,null,null,1723971792567,1723971792567],null,null,0,"August 18, 2024 at 11:03:12 GMT+2",5],[[null,null,48.441975,16.556871],[null,null,null,null,1723971820551,1723971820551],null,null,0,"August 18, 2024 at 11:03:40 GMT+2",5],[[null,null,48.450453,16.55359],[null,null,null,null,1723971848568,1723971848568],null,null,0,"August 18, 2024 at 11:04:08 GMT+2",5],[[null,null,48.459137,16.552724],[null,null,null,null,1723971876567,1723971876567],null,null,0,"August 18, 2024 at 11:04:36 GMT+2",5],[[null,null,48.467513,16.556435],[null,null,null,null,1723971904568,1723971904568],null,null,0,"August 18, 2024 at 11:05:04 GMT+2",5],[[null,null,48.476297,16.563845],[null,null,null,null,1723971932555,1723971932555],null,null,0,"August 18, 2024 at 11:05:32 GMT+2",5],[[null,null,48.483313,16.572531],[null,null,null,null,1723971960571,1723971960571],null,null,0,"August 18, 2024 at 11:06:00 GMT+2",5],[[null,null,48.489242,16.582347],[null,null,null,null,1723971988558,1723971988558],null,null,0,"August 18, 2024 at 11:06:28 GMT+2",5],[[null,null,48.492656,16.59447],[null,null,null,null,1723972016565,1723972016565],null,null,0,"August 18, 2024 at 11:06:56 GMT+2",5],[[null,null,48.500155,16.600978],[null,null,null,null,1723972044572,1723972044572],null,null,0,"August 18, 2024 at 11:07:24 GMT+2",5],[[null,null,48.508166,16.606543],[null,null,null,null,1723972072563,1723972072563],null,null,0,"August 18, 2024 at 11:07:52 GMT+2",5],[[null,null,48.514828,16.615169],[null,null,null,null,1723972100558,1723972100558],null,null,0,"August 18, 2024 at 11:08:20 GMT+2",5],[[null,null,48.520919,16.624653],[null,null,null,null,1723972128586,1723972128586],null,null,0,"August 18, 2024 at 11:08:48 GMT+2",5],[[null,null,48.529474,16.627167],[null,null,null,null,1723972156567,1723972156567],null,null,0,"August 18, 2024 at 11:09:16 GMT+2",5],[[null,null,48.538245,16.626621],[null,null,null,null,1723972184563,1723972184563],null,null,0,"August 18, 2024 at 11:09:44 GMT+2",5],[[null,null,48.546704,16.629901],[null,null,null,null,1723972212561,1723972212561],null,null,0,"August 18, 2024 at 11:10:12 GMT+2",5],[[null,null,48.555061,16.634133],[null,null,null,null,1723972240564,1723972240564],null,null,0,"August 18, 2024 at 11:10:40 GMT+2",5],[[null,null,48.56381,16.63408],[null,null,null,null,1723972268575,1723972268575],null,null,0,"August 18, 2024 at 11:11:08 GMT+2",5],[[null,null,48.571712,16.628231],[null,null,null,null,1723972296553,1723972296553],null,null,0,"August 18, 2024 at 11:11:36 GMT+2",5],[[null,null,48.579917,16.624147],[null,null,null,null,1723972324572,1723972324572],null,null,0,"August 18, 2024 at 11:12:04 GMT+2",5],[[null,null,48.588204,16.628405],[null,null,null,null,1723972352566,1723972352566],null,null,0,"August 18, 2024 at 11:12:32 GMT+2",5],[[null,null,48.596371,16.633102],[null,null,null,null,1723972380563,1723972380563],null,null,0,"August 18, 2024 at 11:13:00 GMT+2",5],[[null,null,48.601633,16.643553],[null,null,null,null,1723972408564,1723972408564],null,null,0,"August 18, 2024 at 11:13:28 GMT+2",5],[[null,null,48.604145,16.6563],[null,null,null,null,1723972436566,1723972436566],null,null,0,"August 18, 2024 at 11:13:56 GMT+2",5],[[null,null,48.607448,16.668544],[null,null,null,null,1723972464569,1723972464569],null,null,0,"August 18, 2024 at 11:14:24 GMT+2",5],[[null,null,48.614602,16.676004],[null,null,null,null,1723972492568,1723972492568],null,null,0,"August 18, 2024 at 11:14:52 GMT+2",5],[[null,null,48.623356,16.676054],[null,null,null,null,1723972520574,1723972520574],null,null,0,"August 18, 2024 at 11:15:20 GMT+2",5],[[null,null,48.63191,16.67879],[null,null,null,null,1723972548566,1723972548566],null,null,0,"August 18, 2024 at 11:15:48 GMT+2",5],[[null,null,48.639732,16.68496],[null,null,null,null,1723972576576,1723972576576],null,null,0,"August 18, 2024 at 11:16:16 GMT+2",5],[[null,null,48.647963,16.689729],[null,null,null,null,1723972604558,1723972604558],null,null,0,"August 18, 2024 at 11:16:44 GMT+2",5],[[null,null,48.652586,16.693024],[null,null,null,null,1723972632570,1723972632570],null,null,0,"August 18, 2024 at 11:17:12 GMT+2",5],[[null,null,48.651661,16.699175],[null,null,null,null,1723972660570,1723972660570],null,null,0,"August 18, 2024 at 11:17:40 GMT+2",5],[[null,null,48.650642,16.706985],[null,null,null,null,1723972688567,1723972688567],null,null,0,"August 18, 2024 at 11:18:08 GMT+2",5],[[null,null,48.648766,16.712113],[null,null,null,null,1723972716566,1723972716566],null,null,0,"August 18, 2024 at 11:18:36 GMT+2",5],[[null,null,48.647055,16.716343],[null,null,null,null,1723972744594,1723972744594],null,null,0,"August 18, 2024 at 11:19:04 GMT+2",5],[[null,null,48.645169,16.720443],[null,null,null,null,1723972772570,1723972772570],null,null,0,"August 18, 2024 at 11:19:32 GMT+2",5],[[null,null,48.64427,16.724459],[null,null,null,null,1723972800568,1723972800568],null,null,0,"August 18, 2024 at 11:20:00 GMT+2",5]
]

results.md

Index	Distance	Speed	Time	Location
1	213.22 meters	47.96 km/h	16.004s	August 18, 2024 at 10:41:57 GMT+2
2	366.98 meters	47.20 km/h	27.99s	August 18, 2024 at 10:42:13 GMT+2
3	190.33 meters	24.46 km/h	28.018s	August 18, 2024 at 10:42:41 GMT+2
4	513.31 meters	66.00 km/h	28s	August 18, 2024 at 10:43:09 GMT+2
5	570.73 meters	73.38 km/h	28s	August 18, 2024 at 10:43:37 GMT+2
6	584.22 meters	75.14 km/h	27.99s	August 18, 2024 at 10:44:05 GMT+2
7	597.67 meters	76.85 km/h	27.999s	August 18, 2024 at 10:44:33 GMT+2
8	446.49 meters	46.73 km/h	34.399s	August 18, 2024 at 10:45:01 GMT+2
9	802.37 meters	104.60 km/h	27.614s	August 18, 2024 at 10:45:35 GMT+2
10	475.29 meters	72.99 km/h	23.441s	August 18, 2024 at 10:46:03 GMT+2
11	536.26 meters	70.07 km/h	27.55s	August 18, 2024 at 10:46:27 GMT+2
12	570.11 meters	73.27 km/h	28.011s	August 18, 2024 at 10:46:54 GMT+2
13	591.89 meters	76.11 km/h	27.997s	August 18, 2024 at 10:47:22 GMT+2
14	643.76 meters	74.81 km/h	30.98s	August 18, 2024 at 10:47:50 GMT+2
15	600.48 meters	77.16 km/h	28.015s	August 18, 2024 at 10:48:21 GMT+2
16	635.89 meters	81.76 km/h	28s	August 18, 2024 at 10:48:49 GMT+2
17	581.02 meters	74.71 km/h	27.996s	August 18, 2024 at 10:49:17 GMT+2
18	585.05 meters	75.22 km/h	28.001s	August 18, 2024 at 10:49:45 GMT+2
19	666.96 meters	85.71 km/h	28.014s	August 18, 2024 at 10:50:13 GMT+2
20	730.82 meters	94.01 km/h	27.987s	August 18, 2024 at 10:50:41 GMT+2
21	740.23 meters	95.15 km/h	28.007s	August 18, 2024 at 10:51:09 GMT+2
22	748.50 meters	96.16 km/h	28.021s	August 18, 2024 at 10:51:37 GMT+2
23	742.12 meters	95.48 km/h	27.981s	August 18, 2024 at 10:52:05 GMT+2
24	739.51 meters	95.04 km/h	28.012s	August 18, 2024 at 10:52:33 GMT+2
25	905.06 meters	116.49 km/h	27.97s	August 18, 2024 at 10:53:01 GMT+2
26	973.75 meters	125.14 km/h	28.013s	August 18, 2024 at 10:53:29 GMT+2
27	964.59 meters	123.97 km/h	28.012s	August 18, 2024 at 10:53:57 GMT+2
28	966.68 meters	124.33 km/h	27.99s	August 18, 2024 at 10:54:25 GMT+2
29	948.56 meters	122.01 km/h	27.987s	August 18, 2024 at 10:54:53 GMT+2
30	1377.04 meters	118.00 km/h	42.01s	August 18, 2024 at 10:55:21 GMT+2
31	735.34 meters	94.55 km/h	27.999s	August 18, 2024 at 10:56:03 GMT+2
32	660.33 meters	84.93 km/h	27.989s	August 18, 2024 at 10:56:31 GMT+2
33	790.21 meters	77.64 km/h	36.639s	August 18, 2024 at 10:56:59 GMT+2
34	896.35 meters	113.78 km/h	28.36s	August 18, 2024 at 10:57:36 GMT+2
35	740.43 meters	95.16 km/h	28.01s	August 18, 2024 at 10:58:04 GMT+2
36	749.39 meters	96.36 km/h	27.996s	August 18, 2024 at 10:58:32 GMT+2
37	731.18 meters	94.00 km/h	28.003s	August 18, 2024 at 10:59:00 GMT+2
38	764.49 meters	98.31 km/h	27.996s	August 18, 2024 at 10:59:28 GMT+2
39	757.02 meters	97.31 km/h	28.006s	August 18, 2024 at 10:59:56 GMT+2
40	789.03 meters	101.48 km/h	27.99s	August 18, 2024 at 11:00:24 GMT+2
41	936.51 meters	120.37 km/h	28.008s	August 18, 2024 at 11:00:52 GMT+2
42	951.44 meters	122.32 km/h	28.002s	August 18, 2024 at 11:01:20 GMT+2
43	968.89 meters	124.56 km/h	28.003s	August 18, 2024 at 11:01:48 GMT+2
44	946.28 meters	121.68 km/h	27.997s	August 18, 2024 at 11:02:16 GMT+2
45	925.94 meters	119.04 km/h	28.002s	August 18, 2024 at 11:02:44 GMT+2
46	948.01 meters	121.96 km/h	27.984s	August 18, 2024 at 11:03:12 GMT+2
47	973.28 meters	125.06 km/h	28.017s	August 18, 2024 at 11:03:40 GMT+2
48	967.73 meters	124.43 km/h	27.999s	August 18, 2024 at 11:04:08 GMT+2
49	970.73 meters	124.80 km/h	28.001s	August 18, 2024 at 11:04:36 GMT+2
50	1119.12 meters	143.95 km/h	27.987s	August 18, 2024 at 11:05:04 GMT+2
51	1009.22 meters	129.68 km/h	28.016s	August 18, 2024 at 11:05:32 GMT+2
52	978.78 meters	125.90 km/h	27.987s	August 18, 2024 at 11:06:00 GMT+2
53	970.69 meters	124.77 km/h	28.007s	August 18, 2024 at 11:06:28 GMT+2
54	961.91 meters	123.64 km/h	28.007s	August 18, 2024 at 11:06:56 GMT+2
55	980.61 meters	126.12 km/h	27.991s	August 18, 2024 at 11:07:24 GMT+2
56	975.97 meters	125.50 km/h	27.995s	August 18, 2024 at 11:07:52 GMT+2
57	972.97 meters	124.97 km/h	28.028s	August 18, 2024 at 11:08:20 GMT+2
58	969.12 meters	124.69 km/h	27.981s	August 18, 2024 at 11:08:48 GMT+2
59	976.12 meters	125.52 km/h	27.996s	August 18, 2024 at 11:09:16 GMT+2
60	971.10 meters	124.86 km/h	27.998s	August 18, 2024 at 11:09:44 GMT+2
61	980.08 meters	126.00 km/h	28.003s	August 18, 2024 at 11:10:12 GMT+2
62	972.85 meters	125.03 km/h	28.011s	August 18, 2024 at 11:10:40 GMT+2
63	978.40 meters	125.89 km/h	27.978s	August 18, 2024 at 11:11:08 GMT+2
64	960.56 meters	123.42 km/h	28.019s	August 18, 2024 at 11:11:36 GMT+2
65	973.25 meters	125.16 km/h	27.994s	August 18, 2024 at 11:12:04 GMT+2
66	971.61 meters	124.93 km/h	27.997s	August 18, 2024 at 11:12:32 GMT+2
67	965.91 meters	124.18 km/h	28.001s	August 18, 2024 at 11:13:00 GMT+2
68	978.03 meters	125.74 km/h	28.002s	August 18, 2024 at 11:13:28 GMT+2
69	972.29 meters	125.00 km/h	28.003s	August 18, 2024 at 11:13:56 GMT+2
70	966.23 meters	124.23 km/h	27.999s	August 18, 2024 at 11:14:24 GMT+2
71	973.41 meters	125.13 km/h	28.006s	August 18, 2024 at 11:14:52 GMT+2
72	972.18 meters	125.03 km/h	27.992s	August 18, 2024 at 11:15:20 GMT+2
73	980.84 meters	126.06 km/h	28.01s	August 18, 2024 at 11:15:48 GMT+2
74	980.02 meters	126.08 km/h	27.982s	August 18, 2024 at 11:16:16 GMT+2
75	568.19 meters	73.02 km/h	28.012s	August 18, 2024 at 11:16:44 GMT+2
76	463.40 meters	59.58 km/h	28s	August 18, 2024 at 11:17:12 GMT+2
77	584.80 meters	75.20 km/h	27.997s	August 18, 2024 at 11:17:40 GMT+2
78	430.61 meters	55.37 km/h	27.999s	August 18, 2024 at 11:18:08 GMT+2
79	364.37 meters	46.80 km/h	28.028s	August 18, 2024 at 11:18:36 GMT+2
80	367.03 meters	47.23 km/h	27.976s	August 18, 2024 at 11:19:04 GMT+2
81	311.53 meters	40.06 km/h	27.998s	August 18, 2024 at 11:19:32 GMT+2