Real time home furnace and temperature data
What's going on here?
This is essentially a realtime web mashup of the temperature and furnace usage in my home.
Gas furnace status (flame) is detected with a phototransistor wired to an old data aquisition board which passes collected data to a linux box via serial port.
Data is captured once every 5 seconds and stored in a mysql database.
The temperature data is gathered from a Lacrosse weather station* outside the house using Open2300.
A Google spreadsheet
pulls the data from a PHP script on my local web server which outputs in csv format.
The spreadsheet contains a google gadget which presents the data as a nifty graph.
The gadget is also embeddable in external web pages like the one you are viewing now.
Update: Looked into the timeline gadget docs and rewrote the page in a way that does not require Google Spreadsheet access.
12/9/2008 - Rolan Yang firstname.lastname@example.org
* the weather station kits are sold for about $80 at Costco