Let me clarify something: the WU wants the total rain that fell in the last hour. So, obvious archive fields such as rain, or rainRate, are not used. Instead, WeeWX calculates the total rain over the last 60 minutes for every post, using the archive table. The daily summaries are not involved at all.
Two suggestions: 1. Do a similar sqlite query, but this time against the table 'archive'. See if those values are non-zero. 2. Another thing you can do is set debug=2. This will cause WeeWX to log the exact URL that is being sent to the WU. See if it fits your expectations. -tk On Fri, Apr 12, 2019 at 12:28 PM Leon Shaner <[email protected]> wrote: > Hi, hi. > > For unknown reasons, Wunderground isn't showing any rain-data for my > KMIDEARB5 station. > > I used sqlite3 to query the weewx.sdb, to confirm that there is rain and > rainRate data and there is. > But what's interesting is that there are positive rainRate values for > today, but in the rain data it shows values of 0.0, everywhere except count > (which presumably is the number of times weewx reported the 0.0 values, > today). > > The WMR300A console itself does show 0.09" of rain today. > > *Is it just that the amount of rain today was too minuscule to register?* > > WU *seems* to be looking at the data corresponding to the > archive_day_rain, in the first table weewx table, further down in this > e-mail, and if the numbers there are 0, it *seems* to ignore the rain > rate. > > For example if I go back to 2016-07-12, there is data showing on the WU > side for both precip accumulation and precip rate : > > > https://www.wunderground.com/dashboard/pws/KMIDEARB5/graph/2016-07-12/2016-07-12/daily > > Above is for reference. > > *Really just asking about the last row of data from today, and why does WU > not show any rain? * > > > https://www.wunderground.com/dashboard/pws/KMIDEARB5/table/2019-04-12/2019-04-12/daily > > NOTE: The below is all the data I have, locally in WeeWX, which is > because I didn't realize that sending a "kill -HUP {weewxd_pid}" to make > the debug = 1 setting take effect would abort the initial ingestion of > archive data from the WMR300A unit. :S > > pi@nixie:/var/lib/weewx $ sqlite3 -header weewx.sdb "select > date(dateTime, 'unixepoch', 'localtime') as day, min, datetime(mintime, > 'unixepoch', 'localtime') as mintime, max, datetime(maxtime, 'unixepoch', > 'localtime') as maxtime, sum, count, wsum, sumtime from archive_day_rain;" > *day* *min* *mintime* *max* *maxtime* *sum* *count* *wsum* *sumtime* > 2012-01-01 0.0 2012-01-01 12:01:00 0.0 2012-01-01 12:01:00 0.0 189 0.0 > 11340 > 2014-09-10 0.0 2014-09-10 09:39:00 0.0 2014-09-10 09:39:00 0.0 325 0.0 > 84938280 > 2016-07-01 0.0 2016-07-01 17:51:00 0.0 2016-07-01 17:51:00 0.0 369 0.0 > 141994320 > 2016-07-02 0.0 2016-07-02 00:01:00 0.0 2016-07-02 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-03 0.0 2016-07-03 00:01:00 0.0 2016-07-03 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-04 0.0 2016-07-04 00:01:00 0.0 2016-07-04 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-05 0.0 2016-07-05 00:01:00 0.0 2016-07-05 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-06 0.0 2016-07-06 00:01:00 0.0 2016-07-06 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-07 0.0 2016-07-07 00:01:00 0.0 2016-07-07 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-08 0.0 2016-07-08 00:01:00 0.04 2016-07-08 00:29:00 0.41 1440 24.6 > 86400 > 2016-07-09 0.0 2016-07-09 00:01:00 0.0 2016-07-09 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-10 0.0 2016-07-10 00:01:00 0.0 2016-07-10 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-11 0.0 2016-07-11 00:01:00 0.0 2016-07-11 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-12 0.0 2016-07-12 00:01:00 0.0100000000000001 2016-07-12 22:04:00 > 0.0500000000000001 1440 3.0 86400 > 2016-07-13 0.0 2016-07-13 00:01:00 0.02 2016-07-13 20:01:00 > 0.0399999999999999 1440 2.4 86400 > 2016-07-14 0.0 2016-07-14 00:01:00 0.0 2016-07-14 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-15 0.0 2016-07-15 00:01:00 0.0 2016-07-15 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-16 0.0 2016-07-16 00:01:00 0.0 2016-07-16 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-17 0.0 2016-07-17 00:01:00 0.0 2016-07-17 00:01:00 0.0 55 0.0 3300 > 2018-12-31 0.0 2018-12-31 06:00:00 0.0 2018-12-31 06:00:00 0.0 17 0.0 > 220817760 > 2019-04-10 0.0 2019-04-10 14:08:20 0.0 2019-04-10 14:08:20 0.0 105 0.0 > 31500 > 2019-04-11 0.0 2019-04-11 00:00:01 0.0 2019-04-11 00:00:01 0.0 288 0.0 > 86400 > 2019-04-12 0.0 2019-04-12 00:00:01 0.0 2019-04-12 00:00:01 0.0 173 0.0 > 51900 > pi@nixie:/var/lib/weewx $ sqlite3 -header weewx.sdb "select > date(dateTime, 'unixepoch', 'localtime') as day, min, datetime(mintime, > 'unixepoch', 'localtime') as mintime, max, datetime(maxtime, 'unixepoch', > 'localtime') as maxtime, sum, count, wsum, sumtime from > archive_day_rainRate;" > *day* *min* *mintime* *max* *maxtime* *sum* *count* *wsum* *sumtime* > 2012-01-01 > > > > 0.0 0 0.0 0 > 2014-09-10 > > > > 0.0 0 0.0 0 > 2016-07-01 0.0 2016-07-01 18:08:00 0.0 2016-07-01 18:08:00 0.0 353 0.0 > 21180 > 2016-07-02 0.0 2016-07-02 00:01:00 0.0 2016-07-02 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-03 0.0 2016-07-03 00:01:00 0.0 2016-07-03 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-04 0.0 2016-07-04 00:01:00 0.0 2016-07-04 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-05 0.0 2016-07-05 00:01:00 0.0 2016-07-05 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-06 0.0 2016-07-06 00:01:00 0.0 2016-07-06 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-07 0.0 2016-07-07 00:01:00 0.0 2016-07-07 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-08 0.0 2016-07-08 00:01:00 2.7199999972256 2016-07-08 19:23:00 > 28.6199999708076 1440 1717.19999824846 86400 > 2016-07-09 0.0 2016-07-09 00:01:00 0.0 2016-07-09 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-10 0.0 2016-07-10 00:01:00 0.0 2016-07-10 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-11 0.0 2016-07-11 00:01:00 0.0 2016-07-11 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-12 0.0 2016-07-12 00:01:00 0.6599999993268 2016-07-12 22:06:00 > 5.09999999479799 1440 305.99999968788 86400 > 2016-07-13 0.0 2016-07-13 00:01:00 0.5399999994492 2016-07-13 20:05:00 > 3.4899999964402 1440 209.399999786412 86400 > 2016-07-14 0.0 2016-07-14 00:01:00 0.0 2016-07-14 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-15 0.0 2016-07-15 00:01:00 0.0 2016-07-15 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-16 0.0 2016-07-16 00:01:00 0.0 2016-07-16 00:01:00 0.0 1440 0.0 > 86400 > 2016-07-17 0.0 2016-07-17 00:01:00 0.0 2016-07-17 00:01:00 0.0 55 0.0 3300 > 2018-12-31 > > > > 0.0 0 0.0 0 > 2019-04-10 0.0 2019-04-10 14:08:19 0.0 2019-04-10 14:08:19 0.0 105 0.0 > 31500 > 2019-04-11 0.0 2019-04-11 00:00:01 0.0 2019-04-11 00:00:01 0.0 288 0.0 > 86400 > 2019-04-12 0.0 2019-04-12 00:00:01 0.4199999995716 2019-04-12 08:46:14 > 1.40269840736274 173 420.809522208823 51900 > > > Regards, > \Leon > -- > Leon Shaner :: Dearborn, Michigan (iPad Pro) > > -- [email protected] - Dearborn, Michigan > > -- > 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. > -- 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.
