Hi I am using fineoffset as well and I am also using mysql database. I had a look at other fineoffset weather stations using the hardware selection from the web page: http://weewx.com/stations.html and they didn't have any wind directions either except for the current conditions.
On Monday, 30 April 2018 01:48:59 UTC+10, Andrew Milner wrote: > > 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]> >> 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]. >>> 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.
