Wrong conversion rainRate?

162 views
Skip to first unread message

Luis

unread,
Nov 21, 2021, 10:03:38 AM11/21/21
to weewx-user
Hi all,
I am running a WeeWx server connected to a Vantage Vue station.
The max rain rate is systematically wrong.
It always shows 13107.0 mm/hr which is impossible.
Today's max rain rate reported by the Vantage Vue console is 25.6 mm/hr
Is there an issue with the conversion from inches to mm and with the decimal separator (comma vs dot)?
Thanks
Luis

Tom Keffer

unread,
Nov 21, 2021, 4:43:45 PM11/21/21
to weewx-user
Two things to check:

1. Are you using hardware record generation? This is the default. Look for option "record_generation" in the stanza [StdArchive].

2. Did you change any values under [StdWXCalculate]? In particular, make sure the setting for 'rainRate' is "prefer_hardware":

[StdWXCalculate]
    [[Calculations]]
        ...
        rainRate = prefer_hardware
    
Assuming both of these are true, the value you are seeing is coming straight from the logger in your Vantage Vue. 

-tk

--
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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/a44a3e2e-7557-48b6-8c5a-a3a7d1607d26n%40googlegroups.com.

Luis

unread,
Feb 23, 2022, 2:02:25 PM2/23/22
to weewx-user
All is set to prefer_hardware.
But then I can't understand why ALL THE REST of values are correct.
I moved to WEEWX from VWIEW after several years using wview and there was no problem at all.
So my data logger works well.
It's just the rain rate which is wrong.

Luis
veleta.png

Tom Keffer

unread,
Feb 23, 2022, 3:11:05 PM2/23/22
to weewx-user
That's certainly an unlikely number.

Are you seeing this all the time? Or, just when it's raining? 

In weewx.conf, set debug = 2, then restart weewxd. Please post the log from startup through the first reporting cycle.

-tk



Luis

unread,
Feb 24, 2022, 9:36:02 AM2/24/22
to weewx-user
Hi Tom,
I have followed your command on https://www.mail-archive.com/weewx...@googlegroups.com/msg33396.html and the result is the following:

$ sqlite3 /var/lib/weewx/weewx.sdb    
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> select
  ...> dateTime,datetime(dateTime,'unixepoch','localtime'),rain,rainRate from
  ...> archive where rainRate>0 order by dateTime desc limit 50;
1641570900|2022-01-07 16:55:00|0.0|0.0393700785
1641570600|2022-01-07 16:50:00|0.0|0.0629921256
1641570300|2022-01-07 16:45:00|0.0157480314|1.4803149516
1641476700|2022-01-06 14:45:00|0.0|0.0314960628
1641476400|2022-01-06 14:40:00|0.0|0.0393700785
1641476100|2022-01-06 14:35:00|0.0|0.078740157
1641475800|2022-01-06 14:30:00|0.0078740157|0.157480314
1641475500|2022-01-06 14:25:00|0.0157480314|0.4409448792
1641475200|2022-01-06 14:20:00|0.0314960628|2.6220472281
1641430800|2022-01-06 02:00:00|0.0|0.0314960628
1641430500|2022-01-06 01:55:00|0.0|0.0551181099
1641430200|2022-01-06 01:50:00|0.0078740157|0.1181102355
1641429900|2022-01-06 01:45:00|0.0078740157|0.0551181099
1641429600|2022-01-06 01:40:00|0.0|0.0551181099
1641429300|2022-01-06 01:35:00|0.0157480314|0.2519685024
1641429000|2022-01-06 01:30:00|0.0078740157|0.2283464553
1641428700|2022-01-06 01:25:00|0.0157480314|0.2283464553
1641428400|2022-01-06 01:20:00|0.0078740157|0.0944881884
1641428100|2022-01-06 01:15:00|0.0078740157|0.1811023611
1641427800|2022-01-06 01:10:00|0.0078740157|0.1653543297
1641427500|2022-01-06 01:05:00|0.0078740157|0.078740157
1641427200|2022-01-06 01:00:00|0.0078740157|0.078740157
1641426900|2022-01-06 00:55:00|0.0|0.078740157
1641426600|2022-01-06 00:50:00|0.0078740157|0.1181102355
1641426300|2022-01-06 00:45:00|0.0078740157|0.0944881884
1641426000|2022-01-06 00:40:00|0.0078740157|0.0629921256
1641308400|2022-01-04 16:00:00|0.0|0.0314960628
1641308100|2022-01-04 15:55:00|0.0|0.0472440942
1641307800|2022-01-04 15:50:00|0.0078740157|0.0551181099
1641307500|2022-01-04 15:45:00|0.0|0.0551181099
1641307200|2022-01-04 15:40:00|0.0236220471|1.6771653441
1641306900|2022-01-04 15:35:00|0.0551181099|2.3779527414
1640620500|2021-12-27 16:55:00|0.0|0.0314960628
1640620200|2021-12-27 16:50:00|0.0|0.0314960628
1640619900|2021-12-27 16:45:00|0.0|0.0314960628
1640619600|2021-12-27 16:40:00|0.0078740157|0.0314960628
1640616300|2021-12-27 15:45:00|0.0|0.0314960628
1640616000|2021-12-27 15:40:00|0.0|0.0393700785
1640615700|2021-12-27 15:35:00|0.0|0.0393700785
1640615400|2021-12-27 15:30:00|0.0078740157|0.0393700785
1640611500|2021-12-27 14:25:00|0.0|0.0314960628
1640611200|2021-12-27 14:20:00|0.0|0.0472440942
1640610900|2021-12-27 14:15:00|0.0078740157|0.0551181099
1640610600|2021-12-27 14:10:00|0.0|0.0551181099
1640610300|2021-12-27 14:05:00|0.0078740157|0.236220471
1640605200|2021-12-27 12:40:00|0.0|0.0314960628
1640604900|2021-12-27 12:35:00|0.0|0.0472440942
1640604600|2021-12-27 12:30:00|0.0078740157|0.2677165338
1640604300|2021-12-27 12:25:00|0.0157480314|0.2283464553
1640547900|2021-12-26 20:45:00|0.0|0.0314960628


