That is a good question. I am not much up on databases and stuff. I found this statement to display the contents of the field for count readings”
mysql> select * from archive_day_lightning_strike_count; +------------+------+------------+------+------------+------+-------+-------+---------+ | dateTime | min | mintime | max | maxtime | sum | count | wsum | sumtime | +------------+------+------------+------+------------+------+-------+-------+---------+ | 1617429600 | 0 | 1617498307 | 0 | 1617498307 | 0 | 291 | 0 | 17460 | | 1617516000 | 0 | 1617516004 | 0 | 1617516004 | 0 | 1254 | 0 | 75240 | | 1617602400 | 0 | 1617602410 | 0 | 1617602410 | 0 | 1437 | 0 | 86220 | | 1617688800 | 0 | 1617688814 | 0 | 1617688814 | 0 | 1434 | 0 | 86040 | | 1617775200 | 0 | 1617775213 | 0 | 1617775213 | 0 | 1440 | 0 | 86400 | | 1617861600 | 0 | 1617861611 | 0 | 1617861611 | 0 | 1438 | 0 | 86280 | | 1617948000 | 0 | 1617948008 | 0 | 1617948008 | 0 | 1440 | 0 | 86400 | | 1618034400 | 0 | 1618034407 | 0 | 1618034407 | 0 | 1440 | 0 | 86400 | | 1618120800 | 0 | 1618120817 | 0 | 1618120817 | 0 | 1440 | 0 | 86400 | | 1618207200 | 0 | 1618207220 | 0 | 1618207220 | 0 | 1411 | 0 | 84660 | | 1618293600 | 0 | 1618293617 | 0 | 1618293617 | 0 | 1431 | 0 | 85860 | | 1618380000 | 0 | 1618380009 | 0 | 1618380009 | 0 | 1432 | 0 | 85920 | | 1618466400 | 0 | 1618466419 | 0 | 1618466419 | 0 | 1396 | 0 | 83760 | | 1618552800 | 0 | 1618552821 | 0 | 1618552821 | 0 | 1440 | 0 | 86400 | | 1618639200 | 0 | 1618639209 | 0 | 1618639209 | 0 | 1433 | 0 | 85980 | | 1618725600 | 0 | 1618725614 | 0 | 1618725614 | 0 | 1440 | 0 | 86400 | | 1618812000 | 0 | 1618812009 | 0 | 1618812009 | 0 | 1440 | 0 | 86400 | | 1618898400 | 0 | 1618898401 | 0 | 1618898401 | 0 | 1438 | 0 | 86280 | | 1618984800 | 0 | 1618984820 | 0 | 1618984820 | 0 | 1421 | 0 | 85260 | | 1619071200 | 0 | 1619071220 | 0 | 1619071220 | 0 | 1440 | 0 | 86400 | | 1619157600 | 0 | 1619157607 | 0 | 1619157607 | 0 | 1198 | 0 | 71880 | | 1619244000 | 0 | 1619244007 | 0 | 1619244007 | 0 | 1440 | 0 | 86400 | | 1619330400 | 0 | 1619330401 | 0 | 1619330401 | 0 | 1440 | 0 | 86400 | | 1619416800 | 0 | 1619416814 | 0 | 1619416814 | 0 | 1437 | 0 | 86220 | | 1619503200 | 0 | 1619503202 | 0 | 1619503202 | 0 | 1440 | 0 | 86400 | | 1619589600 | 0 | 1619589601 | 0 | 1619589601 | 0 | 1431 | 0 | 85860 | | 1619676000 | 0 | 1619676014 | 0 | 1619676014 | 0 | 1440 | 0 | 86400 | | 1619762400 | 0 | 1619762411 | 0 | 1619762411 | 0 | 1440 | 0 | 86400 | | 1619848800 | 0 | 1619848805 | 0 | 1619848805 | 0 | 1440 | 0 | 86400 | | 1619935200 | 0 | 1619935214 | 0 | 1619935214 | 0 | 1439 | 0 | 86340 | | 1620021600 | 0 | 1620021614 | 5 | 1620084300 | 124 | 1438 | 7440 | 86280 | | 1620108000 | 0 | 1620108005 | 0 | 1620108005 | 0 | 1440 | 0 | 86400 | | 1620194400 | 0 | 1620194420 | 0 | 1620194420 | 0 | 1436 | 0 | 86160 | | 1620280800 | 0 | 1620280818 | 0 | 1620280818 | 0 | 1440 | 0 | 86400 | | 1620367200 | 0 | 1620367203 | 1 | 1620433715 | 1 | 1440 | 60 | 86400 | | 1620453600 | 0 | 1620453615 | 0 | 1620453615 | 0 | 1439 | 0 | 86340 | | 1620540000 | 0 | 1620540003 | 0 | 1620540003 | 0 | 1438 | 0 | 86280 | | 1620626400 | 0 | 1620626417 | 1 | 1620668023 | 1 | 1440 | 60 | 86400 | | 1620712800 | 0 | 1620712813 | 1 | 1620724087 | 6 | 1404 | 360 | 84240 | | 1620799200 | 0 | 1620799219 | 0 | 1620799219 | 0 | 1369 | 0 | 82140 | | 1620885600 | 0 | 1620907460 | 0 | 1620907460 | 0 | 770 | 0 | 56280 | | 1620972000 | 0 | 1620972018 | 7 | 1621048320 | 43 | 1114 | 2580 | 83160 | | 1621058400 | 0 | 1621058403 | 2 | 1621123200 | 39 | 1425 | 2340 | 85500 | | 1621144800 | 0 | 1621144806 | 0 | 1621144806 | 0 | 1433 | 0 | 85980 | | 1621231200 | 0 | 1621231202 | 0 | 1621231202 | 0 | 1440 | 0 | 86400 | | 1621317600 | 0 | 1621317609 | 1 | 1621382991 | 1 | 1432 | 60 | 85920 | | 1621404000 | 0 | 1621404016 | 2 | 1621419129 | 15 | 1440 | 900 | 86400 | | 1621490400 | 0 | 1621490409 | 0 | 1621490409 | 0 | 1440 | 0 | 86400 | | 1621576800 | 0 | 1621576805 | 3 | 1621646820 | 27 | 1440 | 1620 | 86400 | | 1621663200 | 0 | 1621663217 | 0 | 1621663217 | 0 | 1357 | 0 | 81420 | | 1621749600 | 0 | 1621749613 | 0 | 1621749613 | 0 | 1440 | 0 | 86400 | | 1621836000 | 0 | 1621836001 | 1 | 1621899661 | 1 | 1440 | 60 | 86400 | | 1621922400 | 0 | 1621922410 | 0 | 1621922410 | 0 | 1440 | 0 | 86400 | | 1622008800 | 0 | 1622008809 | 2 | 1622073360 | 20 | 1440 | 1200 | 86400 | | 1622095200 | 0 | 1622095214 | 0 | 1622095214 | 0 | 1438 | 0 | 86280 | | 1622181600 | 0 | 1622181607 | 18 | 1622254200 | 253 | 1440 | 15180 | 86400 | | 1622268000 | 0 | 1622268003 | 0 | 1622268003 | 0 | 1420 | 0 | 85200 | | 1622354400 | 0 | 1622354408 | 1 | 1622428886 | 12 | 1436 | 720 | 86160 | | 1622440800 | 0 | 1622440803 | 7 | 1622463120 | 133 | 1428 | 7980 | 85680 | | 1622527200 | 0 | 1622527202 | 0 | 1622527202 | 0 | 1440 | 0 | 86400 | | 1622613600 | 0 | 1622613604 | 18 | 1622677920 | 510 | 1440 | 30600 | 86400 | | 1622700000 | 0 | 1622700002 | 0 | 1622700002 | 0 | 1440 | 0 | 86400 | | 1622786400 | 0 | 1622786408 | 0 | 1622786408 | 0 | 1435 | 0 | 86100 | | 1622872800 | 0 | 1622872801 | 0 | 1622872801 | 0 | 1440 | 0 | 86400 | | 1622959200 | 0 | 1622959203 | 1 | 1623033044 | 1 | 1440 | 60 | 86400 | | 1623045600 | 0 | 1623045601 | 0 | 1623045601 | 0 | 1440 | 0 | 86400 | | 1623132000 | 0 | 1623132004 | 0 | 1623132004 | 0 | 1440 | 0 | 86400 | | 1623218400 | 0 | 1623218407 | 0 | 1623218407 | 0 | 1440 | 0 | 86400 | | 1623304800 | 0 | 1623304808 | 0 | 1623304808 | 0 | 1440 | 0 | 86400 | | 1623391200 | 0 | 1623391206 | 0 | 1623391206 | 0 | 1440 | 0 | 86400 | | 1623477600 | 0 | 1623477616 | 0 | 1623477616 | 0 | 1440 | 0 | 86400 | | 1623564000 | 0 | 1623564016 | 1 | 1623577360 | 1 | 1440 | 60 | 86400 | | 1623650400 | 0 | 1623650414 | 0 | 1623650414 | 0 | 1440 | 0 | 86400 | | 1623736800 | 0 | 1623736811 | 0 | 1623736811 | 0 | 1440 | 0 | 86400 | | 1623823200 | 0 | 1623823214 | 0 | 1623823214 | 0 | 1440 | 0 | 86400 | | 1623909600 | 0 | 1623909603 | 0 | 1623909603 | 0 | 1439 | 0 | 86340 | | 1623996000 | 0 | 1623996019 | 0 | 1623996019 | 0 | 1440 | 0 | 86400 | | 1624082400 | 0 | 1624082404 | 0 | 1624082404 | 0 | 1440 | 0 | 86400 | | 1624168800 | 0 | 1624168801 | 1 | 1624232539 | 4 | 1440 | 240 | 86400 | | 1624255200 | 0 | 1624255216 | 0 | 1624255216 | 0 | 1439 | 0 | 86340 | | 1624341600 | 0 | 1624341607 | 0 | 1624341607 | 0 | 1440 | 0 | 86400 | | 1624428000 | 0 | 1624428018 | 1 | 1624499423 | 1 | 1434 | 60 | 86040 | | 1624514400 | 0 | 1624514408 | 6 | 1624572660 | 98 | 1438 | 5880 | 86280 | | 1624600800 | 0 | 1624600818 | 0 | 1624600818 | 0 | 1440 | 0 | 86400 | | 1624687200 | 0 | 1624687205 | 10 | 1624773000 | 314 | 1431 | 18840 | 85860 | | 1624773600 | 0 | 1624773608 | 5 | 1624773840 | 193 | 1435 | 11580 | 86100 | | 1624860000 | 0 | 1624860017 | 0 | 1624860017 | 0 | 1434 | 0 | 86040 | | 1624946400 | 0 | 1624946420 | 0 | 1624946420 | 0 | 1438 | 0 | 86280 | | 1625032800 | 0 | 1625032810 | 1 | 1625100912 | 2 | 1438 | 120 | 86280 | | 1625119200 | 0 | 1625119214 | 0 | 1625119214 | 0 | 1435 | 0 | 86100 | | 1625205600 | 0 | 1625205620 | 4 | 1625267640 | 160 | 1440 | 9600 | 86400 | | 1625292000 | 0 | 1625292006 | 1 | 1625359070 | 4 | 1390 | 240 | 83400 | | 1625378400 | 0 | 1625378411 | 0 | 1625378411 | 0 | 1440 | 0 | 86400 | | 1625464800 | 0 | 1625464806 | 9 | 1625475660 | 256 | 1440 | 15360 | 86400 | | 1625551200 | 0 | 1625551202 | 0 | 1625551202 | 0 | 1440 | 0 | 86400 | | 1625637600 | 0 | 1625637619 | 0 | 1625637619 | 0 | 1440 | 0 | 86400 | | 1625724000 | 0 | 1625724006 | 0 | 1625724006 | 0 | 1433 | 0 | 85980 | | 1625810400 | 0 | 1625810406 | 0 | 1625810406 | 0 | 1422 | 0 | 85320 | | 1625896800 | 0 | 1625896808 | 0 | 1625896808 | 0 | 1353 | 0 | 81180 | | 1625983200 | 0 | 1625983201 | 5 | 1626026640 | 91 | 1416 | 5460 | 84960 | | 1626069600 | 0 | 1626069619 | 0 | 1626069619 | 0 | 1440 | 0 | 86400 | | 1626156000 | 0 | 1626156005 | 0 | 1626156005 | 0 | 1440 | 0 | 86400 | | 1626242400 | 0 | 1626242403 | 0 | 1626242403 | 0 | 1439 | 0 | 86340 | | 1626328800 | 0 | 1626328821 | 0 | 1626328821 | 0 | 1415 | 0 | 84900 | | 1626415200 | 0 | 1626415214 | 0 | 1626415214 | 0 | 1437 | 0 | 86220 | | 1626501600 | 0 | 1626501612 | 1 | 1626561894 | 8 | 1439 | 480 | 86340 | | 1626588000 | 0 | 1626588001 | 6 | 1626614160 | 176 | 503 | 10560 | 30180 | +------------+------+------------+------+------------+------+-------+-------+---------+ 107 rows in set (0.00 sec) From: [email protected] <[email protected]> On Behalf Of vince Sent: Sunday, July 18, 2021 7:52 AM To: weewx-user <[email protected]> Subject: [weewx-user] Re: Lightning Readings On Sunday, July 18, 2021 at 6:45:35 AM UTC-7 Mitchell Tuckness wrote: I have a GW1000 and the WH31L and while it detects the lightning strikes, Weewx woefully underreports them. Does anyone know how to get the counts more inline with what is recorded? How do you know it's 'weewx' that is under-reporting and not the sensor itself ? -- 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/2qT3a5NHI1c/unsubscribe. To unsubscribe from this group and all its topics, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/9d4f42bc-ec21-4124-ada0-0c2c9ee1193en%40googlegroups.com <https://groups.google.com/d/msgid/weewx-user/9d4f42bc-ec21-4124-ada0-0c2c9ee1193en%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/051401d77be0%24e9a16c00%24bce44400%24%40maladomini.com.
