Thanks Gary, much appreciated. I just found the wiki https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data and used that to delete the data, yes it was today. Will rebuild the daily summaries now.
I used 'null' so there is just nothing in those parts of the table (rather than 0.0 in the rest) - does that matter? Colin On Wed, 31 Mar 2021 at 19:20, gjr80 <[email protected]> wrote: > If you know it definitely didn't rain in the archive periods concerned > then use 0.0, if it did rain but you don't know how much then you could use > None to indicate no rainfall data for those periods. Or you could just use > 0.0 for the lot, not really going to make too much difference at the end of > the day. None values may show a gap in your day rain plot, zeros will not. > > Also, don't forget to rebuild your daily summaries for the day concerned > once you have fixed the data. Assuming it is today there will be no need to > rebuild any NOAA reports, if it was an earlier month/year you would need to > delete from that month/year onwards to force regeneration. > > Gary > > On Wednesday, 31 March 2021 at 15:25:09 UTC+10 [email protected] wrote: > >> OK, so used epoch time to find the records I want to delete (with rain >> and rainRate), now do I just delete them or do they need to be replaced by >> null (or 0.0?). I may need a hand with the correct syntax for that please >> >> *pi@wduino*:*~ $* echo "SELECT rainRate FROM archive WHERE (dateTime > >> 1617159600);" | sudo sqlite3 /var/lib/weewx/weewx.sdb >> >> 0.0419816511200587 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 279.980998292116 >> >> 247.545269518011 >> >> 19.3118544276522 >> >> 13.7807155122679 >> >> 5.58392519958292 >> >> 0.957907401564173 >> >> 4.75823850308484 >> >> 5.67484207064662 >> >> 0.84798164620346 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> 0.0 >> >> *pi@wduino*:*~ $* >> >> On Wed, 31 Mar 2021 at 18:05, Colin Larsen <[email protected]> wrote: >> >>> I'm thinking that the easiest road here is to delete (or null??) all of >>> todays rain data. So that would be 'rain' and 'rainRate'? >>> >>> Thanks >>> Colin >>> >>> On Wed, 31 Mar 2021 at 17:44, [email protected] <[email protected]> >>> wrote: >>> >>>> It's not my week lol! >>>> >>>> Now that I've rebuilt Weewx my weather station decided to go rogue and >>>> tell me it rained about 500mm in the last hour. I've stopped it thinking >>>> it's raining but now how do I get rid of the rogue data from the database >>>> in Weewx? I did a search for all kinds of database issues here but my >>>> search fu is failing me. >>>> >>>> Cheers for any help (and yes I have no doubt it's easy!) >>>> >>>> Colin >>>> >>>> -- >>>> 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 [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/weewx-user/ce3e4ec1-e936-487e-8df8-ebd96d376619n%40googlegroups.com >>>> <https://groups.google.com/d/msgid/weewx-user/ce3e4ec1-e936-487e-8df8-ebd96d376619n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/18b79bfa-91e7-47dd-ba1d-2d894401fb1en%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/18b79bfa-91e7-47dd-ba1d-2d894401fb1en%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CACjxfUvtnwn29fM-zt545RBtoKGrDUKoubehWF-A5xGw4yZZnw%40mail.gmail.com.
