You can't look for rain where rainRate is non-zero, because the latter is only loosely connected to the former. Instead, do a simple query for rain:
select datetime(dateTime,'unixepoch','localtime'), rain, rainRate from archive where date(dateTime,'unixepoch','localtime')="2019-04-12"; See if any of those are non-zero. -tk On Sat, Apr 13, 2019 at 7:18 AM Leon Shaner <l...@isylum.org> wrote: > Hey, TK, > > Thanks for the pointers. I didn't know about the archive table and it > wasn't obvious, just grepping for rain in the .dump output. > > Do you know if there is a difference in the way that "real time" data is > read from the WMR300A vs. reading the historical data? > > I wonder if the "bug" is in reading the "real time" data... Could be a > WMR300A bug, because one reason I have been exploring different software > options is because no software I have tried has worked for reporting the > rain data. :-( > > So, by inspecting the "archive" table in weewx.sdb, it is proven that > WeeWX didn't extract any rain on 2019-4-12; only the rainRate has a > non-zero value. > > pi@nixie:/var/lib/weewx $ sqlite3 -header weewx.sdb "select > date(dateTime, 'unixepoch', 'localtime') as day, rain, rainRate from > archive where rainRate != 0.0" | tail -20 > 2016-07-13|0.0|0.0899999999082 > 2016-07-13|0.0|0.0799999999184 > 2016-07-13|0.0|0.0799999999184 > 2016-07-13|0.0|0.0699999999286 > 2016-07-13|0.0|0.0699999999286 > 2016-07-13|0.0|0.0599999999388 > 2019-04-12|0.0|0.044692737384581 > 2019-04-12|0.0|0.314333333012714 > 2019-04-12|0.0|0.183352600969049 > 2019-04-12|0.0|0.131173184223745 > 2019-04-12|0.0|0.0929999999051399 > 2019-04-12|0.0|0.0899999999081999 > 2019-04-12|0.0|0.102011173080306 > 2019-04-12|0.0|0.092914285619513 > 2019-04-12|0.0|0.0669696969013877 > 2019-04-12|0.0|0.0599999999387998 > 2019-04-12|0.0|0.0599999999387998 > 2019-04-12|0.0|0.0599999999387998 > 2019-04-12|0.0|0.0589999999398198 > 2019-04-12|0.0|0.0452513966018882 > > > It isn't as if reading the rain from the WMR300A is completely broken, > because there is some data there from before the initial ingest got aborted: > > pi@nixie:/var/lib/weewx $ sqlite3 -header weewx.sdb "select > date(dateTime, 'unixepoch', 'localtime') as day, rain, rainRate from > archive where rain != 0.0" > day|rain|rainRate > 2016-07-08|0.01|0.0 > 2016-07-08|0.01|0.1199999998776 > 2016-07-08|0.01|0.0899999999082 > 2016-07-08|0.01|0.5099999994798 > 2016-07-08|0.02|1.0699999989086 > 2016-07-08|0.04|1.8299999981334 > 2016-07-08|0.01|0.8199999991636 > 2016-07-08|0.01|0.6199999993676 > 2016-07-08|0.01|0.199999999796 > 2016-07-08|0.01|0.0 > 2016-07-08|0.01|0.1199999998776 > 2016-07-08|0.01|0.149999999847 > 2016-07-08|0.00999999999999998|0.1699999998266 > 2016-07-08|0.01|0.2099999997858 > 2016-07-08|0.01|0.2399999997552 > 2016-07-08|0.00999999999999998|0.2099999997858 > 2016-07-08|0.00999999999999998|0.099999999898 > 2016-07-08|0.01|0.0799999999184 > 2016-07-08|0.01|0.0599999999388 > 2016-07-08|0.00999999999999998|0.0 > 2016-07-08|0.00999999999999998|0.0 > 2016-07-08|0.03|1.4299999985414 > 2016-07-08|0.03|2.7199999972256 > 2016-07-08|0.02|1.5399999984292 > 2016-07-08|0.02|0.8899999990922 > 2016-07-08|0.03|1.4699999985006 > 2016-07-08|0.00999999999999998|0.9099999990718 > 2016-07-08|0.00999999999999998|0.449999999541 > 2016-07-08|0.00999999999999998|0.6099999993778 > 2016-07-12|0.00999999999999998|0.0 > 2016-07-12|0.0100000000000001|0.4899999995002 > 2016-07-12|0.00999999999999998|0.5099999994798 > 2016-07-12|0.00999999999999998|0.6599999993268 > 2016-07-12|0.0100000000000001|0.0799999999184 > 2016-07-13|0.02|0.0 > 2016-07-13|0.00999999999999998|0.2799999997144 > 2016-07-13|0.00999999999999998|0.5399999994492 > > Regards, > Leon > -- > Leon Shaner :: Dearborn, Michigan (iPad Pro) > > On Apr 12, 2019, at 8:43 PM, Thomas Keffer <tkef...@gmail.com> wrote: > > 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 <l...@isylum.org> 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) >> >> -- l...@isylum.org - 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 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. > > -- > 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. > -- 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.
