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.
Speed in the database is always in knots.
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:
Why is speed not same?
time is too diferent.