I forgot to say that the archive columns for windGust and windGustDir ARE populated, whilst the summary tables are populated in archive_day_windGust but not in archive_day_windGustDir - I have a FineOffset station.
On Sunday, 29 April 2018 18:23:44 UTC+3, Tom Keffer wrote: > > No you haven't. My next question was going to be, "What kind of weather > station?" > > -tk > > On Sun, Apr 29, 2018 at 8:18 AM, Andrew Milner <[email protected] > <javascript:>> wrote: > >> Tom >> I'm a bit baffled - after the thread was started I looked at my database >> It seems as though the daily summaries for gust and gust dir are not >> being populated - they are all NULL, and surely these are the tables which >> are used with the week tag - or am i mistaken? The query you gave would >> indeed return the highest wind from the archive table - but the poster was >> trying to use the tags to obtain the result. OK - my station does not >> output gust - although there is a gust column (and gust dir) in the archive >> table. >> >> Have I missed something?? >> >> >> >> On Sunday, 29 April 2018 17:38:48 UTC+3, Tom Keffer wrote: >> >>> For stats on a 'week', the data would be stored in the daily summaries. >>> If you have the start and stop of the week in unix epoch time, you can >>> query the database directly using the tool sqlite3 and see if the data is >>> in there. >>> >>> For example, for the week 21-28 April, AEST, the start and stop time >>> would be 1524319200 to 1524924000. If you are not in the AEST time zone, >>> adjust as necessary. >>> >>> In the example, it's assumed you've used the setup.py install method and >>> the location of your sqlite database is /home/weewx/archive/weewx.sdb. >>> If you used a Debian install, it will be /var/lib/weewx/weewx.sdb >>> >>> You may have to install the tool sqlite3: >>> >>> $ *sudo apt install sqlite3* >>> >>> then >>> >>> $ *sqlite3 /home/weewx/archive/weewx.sdb* >>> SQLite version 3.11.0 2016-02-15 17:29:24 >>> Enter ".help" for usage hints. >>> sqlite> *select max, datetime(maxtime,'unixepoch','localtime') from >>> archive_day_wind where dateTime>1524319200 and dateTime<=1524924000;* >>> 9.0|2018-04-22 00:20:00 >>> 16.0|2018-04-23 15:25:00 >>> 16.0|2018-04-24 13:45:00 >>> 11.0|2018-04-25 14:50:00 >>> 12.0|2018-04-26 14:40:00 >>> 34.0|2018-04-27 09:51:15 >>> 16.0|2018-04-28 11:55:00 >>> sqlite> *.quit* >>> >>> This shows the strength and time of the max wind speeds for the seven >>> days of the week. Try it and see what you get. >>> >>> >>> >>> >>> On Sun, Apr 29, 2018 at 2:32 AM, Greg from Oz <[email protected]> wrote: >>> >>>> My web page displays the wind direction and is using this value >>>> $current.windDir.formatted >>>> >>>> The week web page is using this: $week.wind.max from $week.wind.gustdir >>>> ($week.wind.gustDir.ordinal_compass) at $week.wind.maxtime >>>> >>>> This is what is displayed on the current conditions webpage; >>>> Wind 6 km/h from 217° (SW) >>>> >>>> This is what is being displayed on the week webpage: >>>> High Wind 23 km/h from N/A (N/A) at 11:47:27 (Friday)So my question is >>>> why doesn't the directions show up on any other webpages? >>>> Also where is the data for these values stored? >>>> Are they calculated somewhere? >>>> >>>> I noticed this direction data was missing after I installed the android >>>> weewx app (which is great BTW) and it showed my missing data. >>>> >>>> Thanks in advance. >>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "weewx-user" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
