In playing with the Belchertown skin, I'm getting a bad result for max alltime days in a row without rain, basically for a couple years at the beginning of my data before I got my VP2. While my recollection is long gone, my 'guess' is that I previously cleared bad data and did so incorrectly literally years ago.
Question-1: I notice that all my archive_day_whatever tables have a bad dateTime field ala: $ echo "select * from archive_day_windchill limit 1"|sqlite3 weewx.sdb -57600|49.9|301|49.9|301|0.0|0|0.0|0 Yet the archive table is what I'd expect, pointing to my first spinup of wview back in late 2006 (wow). I can certainly remove the bad records from all the archive_day_* tables via sqlite3, that's not a problem. Using a test copy: $ echo "select * from archive_day_windchill where dateTime < 0" | sqlite3 weewx.sdb -57600|49.9|301|49.9|301|0.0|0|0.0|0 $ echo "delete from archive_day_windchill where dateTime < 0" | sqlite3 weewx.sdb vince@air:fixvp2$ echo "select * from archive_day_windchill where dateTime < 0" | sqlite3 weewx.sdb # (nothing is found) Question is will anything bad happen if I just hand-fix the archive_day_xyz tables ? Or is a more modern approach to use the semi-new --rebuild-daily option with a specified date range (ie, 11/22/2006 to 11/30/2006) to get to the beginning of my data only ? Question-2: I know I previously clearing up the insanely wrong rain prior to me getting my VP2 a couple years later. If I wanted to make it look like I had no rain sensor at all, is the right thing to have the rain and rainRate = 0.00 or '' (ie, NULL) for that time period. Currently it looks like both fields are null for all records prior to the end of 2008, which matches my hazy recollection of what I tried to do years ago. In other words, if I want my alltime record for consecutive days without rain to start 2 years after my earliest archive record, how would I hack my legacy archive records to basically say "no rain sensor here dude" for those archive records ? -- 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/c2f3533a-0907-4969-97fd-08440ff9bb2d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
