The database schema is described in the section *The database <http://www.weewx.com/docs/customizing.htm#The_database>* in the Customizing Guide. It also describes the field dateTime.
The field rain is the amount of rain that fell in that archive record. For an archive interval of, say, 5 minutes, this would be the amount of rain that fell during that 5 minutes. Also, see the Wiki article *Cleaning up old 'bad' data <https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data>*. It may help. -tk On Sun, Dec 22, 2019 at 2:51 PM Dana Roode <[email protected]> wrote: > Hello, > > I've had some issues with the rain collector on my Vantage Pro2 this year, > I replaced it a few weeks back. There were some spurious high readings, > plus my testing generated false readings. The data indicates over 60 > inches of rain in my desert location this year. I'd like to find the bad > values and zero them out, and I see how to do this with sqlite3 on the > database if I understood the data fields. "rain" is the field in the > archive tables, but I don't know what time period thats for. The dateTime > field has numbers like 1539650100 and I don't know how to convert to > something meanful. > > Is there documentation on the database schema and fields somewhere? I > haven't found it in the wiki information. > > Any pointers would be appreciated. > > Dana Roode > > -- > 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/f853d32c-80ce-4114-80a3-7313eb32234a%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/f853d32c-80ce-4114-80a3-7313eb32234a%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/CAPq0zECy%2Bmd6GPZOCcoMpLx3CKTPE2TZ7oLvgF6UaHp_%2B8%3D4-w%40mail.gmail.com.
