Further to my earlier thread about deleting or modifying values in the database (https://groups.google.com/g/weewx-user/c/EN_elfqKhlI), I would like to understand in what units precipitation is expressed. I am comparing the current and previous records of precipitation values in the station software and in Weewx, and I cannot reconcile them in any way. For 24 hours, my station recorded 15 mm of precipitation, while the wsum field in the archive_day_rain table shows 1588.2. What does this mean?
I found a thread titled "Weewx WD Import - Rain data units, values" (https://groups.google.com/g/weewx-user/c/Umc6L8NqXvc), but did not find an answer to my question there. I summed the rainfall data for the whole day from the database using the query (1746223200 = 2025-05-03 00:00:00 localtime, 1746309600 = 2025-05-04 00:00:00 localtime) and exported it to a CSV file: select datetime(dateTime,'unixepoch','localtime'),dateTime,rain from archive where dateTime < 1746309600 and dateTime >= 1746223200; Another query: select sum(rain) from archive where dateTime < 1746309600 and dateTime >= 1746223200; Summing the rainfall both ways from the 'rain' column in the 'archive' array gave me the same value as 'sum' in the 'archive_day_rain' array. Where then did the value of 1588.2 in the wsum column come from? -- 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/a0b712e7-ded5-4a32-a5d5-00ee65602432n%40googlegroups.com.
