I'm pulling some of the data generated by weewx into other mechanisms for
analysis. One of the items I'd like to extract is Signal Quality
(rxCheckPercent). This seems to be available only by a mysql query. I'm
having a bit of trouble getting past the first steps in navigating. If you
have suggestions on 1) how to build this query or 2) a better means of
extracting the data altogether I'd be quite grateful.
What I have so far is this:
mysql> select * from archive_day_rxCheckPercent;
+------------+------------------+------------+------+------------+------------------+-------+------------------+---------+
| dateTime | min | mintime | max | maxtime | sum
| count | wsum | sumtime |
+------------+------------------+------------+------+------------+------------------+-------+------------------+---------+
| 1495263600 | 100 | 1495347200 | 100 | 1495347200 |
1000 | 10 | 300000 | 3000 |
| 1495350000 | 0 | 1495390389 | 100 | 1495350013 |
28634.5588235294 | 288 | 8590367.64705883 | 86400 |
| 1495436400 | 0 | 1495515729 | 100 | 1495436416 |
28698.4068627452 | 288 | 8609522.05882352 | 86400 |
| 1495522800 | 0 | 1495529381 | 100 | 1495522817 |
26965.073529412 | 288 | 8089522.05882352 | 86400 |
| 1495609200 | 0 | 1495647847 | 100 | 1495609214 |
28686.7647058824 | 288 | 8606029.41176471 | 86400 |
| 1495695600 | 0 | 1495745037 | 100 | 1495695604 |
27813.9705882352 | 282 | 8344191.17647059 | 84600 |
[...]
How can I determine what the signal strength (0-100%) is at a given time?
Cheers,
-kkruzich
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
