Hi, i have the following issue. I imported 2 years of data in weewx database but i noticed some issues on daily archive. The most important is with the rain. Taking data from archive table, i perform the following query on sql db for a specific day in order to have the total amount of rain for that specific day. The value i obtain is the correct i expect ,for that day i had 1.13385 inch of rain.
select sum(rain) from archive where dateTime > 1601157600 and dateTime <= 1601244000 and rain != 0 In my NOAA report, and on daily archive for that day i have completely different values( 0.645669 inches). In particular for the same day as before but this time from the archive_daily_rain i have the following output sqlite> select * from archive_day_rain where dateTime=1601157600; dateTime|min|mintime|max|maxtime|sum|count|wsum|sumtime 1601157600|0.0|1601158071|0.165354330708661|1601218891|0.645669|197|920.551181102362|4782 in the sum field there is that 0.645669 inches that is the value i have in NOAA report that is wrong. Why is weewx doing this?i can i fix this for all day i had rain? I tried: wee_database --update wee_database --reweight dropped the daily record and regenerated No one of this action fixed this issue. Thanks in advance. Best regards. Roberto -- 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/450a2860-65fc-4dbe-97ff-c07b48684fe1n%40googlegroups.com.
