It probably more than likely that when I ran rebuild daily after extending my schema for v4 that the vm I did that on was utc and running off old archive data that was in PDT.
Given the UTC-8 here, if the high was after 4pm local (not unusual) wouldn't that be a day offset? Or would it be the other day off ? Darn timezones... On Sun, Apr 5, 2020, 3:46 PM Vince Skahan <[email protected]> wrote: > Actually looks possible. > > https://www.almanac.com/weather/history/WA/Seattle/2007-04-07 > > Pre jan 2009 I had a LaCrosse that tended to read a few degrees hot in the > sun, so yes I could see that date being 75+ here. > > > On Sun, Apr 5, 2020, 3:40 PM Thomas Keffer <[email protected]> wrote: > >> OK, there's the problem. For whatever reason, the column `maxtime` in the >> daily summaries for 5-Apr-2007 has the high temperature for the next day, >> 6-Apr-2007. >> >> This pattern seems to occur sporadically for many other years. >> >> Do you suppose that your computer was running UTC when the daily >> summaries were rebuilt? >> >> Was your weather station vacationing in Miami in 2007? A high of 79 for >> April has got to be very unusual for Seattle! :-) >> >> -tk >> >> >> -tk >> >> On Sun, Apr 5, 2020 at 3:23 PM Vince Skahan <[email protected]> >> wrote: >> >>> On Sunday, April 5, 2020 at 3:20:17 PM UTC-7, Tom Keffer wrote: >>>> >>>> OK, that matches what the historical extension is giving. >>>> >>>> A few more selects to try >>>> >>>> >>>> >>> root@debian:/home/weewx/archive# sqlite3 weewx.sdb >>> SQLite version 3.7.13 2012-06-11 02:05:22 >>> Enter ".help" for instructions >>> Enter SQL statements terminated with a ";" >>> sqlite> select date(dateTime,'unixepoch','localtime'), >>> datetime(`maxtime`,'unixepoch','localtime'),`max` from archive_day_outTemp >>> where strftime("%m-%d", dateTime,'unixepoch','localtime')='04-05'; >>> 2007-04-05|2007-04-06 16:34:00|79.0 >>> 2008-04-05|2008-04-06 11:29:00|51.3 >>> 2009-04-05|2009-04-06 17:00:00|71.199997 >>> 2010-04-05|2010-04-06 14:05:00|52.400002 >>> 2011-04-05|2011-04-05 17:50:00|47.7 >>> 2012-04-05|2012-04-06 16:20:00|55.0 >>> 2013-04-05|2013-04-05 17:05:00|53.7 >>> 2014-04-05|2014-04-06 16:45:00|58.4 >>> 2015-04-05|2015-04-06 16:50:00|57.6 >>> 2016-04-05|2016-04-06 16:10:00|65.9 >>> 2017-04-05|2017-04-06 16:25:00|59.6 >>> 2018-04-05|2018-04-06 16:25:00|68.3 >>> 2019-04-05|2019-04-06 16:15:00|55.5 >>> 2020-04-05|2020-04-05 12:22:41|56.6 >>> sqlite> select datetime(dateTime,'unixepoch','localtime'),outTemp from >>> archive where dateTime >1175756400 and dateTime<=1175842800 order by >>> outTemp desc limit 1; >>> 2007-04-05 17:14:00|72.5 >>> sqlite> select datetime(dateTime,'unixepoch','localtime'),outTemp from >>> archive where dateTime >1175842800 and dateTime<=1175929200 order by >>> outTemp desc limit 1; >>> 2007-04-06 16:34:00|79.0 >>> sqlite> >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "weewx-development" 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-development/23c39c35-2257-4cbc-a78b-5462c73abc9c%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-development/23c39c35-2257-4cbc-a78b-5462c73abc9c%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- You received this message because you are subscribed to the Google Groups "weewx-development" 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-development/CAENBs4-BKaU598nmmJtFLku2PkMq_97C%2BL_1Lvy6Q6RppBHy-g%40mail.gmail.com.
