Thank you very much Gary! This is exactly what I was hunting for.
Much appreciated,
-kkruzich
On 2/11/18 8:25 PM, gjr80 wrote:
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
On Monday, 12 February 2018 14:07:59 UTC+10, Kevin Kruzich wrote:
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*fromarchive_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 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+unsubscr...@googlegroups.com
<mailto:weewx-user+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
