InfluxDB query results are not plotted correctly on Geomap

What Grafana version and what operating system are you using?

Grafana v9.5.2, in Edge browser on Windows 10 with latest updates

What are you trying to achieve?

Plot the geo locations of vessel on a geomap panel. The long and lat locations are stored in ddmm.mmmm format in an influx databases every second.

How are you trying to achieve it?

Query the coordinates for a periode of time and convert the long lat coordinates from ddmm.mmmm format to decimal degrees dd.ddddd

What happened?

When I query the results with a interval bigger than 1 second some of the coordinates fall outside the route (see red underlined coordinates in screenshot).

What did you expect to happen?

I expect all coordinates to be on the vessel route (see 2nd screenshot below)

I checked to see if the there were any coordinates wrong in the database, but there seem not be deviations.

Strange thing is that when I set the interval to 1 second (Max data points / time range) I get a fluid route with no coordinates outside the line.

Can you copy/paste the configuration(s) that you are having problems with?

Not sure what configuration you are asking here.

Perhaps the query I am using, here it is:

SELECT floor(mean(“antennalatitude”)/100)+(mean(“antennalatitude”)-(floor(mean(“antennalatitude”)/100)*100))/60 as AntLat, floor(mean(“antennalongitude”)/100)+(mean(“antennalongitude”)-(floor(mean(“antennalongitude”)/100)*100))/60 as AntLong, floor(mean(“dragheadsblatitude”)/100)+(mean(“dragheadsblatitude”)-(floor(mean(“dragheadsblatitude”)/100)*100))/60 as DraghSBLat, floor(mean(“dragheadsblongitude”)/100)+(mean(“dragheadsblongitude”)-(floor(mean(“dragheadsblongitude”)/100)*100))/60 as DraghSBLong FROM “autogen”.“dredgeview” WHERE (“vesselIdentifier” =~ /^$myVessel$/) AND $timeFilter GROUP BY time($__interval) fill(null)

Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

No

Did you follow any online instructions? If so, what is the URL?

Screenshot:

And here is another screenshot when i increase the Max data points so the interval is 1 sec. instead of 2 minutes. Disadvantage is that dashboard is much much slower.

Welcome

Could you please share your data as csv?

Hello, i downloaded the csv from Grafana results like this:

But how do i attach the csv in this Topic?

  • download it as csv
  • open it using notepad++ or notepad
  • copy data
  • paste to forum

I got a 502 error during reply, probably too big for 1 reply
This topic can’t handle many data

750 rows:

