It going to feed the Internet of Things donchaknow...
I was playing around with graphing barometric pressure over time, which was kind of interesting.
Perhaps RPM or windspeed vs boatspeed over time to let you know when you really need a scrub?
An automated log book?
Contributing to Teamsurv surveys?
Might be you who has the wrong forum, try this one..
<really pedantic> I was quoting George Mallory!</really pedantic>
Yep, and the good news from a newbie php coder is some php/html code which works letting you pick and choose what you want to look at and start/end times of the graph.
from bokeh.plotting import figure, output_file, showimport sqlite3
import pandas as pd
from bokeh.io import output_notebook
import numpy as np
from bokeh.models import ColumnDataSource, CheckboxGroup, RadioGroup, Toggle
from bokeh.layouts import row
conn = sqlite3.connect('boatdata.db')
df = pd.read_sql_query("select timestamp , eng from engine;", conn, parse_dates=['timestamp'])
df2 = pd.read_sql_query("select timestamp , SOG from navdata;", conn, parse_dates=['timestamp'])
df3 = pd.read_sql_query("select timestamp , main_batt / 1000 from LX;", conn, parse_dates=['timestamp'])
source = ColumnDataSource(df)
source1 = ColumnDataSource(df2)
source2 = ColumnDataSource(df3)
# output to static HTML file
output_file("lines.html")
# create a new plot with a title and axis labels
p = figure(title="Boat Database", x_axis_label='Time',plot_width=1200,
plot_height=600, tools="pan, wheel_zoom, box_zoom,hover, reset", x_axis_type='datetime')
# add a line renderer with legend and line thickness
p.line(x='timestamp', y='SOG', legend="Speed", source=source1, line_width=2, visible = False, color='red')
p.line(x='timestamp', y='main_batt / 1000', legend="Battery Voltage", source=source2, line_width=2, color='blue')
p.line(x='timestamp', y='eng', legend="Engine Temperature", source=source, line_width=2, visible = False, color='blue')
# show the results
p.legend.click_policy="hide"
show(p)What are you going to use all that data for?
