Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- mycar:software:db [2019/03/07 08:51] – angelegt admin
+++ mycar:software:db [2019/03/30 22:37] (aktuell) – added table for trackid and gps admin
@@ Zeile 5: / Zeile 5: @@
 ====== schema ======
 {{ :mycar:software:obdgpslogger-schema.png |}}
+As you can see here, there are no direct conections between the tables. Its quite flat. Therfor the logi is in the application (somehow).
+===== Tables =====
+<flow>
+graph TD;
+ obd.time-->trip;
+ gps.time-->trip;
+</flow>
+==== trip ====
+^ Spalte   ^ Beschreibung ^ unit ^
+| tripid | incremented trip number | integer |
+| start | start time | unknown timestamp |
+| end | end time | unknown timestamp |
+==== obd ====
+^ Spalte   ^ Beschreibung ^ unit ^
+| load_pct | Calculated LOAD Value | % |
+| temp | Engine Coolant Temperature | Celsius |
+| rpm | Engine RPM | rev/min (rpm)|
+| vss | vehicle speed sensor | km/h |
+| iat | Intake Air Temperature | Celsius |
+| maf | mass air flow sensor | g/s |
+| throttlepos | Absolute Throttle Position | % |
+| time | Tiem of dataset | unknown timestamp |
+==== gps ====
+^ Spalte   ^ Beschreibung ^ unit ^
+| lat | Latitude |
+| lon | Longitude |
+| alt | Altitude | hight of device |
+| time | Tiem of dataset | unknown timestamp |
+====== SQL Statements ======
+<sxh sql>
+select * FROM obd LEFT JOIN gps ON obd.time=gps.time LEFT JOIN trip ON obd.time>trip.start AND obd.time<trip.end
+</sxh>

× iphelper toolbox

you see this when javscript or css is not working correct

Untested

Input