I took another peek into the database and noticed something strange. I sorted all the records in the ‘rain’ column from smallest to largest. Excluding those with a value of 0.0, all the records have a value much smaller than 1; the largest has a value of 0.4. However, there is one that has a value of 4.984 - and that's the one from May 3, 2025, 10:00 a.m. local time. If I understand correctly, 4.984 is the value in inches - this would explain the false precipitation value (126.6 mm plus the rest from that day). I will do some modification soon and write about the results.
poniedziałek, 5 maja 2025 o 11:12:19 UTC+2 Tomasz Lewicki napisał(a): > For testing purposes, I installed Weewx on my laptop and transferred the > database to it from the Raspberry Pi running my PWS. Weewx runs in > simulator mode, but I'm interested in data from yesterday and earlier, so I > don't pay attention to the current readings. I've done everything, > including rebuilding the database described here: > https://weewx.com/docs/5.1/utilities/weectl-database/?h=derived#recalculate-daily-summary-weights > > Unfortunately, nothing changes - the false value is still visible in daily, > weekly and monthly data. I don't understand what the issue is :| > > poniedziałek, 5 maja 2025 o 09:36:12 UTC+2 [email protected] napisał(a): > >> When the archive table is ok, just rebuild the affected days. If the >> archive really is OK, then everything should be correct. >> >> [email protected] schrieb am Montag, 5. Mai 2025 um 09:35:06 UTC+2: >> >>> sum is the sum, wsum is the weighted sum, needed to calculate averages, >>> etc. >>> >>> Tomasz Lewicki schrieb am Montag, 5. Mai 2025 um 08:59:36 UTC+2: >>> >>>> Thank you for the reply. But as I wrote in othe thread ( >>>> https://groups.google.com/g/weewx-user/c/aPjmvWN9Kss), values in >>>> 'archive' table looks normal. So I don't know what is correlation between >>>> 'sum' and 'wsum' and what is the reason that in the current data I have >>>> the correct values, and the daily summary shows something strongly >>>> deviating from reality. I would like to fix this, because it spoils the >>>> statistics a lot, and I would not like to zero out the rain from the whole >>>> day. >>>> >>>> niedziela, 4 maja 2025 o 11:55:34 UTC+2 [email protected] napisał(a): >>>> >>>>> To correct your rain values modify the column in the archive table, >>>>> then let weewx build the daily values for the affected dates. I can't >>>>> remember if the rainRate is a derived value or not (or if it depends on >>>>> the >>>>> hardware), if so, you might want to (delete and) recalculate this derived >>>>> value also. There shouldn't be any need to modify die archive_day table. >>>>> >>>>> See: >>>>> >>>>> https://weewx.com/docs/5.1/custom/database/?h=reb#rebuilding-the-daily-summaries >>>>> >>>>> https://weewx.com/docs/5.1/utilities/weectl-database/?h=derived#calculate-missing-derived-variables >>>>> >>>>> >>>>> >>>>> >>>>> Tomasz Lewicki schrieb am Samstag, 3. Mai 2025 um 18:44:31 UTC+2: >>>>> >>>>>> I would like to ask which columna in the archive_day_rain array >>>>>> stores the daily rainfall. The problem is that Weewx has treated today's >>>>>> rainfall at my place in a very strange way - the daily summary in the >>>>>> HTML >>>>>> files shows more than 130 mm. The station panel (logger) recorded 12 mm >>>>>> and >>>>>> this is the correct value, because another station located about 1 km >>>>>> from >>>>>> me recorded a similar value. I would like to manually correct the daily >>>>>> precipitation in the weewx.sdb file, but I don't know which column I >>>>>> should >>>>>> edit - sum or wsum. In what units is the precipitation value expressed? >>>>>> In >>>>>> the wsum column I have 1515 - but what? >>>>> >>>>> -- 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 visit https://groups.google.com/d/msgid/weewx-user/bd271c3d-5a19-4df0-bcd3-caca8864ff76n%40googlegroups.com.
