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 [email protected].
For more options, visit https://groups.google.com/d/optout.
