Mysql database vs report

misosz7 years ago

Hi, how is it?
In mysql i have this:

<table name="positions">
<column name="id">1698</column>
<column name="protocol">tk103</column>
<column name="deviceid">1</column>
<column name="servertime">2018-01-25 05:08:55</column>
<column name="devicetime">2018-01-25 05:08:53</column>
<column name="fixtime">2018-01-25 05:08:53</column>
<column name="valid">1</column>
<column name="latitude">48.091386666666665</column>
<column name="longitude">18.192381666666666</column>
<column name="altitude">0</column>
<column name="speed">11.0691</column>
<column name="course">67.85</column>
<column name="address">7-11 Kútiky, Šurany, Nitriansky kraj, SK</column>
<column name="attributes"
{"charge":true,"ignition":false,"in2":0,"panic":0,"out2":0,"fuel":0,"distance":68.18,"totalDistance":8.074338829E7,"motion":true}
</column>
<column name="accuracy">0</column>
<column name="network">null</column>

in report i have this:

Peugeot 508
Áno
2018-01-25 06:08:53
48.091387°
18.192382°
0
20.5 Km/h
7-11 Kútiky, Šurany, Nitriansky kraj, S

Why is speed not same?
time is too diferent.

Anton Tananaev7 years ago

Speed in the database is always in knots.

misosz7 years ago

Thank you.