mysql database queries rxCheckPercent

[Kevin Kruzich]

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

[gjr80]

Hi,

The data in the rxCheckPercent field in table archive is probably what you are after, archive holds the per archive period data. The archive_day_rxCheckPercent table holds daily summaries of the rxCheckPercent data; the daily summaries are an optimization to speed up longer term aggregates (eg day, week, month, year etc). What you will see in there is one row per day with sums, counts, max, min and respective times. To access data in the archive table try a query like:

mysql> SELECT dateTime,rxCheckPercent FROM archive ORDER BY dateTime DESC LIMIT 20;

to view the last 20 rxCheckPercent archive entries and their associated time.

As for how you want to get the data that probably depends on what you want to do with it. Having another app query the database via mysql will work, weeWX could produce a report (tabulated, freeform,CSV etc) every archive period or weeWX could produce a file (again tabulated, freeform, CSV etc) every loop period. You could also post the data to a web server via HTTP GET/POST etc. The mysql query approach may suit but requires intimate knoweldge of the weeWX db schema, reports are dead easy to do and very capable but somewhat limited in when they can be produced, loop based output will require some python programming to get/format/output your data but can generate output far more frequently. HTTP POST/GET requires python programming and knowledge of HTTP POST/GET.

Gary

[kkruzich]

Thank you very much Gary! This is exactly what I was hunting for.

Much appreciated,

-kkruzich

--
You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/-K68VOjvGg4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.