A charting example using weather data from a MySQL database populated by the VWSql utility.

Data was populated into a MySQL database running on a Linux system, using the VWSql utility that feeds data from VWS, the Virtual Weather Station (running on a Windows98 box connected to an Oregon Scientific WMR968 weather station). A Perl script was then written to walk through the main data table and populate an aggregate database table with the recorded highs and lows by date. The sample Perl DBI script is here (caveat: spot testing shows 99% accuracy - still under development). MS Excel was then used with the MySQL ODBC driver (running on a Windows XP Pro box) to query the aggregate table to generate the above quick n' dirty graph (caveat: Excel may have dropped data points). The schema of the aggregate data table (bc_temp) is shown below: 
Field Type Null Key Default
Rec_Date Date   PRI 0000-00-00
RecDate varchar(13) YES   NULL
hitemp float(7,3) YES   NULL
hitime varchar(4) YES   NULL
lotemp float(7,3) YES   NULL
lotime varchar(4) YES   NULL
dirty char(1) YES   NULL
Further development is expected soon utilizing Perl charting modules (under research) for natively generating charts via cronjobs on the Linux box. Learning Perl from the seat of my pants!

Visits to Boulder Creek Weather

Copyright 2002 All rights reserved Boulder-Creek.com. 
Unauthorized duplication or distribution is prohibited.
Never base important decisions on this or any weather information obtained from the Internet
Updated Automatically by Ambient Software's Virtual Weather Station  Version 12.07

Send comments to webmaster@boulder-creek.com.

Revised: 19 Aug 2004 00:21 -0700