Re: [weewx-development] weewx-historical

Good idea. Thanks, Paul! Commit 5441bec On Wed, Apr 8, 2020 at 11:19 AM Paul Anderson wrote: > This is great I love it! > Wondering if you would consider extending it slightly with 2 additional > tags

Re: [weewx-development] weewx-historical

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 outpu

Re: [weewx-development] weewx-historical

Relief! I was hoping there wasn't something subtle that I was missing. On Mon, Apr 6, 2020 at 5:38 PM Vince Skahan 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

Re: [weewx-development] weewx-historical

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. > > O

Re: [weewx-development] weewx-historical

Good morning from Germany, it works with a mysql database Thank you Am Montag, 6. April 2020 02:21:06 UTC+2 schrieb Tom Keffer: > > OK, I've updated the extension to work with MySQL. > > Find it here: > https://github.com/tkeffer/weewx-historical/archive/weewx-historical-0.2.0.tar.gz > > -tk >

Re: [weewx-development] weewx-historical

OK, I've updated the extension to work with MySQL. Find it here: https://github.com/tkeffer/weewx-historical/archive/weewx-historical-0.2.0.tar.gz -tk On Sat, Apr 4, 2020 at 4:38 AM Thomas Keffer wrote: > Silly me. I don't know what made me think this would work with MySQL --- > it does not ha

Re: [weewx-development] weewx-historical

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 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

Re: [weewx-development] weewx-historical

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 oth

Re: [weewx-development] weewx-historical

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 wrote: > OK, there's the problem. For

Re: [weewx-development] weewx-historical

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

Re: [weewx-development] weewx-historical

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 sta

Re: [weewx-development] weewx-historical

OK, that matches what the historical extension is giving. A few more selects to try select date(dateTime,'unixepoch','localtime'), datetime(`maxtime`,'unixepoch','localtime'),`max` from archive_day_outTemp where strftime("%m-%d", dateTime,'unixepoch','localtime')='04-05'; select datetime(dateTime

Re: [weewx-development] weewx-historical

2007-04-05|79.0 2008-04-05|51.3 2009-04-05|71.17 2010-04-05|52.42 2011-04-05|47.7 2012-04-05|55.0 2013-04-05|53.7 2014-04-05|58.4 2015-04-05|57.6 2016-04-05|65.9 2017-04-05|59.6 2018-04-05|68.3 2019-04-05|55.5 2020-04-05|56.6 On Sun, Apr 5, 2020 at 1:02 PM Thomas Keffer wrote: > can you

Re: [weewx-development] weewx-historical

can you try the query directly? select date(dateTime,'unixepoch','localtime'), `max` from archive_day_outTemp where strftime("%m-%d", dateTime,'unixepoch','localtime')='04-05'; This will tell us the max for each year on 5 April. -tk On Sun, Apr 5, 2020 at 10:37 AM Vince Skahan wrote: > Finall

Re: [weewx-development] weewx-historical

Finally got around to installing this - too fun ! Possible bug report - my historical max day as reported by the extention is off by a day in the extension vs. the NOAA report. Look at https://www.skahan.net/weewx/index.html in the Current Conditions section of the table for the Historical hig

Re: [weewx-development] weewx-historical

Silly me. I don't know what made me think this would work with MySQL --- it does not have an equivalent of strftime(). Let me see what I can do. -tk On Sat, Apr 4, 2020 at 3:23 AM Hartmut Schweidler wrote: > Hallo Tom, > > Today I installed the Historical extension, the extension does not wor

Re: [weewx-development] weewx-historical

Hallo Tom, Today I installed the Historical extension, the extension does not work with a MYSQL database. my Weewx version 4.0.0b18 Max Temp   $day.outTemp.historical_max im Jahre $day.outTemp.historical_maxtime.format("%Y") an in syslog Apr 4 12:21:12 wetter weewx-we

Re: [weewx-development] weewx-historical

On Tuesday, March 31, 2020 at 10:51:58 AM UTC-7, Tom Keffer wrote: > > I had forgotten that, in the absence of anything else, XType plot > aggregations leverage individual scalar aggregations. So, to plot > historical highs and lows, I didn't have to write any code, just get the > skin.conf spec

Re: [weewx-development] weewx-historical

I had forgotten that, in the absence of anything else, XType plot aggregations leverage individual scalar aggregations. So, to plot historical highs and lows, I didn't have to write any code, just get the skin.conf spec right. Using this: [[[yearhilow]]] image_width = 800 image_height = 500

[weewx-development] weewx-historical

Not sure I like where this whole Xtypes thing is going. I have a perfectly good SLE that does half as much as this with 50% more lines of code that I will now have to retire. :) Gary -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To uns

[weewx-development] weewx-historical

This is a new extension that nicely shows the power of the new XTypes extensions in V4.0. https://github.com/tkeffer/weewx-historical It creates new aggregation types that allows you to use tags such as Max temperature for this day: $day.outTemp.historical_max in $day.outTemp.historical_maxtime.