As you can see the database contains normal, acceptable values.
I wonder how the html displayed values are computed/retrieved...
Message has been deleted

Tom Keffer

unread,
Feb 24, 2022, 11:06:55 AM2/24/22
to weewx-user
It looks like the log has been filtered to show only debug statements. Please post the full log. I need to see version numbers, conversion targets, etc.

It's nice to know that the database generally has reasonable rainRate values, but the bad value you showed in veleta.png is the highest value seen during some unknown day. I don't know which day because you didn't show the full plot. What does the database show for that day? If you hover a mouse over the value, it will show you the time of that max value. That's what we need from the database.

-tk


On Thu, Feb 24, 2022 at 7:01 AM Luis <luis....@gmail.com> wrote:
Now the debug log file (I think this is the one you refer to)

Luis

unread,
Feb 24, 2022, 11:57:09 AM2/24/22
to weewx-user
The day archive contains lot of data with rain rate 516.0236188995
Supposing this value is in inch/hour and you convert it to mm/hour you get the value showed on my webpage ~13107

Luis

unread,
Feb 24, 2022, 11:59:15 AM2/24/22
to weewx-user
I can't my previous question about the log. I have sent the one I thought was produced by weewx with the debug option.
Which one is the "full log"?


On Thursday, February 24, 2022 at 5:06:55 PM UTC+1 tke...@gmail.com wrote:

Tom Keffer

unread,
Feb 24, 2022, 12:17:47 PM2/24/22
to weewx-user
I'm not sure what "contains a lot of data" means. Could you be more specific? Many days? Just one? Is it in the archive table as well as the daily summaries? We need to know if this is a one-time thing, or a chronic issue. It would be helpful to see the main archive table. Assuming your database is using US units (the default), then perhaps a query like this:

SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), usUnits, rain, rainRate FROM archive WHERE rainRate > 100.0 LIMIT 100;

If the database does contain bad data, then it is a source problem, not a reporting problem.

I can't tell you where your log is, because you haven't said what kind of operating system you are running on. See Where to find things for likely locations.

Luis

unread,
Feb 24, 2022, 1:30:14 PM2/24/22
to weewx-user
You are right. I gave no detailed information:

Vantage Vue
Raspberry Pi + Raspbian Buster

Your query gives no records with rainRate > 100 (and no errors)

sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), usUnits, rain, rainRate FROM archive WHERE rainRate > 100.0 LIMIT 100;
sqlite>


But I executed that query for the archive_day_rainRate table and you can see that impossible rainRate value:

sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), max FROM archive_day_rainRate WHERE max > 100.0 LIMIT 100;
1588975200|2020-05-09 00:00:00|516.0236188995
1589148000|2020-05-11 00:00:00|516.0236188995
1589234400|2020-05-12 00:00:00|516.0236188995
1589320800|2020-05-13 00:00:00|516.0236188995
1589407200|2020-05-14 00:00:00|516.0236188995
1589493600|2020-05-15 00:00:00|516.0236188995
1589580000|2020-05-16 00:00:00|516.0236188995
1589752800|2020-05-18 00:00:00|516.0236188995
1589839200|2020-05-19 00:00:00|516.0236188995
1589925600|2020-05-20 00:00:00|516.0236188995
1590012000|2020-05-21 00:00:00|516.0236188995
1590098400|2020-05-22 00:00:00|516.0236188995
1590184800|2020-05-23 00:00:00|516.0236188995
1590357600|2020-05-25 00:00:00|516.0236188995
1590444000|2020-05-26 00:00:00|516.0236188995
1590530400|2020-05-27 00:00:00|516.0236188995
1590616800|2020-05-28 00:00:00|516.0236188995
1590703200|2020-05-29 00:00:00|516.0236188995
1590789600|2020-05-30 00:00:00|516.0236188995
1590876000|2020-05-31 00:00:00|516.0236188995
1590962400|2020-06-01 00:00:00|516.0236188995
1591048800|2020-06-02 00:00:00|516.0236188995
1592863200|2020-06-23 00:00:00|516.0236188995
1592949600|2020-06-24 00:00:00|516.0236188995
1594504800|2020-07-12 00:00:00|516.0236188995
1594591200|2020-07-13 00:00:00|516.0236188995
1594677600|2020-07-14 00:00:00|516.0236188995
1594764000|2020-07-15 00:00:00|516.0236188995
1594850400|2020-07-16 00:00:00|516.0236188995
1594936800|2020-07-17 00:00:00|516.0236188995
1595023200|2020-07-18 00:00:00|516.0236188995
1595109600|2020-07-19 00:00:00|516.0236188995
1595196000|2020-07-20 00:00:00|516.0236188995
1595282400|2020-07-21 00:00:00|516.0236188995
1595368800|2020-07-22 00:00:00|516.0236188995
1596232800|2020-08-01 00:00:00|516.0236188995
1596319200|2020-08-02 00:00:00|516.0236188995
1596405600|2020-08-03 00:00:00|516.0236188995
1596492000|2020-08-04 00:00:00|516.0236188995
1596578400|2020-08-05 00:00:00|516.0236188995
1596664800|2020-08-06 00:00:00|516.0236188995
1596751200|2020-08-07 00:00:00|516.0236188995
1596837600|2020-08-08 00:00:00|516.0236188995
1596924000|2020-08-09 00:00:00|516.0236188995
1597010400|2020-08-10 00:00:00|516.0236188995
1598306400|2020-08-25 00:00:00|516.0236188995
1598392800|2020-08-26 00:00:00|516.0236188995
1598479200|2020-08-27 00:00:00|516.0236188995
1598565600|2020-08-28 00:00:00|516.0236188995
1598652000|2020-08-29 00:00:00|516.0236188995
1598738400|2020-08-30 00:00:00|516.0236188995
1598997600|2020-09-02 00:00:00|516.0236188995
1599084000|2020-09-03 00:00:00|516.0236188995
1599170400|2020-09-04 00:00:00|516.0236188995
1599256800|2020-09-05 00:00:00|516.0236188995
1599343200|2020-09-06 00:00:00|516.0236188995
1599429600|2020-09-07 00:00:00|516.0236188995
1599516000|2020-09-08 00:00:00|516.0236188995
1599602400|2020-09-09 00:00:00|516.0236188995
1599688800|2020-09-10 00:00:00|516.0236188995
1599775200|2020-09-11 00:00:00|516.0236188995
1599861600|2020-09-12 00:00:00|516.0236188995
1599948000|2020-09-13 00:00:00|516.0236188995
1600034400|2020-09-14 00:00:00|516.0236188995
1600120800|2020-09-15 00:00:00|516.0236188995
1600207200|2020-09-16 00:00:00|516.0236188995
1600293600|2020-09-17 00:00:00|516.0236188995
1600380000|2020-09-18 00:00:00|516.0236188995
1600466400|2020-09-19 00:00:00|516.0236188995
1600552800|2020-09-20 00:00:00|516.0236188995
1600725600|2020-09-22 00:00:00|516.0236188995
1600812000|2020-09-23 00:00:00|516.0236188995
1600898400|2020-09-24 00:00:00|516.0236188995
1600984800|2020-09-25 00:00:00|516.0236188995
1601071200|2020-09-26 00:00:00|516.0236188995
1601157600|2020-09-27 00:00:00|516.0236188995
1601244000|2020-09-28 00:00:00|516.0236188995
1601330400|2020-09-29 00:00:00|516.0236188995
1601416800|2020-09-30 00:00:00|516.0236188995
1601503200|2020-10-01 00:00:00|516.0236188995
1601589600|2020-10-02 00:00:00|516.0236188995
1601676000|2020-10-03 00:00:00|516.0236188995
1601762400|2020-10-04 00:00:00|516.0236188995
1601848800|2020-10-05 00:00:00|516.0236188995
1601935200|2020-10-06 00:00:00|516.0236188995
1602021600|2020-10-07 00:00:00|516.0236188995
1602108000|2020-10-08 00:00:00|516.0236188995
1602194400|2020-10-09 00:00:00|516.0236188995
1602280800|2020-10-10 00:00:00|516.0236188995
1603058400|2020-10-19 00:00:00|516.0236188995
1603144800|2020-10-20 00:00:00|516.0236188995
1603231200|2020-10-21 00:00:00|516.0236188995
1603317600|2020-10-22 00:00:00|516.0236188995
1603404000|2020-10-23 00:00:00|516.0236188995
1603753200|2020-10-27 00:00:00|516.0236188995
1603839600|2020-10-28 00:00:00|516.0236188995
1603926000|2020-10-29 00:00:00|516.0236188995
1604012400|2020-10-30 00:00:00|516.0236188995
1604098800|2020-10-31 00:00:00|516.0236188995
1604185200|2020-11-01 00:00:00|516.0236188995

