Data mining
UPDATE The WeatherSTEM Data Mining Tool is open without restriction again! Please follow WeatherSTEM on Facebook and Twitter and help us spread the word about our innovative program!
Station 1
Oldest record: 2021-05-27 07:01:29
Oldest record: 2021-05-27 07:01:29
Add comparison station
Click instruments whose data you want to mine MySQL mode is off
Working
Sensor | Property | Units |
---|---|---|
10 Minute Wind Gust Column: sensor_35737 Column type: INT(4) | Wind Speed | Miles Per Hour |
Anemometer Column: sensor_35739 Column type: INT(4) | Wind Speed | Miles Per Hour |
Barometer Column: sensor_35731 Column type: DECIMAL(5,3) | Barometric Pressure | Inches of Mercury |
Barometer Tendency Column: sensor_35734 Column type: VARCHAR(16) | Barometric Pressure Tendency | Pressure Tendency |
Dewpoint Column: sensor_35740 Column type: DECIMAL(4,1) | Temperature | Degrees Fahrenheit |
Heat Index Column: sensor_35742 Column type: DECIMAL(4,1) | Temperature | Degrees Fahrenheit |
Hygrometer Column: sensor_35745 Column type: INT(4) | Relative Humidity | Percent Humidity |
Rain Gauge Column: sensor_35748 Column type: DECIMAL(4,2) | Today's Rainfall | Inches |
Rain Rate Column: sensor_35749 Column type: DECIMAL(4,2) | Rain Rate | Inches Per Hour |
Solar Radiation Sensor Column: sensor_35750 Column type: INT(4) | Solar Radiation | Watts Per Square Meter |
Thermometer Column: sensor_35753 Column type: DECIMAL(4,1) | Temperature | Degrees Fahrenheit |
UV Radiation Sensor Column: sensor_35756 Column type: INT(2) | Ultra Violet Radiation | UV Index |
Wet Bulb Globe Temperature Column: sensor_35759 Column type: DECIMAL(4,1) | Temperature | Degrees Fahrenheit |
Wind Chill Column: sensor_35762 Column type: DECIMAL(4,1) | Temperature | Degrees Fahrenheit |
Wind Vane Column: sensor_35765 Column type: INT(3) | Wind Direction | Degrees |
Enter MySQL Query (this table name: records_1678; columns: id INT(11) PRI AUTO_INC, time (DATETIME)) DESCRIBE records_1678
Select time period (Oldest record 2021-05-27 07:01:29)
Frame rate
frames per second
Optional timelapse creation (Must be logged in)
Frame rate
frames per second
Select output format
Select time format
Select interval Operation
