Curt Blank's
Milwaukee Weather Report
Vantage Pro VProWeather
Communications Software
VProWeather/mySQL DB Interface

Milwaukee Weather Timestamp

Now supports Vantage Pro2
With mySQL DB support! (23-Jan-2008)
New Database Version 11.2 (05-Sep-2011)
 
After weeks of design, coding, testing, and loading close to 3 years of Vantage Pro derived weather data, then reloading, and then reloading again, the VProWeather/MySQL Database and interface was released back in 2008. VProWeather now supports and directly interfaces with a MySQL Database. It directly updates the Real Time and Graph data downloaded from the Vantage Pro Console and stores it in the MySQL database. Daily Highs and Lows, Monthly Highs and Lows, and Yearly Highs and Lows are also automatically determined and stored in the Database.
 
In the spring of 2011 after a bit of neglect, vProWeather's MySQL's interface and database was given a facelift. A few bugs were fixed, columns were added to store additional data, to mention a few things. See the CHANGELOG for a comprehesive list of what was done.
 
All mySQL SQL scripts are included to create the Database, setup the Triggers on the various Tables, and setup additional Indexes for fast data retrieval. Click on the Thumbnail Image below for the Full Size View of the Database structure.
 
In addition, the Spring 2011 facelift includes some additonal utility type programs to populate the data of some of the new columns that were added. A program to load data that may have been gathered from a Vantage Pro or other weather station is also provided to load that data into the MySQL Database. And a conversion program is provided to format the data so that it can be loaded.
 
Current Version
v1.0.5   16 OCT-2011
Click Here to Download
md5 checksum here
View the Change Log here
Click Here to see Data Variable Names & Descriptions and Sample Data
 
Email me at: Weather[replace with(at)]curtronics.com with any questions.

This is an extension of Joe Jaworski's initial work, adding some functionality not in his initial work (Solar, ET, THSW UV, Leaf, Soil, etc.), and fixing some bugs.

Milwaukee Weather Current Conditions Milwaukee Weather Radar Milwaukee Weather Graphs Milwaukee Weather Archives
Milwaukee Weather Temperature Charts Milwaukee Weather Rain Data Milwaukee Weather Wind Data Milwaukee Solar Radiation Data

All content Copyright © Curtronics.com Curtis J. Blank -- May not be used in any form without permission
Tux, the Dancin' Fool - Hit ESCAPE to stop the dancin' Best yet! Apache Web Server Tux, the Dancin' Fool - Hit ESCAPE to stop the dancin'