Good idea. Thanks, Paul! Commit 5441bec <https://github.com/tkeffer/weewx-historical/commit/5441becd23d60c45f3bd70ca93a3ed5531a9b2a8>
On Wed, Apr 8, 2020 at 11:19 AM Paul Anderson <[email protected]> wrote: > This is great I love it! > Wondering if you would consider extending it slightly with 2 additional > tags? > > historical_min_avg > historical_max_avg > > As mentioned earlier Probably only useful if your database covers many > years. > I have done so on my local copy and like it because I can now produce > output like this: > > *Today's Climatological Summary* > Climatological Period 2006 To 2019 > Normal High Temp 52.7°F > Normal Low Temp 35.6°F > Normal Avg Temp 43.9°F > Record High Temp 66.0°F in 2013 > Record Low Temp 26.1°F in 2011 > > Attached are my changes. > Please note I have tested it with sqlite , it seems to produce sane > expected results. Not test with mysql. > > Thanks, > Paul > > > On Monday, April 6, 2020 at 8:49:42 PM UTC-4, Tom Keffer wrote: >> >> Relief! I was hoping there wasn't something subtle that I was missing. >> >> On Mon, Apr 6, 2020 at 5:38 PM Vince Skahan <[email protected]> wrote: >> >>> >>> I can confirm this is what was happening.... >>> Set my VM to PDT and rebuilt daily and the right results are coming out >>> now. >>> Thanks Tom ! >>> >>> On Sunday, April 5, 2020 at 4:33:24 PM UTC-7, Tom Keffer wrote: >>>> >>>> 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... >>>>> >>>>>> >>>>>>>> -- >>> 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/1e8fa790-5373-4459-81b8-da128f4a10c2%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-development/1e8fa790-5373-4459-81b8-da128f4a10c2%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/8cbeb74f-0de9-455f-87e2-6dd99b5c1971%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-development/8cbeb74f-0de9-455f-87e2-6dd99b5c1971%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/CAPq0zEBQnic%3DsJ4Tk1wrvVKoPaDfjXTGHyvdN1SiEOO9anRe_Q%40mail.gmail.com.