“Time”,“dredgeview.AntLat”,“dredgeview.AntLong”,“dredgeview.DraghSBLat”,“dredgeview.DraghSBLong”,“Total”
2023-05-16 03:45:09,54.50871,12.27698,54.50880,12.27723,133.57172
2023-05-16 03:45:10,54.50874,12.27702,54.50884,12.27728,133.57189
2023-05-16 03:45:11,54.50878,12.27707,54.50887,12.27733,133.57205
2023-05-16 03:45:12,54.50882,12.27712,54.50891,12.27737,133.57222
2023-05-16 03:45:13,54.50886,12.27716,54.50895,12.27742,133.57239
2023-05-16 03:45:14,54.50890,12.27721,54.50899,12.27747,133.57256
2023-05-16 03:45:15,54.50894,12.27725,54.50903,12.27751,133.57273
2023-05-16 03:45:16,54.50897,12.27730,54.50906,12.27756,133.57290
2023-05-16 03:45:17,54.50901,12.27735,54.50910,12.27761,133.57307
2023-05-16 03:45:18,54.50905,12.27739,54.50914,12.27765,133.57324
2023-05-16 03:45:19,54.50909,12.27744,54.50918,12.27770,133.57341
2023-05-16 03:45:20,54.50913,12.27749,54.50921,12.27775,133.57358
2023-05-16 03:45:21,54.50917,12.27754,54.50925,12.27780,133.57375
2023-05-16 03:45:22,54.50920,12.27758,54.50929,12.27784,133.57392
2023-05-16 03:45:23,54.50924,12.27763,54.50933,12.27789,133.57409
2023-05-16 03:45:24,54.50928,12.27768,54.50936,12.27794,133.57426
2023-05-16 03:45:25,54.50932,12.27773,54.50940,12.27799,133.57443
2023-05-16 03:45:26,54.50935,12.27777,54.50944,12.27804,133.57461
2023-05-16 03:45:27,54.50939,12.27782,54.50948,12.27809,133.57478
2023-05-16 03:45:28,54.50943,12.27787,54.50951,12.27814,133.57495
2023-05-16 03:45:29,54.50947,12.27792,54.50955,12.27818,133.57512
2023-05-16 03:45:30,54.50950,12.27797,54.50959,12.27823,133.57530
2023-05-16 03:45:31,54.50954,12.27802,54.50963,12.27828,133.57547
2023-05-16 03:45:32,54.50958,12.27807,54.50966,12.27833,133.57564
2023-05-16 03:45:33,54.50962,12.27812,54.50970,12.27838,133.57582
2023-05-16 03:45:34,54.50965,12.27817,54.50974,12.27843,133.57599
2023-05-16 03:45:35,54.50969,12.27822,54.50977,12.27848,133.57616
2023-05-16 03:45:36,54.50973,12.27827,54.50981,12.27853,133.57634
2023-05-16 03:45:37,54.50976,12.27832,54.50985,12.27858,133.57651
2023-05-16 03:45:38,54.50980,12.27837,54.50988,12.27863,133.57669
2023-05-16 03:45:39,54.50984,12.27842,54.50992,12.27868,133.57686
2023-05-16 03:45:40,54.50987,12.27847,54.50996,12.27874,133.57703
2023-05-16 03:45:41,54.50991,12.27852,54.50999,12.27879,133.57721
2023-05-16 03:45:42,54.50995,12.27857,54.51003,12.27884,133.57738
2023-05-16 03:45:43,54.50998,12.27863,54.51006,12.27889,133.57756
2023-05-16 03:45:44,54.51002,12.27868,54.51010,12.27894,133.57773
2023-05-16 03:45:45,54.51005,12.27873,54.51014,12.27899,133.57791
2023-05-16 03:45:46,54.51009,12.27878,54.51017,12.27904,133.57808
2023-05-16 03:45:47,54.51013,12.27883,54.51021,12.27909,133.57826
2023-05-16 03:45:48,54.51016,12.27888,54.51025,12.27915,133.57844
2023-05-16 03:45:49,54.51020,12.27893,54.51028,12.27920,133.57861
2023-05-16 03:45:50,54.51023,12.27899,54.51032,12.27925,133.57879
2023-05-16 03:45:51,54.51027,12.27904,54.51036,12.27930,133.57896
2023-05-16 03:45:52,54.51031,12.27909,54.51039,12.27935,133.57914
2023-05-16 03:45:53,54.51034,12.27914,54.51043,12.27940,133.57931
2023-05-16 03:45:54,54.51038,12.27919,54.51046,12.27945,133.57949
2023-05-16 03:45:55,54.51042,12.27924,54.51050,12.27950,133.57966
2023-05-16 03:45:56,54.51045,12.27929,54.51054,12.27956,133.57984
2023-05-16 03:45:57,54.51049,12.27935,54.51057,12.27961,133.58002
2023-05-16 03:45:58,54.51053,12.27940,54.51061,12.27966,133.58019
2023-05-16 03:45:59,54.51056,12.27945,54.51065,12.27971,133.58037
2023-05-16 03:46:00,54.51060,12.27950,54.51068,12.27976,133.58054
2023-05-16 03:46:01,54.51063,12.27955,54.51072,12.27981,133.58072
2023-05-16 03:46:02,54.51067,12.27960,54.51076,12.27986,133.58089
2023-05-16 03:46:03,54.51071,12.27965,54.51079,12.27992,133.58107
2023-05-16 03:46:04,54.51074,12.27971,54.51083,12.27997,133.58124
2023-05-16 03:46:05,54.51078,12.27976,54.51087,12.28002,133.58142
2023-05-16 03:46:06,54.51082,12.27981,54.51090,12.28007,133.58160
2023-05-16 03:46:07,54.51085,12.27986,54.51094,12.28012,133.58177
2023-05-16 03:46:08,54.51089,12.27991,54.51097,12.28017,133.58195
2023-05-16 03:46:09,54.51093,12.27996,54.51101,12.28022,133.58212
2023-05-16 03:46:10,54.51096,12.28001,54.51105,12.28027,133.58230
2023-05-16 03:46:11,54.51100,12.28007,54.51108,12.28033,133.58247
2023-05-16 03:46:12,54.51103,12.28012,54.51112,12.28038,133.58265
2023-05-16 03:46:13,54.51107,12.28017,54.51116,12.28043,133.58282
2023-05-16 03:46:14,54.51111,12.28022,54.51119,12.28048,133.58300
2023-05-16 03:46:15,54.51114,12.28027,54.51123,12.28053,133.58317
2023-05-16 03:46:16,54.51118,12.28032,54.51127,12.28058,133.58335
2023-05-16 03:46:17,54.51122,12.28037,54.51130,12.28063,133.58353
2023-05-16 03:46:18,54.51125,12.28042,54.51134,12.28068,133.58370
2023-05-16 03:46:19,54.51129,12.28048,54.51138,12.28073,133.58388
2023-05-16 03:46:20,54.51133,12.28053,54.51141,12.28079,133.58405
2023-05-16 03:46:21,54.51136,12.28058,54.51145,12.28084,133.58423
2023-05-16 03:46:22,54.51140,12.28063,54.51149,12.28089,133.58440
2023-05-16 03:46:23,54.51144,12.28068,54.51152,12.28094,133.58457
2023-05-16 03:46:24,54.51147,12.28073,54.51156,12.28099,133.58475
2023-05-16 03:46:25,54.51151,12.28078,54.51160,12.28104,133.58492
2023-05-16 03:46:26,54.51154,12.28083,54.51163,12.28109,133.58510
2023-05-16 03:46:27,54.51158,12.28088,54.51167,12.28114,133.58527
2023-05-16 03:46:28,54.51162,12.28093,54.51171,12.28119,133.58545
2023-05-16 03:46:29,54.51165,12.28098,54.51174,12.28124,133.58562
2023-05-16 03:46:30,54.51169,12.28104,54.51178,12.28129,133.58580
2023-05-16 03:46:31,54.51173,12.28109,54.51182,12.28134,133.58597
2023-05-16 03:46:32,54.51177,12.28113,54.51186,12.28139,133.58615
2023-05-16 03:46:33,54.51180,12.28118,54.51189,12.28144,133.58632
2023-05-16 03:46:34,54.51184,12.28123,54.51193,12.28149,133.58649
2023-05-16 03:46:35,54.51188,12.28128,54.51197,12.28154,133.58667
2023-05-16 03:46:36,54.51191,12.28133,54.51201,12.28159,133.58684
2023-05-16 03:46:37,54.51195,12.28138,54.51204,12.28164,133.58702
2023-05-16 03:46:38,54.51199,12.28143,54.51208,12.28169,133.58719
2023-05-16 03:46:39,54.51202,12.28148,54.51212,12.28174,133.58736
2023-05-16 03:46:40,54.51206,12.28153,54.51215,12.28179,133.58754
2023-05-16 03:46:41,54.51210,12.28158,54.51219,12.28184,133.58771
2023-05-16 03:46:42,54.51214,12.28163,54.51223,12.28189,133.58788
2023-05-16 03:46:43,54.51217,12.28168,54.51227,12.28193,133.58806
2023-05-16 03:46:44,54.51221,12.28173,54.51230,12.28198,133.58823
2023-05-16 03:46:45,54.51225,12.28178,54.51234,12.28203,133.58840
2023-05-16 03:46:46,54.51229,12.28183,54.51238,12.28208,133.58858
2023-05-16 03:46:47,54.51232,12.28188,54.51242,12.28213,133.58875
2023-05-16 03:46:48,54.51236,12.28193,54.51245,12.28218,133.58892
2023-05-16 03:46:49,54.51240,12.28198,54.51249,12.28223,133.58909
2023-05-16 03:46:50,54.51244,12.28202,54.51253,12.28228,133.58926
2023-05-16 03:46:51,54.51247,12.28207,54.51257,12.28232,133.58943
2023-05-16 03:46:52,54.51251,12.28212,54.51261,12.28237,133.58961
2023-05-16 03:46:53,54.51255,12.28217,54.51264,12.28242,133.58978
2023-05-16 03:46:54,54.51259,12.28221,54.51268,12.28246,133.58995
2023-05-16 03:46:55,54.51263,12.28226,54.51272,12.28251,133.59011
2023-05-16 03:46:56,54.51267,12.28230,54.51276,12.28256,133.59028
2023-05-16 03:46:57,54.51270,12.28235,54.51279,12.28260,133.59045
2023-05-16 03:46:58,54.51274,12.28239,54.51283,12.28265,133.59062
2023-05-16 03:46:59,54.51278,12.28244,54.51287,12.28270,133.59078
2023-05-16 03:47:00,54.51282,12.28248,54.51291,12.28274,133.59095
2023-05-16 03:47:01,54.51286,12.28253,54.51295,12.28279,133.59112
2023-05-16 03:47:02,54.51290,12.28257,54.51298,12.28283,133.59129
2023-05-16 03:47:03,54.51294,12.28262,54.51302,12.28288,133.59146
2023-05-16 03:47:04,54.51297,12.28266,54.51306,12.28293,133.59163
2023-05-16 03:47:05,54.51301,12.28271,54.51310,12.28298,133.59179
2023-05-16 03:47:06,54.51305,12.28276,54.51313,12.28302,133.59196
2023-05-16 03:47:07,54.51309,12.28280,54.51317,12.28307,133.59213
2023-05-16 03:47:08,54.51313,12.28285,54.51321,12.28312,133.59230
2023-05-16 03:47:09,54.51317,12.28290,54.51324,12.28317,133.59247
2023-05-16 03:47:10,54.51320,12.28295,54.51328,12.28322,133.59264
2023-05-16 03:47:11,54.51324,12.28299,54.51332,12.28326,133.59282
2023-05-16 03:47:12,54.51328,12.28304,54.51335,12.28331,133.59299
2023-05-16 03:47:13,54.51331,12.28309,54.51339,12.28336,133.59316
2023-05-16 03:47:14,54.51335,12.28314,54.51342,12.28342,133.59333
2023-05-16 03:47:15,54.51339,12.28319,54.51346,12.28347,133.59351
2023-05-16 03:47:16,54.51342,12.28325,54.51350,12.28352,133.59368
2023-05-16 03:47:17,54.51346,12.28330,54.51353,12.28357,133.59386
2023-05-16 03:47:18,54.51349,12.28335,54.51357,12.28362,133.59403
2023-05-16 03:47:19,54.51353,12.28340,54.51360,12.28367,133.59421
2023-05-16 03:47:20,54.51356,12.28345,54.51364,12.28373,133.59438
2023-05-16 03:47:21,54.51360,12.28351,54.51367,12.28378,133.59456
2023-05-16 03:47:22,54.51363,12.28356,54.51371,12.28383,133.59473
2023-05-16 03:47:23,54.51367,12.28361,54.51374,12.28389,133.59491
2023-05-16 03:47:24,54.51370,12.28367,54.51378,12.28394,133.59509
2023-05-16 03:47:25,54.51374,12.28372,54.51381,12.28399,133.59526
2023-05-16 03:47:26,54.51377,12.28378,54.51385,12.28405,133.59544
2023-05-16 03:47:27,54.51381,12.28383,54.51388,12.28410,133.59562
2023-05-16 03:47:28,54.51384,12.28388,54.51392,12.28416,133.59580
2023-05-16 03:47:29,54.51388,12.28394,54.51395,12.28421,133.59597
2023-05-16 03:47:30,54.51391,12.28399,54.51398,12.28426,133.59615
2023-05-16 03:47:31,54.51395,12.28405,54.51402,12.28432,133.59633
2023-05-16 03:47:32,54.51398,12.28410,54.51405,12.28437,133.59651
2023-05-16 03:47:33,54.51401,12.28416,54.51409,12.28443,133.59668
2023-05-16 03:47:34,54.51405,12.28421,54.51412,12.28448,133.59686
2023-05-16 03:47:35,54.51408,12.28427,54.51416,12.28454,133.59704
2023-05-16 03:47:36,54.51412,12.28432,54.51419,12.28459,133.59722
2023-05-16 03:47:37,54.51415,12.28438,54.51422,12.28465,133.59740
2023-05-16 03:47:38,54.51419,12.28443,54.51426,12.28470,133.59758
2023-05-16 03:47:39,54.51422,12.28449,54.51429,12.28476,133.59776
2023-05-16 03:47:40,54.51425,12.28454,54.51433,12.28481,133.59793
2023-05-16 03:47:41,54.51429,12.28460,54.51436,12.28487,133.59811
2023-05-16 03:47:42,54.51432,12.28465,54.51440,12.28492,133.59829
2023-05-16 03:47:43,54.51436,12.28471,54.51443,12.28498,133.59847
2023-05-16 03:47:44,54.51439,12.28476,54.51447,12.28503,133.59865
2023-05-16 03:47:45,54.51443,12.28481,54.51450,12.28509,133.59883
2023-05-16 03:47:46,54.51446,12.28487,54.51453,12.28514,133.59901
2023-05-16 03:47:47,54.51449,12.28492,54.51457,12.28520,133.59918
2023-05-16 03:47:48,54.51453,12.28498,54.51460,12.28525,133.59936
2023-05-16 03:47:49,54.51456,12.28504,54.51464,12.28531,133.59954
2023-05-16 03:47:50,54.51460,12.28509,54.51467,12.28536,133.59972
2023-05-16 03:47:51,54.51463,12.28514,54.51471,12.28542,133.59990
2023-05-16 03:47:52,54.51467,12.28520,54.51474,12.28547,133.60008
2023-05-16 03:47:53,54.51470,12.28525,54.51477,12.28553,133.60026
2023-05-16 03:47:54,54.51474,12.28531,54.51481,12.28558,133.60044
2023-05-16 03:47:55,54.51477,12.28537,54.51484,12.28564,133.60061
2023-05-16 03:47:56,54.51480,12.28542,54.51488,12.28569,133.60079
2023-05-16 03:47:57,54.51484,12.28548,54.51491,12.28575,133.60097
2023-05-16 03:47:58,54.51487,12.28553,54.51495,12.28580,133.60115
2023-05-16 03:47:59,54.51491,12.28559,54.51498,12.28586,133.60133
2023-05-16 03:48:00,54.51494,12.28564,54.51501,12.28591,133.60151
2023-05-16 03:48:01,54.51498,12.28570,54.51505,12.28597,133.60169
2023-05-16 03:48:02,54.51501,12.28575,54.51508,12.28602,133.60187
2023-05-16 03:48:03,54.51504,12.28581,54.51512,12.28608,133.60205
2023-05-16 03:48:04,54.51508,12.28586,54.51515,12.28613,133.60222
2023-05-16 03:48:05,54.51511,12.28592,54.51519,12.28619,133.60240
2023-05-16 03:48:06,54.51515,12.28597,54.51522,12.28625,133.60258
2023-05-16 03:48:07,54.51518,12.28603,54.51525,12.28630,133.60276
2023-05-16 03:48:08,54.51522,12.28608,54.51529,12.28636,133.60294
2023-05-16 03:48:09,54.51525,12.28614,54.51532,12.28641,133.60312
2023-05-16 03:48:10,54.51528,12.28620,54.51536,12.28647,133.60330
2023-05-16 03:48:11,54.51532,12.28625,54.51539,12.28652,133.60348
2023-05-16 03:48:12,54.51535,12.28631,54.51542,12.28658,133.60366
2023-05-16 03:48:13,54.51539,12.28636,54.51546,12.28664,133.60384
2023-05-16 03:48:14,54.51542,12.28642,54.51549,12.28669,133.60402
2023-05-16 03:48:15,54.51545,12.28648,54.51553,12.28675,133.60420
2023-05-16 03:48:16,54.51549,12.28653,54.51556,12.28680,133.60438
2023-05-16 03:48:17,54.51552,12.28659,54.51560,12.28686,133.60457
2023-05-16 03:48:18,54.51556,12.28664,54.51563,12.28692,133.60475
2023-05-16 03:48:19,54.51559,12.28670,54.51566,12.28697,133.60493
2023-05-16 03:48:20,54.51562,12.28676,54.51570,12.28703,133.60511
2023-05-16 03:48:21,54.51566,12.28681,54.51573,12.28708,133.60529
2023-05-16 03:48:22,54.51569,12.28687,54.51577,12.28714,133.60547
2023-05-16 03:48:23,54.51573,12.28693,54.51580,12.28720,133.60565
2023-05-16 03:48:24,54.51576,12.28698,54.51584,12.28725,133.60583
2023-05-16 03:48:25,54.51580,12.28704,54.51587,12.28731,133.60601
2023-05-16 03:48:26,54.51583,12.28709,54.51590,12.28736,133.60619
2023-05-16 03:48:27,54.51586,12.28715,54.51594,12.28742,133.60637
2023-05-16 03:48:28,54.51590,12.28721,54.51597,12.28748,133.60655
2023-05-16 03:48:29,54.51593,12.28726,54.51601,12.28753,133.60673
2023-05-16 03:48:30,54.51597,12.28732,54.51604,12.28759,133.60691
2023-05-16 03:48:31,54.51600,12.28737,54.51608,12.28764,133.60710
2023-05-16 03:48:32,54.51604,12.28743,54.51611,12.28770,133.60728
2023-05-16 03:48:33,54.51607,12.28749,54.51615,12.28776,133.60746
2023-05-16 03:48:34,54.51610,12.28754,54.51618,12.28781,133.60764
2023-05-16 03:48:35,54.51614,12.28760,54.51621,12.28787,133.60782
2023-05-16 03:48:36,54.51617,12.28765,54.51625,12.28792,133.60800
2023-05-16 03:48:37,54.51621,12.28771,54.51628,12.28798,133.60818
2023-05-16 03:48:38,54.51624,12.28776,54.51632,12.28803,133.60836
2023-05-16 03:48:39,54.51628,12.28782,54.51635,12.28809,133.60854
2023-05-16 03:48:40,54.51631,12.28788,54.51639,12.28814,133.60872
2023-05-16 03:48:41,54.51635,12.28793,54.51642,12.28820,133.60890
2023-05-16 03:48:42,54.51638,12.28799,54.51646,12.28826,133.60908
2023-05-16 03:48:43,54.51642,12.28804,54.51649,12.28831,133.60926
2023-05-16 03:48:44,54.51645,12.28810,54.51653,12.28837,133.60944
2023-05-16 03:48:45,54.51648,12.28815,54.51656,12.28842,133.60962
2023-05-16 03:48:46,54.51652,12.28821,54.51660,12.28848,133.60980
2023-05-16 03:48:47,54.51656,12.28826,54.51663,12.28853,133.60998
2023-05-16 03:48:48,54.51659,12.28832,54.51667,12.28858,133.61016
2023-05-16 03:48:49,54.51663,12.28837,54.51670,12.28864,133.61034
2023-05-16 03:48:50,54.51666,12.28842,54.51674,12.28869,133.61052
2023-05-16 03:48:51,54.51670,12.28848,54.51677,12.28875,133.61069
2023-05-16 03:48:52,54.51673,12.28853,54.51681,12.28880,133.61087
2023-05-16 03:48:53,54.51677,12.28859,54.51684,12.28886,133.61105
2023-05-16 03:48:54,54.51680,12.28864,54.51688,12.28891,133.61123
2023-05-16 03:48:55,54.51684,12.28870,54.51691,12.28897,133.61141
2023-05-16 03:48:56,54.51687,12.28875,54.51695,12.28902,133.61159
2023-05-16 03:48:57,54.51691,12.28881,54.51698,12.28908,133.61177
2023-05-16 03:48:58,54.51694,12.28886,54.51702,12.28913,133.61195
2023-05-16 03:48:59,54.51698,12.28892,54.51705,12.28919,133.61213
2023-05-16 03:49:00,54.51701,12.28897,54.51709,12.28924,133.61231
2023-05-16 03:49:01,54.51705,12.28902,54.51712,12.28929,133.61249
2023-05-16 03:49:02,54.51708,12.28908,54.51716,12.28935,133.61267
2023-05-16 03:49:03,54.51712,12.28913,54.51719,12.28940,133.61285
2023-05-16 03:49:04,54.51715,12.28919,54.51723,12.28946,133.61303
2023-05-16 03:49:05,54.51719,12.28924,54.51726,12.28951,133.61321
2023-05-16 03:49:06,54.51722,12.28930,54.51730,12.28957,133.61339
2023-05-16 03:49:07,54.51726,12.28935,54.51733,12.28962,133.61357
2023-05-16 03:49:08,54.51729,12.28941,54.51737,12.28968,133.61375
2023-05-16 03:49:09,54.51733,12.28946,54.51740,12.28973,133.61393
2023-05-16 03:49:10,54.51736,12.28952,54.51744,12.28979,133.61411
2023-05-16 03:49:11,54.51740,12.28957,54.51747,12.28984,133.61429
2023-05-16 03:49:12,54.51743,12.28963,54.51751,12.28990,133.61447
2023-05-16 03:49:13,54.51747,12.28968,54.51754,12.28995,133.61465
2023-05-16 03:49:14,54.51750,12.28974,54.51758,12.29001,133.61483
2023-05-16 03:49:15,54.51754,12.28979,54.51761,12.29006,133.61501
2023-05-16 03:49:16,54.51757,12.28985,54.51765,12.29012,133.61519
2023-05-16 03:49:17,54.51761,12.28990,54.51768,12.29017,133.61537
2023-05-16 03:49:18,54.51764,12.28996,54.51772,12.29023,133.61555
2023-05-16 03:49:19,54.51768,12.29001,54.51775,12.29028,133.61573
2023-05-16 03:49:20,54.51771,12.29007,54.51779,12.29034,133.61591
2023-05-16 03:49:21,54.51775,12.29012,54.51782,12.29039,133.61609
2023-05-16 03:49:22,54.51778,12.29018,54.51786,12.29045,133.61627
2023-05-16 03:49:23,54.51782,12.29023,54.51789,12.29051,133.61645
2023-05-16 03:49:24,54.51785,12.29029,54.51793,12.29056,133.61663
2023-05-16 03:49:25,54.51789,12.29034,54.51796,12.29062,133.61681
2023-05-16 03:49:26,54.51792,12.29040,54.51800,12.29067,133.61699
2023-05-16 03:49:27,54.51796,12.29045,54.51803,12.29073,133.61717
2023-05-16 03:49:28,54.51799,12.29051,54.51807,12.29078,133.61735
2023-05-16 03:49:29,54.51803,12.29057,54.51810,12.29084,133.61754
2023-05-16 03:49:30,54.51806,12.29062,54.51814,12.29089,133.61772
2023-05-16 03:49:31,54.51810,12.29068,54.51817,12.29095,133.61790
2023-05-16 03:49:32,54.51813,12.29073,54.51821,12.29100,133.61808
2023-05-16 03:49:33,54.51817,12.29079,54.51824,12.29106,133.61826
2023-05-16 03:49:34,54.51820,12.29084,54.51828,12.29112,133.61844
2023-05-16 03:49:35,54.51824,12.29090,54.51831,12.29117,133.61862
2023-05-16 03:49:36,54.51827,12.29095,54.51835,12.29123,133.61880
2023-05-16 03:49:37,54.51831,12.29101,54.51838,12.29128,133.61898
2023-05-16 03:49:38,54.51834,12.29107,54.51842,12.29134,133.61917
2023-05-16 03:49:39,54.51838,12.29112,54.51845,12.29139,133.61935
2023-05-16 03:49:40,54.51841,12.29118,54.51849,12.29145,133.61953
2023-05-16 03:49:41,54.51845,12.29123,54.51852,12.29151,133.61971
2023-05-16 03:49:42,54.51848,12.29129,54.51856,12.29156,133.61989
2023-05-16 03:49:43,54.51852,12.29135,54.51859,12.29162,133.62007
2023-05-16 03:49:44,54.51855,12.29140,54.51863,12.29167,133.62025
2023-05-16 03:49:45,54.51859,12.29146,54.51866,12.29173,133.62043
2023-05-16 03:49:46,54.51862,12.29151,54.51869,12.29179,133.62061
2023-05-16 03:49:47,54.51866,12.29157,54.51873,12.29184,133.62080
2023-05-16 03:49:48,54.51869,12.29162,54.51876,12.29190,133.62098
2023-05-16 03:49:49,54.51873,12.29168,54.51880,12.29195,133.62116
2023-05-16 03:49:50,54.51876,12.29173,54.51883,12.29201,133.62134
2023-05-16 03:49:51,54.51880,12.29179,54.51887,12.29206,133.62152
2023-05-16 03:49:52,54.51883,12.29184,54.51890,12.29212,133.62170
2023-05-16 03:49:53,54.51887,12.29190,54.51894,12.29217,133.62188
2023-05-16 03:49:54,54.51890,12.29195,54.51897,12.29223,133.62206
2023-05-16 03:49:55,54.51894,12.29201,54.51901,12.29229,133.62224
2023-05-16 03:49:56,54.51897,12.29207,54.51904,12.29234,133.62242
2023-05-16 03:49:57,54.51901,12.29212,54.51908,12.29240,133.62260
2023-05-16 03:49:58,54.51904,12.29218,54.51911,12.29245,133.62278
2023-05-16 03:49:59,54.51908,12.29223,54.51914,12.29251,133.62297
2023-05-16 03:50:00,54.51911,12.29229,54.51918,12.29257,133.62315
2023-05-16 03:50:01,54.51915,12.29234,54.51921,12.29262,133.62333
2023-05-16 03:50:02,54.51918,12.29240,54.51925,12.29268,133.62351
2023-05-16 03:50:03,54.51922,12.29246,54.51928,12.29274,133.62369
2023-05-16 03:50:04,54.51925,12.29251,54.51932,12.29279,133.62387
2023-05-16 03:50:05,54.51928,12.29257,54.51935,12.29285,133.62405
2023-05-16 03:50:06,54.51932,12.29263,54.51938,12.29291,133.62424
2023-05-16 03:50:07,54.51935,12.29268,54.51942,12.29296,133.62442
2023-05-16 03:50:08,54.51939,12.29274,54.51945,12.29302,133.62460
2023-05-16 03:50:09,54.51942,12.29280,54.51948,12.29308,133.62478
2023-05-16 03:50:10,54.51946,12.29286,54.51952,12.29314,133.62497
2023-05-16 03:50:11,54.51949,12.29291,54.51955,12.29319,133.62515
2023-05-16 03:50:12,54.51952,12.29297,54.51958,12.29325,133.62533
2023-05-16 03:50:13,54.51956,12.29303,54.51962,12.29331,133.62551
2023-05-16 03:50:14,54.51959,12.29309,54.51965,12.29337,133.62570
2023-05-16 03:50:15,54.51962,12.29315,54.51968,12.29343,133.62588
2023-05-16 03:50:16,54.51966,12.29320,54.51972,12.29349,133.62607
2023-05-16 03:50:17,54.51969,12.29326,54.51975,12.29355,133.62625
2023-05-16 03:50:18,54.51972,12.29332,54.51978,12.29361,133.62643
2023-05-16 03:50:19,54.51976,12.29338,54.51982,12.29366,133.62662
2023-05-16 03:50:20,54.51979,12.29344,54.51985,12.29372,133.62680
2023-05-16 03:50:21,54.51982,12.29350,54.51988,12.29378,133.62699
2023-05-16 03:50:22,54.51985,12.29356,54.51991,12.29384,133.62717
2023-05-16 03:50:23,54.51989,12.29362,54.51994,12.29390,133.62736
2023-05-16 03:50:24,54.51992,12.29368,54.51998,12.29396,133.62754
2023-05-16 03:50:25,54.51995,12.29374,54.52001,12.29403,133.62773
2023-05-16 03:50:26,54.51998,12.29380,54.52004,12.29409,133.62791
2023-05-16 03:50:27,54.52001,12.29386,54.52007,12.29415,133.62810
2023-05-16 03:50:28,54.52005,12.29392,54.52011,12.29421,133.62828
2023-05-16 03:50:29,54.52008,12.29399,54.52014,12.29427,133.62847
2023-05-16 03:50:30,54.52011,12.29405,54.52017,12.29433,133.62866
2023-05-16 03:50:31,54.52014,12.29411,54.52020,12.29439,133.62884
2023-05-16 03:50:32,54.52017,12.29417,54.52023,12.29445,133.62903
2023-05-16 03:50:33,54.52021,12.29423,54.52026,12.29451,133.62921
2023-05-16 03:50:34,54.52024,12.29429,54.52030,12.29457,133.62940
2023-05-16 03:50:35,54.52027,12.29435,54.52033,12.29463,133.62959
2023-05-16 03:50:36,54.52030,12.29441,54.52036,12.29470,133.62977
2023-05-16 03:50:37,54.52033,12.29448,54.52039,12.29476,133.62996
2023-05-16 03:50:38,54.52036,12.29454,54.52042,12.29482,133.63015
2023-05-16 03:50:39,54.52040,12.29460,54.52046,12.29488,133.63033
2023-05-16 03:50:40,54.52043,12.29466,54.52049,12.29494,133.63052
2023-05-16 03:50:41,54.52046,12.29472,54.52052,12.29500,133.63071
2023-05-16 03:50:42,54.52049,12.29478,54.52055,12.29506,133.63089
2023-05-16 03:50:43,54.52052,12.29485,54.52058,12.29513,133.63108
2023-05-16 03:50:44,54.52055,12.29491,54.52062,12.29519,133.63126
2023-05-16 03:50:45,54.52059,12.29497,54.52065,12.29525,133.63145
2023-05-16 03:50:46,54.52062,12.29503,54.52068,12.29531,133.63164
2023-05-16 03:50:47,54.52065,12.29509,54.52071,12.29537,133.63182
2023-05-16 03:50:48,54.52068,12.29515,54.52074,12.29543,133.63201
2023-05-16 03:50:49,54.52071,12.29522,54.52078,12.29549,133.63220
2023-05-16 03:50:50,54.52074,12.29528,54.52081,12.29555,133.63238
2023-05-16 03:50:51,54.52078,12.29534,54.52084,12.29562,133.63257
2023-05-16 03:50:52,54.52081,12.29540,54.52087,12.29568,133.63276
2023-05-16 03:50:53,54.52084,12.29546,54.52091,12.29574,133.63294
2023-05-16 03:50:54,54.52087,12.29552,54.52094,12.29580,133.63313
2023-05-16 03:50:55,54.52090,12.29558,54.52097,12.29586,133.63332
2023-05-16 03:50:56,54.52094,12.29564,54.52100,12.29592,133.63350
2023-05-16 03:50:57,54.52097,12.29570,54.52104,12.29598,133.63369
2023-05-16 03:50:58,54.52100,12.29576,54.52107,12.29604,133.63387
2023-05-16 03:50:59,54.52103,12.29582,54.52110,12.29610,133.63406
2023-05-16 03:51:00,54.52107,12.29589,54.52113,12.29616,133.63424
2023-05-16 03:51:01,54.52110,12.29595,54.52117,12.29622,133.63443
2023-05-16 03:51:02,54.52113,12.29601,54.52120,12.29628,133.63462
2023-05-16 03:51:03,54.52116,12.29607,54.52123,12.29634,133.63480
2023-05-16 03:51:04,54.52120,12.29613,54.52126,12.29640,133.63499
2023-05-16 03:51:05,54.52123,12.29619,54.52130,12.29646,133.63517
2023-05-16 03:51:06,54.52126,12.29624,54.52133,12.29652,133.63536
2023-05-16 03:51:07,54.52129,12.29630,54.52136,12.29658,133.63554
2023-05-16 03:51:08,54.52133,12.29636,54.52140,12.29664,133.63572
2023-05-16 03:51:09,54.52136,12.29642,54.52143,12.29670,133.63591
2023-05-16 03:51:10,54.52139,12.29648,54.52146,12.29675,133.63609
2023-05-16 03:51:11,54.52143,12.29654,54.52150,12.29681,133.63628
2023-05-16 03:51:12,54.52146,12.29660,54.52153,12.29687,133.63646
2023-05-16 03:51:13,54.52149,12.29666,54.52156,12.29693,133.63664
2023-05-16 03:51:14,54.52153,12.29672,54.52160,12.29699,133.63683
2023-05-16 03:51:15,54.52156,12.29677,54.52163,12.29705,133.63701
2023-05-16 03:51:16,54.52159,12.29683,54.52167,12.29710,133.63719
2023-05-16 03:51:17,54.52163,12.29689,54.52170,12.29716,133.63738
2023-05-16 03:51:18,54.52166,12.29695,54.52173,12.29722,133.63756
2023-05-16 03:51:19,54.52169,12.29700,54.52177,12.29728,133.63774
2023-05-16 03:51:20,54.52173,12.29706,54.52180,12.29733,133.63793
2023-05-16 03:51:21,54.52176,12.29712,54.52183,12.29739,133.63811
2023-05-16 03:51:22,54.52180,12.29718,54.52187,12.29745,133.63829
2023-05-16 03:51:23,54.52183,12.29723,54.52190,12.29751,133.63847
2023-05-16 03:51:24,54.52186,12.29729,54.52194,12.29756,133.63865
2023-05-16 03:51:25,54.52190,12.29735,54.52197,12.29762,133.63884
2023-05-16 03:51:26,54.52193,12.29740,54.52200,12.29768,133.63902
2023-05-16 03:51:27,54.52197,12.29746,54.52204,12.29774,133.63920
2023-05-16 03:51:28,54.52200,12.29752,54.52207,12.29779,133.63938
2023-05-16 03:51:29,54.52203,12.29758,54.52211,12.29785,133.63956
2023-05-16 03:51:30,54.52207,12.29763,54.52214,12.29791,133.63975
2023-05-16 03:51:31,54.52210,12.29769,54.52217,12.29796,133.63993
2023-05-16 03:51:32,54.52214,12.29775,54.52221,12.29802,133.64011
2023-05-16 03:51:33,54.52217,12.29780,54.52224,12.29808,133.64029
2023-05-16 03:51:34,54.52221,12.29786,54.52228,12.29813,133.64047
2023-05-16 03:51:35,54.52224,12.29791,54.52231,12.29819,133.64065
2023-05-16 03:51:36,54.52227,12.29797,54.52234,12.29825,133.64084
2023-05-16 03:51:37,54.52231,12.29803,54.52238,12.29830,133.64102
2023-05-16 03:51:38,54.52234,12.29809,54.52241,12.29836,133.64120
2023-05-16 03:51:39,54.52238,12.29814,54.52245,12.29842,133.64138
2023-05-16 03:51:40,54.52241,12.29820,54.52248,12.29847,133.64156
2023-05-16 03:51:41,54.52244,12.29826,54.52251,12.29853,133.64174
2023-05-16 03:51:42,54.52248,12.29831,54.52255,12.29859,133.64193
2023-05-16 03:51:43,54.52251,12.29837,54.52258,12.29864,133.64211
2023-05-16 03:51:44,54.52255,12.29843,54.52262,12.29870,133.64229
2023-05-16 03:51:45,54.52258,12.29848,54.52265,12.29876,133.64247
2023-05-16 03:51:46,54.52262,12.29854,54.52269,12.29881,133.64266
2023-05-16 03:51:47,54.52265,12.29860,54.52272,12.29887,133.64284
2023-05-16 03:51:48,54.52268,12.29865,54.52275,12.29893,133.64302
2023-05-16 03:51:49,54.52272,12.29871,54.52279,12.29899,133.64320
2023-05-16 03:51:50,54.52275,12.29877,54.52282,12.29904,133.64338
2023-05-16 03:51:51,54.52279,12.29882,54.52286,12.29910,133.64356
2023-05-16 03:51:52,54.52282,12.29888,54.52289,12.29916,133.64375
2023-05-16 03:51:53,54.52286,12.29894,54.52292,12.29921,133.64393
2023-05-16 03:51:54,54.52289,12.29899,54.52296,12.29927,133.64411
2023-05-16 03:51:55,54.52292,12.29905,54.52299,12.29933,133.64429
2023-05-16 03:51:56,54.52296,12.29911,54.52303,12.29938,133.64448
2023-05-16 03:51:57,54.52299,12.29917,54.52306,12.29944,133.64466
2023-05-16 03:51:58,54.52303,12.29922,54.52309,12.29950,133.64484
2023-05-16 03:51:59,54.52306,12.29928,54.52313,12.29956,133.64502
2023-05-16 03:52:00,54.52309,12.29934,54.52316,12.29961,133.64520
2023-05-16 03:52:01,54.52313,12.29939,54.52319,12.29967,133.64539
2023-05-16 03:52:02,54.52316,12.29945,54.52323,12.29973,133.64557
2023-05-16 03:52:03,54.52320,12.29951,54.52326,12.29979,133.64575
2023-05-16 03:52:04,54.52323,12.29957,54.52330,12.29984,133.64593
2023-05-16 03:52:05,54.52326,12.29962,54.52333,12.29990,133.64612
2023-05-16 03:52:06,54.52330,12.29968,54.52336,12.29996,133.64630
2023-05-16 03:52:07,54.52333,12.29974,54.52340,12.30002,133.64648
2023-05-16 03:52:08,54.52337,12.29980,54.52343,12.30007,133.64667
2023-05-16 03:52:09,54.52340,12.29985,54.52346,12.30013,133.64685
2023-05-16 03:52:10,54.52343,12.29991,54.52350,12.30019,133.64703
2023-05-16 03:52:11,54.52347,12.29997,54.52353,12.30025,133.64721
2023-05-16 03:52:12,54.52350,12.30003,54.52356,12.30031,133.64740
2023-05-16 03:52:13,54.52353,12.30009,54.52360,12.30037,133.64758
2023-05-16 03:52:14,54.52357,12.30014,54.52363,12.30042,133.64776
2023-05-16 03:52:15,54.52360,12.30020,54.52366,12.30048,133.64795
2023-05-16 03:52:16,54.52363,12.30026,54.52370,12.30054,133.64813
2023-05-16 03:52:17,54.52367,12.30032,54.52373,12.30060,133.64831
2023-05-16 03:52:18,54.52370,12.30038,54.52376,12.30066,133.64850
2023-05-16 03:52:19,54.52373,12.30044,54.52380,12.30072,133.64868
2023-05-16 03:52:20,54.52377,12.30050,54.52383,12.30077,133.64886
2023-05-16 03:52:21,54.52380,12.30055,54.52386,12.30083,133.64905
2023-05-16 03:52:22,54.52383,12.30061,54.52389,12.30089,133.64923
2023-05-16 03:52:23,54.52386,12.30067,54.52393,12.30095,133.64942
2023-05-16 03:52:24,54.52390,12.30073,54.52396,12.30101,133.64960
2023-05-16 03:52:25,54.52393,12.30079,54.52399,12.30107,133.64979
2023-05-16 03:52:26,54.52396,12.30085,54.52403,12.30113,133.64997
2023-05-16 03:52:27,54.52400,12.30091,54.52406,12.30119,133.65015
2023-05-16 03:52:28,54.52403,12.30097,54.52409,12.30125,133.65034
2023-05-16 03:52:29,54.52406,12.30103,54.52412,12.30131,133.65052
2023-05-16 03:52:30,54.52409,12.30109,54.52416,12.30137,133.65071
2023-05-16 03:52:31,54.52413,12.30115,54.52419,12.30143,133.65089
2023-05-16 03:52:32,54.52416,12.30121,54.52422,12.30149,133.65108
2023-05-16 03:52:33,54.52419,12.30127,54.52425,12.30155,133.65126
2023-05-16 03:52:34,54.52423,12.30133,54.52429,12.30161,133.65145
2023-05-16 03:52:35,54.52426,12.30139,54.52432,12.30167,133.65163
2023-05-16 03:52:36,54.52429,12.30145,54.52435,12.30173,133.65182
2023-05-16 03:52:37,54.52432,12.30151,54.52439,12.30179,133.65200
2023-05-16 03:52:38,54.52436,12.30157,54.52442,12.30185,133.65219
2023-05-16 03:52:39,54.52439,12.30163,54.52445,12.30191,133.65238
2023-05-16 03:52:40,54.52442,12.30169,54.52448,12.30197,133.65256
2023-05-16 03:52:41,54.52445,12.30175,54.52452,12.30203,133.65275
2023-05-16 03:52:42,54.52449,12.30181,54.52455,12.30209,133.65293
2023-05-16 03:52:43,54.52452,12.30187,54.52458,12.30215,133.65312
2023-05-16 03:52:44,54.52455,12.30193,54.52461,12.30221,133.65330
2023-05-16 03:52:45,54.52458,12.30199,54.52465,12.30227,133.65349
2023-05-16 03:52:46,54.52461,12.30205,54.52468,12.30233,133.65367
2023-05-16 03:52:47,54.52465,12.30211,54.52471,12.30239,133.65386
2023-05-16 03:52:48,54.52468,12.30217,54.52474,12.30245,133.65404
2023-05-16 03:52:49,54.52471,12.30223,54.52478,12.30251,133.65423
2023-05-16 03:52:50,54.52474,12.30229,54.52481,12.30257,133.65442
2023-05-16 03:52:51,54.52478,12.30235,54.52484,12.30263,133.65460
2023-05-16 03:52:52,54.52481,12.30241,54.52487,12.30269,133.65479
2023-05-16 03:52:53,54.52484,12.30247,54.52491,12.30275,133.65497
2023-05-16 03:52:54,54.52487,12.30253,54.52494,12.30281,133.65516
2023-05-16 03:52:55,54.52491,12.30259,54.52497,12.30287,133.65534
2023-05-16 03:52:56,54.52494,12.30265,54.52500,12.30293,133.65553
2023-05-16 03:52:57,54.52497,12.30271,54.52504,12.30299,133.65571
2023-05-16 03:52:58,54.52500,12.30277,54.52507,12.30305,133.65590
2023-05-16 03:52:59,54.52504,12.30283,54.52510,12.30311,133.65608
2023-05-16 03:53:00,54.52507,12.30289,54.52514,12.30317,133.65627
2023-05-16 03:53:01,54.52510,12.30295,54.52517,12.30323,133.65645
2023-05-16 03:53:02,54.52514,12.30301,54.52520,12.30329,133.65664
2023-05-16 03:53:03,54.52517,12.30307,54.52524,12.30335,133.65682
2023-05-16 03:53:04,54.52520,12.30313,54.52527,12.30341,133.65701
2023-05-16 03:53:05,54.52523,12.30319,54.52530,12.30347,133.65719
2023-05-16 03:53:06,54.52527,12.30325,54.52533,12.30352,133.65738
2023-05-16 03:53:07,54.52530,12.30331,54.52537,12.30358,133.65756
2023-05-16 03:53:08,54.52533,12.30337,54.52540,12.30364,133.65774
2023-05-16 03:53:09,54.52537,12.30343,54.52543,12.30370,133.65793
2023-05-16 03:53:10,54.52540,12.30349,54.52547,12.30376,133.65811
2023-05-16 03:53:11,54.52543,12.30354,54.52550,12.30382,133.65830
2023-05-16 03:53:12,54.52547,12.30360,54.52553,12.30388,133.65848
2023-05-16 03:53:13,54.52550,12.30366,54.52557,12.30394,133.65866
2023-05-16 03:53:14,54.52553,12.30372,54.52560,12.30399,133.65885
2023-05-16 03:53:15,54.52557,12.30378,54.52563,12.30405,133.65903
2023-05-16 03:53:16,54.52560,12.30384,54.52567,12.30411,133.65921
2023-05-16 03:53:17,54.52563,12.30389,54.52570,12.30417,133.65940
2023-05-16 03:53:18,54.52567,12.30395,54.52574,12.30423,133.65958
2023-05-16 03:53:19,54.52570,12.30401,54.52577,12.30428,133.65976
2023-05-16 03:53:20,54.52573,12.30407,54.52580,12.30434,133.65994
2023-05-16 03:53:21,54.52577,12.30412,54.52584,12.30440,133.66013
2023-05-16 03:53:22,54.52580,12.30418,54.52587,12.30446,133.66031
2023-05-16 03:53:23,54.52584,12.30424,54.52590,12.30451,133.66049
2023-05-16 03:53:24,54.52587,12.30430,54.52594,12.30457,133.66068
2023-05-16 03:53:25,54.52590,12.30435,54.52597,12.30463,133.66086
2023-05-16 03:53:26,54.52594,12.30441,54.52601,12.30469,133.66104
2023-05-16 03:53:27,54.52597,12.30447,54.52604,12.30474,133.66122
2023-05-16 03:53:28,54.52600,12.30453,54.52607,12.30480,133.66141
2023-05-16 03:53:29,54.52604,12.30459,54.52611,12.30486,133.66159
2023-05-16 03:53:30,54.52607,12.30464,54.52614,12.30492,133.66177
2023-05-16 03:53:31,54.52610,12.30470,54.52617,12.30498,133.66195
2023-05-16 03:53:32,54.52614,12.30476,54.52621,12.30503,133.66214
2023-05-16 03:53:33,54.52617,12.30482,54.52624,12.30509,133.66232
2023-05-16 03:53:34,54.52621,12.30487,54.52627,12.30515,133.66250
2023-05-16 03:53:35,54.52624,12.30493,54.52631,12.30521,133.66269
2023-05-16 03:53:36,54.52627,12.30499,54.52634,12.30526,133.66287
2023-05-16 03:53:37,54.52631,12.30505,54.52638,12.30532,133.66305
2023-05-16 03:53:38,54.52634,12.30510,54.52641,12.30538,133.66323
2023-05-16 03:53:39,54.52638,12.30516,54.52644,12.30544,133.66342
2023-05-16 03:53:40,54.52641,12.30522,54.52648,12.30550,133.66360
2023-05-16 03:53:41,54.52644,12.30528,54.52651,12.30555,133.66378
2023-05-16 03:53:42,54.52648,12.30533,54.52654,12.30561,133.66397
2023-05-16 03:53:43,54.52651,12.30539,54.52658,12.30567,133.66415
2023-05-16 03:53:44,54.52654,12.30545,54.52661,12.30573,133.66433
2023-05-16 03:53:45,54.52658,12.30551,54.52665,12.30578,133.66451
2023-05-16 03:53:46,54.52661,12.30557,54.52668,12.30584,133.66470
2023-05-16 03:53:47,54.52664,12.30562,54.52671,12.30590,133.66488
2023-05-16 03:53:48,54.52668,12.30568,54.52675,12.30596,133.66506
2023-05-16 03:53:49,54.52671,12.30574,54.52678,12.30602,133.66525
2023-05-16 03:53:50,54.52675,12.30580,54.52681,12.30607,133.66543
2023-05-16 03:53:51,54.52678,12.30586,54.52685,12.30613,133.66561
2023-05-16 03:53:52,54.52681,12.30591,54.52688,12.30619,133.66580
2023-05-16 03:53:53,54.52685,12.30597,54.52691,12.30625,133.66598
2023-05-16 03:53:54,54.52688,12.30603,54.52695,12.30631,133.66616
2023-05-16 03:53:55,54.52691,12.30609,54.52698,12.30636,133.66635
2023-05-16 03:53:56,54.52695,12.30615,54.52701,12.30642,133.66653
2023-05-16 03:53:57,54.52698,12.30620,54.52705,12.30648,133.66671
2023-05-16 03:53:58,54.52701,12.30626,54.52708,12.30654,133.66690
2023-05-16 03:53:59,54.52705,12.30632,54.52712,12.30660,133.66708
2023-05-16 03:54:00,54.52708,12.30638,54.52715,12.30665,133.66726
2023-05-16 03:54:01,54.52712,12.30644,54.52718,12.30671,133.66745
2023-05-16 03:54:02,54.52715,12.30649,54.52722,12.30677,133.66763
2023-05-16 03:54:03,54.52718,12.30655,54.52725,12.30683,133.66781
2023-05-16 03:54:04,54.52722,12.30661,54.52728,12.30689,133.66800
2023-05-16 03:54:05,54.52725,12.30667,54.52732,12.30694,133.66818
2023-05-16 03:54:06,54.52728,12.30673,54.52735,12.30700,133.66836
2023-05-16 03:54:07,54.52732,12.30678,54.52739,12.30706,133.66855
2023-05-16 03:54:08,54.52735,12.30684,54.52742,12.30712,133.66873
2023-05-16 03:54:09,54.52739,12.30690,54.52745,12.30718,133.66891
2023-05-16 03:54:10,54.52742,12.30696,54.52749,12.30723,133.66909
2023-05-16 03:54:11,54.52745,12.30701,54.52752,12.30729,133.66928
2023-05-16 03:54:12,54.52749,12.30707,54.52755,12.30735,133.66946
2023-05-16 03:54:13,54.52752,12.30713,54.52759,12.30741,133.66964
2023-05-16 03:54:14,54.52755,12.30719,54.52762,12.30746,133.66983
2023-05-16 03:54:15,54.52759,12.30725,54.52766,12.30752,133.67001
2023-05-16 03:54:16,54.52762,12.30730,54.52769,12.30758,133.67019
2023-05-16 03:54:17,54.52766,12.30736,54.52772,12.30764,133.67038
2023-05-16 03:54:18,54.52769,12.30742,54.52776,12.30770,133.67056
2023-05-16 03:54:19,54.52772,12.30748,54.52779,12.30775,133.67074
2023-05-16 03:54:20,54.52776,12.30753,54.52782,12.30781,133.67093
2023-05-16 03:54:21,54.52779,12.30759,54.52786,12.30787,133.67111
2023-05-16 03:54:22,54.52783,12.30765,54.52789,12.30793,133.67129
2023-05-16 03:54:23,54.52786,12.30771,54.52793,12.30799,133.67148
2023-05-16 03:54:24,54.52789,12.30777,54.52796,12.30804,133.67166
2023-05-16 03:54:25,54.52793,12.30782,54.52799,12.30810,133.67184
2023-05-16 03:54:26,54.52796,12.30788,54.52803,12.30816,133.67203
2023-05-16 03:54:27,54.52799,12.30794,54.52806,12.30822,133.67221
2023-05-16 03:54:28,54.52803,12.30800,54.52809,12.30828,133.67240
2023-05-16 03:54:29,54.52806,12.30806,54.52813,12.30833,133.67258
2023-05-16 03:54:30,54.52810,12.30811,54.52816,12.30839,133.67276
2023-05-16 03:54:31,54.52813,12.30817,54.52819,12.30845,133.67295
2023-05-16 03:54:32,54.52816,12.30823,54.52823,12.30851,133.67313
2023-05-16 03:54:33,54.52820,12.30829,54.52826,12.30857,133.67332
2023-05-16 03:54:34,54.52823,12.30835,54.52829,12.30863,133.67350
2023-05-16 03:54:35,54.52826,12.30841,54.52833,12.30869,133.67368
2023-05-16 03:54:36,54.52830,12.30847,54.52836,12.30874,133.67387
2023-05-16 03:54:37,54.52833,12.30852,54.52839,12.30880,133.67405
2023-05-16 03:54:38,54.52836,12.30858,54.52843,12.30886,133.67424
2023-05-16 03:54:39,54.52840,12.30864,54.52846,12.30892,133.67442
2023-05-16 03:54:40,54.52843,12.30870,54.52849,12.30898,133.67460
2023-05-16 03:54:41,54.52846,12.30876,54.52853,12.30904,133.67479
2023-05-16 03:54:42,54.52850,12.30882,54.52856,12.30910,133.67497
2023-05-16 03:54:43,54.52853,12.30888,54.52859,12.30916,133.67516
2023-05-16 03:54:44,54.52856,12.30894,54.52863,12.30921,133.67534
2023-05-16 03:54:45,54.52860,12.30900,54.52866,12.30927,133.67553
2023-05-16 03:54:46,54.52863,12.30905,54.52869,12.30933,133.67571
2023-05-16 03:54:47,54.52866,12.30911,54.52873,12.30939,133.67589
2023-05-16 03:54:48,54.52870,12.30917,54.52876,12.30945,133.67608
2023-05-16 03:54:49,54.52873,12.30923,54.52879,12.30951,133.67626
2023-05-16 03:54:50,54.52876,12.30929,54.52883,12.30957,133.67645
2023-05-16 03:54:51,54.52880,12.30935,54.52886,12.30963,133.67663
2023-05-16 03:54:52,54.52883,12.30941,54.52889,12.30969,133.67682
2023-05-16 03:54:53,54.52886,12.30947,54.52893,12.30975,133.67700
2023-05-16 03:54:54,54.52890,12.30953,54.52896,12.30981,133.67719
2023-05-16 03:54:55,54.52893,12.30959,54.52899,12.30986,133.67737
2023-05-16 03:54:56,54.52896,12.30965,54.52903,12.30992,133.67756
2023-05-16 03:54:57,54.52900,12.30970,54.52906,12.30998,133.67774
2023-05-16 03:54:58,54.52903,12.30976,54.52909,12.31004,133.67793
2023-05-16 03:54:59,54.52906,12.30982,54.52913,12.31010,133.67811
2023-05-16 03:55:00,54.52909,12.30988,54.52916,12.31016,133.67830
2023-05-16 03:55:01,54.52913,12.30994,54.52919,12.31022,133.67848
2023-05-16 03:55:02,54.52916,12.31000,54.52923,12.31028,133.67867
2023-05-16 03:55:03,54.52919,12.31006,54.52926,12.31034,133.67885
2023-05-16 03:55:04,54.52923,12.31012,54.52929,12.31040,133.67904
2023-05-16 03:55:05,54.52926,12.31018,54.52933,12.31046,133.67922
2023-05-16 03:55:06,54.52929,12.31024,54.52936,12.31052,133.67941
2023-05-16 03:55:07,54.52933,12.31030,54.52939,12.31058,133.67959
2023-05-16 03:55:08,54.52936,12.31036,54.52943,12.31063,133.67978
2023-05-16 03:55:09,54.52939,12.31042,54.52946,12.31069,133.67996
2023-05-16 03:55:10,54.52943,12.31048,54.52949,12.31075,133.68015
2023-05-16 03:55:11,54.52946,12.31054,54.52953,12.31081,133.68033
2023-05-16 03:55:12,54.52949,12.31059,54.52956,12.31087,133.68052
2023-05-16 03:55:13,54.52953,12.31065,54.52959,12.31093,133.68070
2023-05-16 03:55:14,54.52956,12.31071,54.52963,12.31099,133.68089
2023-05-16 03:55:15,54.52959,12.31077,54.52966,12.31105,133.68107
2023-05-16 03:55:16,54.52963,12.31083,54.52969,12.31111,133.68126
2023-05-16 03:55:17,54.52966,12.31089,54.52973,12.31117,133.68144
2023-05-16 03:55:18,54.52969,12.31095,54.52976,12.31123,133.68162
2023-05-16 03:55:19,54.52973,12.31101,54.52979,12.31128,133.68181
2023-05-16 03:55:20,54.52976,12.31107,54.52983,12.31134,133.68199
2023-05-16 03:55:21,54.52979,12.31112,54.52986,12.31140,133.68218
2023-05-16 03:55:22,54.52983,12.31118,54.52989,12.31146,133.68236
2023-05-16 03:55:23,54.52986,12.31124,54.52993,12.31152,133.68255
2023-05-16 03:55:24,54.52989,12.31130,54.52996,12.31158,133.68273
2023-05-16 03:55:25,54.52993,12.31136,54.52999,12.31164,133.68292
2023-05-16 03:55:26,54.52996,12.31142,54.53003,12.31170,133.68310
2023-05-16 03:55:27,54.52999,12.31148,54.53006,12.31176,133.68329
2023-05-16 03:55:28,54.53003,12.31154,54.53009,12.31181,133.68347
2023-05-16 03:55:29,54.53006,12.31160,54.53013,12.31187,133.68366
2023-05-16 03:55:30,54.53009,12.31166,54.53016,12.31193,133.68384
2023-05-16 03:55:31,54.53013,12.31171,54.53019,12.31199,133.68402
2023-05-16 03:55:32,54.53016,12.31177,54.53023,12.31205,133.68421
2023-05-16 03:55:33,54.53019,12.31183,54.53026,12.31211,133.68439
2023-05-16 03:55:34,54.53023,12.31189,54.53029,12.31217,133.68458
2023-05-16 03:55:35,54.53026,12.31195,54.53033,12.31223,133.68476
2023-05-16 03:55:36,54.53029,12.31201,54.53036,12.31229,133.68495
2023-05-16 03:55:37,54.53033,12.31207,54.53039,12.31235,133.68513
2023-05-16 03:55:38,54.53036,12.31213,54.53043,12.31240,133.68532
2023-05-16 03:55:39,54.53039,12.31219,54.53046,12.31246,133.68550
2023-05-16 03:55:40,54.53043,12.31224,54.53049,12.31252,133.68569
2023-05-16 03:55:41,54.53046,12.31230,54.53053,12.31258,133.68587
2023-05-16 03:55:42,54.53049,12.31236,54.53056,12.31264,133.68605
2023-05-16 03:55:43,54.53053,12.31242,54.53059,12.31270,133.68624
2023-05-16 03:55:44,54.53056,12.31248,54.53063,12.31276,133.68642
2023-05-16 03:55:45,54.53059,12.31254,54.53066,12.31282,133.68661
2023-05-16 03:55:46,54.53063,12.31260,54.53069,12.31288,133.68679
2023-05-16 03:55:47,54.53066,12.31266,54.53073,12.31293,133.68698
2023-05-16 03:55:48,54.53069,12.31272,54.53076,12.31299,133.68716
2023-05-16 03:55:49,54.53073,12.31277,54.53079,12.31305,133.68735
2023-05-16 03:55:50,54.53076,12.31283,54.53083,12.31311,133.68753
2023-05-16 03:55:51,54.53079,12.31289,54.53086,12.31317,133.68771
2023-05-16 03:55:52,54.53083,12.31295,54.53089,12.31323,133.68790
2023-05-16 03:55:53,54.53086,12.31301,54.53093,12.31329,133.68808
2023-05-16 03:55:54,54.53089,12.31307,54.53096,12.31335,133.68827
2023-05-16 03:55:55,54.53093,12.31313,54.53099,12.31340,133.68845
2023-05-16 03:55:56,54.53096,12.31319,54.53103,12.31346,133.68864
2023-05-16 03:55:57,54.53099,12.31325,54.53106,12.31352,133.68882
2023-05-16 03:55:58,54.53103,12.31330,54.53109,12.31358,133.68900
2023-05-16 03:55:59,54.53106,12.31336,54.53113,12.31364,133.68919
2023-05-16 03:56:00,54.53109,12.31342,54.53116,12.31370,133.68937
2023-05-16 03:56:01,54.53113,12.31348,54.53119,12.31376,133.68956
2023-05-16 03:56:02,54.53116,12.31354,54.53123,12.31382,133.68974
2023-05-16 03:56:03,54.53119,12.31360,54.53126,12.31387,133.68993
2023-05-16 03:56:04,54.53123,12.31366,54.53130,12.31393,133.69011
2023-05-16 03:56:05,54.53126,12.31371,54.53133,12.31399,133.69029
2023-05-16 03:56:06,54.53129,12.31377,54.53136,12.31405,133.69048
2023-05-16 03:56:07,54.53133,12.31383,54.53140,12.31411,133.69066
2023-05-16 03:56:08,54.53136,12.31389,54.53143,12.31417,133.69085
2023-05-16 03:56:09,54.53140,12.31395,54.53146,12.31422,133.69103
2023-05-16 03:56:10,54.53143,12.31401,54.53150,12.31428,133.69121
2023-05-16 03:56:11,54.53146,12.31406,54.53153,12.31434,133.69140
2023-05-16 03:56:12,54.53150,12.31412,54.53156,12.31440,133.69158
2023-05-16 03:56:13,54.53153,12.31418,54.53160,12.31446,133.69176
2023-05-16 03:56:14,54.53156,12.31424,54.53163,12.31452,133.69195
2023-05-16 03:56:15,54.53160,12.31430,54.53166,12.31457,133.69213
2023-05-16 03:56:16,54.53163,12.31436,54.53170,12.31463,133.69232
2023-05-16 03:56:17,54.53166,12.31441,54.53173,12.31469,133.69250
2023-05-16 03:56:18,54.53170,12.31447,54.53176,12.31475,133.69268
2023-05-16 03:56:19,54.53173,12.31453,54.53180,12.31481,133.69287
2023-05-16 03:56:20,54.53176,12.31459,54.53183,12.31487,133.69305
2023-05-16 03:56:21,54.53180,12.31465,54.53187,12.31492,133.69323
2023-05-16 03:56:22,54.53183,12.31471,54.53190,12.31498,133.69342
2023-05-16 03:56:23,54.53187,12.31476,54.53193,12.31504,133.69360
2023-05-16 03:56:24,54.53190,12.31482,54.53197,12.31510,133.69379
2023-05-16 03:56:25,54.53193,12.31488,54.53200,12.31516,133.69397
2023-05-16 03:56:26,54.53197,12.31494,54.53203,12.31522,133.69416
2023-05-16 03:56:27,54.53200,12.31500,54.53207,12.31528,133.69434
2023-05-16 03:56:28,54.53203,12.31506,54.53210,12.31533,133.69452
2023-05-16 03:56:29,54.53207,12.31512,54.53213,12.31539,133.69471
2023-05-16 03:56:30,54.53210,12.31517,54.53217,12.31545,133.69489
2023-05-16 03:56:31,54.53213,12.31523,54.53220,12.31551,133.69508
2023-05-16 03:56:32,54.53217,12.31529,54.53223,12.31557,133.69526
2023-05-16 03:56:33,54.53220,12.31535,54.53227,12.31563,133.69544
2023-05-16 03:56:34,54.53223,12.31541,54.53230,12.31569,133.69563
2023-05-16 03:56:35,54.53227,12.31547,54.53233,12.31575,133.69581
2023-05-16 03:56:36,54.53230,12.31553,54.53237,12.31581,133.69600
2023-05-16 03:56:37,54.53233,12.31559,54.53240,12.31586,133.69618
2023-05-16 03:56:38,54.53237,12.31565,54.53243,12.31592,133.69637
2023-05-16 03:56:39,54.53240,12.31570,54.53247,12.31598,133.69655
2023-05-16 03:56:40,54.53243,12.31576,54.53250,12.31604,133.69673
2023-05-16 03:56:41,54.53247,12.31582,54.53253,12.31610,133.69692
2023-05-16 03:56:42,54.53250,12.31588,54.53257,12.31616,133.69710
2023-05-16 03:56:43,54.53253,12.31594,54.53260,12.31622,133.69728
2023-05-16 03:56:44,54.53257,12.31600,54.53263,12.31627,133.69747
2023-05-16 03:56:45,54.53260,12.31605,54.53267,12.31633,133.69765
2023-05-16 03:56:46,54.53263,12.31611,54.53270,12.31639,133.69784
2023-05-16 03:56:47,54.53267,12.31617,54.53273,12.31645,133.69802
2023-05-16 03:56:48,54.53270,12.31623,54.53277,12.31651,133.69820
2023-05-16 03:56:49,54.53273,12.31629,54.53280,12.31657,133.69839
2023-05-16 03:56:50,54.53277,12.31635,54.53283,12.31662,133.69857
2023-05-16 03:56:51,54.53280,12.31641,54.53287,12.31668,133.69875
2023-05-16 03:56:52,54.53283,12.31646,54.53290,12.31674,133.69894
2023-05-16 03:56:53,54.53287,12.31652,54.53293,12.31680,133.69912
2023-05-16 03:56:54,54.53290,12.31658,54.53297,12.31686,133.69930
2023-05-16 03:56:55,54.53293,12.31664,54.53300,12.31692,133.69949
2023-05-16 03:56:56,54.53297,12.31669,54.53303,12.31697,133.69967
2023-05-16 03:56:57,54.53300,12.31675,54.53307,12.31703,133.69985
2023-05-16 03:56:58,54.53304,12.31681,54.53310,12.31709,133.70004
2023-05-16 03:56:59,54.53307,12.31687,54.53313,12.31715,133.70022
2023-05-16 03:57:00,54.53310,12.31693,54.53317,12.31721,133.70040
2023-05-16 03:57:01,54.53314,12.31699,54.53320,12.31727,133.70059
2023-05-16 03:57:02,54.53317,12.31704,54.53323,12.31732,133.70077
2023-05-16 03:57:03,54.53320,12.31710,54.53327,12.31738,133.70095
2023-05-16 03:57:04,54.53324,12.31716,54.53330,12.31744,133.70114
2023-05-16 03:57:05,54.53327,12.31722,54.53333,12.31750,133.70132
2023-05-16 03:57:06,54.53330,12.31728,54.53336,12.31756,133.70150
2023-05-16 03:57:07,54.53334,12.31734,54.53340,12.31762,133.70169
2023-05-16 03:57:08,54.53337,12.31740,54.53343,12.31768,133.70187
2023-05-16 03:57:09,54.53340,12.31745,54.53346,12.31774,133.70206
2023-05-16 03:57:10,54.53344,12.31751,54.53350,12.31780,133.70224
2023-05-16 03:57:11,54.53347,12.31757,54.53353,12.31785,133.70242
2023-05-16 03:57:12,54.53350,12.31763,54.53356,12.31791,133.70261
2023-05-16 03:57:13,54.53353,12.31769,54.53359,12.31797,133.70279
2023-05-16 03:57:14,54.53357,12.31775,54.53363,12.31803,133.70298
2023-05-16 03:57:15,54.53360,12.31781,54.53366,12.31809,133.70316
2023-05-16 03:57:16,54.53363,12.31787,54.53369,12.31815,133.70334
2023-05-16 03:57:17,54.53366,12.31793,54.53372,12.31821,133.70353
2023-05-16 03:57:18,54.53370,12.31799,54.53375,12.31827,133.70371
2023-05-16 03:57:19,54.53373,12.31805,54.53379,12.31833,133.70390
2023-05-16 03:57:20,54.53376,12.31811,54.53382,12.31839,133.70408
2023-05-16 03:57:21,54.53379,12.31817,54.53385,12.31845,133.70427
2023-05-16 03:57:22,54.53383,12.31823,54.53388,12.31851,133.70445
2023-05-16 03:57:23,54.53386,12.31829,54.53392,12.31857,133.70464
2023-05-16 03:57:24,54.53389,12.31835,54.53395,12.31863,133.70482
2023-05-16 03:57:25,54.53392,12.31841,54.53398,12.31869,133.70501
2023-05-16 03:57:26,54.53396,12.31847,54.53401,12.31876,133.70519
2023-05-16 03:57:27,54.53399,12.31853,54.53404,12.31882,133.70538
2023-05-16 03:57:28,54.53402,12.31859,54.53407,12.31888,133.70556
2023-05-16 03:57:29,54.53405,12.31865,54.53411,12.31894,133.70575
2023-05-16 03:57:30,54.53408,12.31871,54.53414,12.31900,133.70593
2023-05-16 03:57:31,54.53411,12.31878,54.53417,12.31906,133.70612
2023-05-16 03:57:32,54.53415,12.31884,54.53420,12.31912,133.70631
2023-05-16 03:57:33,54.53418,12.31890,54.53423,12.31918,133.70649
2023-05-16 03:57:34,54.53421,12.31896,54.53426,12.31925,133.70668
2023-05-16 03:57:35,54.53424,12.31902,54.53429,12.31931,133.70686
2023-05-16 03:57:36,54.53427,12.31908,54.53432,12.31937,133.70705
2023-05-16 03:57:37,54.53430,12.31915,54.53436,12.31943,133.70724

