On Saturday, 14 January 2017 00:00:06 UTC+10, Andrew Milner wrote: > > Gary - the daily table for windSpeed is called archive_day_wind not > archive_day_windSpeed >
Um, actually it is called archive_day_windSpeed. archive_day_wind is the daily sumamry for the vector wind. mysql> SELECT * FROM archive_day_windSpeed ORDER BY dateTime DESC LIMIT 1; +------------+------+------------+------------------+------------+------------------+-------+------------------+---------+ | dateTime | min | mintime | max | maxtime | sum | count | wsum | sumtime | +------------+------+------------+------------------+------------+------------------+-------+------------------+---------+ | 1484229600 | 0 | 1484229602 | 20.9215240001292 | 1484274119 | 975.264888006056 | 288 | 975.264888006056 | 288 | +------------+------+------------+------------------+------------+------------------+-------+------------------+---------+ 1 row in set (0.00 sec) mysql> SELECT * FROM archive_day_windGust ORDER BY dateTime DESC LIMIT 1; +------------+------+------------+------------------+------------+------------------+-------+------------------+---------+ | dateTime | min | mintime | max | maxtime | sum | count | wsum | sumtime | +------------+------+------------+------------------+------------+------------------+-------+------------------+---------+ | 1484229600 | 0 | 1484229604 | 20.9215240001292 | 1484274301 | 2335.16394801449 | 288 | 2335.16394801449 | 288 | +------------+------+------------+------------------+------------+------------------+-------+------------------+---------+ 1 row in set (0.01 sec) mysql> show tables; +----------------------------------+ | Tables_in_weewx | +----------------------------------+ | archive | | archive_day_ET | | archive_day_UV | | archive_day__metadata | | archive_day_altimeter | | archive_day_barometer | | archive_day_consBatteryVoltage | | archive_day_dewpoint | | archive_day_extraHumid1 | | archive_day_extraHumid2 | | archive_day_extraTemp1 | | archive_day_extraTemp2 | | archive_day_extraTemp3 | | archive_day_hail | | archive_day_hailRate | | archive_day_heatindex | | archive_day_heatingTemp | | archive_day_heatingVoltage | | archive_day_inHumidity | | archive_day_inTemp | | archive_day_inTempBatteryStatus | | archive_day_leafTemp1 | | archive_day_leafTemp2 | | archive_day_leafWet1 | | archive_day_leafWet2 | | archive_day_outHumidity | | archive_day_outTemp | | archive_day_outTempBatteryStatus | | archive_day_pressure | | archive_day_radiation | | archive_day_rain | | archive_day_rainBatteryStatus | | archive_day_rainRate | | archive_day_referenceVoltage | | archive_day_rxCheckPercent | | archive_day_soilMoist1 | | archive_day_soilMoist2 | | archive_day_soilMoist3 | | archive_day_soilMoist4 | | archive_day_soilTemp1 | | archive_day_soilTemp2 | | archive_day_soilTemp3 | | archive_day_soilTemp4 | | archive_day_supplyVoltage | | archive_day_txBatteryStatus | | archive_day_wind | | archive_day_windBatteryStatus | | archive_day_windDir | | archive_day_windGust | | archive_day_windGustDir | | archive_day_windSpeed | | archive_day_windchill | +----------------------------------+ 52 rows in set (0.00 sec) mysql> -- 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.