Nice to have: horizontal speed plot in Grafana

[zanco]

During a summerstorm PD3EGE launched an 4fsk tracker. It would be really nice to re-view the horizontal speed in Grafana too.

https://grafana.v2.sondehub.org/d/HJgOZLq7k/basic?var-Payload=PD3EGE&from=1688545183000&to=now&orgId=1&refresh=1m

Thanks,

[TheSkorm]

This is one of those things that sounds really simple to do but is actually quite hard in Grafana. I actually spent most of tonight looking at different approaches to doing this and I couldn't find anything suitable yet.

The two closest solutions I have is:

• developing an API that queries sondehub db and calculates the horizontal speed that can then be loaded into grafana
• using something like echarts https://volkovlabs.io/plugins/volkovlabs-echarts-panel/options/ to create a custom chart / data processing for it

I'm leaning towards the echarts approach as it may be useful for other charts that require complex processing.

For now the only work around I can offer is download the data in json format and using some other tool to calculate it.

[zanco]

Hi Michaela , sorry to hear that this question takes so (maybe to) much time. Indeed it sounded really simple because the horizontal speed is allready shown in the sondehub.amateur map, so my thoughts where it was as easy as grabbing it from there.

Caclulating from json export is still a possibility which would be appreciated !

Thanks,
Ben

[darksidelemm]

As a way to get a little bit closer to this, at least for some payloads, I've updated Horus-GUI (in v0.3.12), and HorusDemodLib (v0.3.11) to upload the speed information which is present in Horus Binary v2 payload telemetry. Note that the speed indication in Horus v2 is in km/hr, and will wrap at 256 km/hr!

Users will need to update to the latest versions of these apps for this to be uploaded and be available for use on dashboards.
For Horus-GUI, just grab the latest release at https://github.com/projecthorus/horus-gui/releases/tag/v0.3.12

For horusdemodlib, you will need to update the python package with something like:

pip3 install -U horusdemodlib

Depending on your installation this might need to be run within a virtualenv.

Hopefully we can get echarts going as well, as this will let us do speed and maybe other calculations for payloads that don't report this information in telemetry.

[zanco]

It was nice to see that round 08:00 UTC the first stations updated their software :-)

[TheSkorm]

I've added an experimental eCharts widget that tries to calculate speed. There's a few issues though however.

• The data seems to end up with spikes in it - not sure why this happens - it seems to be related to intervals and at some zoom levels / intervals it doesn't happen.
• Since it's not a grafana graph the cross hairs don't map across, also the data extents are aligned to what data is available rather that the requests area (this might be easy to fix , I haven't checked)
• The timezone is always going to be based on browser time due to Possibility to set specific timezone for time axis apache/echarts#14453

[TheSkorm]

the time range wasn't too hard to fix, though I'm not sure how hacky it is.

[TheSkorm]

I set the lookback from one day point to 10 to give it more distance and time delta. It's little fuzzy but it's probably "good enough" There was this problem where the speed shot off to a large number. Not entirely sure why given that we filter for sats == 0

For now I've set it to discard anything greater than 1000.

[zanco]

Thanks again, yesterday evening PD3EGE had an 4fsk flight, and this morning he talked to me about the excessive speeds het noted yesterday evening for his payload, and the big bumps ;-) I asked him to show me what he meant and all his problems where allready solved by the developer(s) :-)

We might go for a little bit less figures behind the digit ?

[darksidelemm]

That's what we get for testing this stuff on a 'production' dashboard :-P

[TheSkorm]

Only thing that still needs to be fixed is the timezone issue, however this is waiting for upstream fix. Closing for now.