That's what I'm thinking. It recorded the high for UTC day 6-Apr-2007, not local day.
On Sun, Apr 5, 2020 at 3:52 PM Vince Skahan <[email protected]> wrote: > 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/CAPq0zECzJzSEBGpWCku6LJSBSTTBWzgsyv3MDjFqbn2i6jemEQ%40mail.gmail.com.
