Thanks for reply Tom, I did this: sudo /etc/init.d/weewx stop cp /home/weewx/archive/weewx.sdb /var/tmp/backup.sdb echo "UPDATE archive SET extraTemp1=NULL WHERE (extraTemp1 > 50);" | sqlite3 /var/tmp/backup.sdb sudo cp /var/tmp/backup.sdb /home/weewx/archive/weewx.sdb sudo /etc/init.d/weewx start echo "SELECT * FROM archive WHERE (extraTemp1 > 50);" | sqlite3 /home/weewx/archive/weewx.sdb no results found
Wait for Weewx: Jan 30 18:57:03 pyzero weewx[1237]: restx: StationRegistry: Published record 2019-01-30 18:51:59 GMT (1548874319) Jan 30 19:00:20 pyzero weewx[1237]: manager: Added record 2019-01-30 19:00:00 GMT (1548874800) to database 'weewx.sdb' Jan 30 19:00:21 pyzero weewx[1237]: manager: Added record 2019-01-30 19:00:00 GMT (1548874800) to daily summary in 'weewx.sdb' Jan 30 19:00:44 pyzero weewx[1237]: cheetahgenerator: Generated 16 files for report StandardReport in 22.80 seconds Jan 30 19:00:58 pyzero weewx[1237]: imagegenerator: Generated 24 images for StandardReport in 13.05 seconds Jan 30 19:00:58 pyzero weewx[1237]: copygenerator: copied 14 files to /home/weewx/public_html Jan 30 19:01:02 pyzero weewx[1237]: ftpgenerator: ftp'd 54 files in 4.06 seconds echo "SELECT * FROM archive WHERE (extraTemp1 > 50);" | sqlite3 /home/weewx/archive/weewx.sdb 1548874319|1|5|29.7418113163833|29.65696644625|29.7287245690177|64.4|32.54|50.0|84.0|3.13171859271503|180.0|4.47388370387861||0.0||28.2528638899494|29.7479396035033|32.54||||102.884|||||||||||||||||100.0|||||||||||0.0| 1548874619|1|5|29.7507267496848|29.6658254425|29.7376030647443|64.04|32.36|51.0|84.0|3.13171859271503|180.0|3.80280114829682||0.0|0.0|28.0764477571856|29.5436989829887|32.36||||102.884|||||||||||||||||100.0|||||||||||0.0| The initial spike is showing again. This occurred originally before i converted the data to Centigrade (see update to my original post). [image: Screenshot from 2019-01-30 19-12-48.png] -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.