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 manageable 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, updated in 5 minute increments.
  • Wind turbine and solar panel data, updated in 1 hour increments and uploaded once a day.

Weather Data

Initially only some of the important data is collected being:

  • Temperature
  • Humidity
  • Wind
  • Rain (reset of total rain is a 9AM each morning.)
  • Barometer

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)"

 

Wind turbine 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

Weather station database

This database stores the feeds received from the Davis Vantage Pro2 Plus weather station. You can say that this is the most important database.

All weather related graphs are generated from this database.

Total weather database records: 218776
Collecting data for 853days.

Solar and UV database

Total solar database records: 218776
Maximum UV index recorded: 16.00
Maximum Watts/m2 recorded: 1579
Longest solar light recorded: 13:52:00
Highest evaporation recorded: 8.50 mm
Shortest time recorded to get sun burned: 7.00 minutes
Collecting data for 853days.

Plasmatronics database

This database keep track of (well supposed to be), energy produced by the Wind-Turbine and the Solar panel.

Total plasmatronic database records: 11424
Max Wind AMP input (for an hour period): "Ext 0.8"
Max Solar AMP input (for an hour period): "Int 1.2"
Collecting data for 488 days.

Yesterday database

This database tracks the averages for the day, and the minimums and maximums for a day. This is used for the history graphs and should allow for faster processing.

Total records in yesterday database: 910
Database size is: 133581184 bytes
or approx: 128 MB