The archive table does not contain strange values (result of your query is no records and no error is produced).
On the other hand, the archive_day_rainRate table  does contain that error for every day at 00:00:00 and only at that hour.

Luis

unread,
Feb 24, 2022, 1:46:10 PM2/24/22
to weewx-user
Now with the rest of the columns for these values (max  > 100)
I insist, only at 00:00:00 every day

SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'),min, max, sum, count, wsum, sumtime FROM archive_day_rainRate WHERE max > 100.0 LIMIT 100;


dateTime          datetime (human)           min      max                   sum      count     wsum     sumtime
1588975200        2020-05-09 00:00:00        0        516.0236188995        0        48        0        86400
1589148000        2020-05-11 00:00:00        0        516.0236188995        0        47        0        84600
1589234400        2020-05-12 00:00:00        0        516.0236188995        0.6377952717        48        1148.03148906        86400
1589320800        2020-05-13 00:00:00        0        516.0236188995        0.8188976328        48        1474.01573904        86400
1589407200        2020-05-14 00:00:00        0        516.0236188995        4.8661417026        48        8759.055064680002        86400
1589493600        2020-05-15 00:00:00        0        516.0236188995        0.6141732246        48        1105.5118042800002        86400
1589580000        2020-05-16 00:00:00        0        516.0236188995        9.5511810441        48        17192.125879380004        86400
1589752800        2020-05-18 00:00:00        0        516.0236188995        0        48        0        86400
1589839200        2020-05-19 00:00:00        0        516.0236188995        0        48        0        86400
1589925600        2020-05-20 00:00:00        0        516.0236188995        0        48        0        86400
1590012000        2020-05-21 00:00:00        0        516.0236188995        0        48        0        86400
1590098400        2020-05-22 00:00:00        0        516.0236188995        0        48        0        86400
1590184800        2020-05-23 00:00:00        0        516.0236188995        0        48        0        86400
1590357600        2020-05-25 00:00:00        0        516.0236188995        0        48        0        86400
1590444000        2020-05-26 00:00:00        0        516.0236188995        0        48        0        86400
1590530400        2020-05-27 00:00:00        0        516.0236188995        0        48        0        86400
1590616800        2020-05-28 00:00:00        0        516.0236188995        0        48        0        86400
1590703200        2020-05-29 00:00:00        0        516.0236188995        0        48        0        86400
1590789600        2020-05-30 00:00:00        0        516.0236188995        0        48        0        86400
1590876000        2020-05-31 00:00:00        0        516.0236188995        0.2913385809        48        524.40944562        86400
1590962400        2020-06-01 00:00:00        0        516.0236188995        0        48        0        86400
1591048800        2020-06-02 00:00:00        0        516.0236188995        0        48        0        86400
1592863200        2020-06-23 00:00:00        0        516.0236188995        0        48        0        86400
1592949600        2020-06-24 00:00:00        0        516.0236188995        0        48        0        86400
1594504800        2020-07-12 00:00:00        0        516.0236188995        0        48        0        86400
1594591200        2020-07-13 00:00:00        0        516.0236188995        0        48        0        86400
1594677600        2020-07-14 00:00:00        0        516.0236188995        0        48        0        86400
1594764000        2020-07-15 00:00:00        0        516.0236188995        0        48        0        86400
1594850400        2020-07-16 00:00:00        0        516.0236188995        0        48        0        86400
1594936800        2020-07-17 00:00:00        0        516.0236188995        0        48        0        86400
1595023200        2020-07-18 00:00:00        0        516.0236188995        0        48        0        86400
1595109600        2020-07-19 00:00:00        0        516.0236188995        0        48        0        86400
1595196000        2020-07-20 00:00:00        0        516.0236188995        0        48        0        86400
1595282400        2020-07-21 00:00:00        0        516.0236188995        0        48        0        86400
1595368800        2020-07-22 00:00:00        0        516.0236188995        0        48        0        86400
1596232800        2020-08-01 00:00:00        0        516.0236188995        0        48        0        86400
1596319200        2020-08-02 00:00:00        0        516.0236188995        0        48        0        86400
1596405600        2020-08-03 00:00:00        0        516.0236188995        0        48        0        86400
1596492000        2020-08-04 00:00:00        0        516.0236188995        0        48        0        86400
1596578400        2020-08-05 00:00:00        0        516.0236188995        0        48        0        86400
1596664800        2020-08-06 00:00:00        0        516.0236188995        0        48        0        86400
1596751200        2020-08-07 00:00:00        0        516.0236188995        0        128        0        84900
1596837600        2020-08-08 00:00:00        0        516.0236188995        0        288        0        86400
1596924000        2020-08-09 00:00:00        0        516.0236188995        0        288        0        86400
1597010400        2020-08-10 00:00:00        0        516.0236188995        0.9921259782        288        297.63779346        86400
1598306400        2020-08-25 00:00:00        0        516.0236188995        0        288        0        86400
1598392800        2020-08-26 00:00:00        0        516.0236188995        0        288        0        86400
1598479200        2020-08-27 00:00:00        0        516.0236188995        0        288        0        86400
1598565600        2020-08-28 00:00:00        0        516.0236188995        0        288        0        86400
1598652000        2020-08-29 00:00:00        0        516.0236188995        0        288        0        86400
1598738400        2020-08-30 00:00:00        0        516.0236188995        0        288        0        86400
1598997600        2020-09-02 00:00:00        0        516.0236188995        0        288        0        86400
1599084000        2020-09-03 00:00:00        0        516.0236188995        0        288        0        86400
1599170400        2020-09-04 00:00:00        0        516.0236188995        0        288        0        86400
1599256800        2020-09-05 00:00:00        0        516.0236188995        0        288        0        86400
1599343200        2020-09-06 00:00:00        0        516.0236188995        0        288        0        86400
1599429600        2020-09-07 00:00:00        0        516.0236188995        0        288        0        86400
1599516000        2020-09-08 00:00:00        0        516.0236188995        0        288        0        86400
1599602400        2020-09-09 00:00:00        0        516.0236188995        0        288        0        86400
1599688800        2020-09-10 00:00:00        0        516.0236188995        0        288        0        86400
1599775200        2020-09-11 00:00:00        0        516.0236188995        0        288        0        86400
1599861600        2020-09-12 00:00:00        0        516.0236188995        0        288        0        86400
1599948000        2020-09-13 00:00:00        0        516.0236188995        0        288        0        86400
1600034400        2020-09-14 00:00:00        0        516.0236188995        0        288        0        86400
1600120800        2020-09-15 00:00:00        0        516.0236188995        0        288        0        86400
1600207200        2020-09-16 00:00:00        0        516.0236188995        0        288        0        86400
1600293600        2020-09-17 00:00:00        0        516.0236188995        0        288        0        86400
1600380000        2020-09-18 00:00:00        0        516.0236188995        1.9291338465        288        578.7401539499999        86400
1600466400        2020-09-19 00:00:00        0        516.0236188995        6.0551180733        288        1816.5354219900005        86400
1600552800        2020-09-20 00:00:00        0        516.0236188995        0        288        0        86400
1600725600        2020-09-22 00:00:00        0        516.0236188995        0        288        0        86400
1600812000        2020-09-23 00:00:00        0        516.0236188995        0        288        0        86400
1600898400        2020-09-24 00:00:00        0        516.0236188995        0        288        0        86400
1600984800        2020-09-25 00:00:00        0        516.0236188995        0        288        0        86400
1601071200        2020-09-26 00:00:00        0        516.0236188995        0        288        0        86400
1601157600        2020-09-27 00:00:00        0        516.0236188995        0        288        0        86400
1601244000        2020-09-28 00:00:00        0        516.0236188995        0        288        0        86400
1601330400        2020-09-29 00:00:00        0        516.0236188995        0        288        0        86400
1601416800        2020-09-30 00:00:00        0        516.0236188995        0        288        0        86400
1601503200        2020-10-01 00:00:00        0        516.0236188995        0        288        0        86400
1601589600        2020-10-02 00:00:00        0        516.0236188995        0        288        0        86400
1601676000        2020-10-03 00:00:00        0        516.0236188995        0        288        0        86400
1601762400        2020-10-04 00:00:00        0        516.0236188995        0        288        0        86400
1601848800        2020-10-05 00:00:00        0        516.0236188995        0        288        0        86400
1601935200        2020-10-06 00:00:00        0        516.0236188995        0        288        0        86400
1602021600        2020-10-07 00:00:00        0        516.0236188995        0        288        0        86400
1602108000        2020-10-08 00:00:00        0        516.0236188995        0        288        0        86400
1602194400        2020-10-09 00:00:00        0        516.0236188995        0        288        0        86400
1602280800        2020-10-10 00:00:00        0        516.0236188995        0        288        0        86400
1603058400        2020-10-19 00:00:00        0        516.0236188995        0        288        0        86400
1603144800        2020-10-20 00:00:00        0        516.0236188995        0        288        0        86400
1603231200        2020-10-21 00:00:00        0        516.0236188995        0        288        0        86400
1603317600        2020-10-22 00:00:00        0        516.0236188995        14.9685038457        287        4490.55115371        86100
1603404000        2020-10-23 00:00:00        0        516.0236188995        4.3700787135        288        1311.0236140500003        86400
1603753200        2020-10-27 00:00:00        0        516.0236188995        0        288        0        86400
1603839600        2020-10-28 00:00:00        0        516.0236188995        0        288        0        86400
1603926000        2020-10-29 00:00:00        0        516.0236188995        0        288        0        86400
1604012400        2020-10-30 00:00:00        0        516.0236188995        0        288        0        86400
1604098800        2020-10-31 00:00:00        0        516.0236188995        0        288        0        86400
1604185200        2020-11-01 00:00:00        0        516.0236188995        0        288        0        86400

