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 On Friday, February 25, 2022 at 12:03:27 AM UTC+1 [email protected] wrote: > 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 > > On Thu, Feb 24, 2022 at 10:46 AM Luis <[email protected]> wrote: > >> 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 <(818)%20897-6328> 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 >> >> >> On Thursday, February 24, 2022 at 7:30:14 PM UTC+1 Luis wrote: >> >>> 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. >>> >>> On Thursday, February 24, 2022 at 6:17:47 PM UTC+1 [email protected] >>> wrote: >>> >>>> 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 >>>> <http://www.weewx.com/docs/usersguide.htm#Where_to_find_things>* for >>>> likely locations. >>>> >>>> On Thu, Feb 24, 2022 at 8:59 AM Luis <[email protected]> wrote: >>>> >>>>> 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 [email protected] >>>>> wrote: >>>>> >>>>>> 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 <[email protected]> wrote: >>>>>> >>>>>>> Now the debug log file (I think this is the one you refer to) >>>>>>> >>>>>> >>>>>>> >>>>>>> On Thursday, February 24, 2022 at 3:36:02 PM UTC+1 Luis wrote: >>>>>>> >>>>>>>> Hi Tom, >>>>>>>> I have followed your command on >>>>>>>> https://www.mail-archive.com/[email protected]/msg33396.html >>>>>>>> <https://www.mail-archive.com/[email protected]/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 >>>>>>>> <(480)%20314-9516> >>>>>>>> 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 >>>>>>>> <(440)%20944-8792> >>>>>>>> 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 >>>>>>>> <(251)%20968-5024> >>>>>>>> 1641429000|2022-01-06 01:30:00|0.0078740157|0.2283464553 >>>>>>>> <(228)%20346-4553> >>>>>>>> 1641428700|2022-01-06 01:25:00|0.0157480314|0.2283464553 >>>>>>>> <(228)%20346-4553> >>>>>>>> 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 >>>>>>>> <(267)%20716-5338> >>>>>>>> 1640604300|2021-12-27 12:25:00|0.0157480314|0.2283464553 >>>>>>>> <(228)%20346-4553> >>>>>>>> 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... >>>>>>>> On Wednesday, February 23, 2022 at 9:11:05 PM UTC+1 >>>>>>>> [email protected] wrote: >>>>>>>> >>>>>>>>> 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 >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Wed, Feb 23, 2022 at 11:02 AM Luis <[email protected]> wrote: >>>>>>>>> >>>>>>>>>> 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 >>>>>>>>>> On Sunday, November 21, 2021 at 10:43:45 PM UTC+1 >>>>>>>>>> [email protected] wrote: >>>>>>>>>> >>>>>>>>>>> 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 >>>>>>>>>>> >>>>>>>>>>> On Sun, Nov 21, 2021 at 7:03 AM Luis <[email protected]> wrote: >>>>>>>>>>> >>>>>>>>>>>> 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 >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> 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]. >>>>>>>>>>>> To view this discussion on the web visit >>>>>>>>>>>> https://groups.google.com/d/msgid/weewx-user/a44a3e2e-7557-48b6-8c5a-a3a7d1607d26n%40googlegroups.com >>>>>>>>>>>> >>>>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/a44a3e2e-7557-48b6-8c5a-a3a7d1607d26n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>> . >>>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>> 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]. >>>>>>>>>> >>>>>>>>> To view this discussion on the web visit >>>>>>>>>> https://groups.google.com/d/msgid/weewx-user/dcc3ed51-7b11-4739-a4d2-b06d562a7b73n%40googlegroups.com >>>>>>>>>> >>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/dcc3ed51-7b11-4739-a4d2-b06d562a7b73n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>> . >>>>>>>>>> >>>>>>>>> -- >>>>>>> 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]. >>>>>>> >>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/weewx-user/d3b6d73a-0918-406e-b2af-1564bb433fd8n%40googlegroups.com >>>>>>> >>>>>>> <https://groups.google.com/d/msgid/weewx-user/d3b6d73a-0918-406e-b2af-1564bb433fd8n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> >>>>>> -- >>>>> 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]. >>>>> >>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/weewx-user/415ff46f-4e77-4781-b97a-e304f3a9f479n%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/415ff46f-4e77-4781-b97a-e304f3a9f479n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >> 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]. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/32acb126-6d67-470c-8c70-fb1d3d6ab804n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/32acb126-6d67-470c-8c70-fb1d3d6ab804n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/899fc746-aac6-4b8a-8c30-df5cfdc24135n%40googlegroups.com.
