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.
