Daily Trip Logs
We're beginning our Pacific crossing in a few days and I'm looking for an easy and automatic way to provide daily reports.
Specifically, I would like to do noon to noon reports that list position, log, average speed, max speed, average wind speed, max wind speed.
What are some options to do this?
12 Replies
well, for the min/max/average over a certain period influxdb would be my go to tool. you are able to query at will those for periods you want
as for capturing that data outside influx I'd imagine automated/assisted/manual log entry creation in signalk-logbook would be the ticket, but i don't think that functionality is there yet
- automated: capture aggregate values on a configured sheduled and create entries
- assisted: support retrieving the values from db in the log entry ui, but create the entry manually
- manual: you do the work
the current History API implementation is for use via http, but I think exposing it to other plugins would make also sense (for the automated use case)
oh forgot to ping @Lille Ø
then there's postgsail, but @xbgmsharp can fill in details there
Signalk-triplogger does store the daily distance, but it is (UTC) midnight to midnight instead of noon. Those stats could also be interesting to produce.
The noon-to-noon thing is traditional, but obviously an artefact of the sextant era (yes, we still carry a sextant and tables on board). Not sure if I should add support for that. Then question is, would it only be noon-to-noon for daily stats, or also monthly?
Maybe the right way to do this would be to have a way for users to reset the "current trip" so you can do it at arbitrary intervals. Now it's automatically done from when autostate determines vessel to be under way to when autostate determines vessel to be stopped.
Also if you have opencpn running all the time it can record daily tracks, so it starts a new track at a specific time each day. That woud give you lat/long, ave speed & distance run. Plus the opencpn logbook plugin has a lot of options for min/max wind etc
postgsail don't noon to noon reports even so it could be possible. It does provide automatic details information about your trip. https://xbgmsharp.github.io/postgsail/
Cool, lots of options to work on before we cast off. Thank you!
Influxdb/grafana looks like it's the easiest to put together. I'm struggling with the daily log. Our B&G system sends out the log but it's through the water and I would rather use GPS. Do you know if there's a way to get a log based on the GPS?
Signalk-triplogger uses GPS for producing the log reading
History API (as implemented by signalk-to-influxdb2) could provide distance-log-based-on-position-history, this would allow showing it in Grafana and retrieving it at will for the chosen duration
I'll look at that plugin. I'm still using influxdb1 because I don't want to rebuild all my grafana pages.
this is the use case for tinkering with the Grafana Signal K History API datasource: so that Grafana does not use any particular database's query lanaguage and idiosyncracies, but operates on SK concepts, primarily
path. But I have yet to discover others besides myself who'd be interested in this idea....one effect is that you would not need to redo your Grafana dashboads when you switch from one db to another, provided that somebody's implemented History API for that db
Triplogger has some strange entries in Influx so I haven't been able to figure out how to use the data yet.
The trip.log entries will be 48 (meters?) every six hours then it'll place an entry of 8462558 (for example) for one of the hours.
Perhaps this will be enough:
https://www.npmjs.com/package/naivegpxlogger
postgsail use GPS for producing the log and the auto-state plugin to detect movement. GPX and others format can be export simply. An API is available.