Benutzer-Werkzeuge

Webseiten-Werkzeuge


mycar:software:db

abstract

The obdgpslogger uses a sqlite database to store its recorded data. The schema is quite undocumented. I try to do this here on my own.

schema

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

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

select * FROM obd LEFT JOIN gps ON obd.time=gps.time LEFT JOIN trip ON obd.time>trip.start AND obd.time<trip.end

× iphelper toolbox

you see this when javscript or css is not working correct

Untested
IP Address:
First usable:
Subnet:
Last usable:
CIDR:
Amount of usable:
Network address:
Reverse address:
Broadcast address:

mycar/software/db.txt · Zuletzt geändert: 2019/03/30 23:37 von admin