wh1080: db/tidy-observations annotate

annotate db/tidy-observations @ 7:9a14029b3782

- Wait longer (100msec) for a read, and reduce the number of retries to match. - Print out if we read OK after more than 1 attempt for diagnostic purposes.

author	Daniel O'Connor <darius@dons.net.au>
date	Thu, 11 Feb 2010 12:47:59 +1030
parents	9dab44dcb331
children

rev	line source
0 9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	1 /*
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	2 * $Id: tidy-observations,v 1.4 2010/01/03 03:03:17 grog Exp grog $
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	3 *
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	4 * Tidy up messed-up values returned from various stations.
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	5 */
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	6 USE weather
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	7 UPDATE remote_observations SET wind_gust = NULL WHERE wind_gust < 0;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	8 UPDATE remote_observations SET rain = NULL WHERE rain < 0;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	9 /* Never likely to go below this temperature here */
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	10 UPDATE remote_observations SET outside_temp = NULL WHERE outside_temp < -10;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	11 /* This one is 0° F, which must mean something special to Wunderground */
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	12 UPDATE remote_observations SET outside_dewpoint = NULL WHERE outside_dewpoint = -17.8;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	13 UPDATE remote_observations SET wind_gust = NULL WHERE wind_gust < 0;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	14 UPDATE remote_observations SET rain = NULL WHERE rain < 0;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	15 UPDATE remote_observations SET wind_speed = NULL WHERE wind_speed < 0;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	16 UPDATE remote_observations SET outside_humidity = NULL WHERE outside_humidity < 0;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	17 UPDATE remote_observations SET wind_direction = NULL WHERE wind_direction < 0;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	18 UPDATE remote_observations SET pressure_msl = NULL WHERE pressure_msl < 900 OR pressure_msl > 1100;
9dab44dcb331 Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz Daniel O'Connor <darius@dons.net.au> parents: diff changeset	19 UPDATE remote_observations SET outside_dewpoint = NULL WHERE outside_dewpoint < -20;