I sure do appreciate all the help!! OK, well I'll force a regeneration of all NOAA Monthly reports and see what happens. Gary suggested that might do it.
Many thanks to all. jjs On Friday, July 5, 2019 at 5:51:49 PM UTC-5, Thomas Keffer wrote: > > Forgot to include a NOAA report. Here's April's. Again, looks reasonable: > > MONTHLY CLIMATOLOGICAL SUMMARY for Apr 2019 > > > NAME: Hood River, Oregon > ELEV: 700 feet LAT: 45-41.16 N LONG: 121-33.96 W > > > TEMPERATURE (F), RAIN (in), WIND SPEED (mph) > > HEAT COOL AVG > MEAN DEG DEG WIND > DOM > DAY TEMP HIGH TIME LOW TIME DAYS DAYS RAIN SPEED HIGH > TIME DIR > --------------------------------------------------------------------------------------- > 01 52.9 63.9 13:05 42.8 05:43 12.1 0.0 0.00 0.0 13.0 > 17:19 84 > 02 54.5 61.6 13:51 48.8 06:56 10.5 0.0 0.00 0.0 2.0 > 17:32 90 > 03 52.0 58.1 16:42 47.0 06:52 13.0 0.0 0.00 1.6 18.0 > 15:28 282 > 04 50.2 57.7 16:00 43.8 06:40 14.8 0.0 0.07 0.3 9.0 > 00:10 1 > 05 48.0 52.3 16:34 42.0 23:58 17.0 0.0 0.15 0.9 20.0 > 13:18 273 > 06 44.2 52.0 16:20 37.9 02:25 20.8 0.0 0.40 0.2 10.0 > 16:17 218 > 07 45.8 52.7 12:53 42.5 06:00 19.2 0.0 0.91 0.9 17.0 > 11:40 224 > 08 46.6 52.6 17:16 43.3 04:29 18.4 0.0 1.01 0.2 12.0 > 23:44 275 > 09 48.0 53.1 16:36 44.7 23:59 17.0 0.0 0.09 3.8 27.0 > 16:07 279 > 10 47.5 52.1 16:15 42.9 04:39 17.5 0.0 0.09 4.1 24.0 > 00:54 281 > 11 48.7 53.5 15:47 45.2 08:14 16.3 0.0 0.22 2.0 18.0 > 02:57 281 > 12 51.7 59.1 14:19 46.9 06:37 13.3 0.0 0.01 1.4 20.0 > 14:21 280 > 13 46.8 51.4 11:00 43.9 23:00 18.2 0.0 0.16 4.6 26.0 > 11:05 284 > 14 44.6 50.9 14:35 40.8 23:40 20.4 0.0 0.04 1.3 27.0 > 02:55 277 > 15 44.7 56.0 16:00 32.3 06:10 20.3 0.0 0.02 0.1 11.0 > 17:10 287 > 16 50.5 58.2 14:15 43.4 06:40 14.5 0.0 0.03 0.9 18.0 > 14:30 280 > 17 53.7 61.9 16:35 48.2 04:55 11.3 0.0 0.01 1.5 20.0 > 15:55 280 > 18 59.0 75.8 15:35 41.9 06:15 6.0 0.0 0.00 0.0 13.0 > 14:35 291 > 19 59.7 64.2 00:05 54.9 06:15 5.3 0.0 0.00 0.4 14.0 > 07:30 275 > 20 > 21 > 22 > 23 > 24 > 25 > 26 > 27 > 28 > 29 > 30 > --------------------------------------------------------------------------------------- > 49.6 75.8 18 32.3 15 286.0 0.0 3.21 1.3 27.0 > 09 279 > > > > On Fri, Jul 5, 2019 at 3:47 PM Thomas Keffer <[email protected] > <javascript:>> wrote: > >> I don't see anything unusual. I was actually able to run wee_reports >> against it. This is what I got (ignore the station location... that's my >> station). Looks reasonable to me. >> >> [image: image.png] >> >> >> On Fri, Jul 5, 2019 at 3:06 PM shvman <[email protected] <javascript:>> >> wrote: >> >>> Maybe it's best to post the whole DB since there isn't much to it. jjs >>> >>> >>> >>> >>> On Friday, July 5, 2019 at 4:29:40 PM UTC-5, vince wrote: >>>> >>>> On Friday, July 5, 2019 at 12:38:30 PM UTC-7, Thomas Keffer wrote: >>>>> >>>>> It would be useful to see what actually ended up in the database. Use >>>>> the tool sqlite3 to do this (you may have to install). >>>>> >>>>> *sqlite3 weewx.sdb* >>>>> sqlite> *select dateTime, datetime(dateTime,'unixepoch','localtime'), >>>>> windSpeed, windDir from archive limit 20;* >>>>> >>>>>> >>>> >>>> one thing I normally do is add a second 'dateTime' to the end of the >>>> select statement, so you can see nulls (which aren't always visually >>>> obvious), as dateTime is always going to be there >>>> >>>> *select dateTime, datetime(dateTime,'unixepoch','localtime'), >>>> windSpeed, windDir, dateTime from archive limit 20;* >>>> >>>> >>>> >>>> -- >>> 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] <javascript:>. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/weewx-user/9894df53-d438-4f7b-a1dd-86401f900db5%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/9894df53-d438-4f7b-a1dd-86401f900db5%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- 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/bb6d3247-2bf0-4991-8e8b-70fe4e8598ba%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
