Skip to main content.

Data collection

This site collects weather data on a minute by minute basis, I decided to update the database in a relative manageble form and kept the database update to a 5 minutes interval.

Different sets of data are collected at different times and time scales, the following data is uploaded to a MySQL database:

Weather Data

Initially only some of the important data is collected being:

This data is graphed by hour and by month, some data might look a bit "funny" this is because the average for the day is used and this includes zero values. The formula used is "avg(field)"

 

Windturbine and solar panel data

This data is collected from a Plasmatronic unit that is connected to the wind turbine and a solar panel, each hour a record is written to the plasmatronic and retrieved by my weather server. These records are consolidated and uploaded once a day at 1AM in the morning.

Current database statistics:

Database collection started: 23/3/2008 Solar and UV collection started: 21/04/2008

Weatherstation database

Total weather database records: 37436
Collecting data for 160 days.

Solar and UV database

Total solar database records: 37434
Maximum UV index recorded: 9.90
Maximum Watts/m2 recorded: 1074
Longest solar light recorded: 12:36
Highest evaporation recorded: 6.00 mm
Shortest time recorded to get sun burned: 19.00 minutes
Collecting data for 162 days.

Plasmatronics database

Total plasmatronic database records: 1463
Max Wind AMP input (for an hour period): Ext 6.5
Max Solar AMP input (for an hour period): Int 8.4
Collecting data for 66 days.

Yesterday database

Total records in yesterday database: 106
Database size is: 17667888 bytes
or approx: 17 MB