1 Like

The Total column makes no sense, but that’s the default behavior from Grafana. I did not find a solution to get rid of this column in the result query

1 Like

Do you want just a solution to your issue or do you want an architectural review of this whole thing?

Since this ‘whole thing’ needs to be live next Monday, i rather prefer a solution.
However we could discuss about the architecture in parallel or after it.

1 Like

using the sample data you provided

not sure why you are aggregating your data with mean and group by and dividing and multiplying, subtracting etc?

Hi isn’t this the whole idea about plotting time series data in Grafana?
I mean i have an influxDB containing a lat and long value for every second. So when printing this for big time ranges of your choice 24 hours, 2 days this implies 86400 and 172800 data points.
In order to have less data points for performance reasons i use an aggregation mean (which in fact Grafana offers as default when you start writing your query).

The calculation in the query is caused by the fact that the Lat and Long in the datasource have unit ddmm.mmmm so for example lat=5230.6000, meaning 52 degrees and 30.6 minutes.

The Carto geomap expects the Lat Long value to be in unit decimal degrees, so 5230.6000 is 52 + 30.6000 / 60 = 52 + 0.51 = 52.51 degrees.

As stated in the beginning, when i plot the route withthe maximum datapoints i get a fluid line, but as soon as i decrease the number of datapoints in the query for performance reasons then some of the points fall outside the route. And that’s what i don’t understand.

1 Like

Try it out without th3 extra calculation and see what grafana does with it

If you want to reduce your data maybe look at using max() with

GROUP BY time(12m)

Mean is average which to me does not make sense for long lat and then on top of thwt youvhave floor though might be something grafana gives you out of the box

I don’t know a lot about using geo locations.

however, when I saw your query hade the same thoughts as @yosiasz (maybe you are doing some aggregations that are transforming your data in the wrong way)

Again, not my field of expertise but your query looks a little bit too complicated to me, (I use InfluxDB a lot but never used InfluxQL), I do everything with flux, and I remember seeing a geo package:

Experimental geo package | Flux 0.x Documentation (influxdata.com)

maybe will be easier to use flux and the pre-built geo functions?. just a thought

2 Likes

exactly @fercasjr mean might change your long lat values and you do not want that unless it changes it slightly.
max does not calculate it. it just gives you highest value.

Thanks @yosiasz @fercasjr i replaced aggregation mean() by max() and now i get a fluid route.
For me the issue issolved.

1 Like

Cool. After Monday, maybe look into upgrading influx to use flux query language instead of inflixql :call_me_hand::call_me_hand::call_me_hand: