Yes, as described above: correct the values in archive table and then rebuild the affected days.
Tomasz Lewicki schrieb am Montag, 5. Mai 2025 um 11:32:37 UTC+2: > 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/c1938362-924c-4edd-b90b-2f511be7ee76n%40googlegroups.com.
