bad rain data

[Chris Thompstone]

Hi Guys,

1st thanks TK, got updated to latest version,

After a bit of messing, I think it's gone OK... will see...

Anyway if you look here:

http://rollestonpark.myzen.co.uk/Bootstrap/history.html

In March 18 there is a crazy rain figure.

If you then scroll to the NOAA data at bottom and click Mar 18, you see that on the 2nd March 18, there is some bad data.

Had a browse in the database and see this:

will need to zoom in.  How do I just set the total rain for 2nd mar 18 to zero?

Thanks

Chris

[Chris Thompstone]

Maybe you can't zoom on this file?

Sorry

[Chris Thompstone]

just trying something:

echo "SELECT * FROM archive_day_rain WHERE (sum > 4);" | sqlite3 weewx.sdb.old2

if I do this, it brings up the rows with big sums.

can I just do this:

echo "UPDATE archive_day_rain SET sum=NULL WHERE (sum > 4);" | sqlite3 weewx.sdb.old2

or will that not work? maybe sum=0 is better?

Thanks
Chris

[Andrew Milner]

I would suggest:

a) stop weewx

b) take a copy of database

c) sort out any bad data in archive table - not in archive_day_rain table.  set any unwanted rain to 0

d) drop daily tables with database utility

e) rebuild daily tables with database utility

f) delete all noaa files (they will be rebuilt on first report cycle)

g) restart weewx

[Chris Thompstone]

Thanks, that has fixed it.

It appears (i think), that you have to zero the rainRate also, else some strange figures appear.

This is where I had gone wrong I think.