I imported years of data from wunderground into my weewx db. There was a period of very bad rain data due to a malfunctioning tipping bucket. Also had a day where a small grasshopper managed to get into the little hole, then proceeded to rack up about 15 inches of rain for me that day while trying to escape.
I stopped weewx, made a copy of my db, then used sqlite browser to remove all of the bad rain data, day by day, week by week. When I was satisfied, I restarted weewx and life was good. It wasn't until a month later, while flipping through some of my past data that I realized I had somehow managed to remove much more data than I wanted to. I mean, we're talking like a year's worth of rain data. I don't want to import those days all over again, but I can if that's the only way. I'd much rather like to find a way to "bring over" the rain from the saved database for a range of dates, then start the fixing process again. When I brought the data over from wunderground, there were lots of dew point/humidity and temperature anomolies I had to fix as well. My question: Is there a way (perhaps using the sqlite browser) to import a column (rain) from one database (the saved one) to the new database for just a range of dates? Thanks in advance! -- 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/CAC5oUmN6qQVrx0YTCLHhkKRdxJAg7%3DEjtcwDkudBO8bzJm956A%40mail.gmail.com.
