That matches what I see anyway!! The command Tom gave was for SQLite - MySQL handles date conversions differently
I THINK it is something like SELECT max, FROM_UNIXTIME(maxtime) eg: SELECT max, FROM_UNIXTIME(maxtime) from archive_day_wind where dateTime>1524319200 and dateTime<=1524924000; On Tuesday, 1 May 2018 12:59:23 UTC+3, Greg from Oz wrote: > > Hi It seems like any fineoffset weather stations don't see wind direction > for week/month/year only current. > I have looked at other weather sites running fineoffset. > > Greg > > On Monday, 30 April 2018 00:38:48 UTC+10, Thomas 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.
