Thanks. I need to go back to late November.
I've found out how to get the date & time from the dateTime column. :) But is it just archive_day_rain.sum I need to update? The weather station is one of the FineOffset ones, does this do rain rate? I always assumed it was calculated. But if fixing the rain & running weewx_database will fix it that will be great. Looks like I need to read up weewx_database. I can pick up the external data and put it in Excel which will let me build the SQL statements. And yes, I will stop weewx and take a copy of weewx.sdb before I start changing data! On Monday, 17 February 2020 15:18:49 UTC, Andrew Milner wrote: > > depends how completely you want to backfill!! > in the archive table there are columns for rain and rainrate which is a) > the rain fall in the arhive period and b) the rainrate in the archive > period. For stations which do not provide rainrate this may well be a > rainrate which decays over a period . > > If you can fill in all the archive periods with the rainfall data the > summary data could be recreated from the archive using drop daily and > rebuild daily options of weewx_database utility. > > alternatively you could fill in the columns in the rain daily summary > table and the rainrate daily summary table for all the days you are missing > > > > > On Monday, 17 February 2020 17:00:58 UTC+2, Auchtermuchty Weather wrote: >> >> I've finally sorted out my rain gauge, but now I need to backfill the >> rainfall data. There is a station near enough to me to use their data, but >> I could do with some guidance about what needs updating in my database, and >> if I need to run anything afterwards. I used SQL for years in the day job >> so no problems there. >> > -- 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/010a7ca7-a2d3-48dd-b012-591987ca2a33%40googlegroups.com.