Tom Keffer

unread,
Feb 24, 2022, 6:03:27 PM2/24/22
to weewx-user
Because these are daily summaries, the value for dateTime will always be midnight. What you need is the time of the max, which is given by the field 'maxtime'. 

SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), max, maxtime, datetime(maxtime, 'unixepoch', 'localtime') FROM archive_day_rainRate WHERE max > 100.0 ORDER BY dateTime DESC LIMIT 100;

Still need the log!

-tk

Luis

unread,
Mar 1, 2022, 3:02:51 PM3/1/22
to weewx-user
Hi Tom,
I think I can spot the origin of this problem.
My Vantage Vue has a problem with the battery.
Even though I change it for a new one it keeps showing the "Low battery" warning on the console.
Your query shows clearly that the rain rate problem starts when the signal problem begins every day as you can see on https://veleta.es
The output of your query is:

dateTime        datetime(dateTime, 'unixepoch', 'localtime')        max        maxtime        datetime(maxtime, 'unixepoch', 'localtime')
1646089200        2022-03-01 00:00:00        516.0236188995        1646108645        2022-03-01 05:24:05
1646002800        2022-02-28 00:00:00        516.0236188995        1646024224        2022-02-28 05:57:04
1645916400        2022-02-27 00:00:00        516.0236188995        1645936199        2022-02-27 05:29:59
1645830000        2022-02-26 00:00:00        516.0236188995        1645850525        2022-02-26 05:42:05
1645743600        2022-02-25 00:00:00        516.0236188995        1645762218        2022-02-25 05:10:18
1645657200        2022-02-24 00:00:00        516.0236188995        1645677907        2022-02-24 05:45:07
1645570800        2022-02-23 00:00:00        516.0236188995        1645591634        2022-02-23 05:47:14
1645484400        2022-02-22 00:00:00        516.0236188995        1645505445        2022-02-22 05:50:45
1645398000        2022-02-21 00:00:00        516.0236188995        1645418960        2022-02-21 05:49:20
1645311600        2022-02-20 00:00:00        516.0236188995        1645331930        2022-02-20 05:38:50
1645225200        2022-02-19 00:00:00        516.0236188995        1645246265        2022-02-19 05:51:05
1645138800        2022-02-18 00:00:00        516.0236188995        1645159816        2022-02-18 05:50:16
1645052400        2022-02-17 00:00:00        516.0236188995        1645073286        2022-02-17 05:48:06
1644966000        2022-02-16 00:00:00        516.0236188995        1644986715        2022-02-16 05:45:15
1644879600        2022-02-15 00:00:00        516.0236188995        1644900373        2022-02-15 05:46:13
1644793200        2022-02-14 00:00:00        516.0236188995        1644813604        2022-02-14 05:40:04
1644706800        2022-02-13 00:00:00        516.0236188995        1644727067        2022-02-13 05:37:47
1644620400        2022-02-12 00:00:00        516.0236188995        1644640808        2022-02-12 05:40:08
1644534000        2022-02-11 00:00:00        516.0236188995        1644554285        2022-02-11 05:38:05
1644447600        2022-02-10 00:00:00        516.0236188995        1644468235        2022-02-10 05:43:55
1644361200        2022-02-09 00:00:00        516.0236188995        1644379485        2022-02-09 05:04:45
1644274800        2022-02-08 00:00:00        516.0236188995        1644295083        2022-02-08 05:38:03
1644188400        2022-02-07 00:00:00        516.0236188995        1644208682        2022-02-07 05:38:02
1644102000        2022-02-06 00:00:00        516.0236188995        1644122355        2022-02-06 05:39:15
1644015600        2022-02-05 00:00:00        516.0236188995        1644034307        2022-02-05 05:11:47
1643929200        2022-02-04 00:00:00        516.0236188995        1643948777        2022-02-04 05:26:17
1643842800        2022-02-03 00:00:00        516.0236188995        1643862786        2022-02-03 05:33:06
1643756400        2022-02-02 00:00:00        516.0236188995        1643774347        2022-02-02 04:59:07
1643670000        2022-02-01 00:00:00        516.0236188995        1643689927        2022-02-01 05:32:07
1643583600        2022-01-31 00:00:00        516.0236188995        1643603384        2022-01-31 05:29:44
1643497200        2022-01-30 00:00:00        516.0236188995        1643516596        2022-01-30 05:23:16
1643410800        2022-01-29 00:00:00        516.0236188995        1643430826        2022-01-29 05:33:46
1643324400        2022-01-28 00:00:00        516.0236188995        1643342104        2022-01-28 04:55:04
1643238000        2022-01-27 00:00:00        516.0236188995        1643255507        2022-01-27 04:51:47
1643151600        2022-01-26 00:00:00        516.0236188995        1643169008        2022-01-26 04:50:08
1643065200        2022-01-25 00:00:00        516.0236188995        1643083873        2022-01-25 05:11:13
1642978800        2022-01-24 00:00:00        516.0236188995        1642995701        2022-01-24 04:41:41
1642892400        2022-01-23 00:00:00        516.0236188995        1642909934        2022-01-23 04:52:14
1642806000        2022-01-22 00:00:00        516.0236188995        1642822749        2022-01-22 04:39:09
1642719600        2022-01-21 00:00:00        516.0236188995        1642738983        2022-01-21 05:23:03
1642633200        2022-01-20 00:00:00        516.0236188995        1642652462        2022-01-20 05:21:02
1642546800        2022-01-19 00:00:00        516.0236188995        1642566195        2022-01-19 05:23:15
1642460400        2022-01-18 00:00:00        516.0236188995        1642477449        2022-01-18 04:44:09
1642374000        2022-01-17 00:00:00        516.0236188995        1642393264        2022-01-17 05:21:04
1642201200        2022-01-15 00:00:00        516.0236188995        1642218313        2022-01-15 04:45:13
1642114800        2022-01-14 00:00:00        516.0236188995        1642131875        2022-01-14 04:44:35
1642028400        2022-01-13 00:00:00        516.0236188995        1642045261        2022-01-13 04:41:01
1641942000        2022-01-12 00:00:00        516.0236188995        1641960793        2022-01-12 05:13:13
1641855600        2022-01-11 00:00:00        516.0236188995        1641874217        2022-01-11 05:10:17
1641769200        2022-01-10 00:00:00        516.0236188995        1641788058        2022-01-10 05:14:18
1641682800        2022-01-09 00:00:00        516.0236188995        1641701762        2022-01-09 05:16:02
1641596400        2022-01-08 00:00:00        516.0236188995        1641614887        2022-01-08 05:08:07
1641510000        2022-01-07 00:00:00        516.0236188995        1641528163        2022-01-07 05:02:43
1641423600        2022-01-06 00:00:00        516.0236188995        1641439066        2022-01-06 04:17:46
1641337200        2022-01-05 00:00:00        516.0236188995        1641351402        2022-01-05 03:56:42
1641250800        2022-01-04 00:00:00        516.0236188995        1641266060        2022-01-04 04:14:20
1641164400        2022-01-03 00:00:00        516.0236188995        1641179756        2022-01-03 04:15:56
1641078000        2022-01-02 00:00:00        516.0236188995        1641093548        2022-01-02 04:19:08
1640991600        2022-01-01 00:00:00        516.0236188995        1641006735        2022-01-01 04:12:15
1640905200        2021-12-31 00:00:00        516.0236188995        1640920211        2021-12-31 04:10:11
1640818800        2021-12-30 00:00:00        516.0236188995        1640833680        2021-12-30 04:08:00
1640732400        2021-12-29 00:00:00        516.0236188995        1640746884        2021-12-29 04:01:24
1640646000        2021-12-28 00:00:00        516.0236188995        1640662044        2021-12-28 04:27:24
1640559600        2021-12-27 00:00:00        516.0236188995        1640574663        2021-12-27 04:11:03
1640473200        2021-12-26 00:00:00        516.0236188995        1640490410        2021-12-26 04:46:50
1640386800        2021-12-25 00:00:00        516.0236188995        1640403976        2021-12-25 04:46:16
1640300400        2021-12-24 00:00:00        516.0236188995        1640312179        2021-12-24 03:16:19
1640214000        2021-12-23 00:00:00        516.0236188995        1640227598        2021-12-23 03:46:38
1640127600        2021-12-22 00:00:00        516.0236188995        1640139850        2021-12-22 03:24:10
1640041200        2021-12-21 00:00:00        516.0236188995        1640055552        2021-12-21 03:59:12
1639954800        2021-12-20 00:00:00        516.0236188995        1639969337        2021-12-20 04:02:17
1639868400        2021-12-19 00:00:00        516.0236188995        1639883159        2021-12-19 04:05:59
1639782000        2021-12-18 00:00:00        516.0236188995        1639796530        2021-12-18 04:02:10
1639695600        2021-12-17 00:00:00        516.0236188995        1639709420        2021-12-17 03:50:20
1639609200        2021-12-16 00:00:00        516.0236188995        1639623925        2021-12-16 04:05:25
1639522800        2021-12-15 00:00:00        516.0236188995        1639537128        2021-12-15 03:58:48
1639436400        2021-12-14 00:00:00        516.0236188995        1639451027        2021-12-14 04:03:47
1639350000        2021-12-13 00:00:00        516.0236188995        1639364512        2021-12-13 04:01:52
1639263600        2021-12-12 00:00:00        516.0236188995        1639278135        2021-12-12 04:02:15
1639177200        2021-12-11 00:00:00        516.0236188995        1639192333        2021-12-11 04:12:13
1639090800        2021-12-10 00:00:00        516.0236188995        1639106928        2021-12-10 04:28:48
1639004400        2021-12-09 00:00:00        516.0236188995        1639021330        2021-12-09 04:42:10
1638918000        2021-12-08 00:00:00        516.0236188995        1638934956        2021-12-08 04:42:36
1638831600        2021-12-07 00:00:00        516.0236188995        1638846105        2021-12-07 04:01:45
1638745200        2021-12-06 00:00:00        516.0236188995        1638759974        2021-12-06 04:06:14
1638658800        2021-12-05 00:00:00        516.0236188995        1638673295        2021-12-05 04:01:35
1638572400        2021-12-04 00:00:00        516.0236188995        1638587003        2021-12-04 04:03:23
1638486000        2021-12-03 00:00:00        516.0236188995        1638500791        2021-12-03 04:06:31
1638399600        2021-12-02 00:00:00        516.0236188995        1638414803        2021-12-02 04:13:23
1638313200        2021-12-01 00:00:00        516.0236188995        1638327980        2021-12-01 04:06:20
1638226800        2021-11-30 00:00:00        516.0236188995        1638240298        2021-11-30 03:44:58
1638140400        2021-11-29 00:00:00        516.0236188995        1638155300        2021-11-29 04:08:20
1638054000        2021-11-28 00:00:00        516.0236188995        1638068780        2021-11-28 04:06:20
1637967600        2021-11-27 00:00:00        516.0236188995        1637984525        2021-11-27 04:42:05
1637881200        2021-11-26 00:00:00        516.0236188995        1637896274        2021-11-26 04:11:14
1637794800        2021-11-25 00:00:00        516.0236188995        1637811638        2021-11-25 04:40:38
1637708400        2021-11-24 00:00:00        516.0236188995        1637724295        2021-11-24 04:24:55
1637622000        2021-11-23 00:00:00        516.0236188995        1637635638        2021-11-23 03:47:18
1637535600        2021-11-22 00:00:00        516.0236188995        1637552417        2021-11-22 04:40:17
1637449200        2021-11-21 00:00:00        516.0236188995        1637464479        2021-11-21 04:14:39
 
Now the question is, is there a way to prevent recording impossible data or detecting bad data quality due to signal problems?
Thanks

vince

unread,
Mar 1, 2022, 3:46:16 PM3/1/22
to weewx-user
On Tuesday, March 1, 2022 at 12:02:51 PM UTC-8 luis....@gmail.com wrote:

Now the question is, is there a way to prevent recording impossible data or detecting bad data quality due to signal problems?

Try StdQC and see if that helps.
Be careful to use the Units you have for group_rainrate that matches your StdConvert 'target_unit' settings

That would look something like (untested):

 [StdQC]
   [[MinMax]]
      # only use 'one' of the following
      0, 300, mm_per_hour    # if you use METRICWX
      0,  30, cm_per_hour    # or this if you use METRIC
      0,  10, inch_per_hour  # or this if you use US units



Tom Keffer

unread,
Mar 1, 2022, 4:40:27 PM3/1/22
to weewx-user
Using StdQC is always a good idea.

Just one small correction: if you specify a unit, then it doesn't matter what unit system is in StdConvert. It's when you don't specify a unit that the problems begin. 

--
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+...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages