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/CAENBs48N22eV7kpEn4iQM%2BR1oxZV8q7d0q404vaY%3DNwDNY-0%2Bw%40mail.gmail.com.
