Andrew I used some of the posts in the thread I just cited and went looking for very negative temperature minima in other tables in addition to outTemp: archive_day_windchill and archive_day_dewpoint. I found records with bad minima in both and replaced them NULL. I have dropped the daily tables, checked that they were empty and am now rebuilding them. Let's see if this works.
Roberto On Thursday, December 13, 2018 at 1:25:19 PM UTC, Roberto Botero wrote: > > Hi Andrew > > Yes, have done both --drop and --rebuild as per the procedure in the link > I provided. I am going through the replies in this post of earlier > https://groups.google.com/forum/#!topic/weewx-user/fZtyq_cTyZ4 where you > helped a lot! > I think I have the same issue. > > Roberto > > On Thursday, December 13, 2018 at 12:49:30 PM UTC, Andrew Milner wrote: >> >> did you drop daily and rebuild daily after updating the archive?? >> >> if you did not do that try it (stop weewx first of course!!) >> >> >> >> >> >> On Thursday, 13 December 2018 13:03:21 UTC+2, Roberto Botero wrote: >>> >>> And for completeness the NOAA data for December this year shows the >>> offending dates. Is there a way to just delete those records from the >>> database and get things up and running again? >>> >>> MONTHLY CLIMATOLOGICAL SUMMARY for Dec 2018 >>> >>> >>> NAME: Petts Wood, Kent, England >>> ELEV: 79 meter LAT: 51-23.38 N LONG: 000-04.95 E >>> >>> >>> TEMPERATURE (°C), RAIN (mm), WIND SPEED (m/s) >>> >>> HEAT COOL AVG >>> MEAN DEG DEG WIND >>> DOM >>> DAY TEMP HIGH TIME LOW TIME DAYS DAYS RAIN SPEED HIGH >>> TIME DIR >>> --------------------------------------------------------------------------------------- >>> 01 10.2 12.6 16:25 6.9 01:40 4.3 0.0 4.3 0.6 6.3 >>> 12:20 254 >>> 02 13.4 14.8 12:25 11.8 00:05 2.6 0.0 2.3 1.2 7.2 >>> 09:55 252 >>> 03 10.3 13.7 11:55 3.6 00:00 4.3 0.0 3.0 0.8 8.5 >>> 12:05 251 >>> 04 4.5 7.6 14:10 0.8 08:15 7.5 0.0 1.0 0.0 1.8 >>> 20:25 248 >>> 05 10.1 12.3 13:55 5.5 00:30 4.4 0.0 3.6 0.4 5.4 >>> 12:50 236 >>> 06 11.6 12.8 23:15 10.0 02:55 3.5 0.0 0.0 0.9 7.2 >>> 16:35 258 >>> 07 9.9 13.0 02:30 6.5 20:25 4.5 0.0 6.3 1.4 9.4 >>> 06:25 253 >>> 08 9.4 11.4 14:10 7.6 00:05 4.8 0.0 4.6 1.8 8.9 >>> 02:50 257 >>> 09 8.5 9.8 06:25 5.3 22:25 5.3 0.0 1.5 0.6 8.9 >>> 03:15 252 >>> 10 7.0 8.7 13:15 5.6 00:20 6.1 0.0 0.0 0.1 3.1 >>> 01:45 245 >>> 11 4.0 8.5 13:35 -67.8 08:15 7.8 0.0 0.3 0.0 2.2 >>> 22:25 105 >>> 12 4.1 6.8 02:00 -67.8 05:25 7.7 0.0 0.0 0.2 4.5 >>> 14:05 103 >>> 13 2.2 2.5 01:05 1.5 02:05 8.8 0.0 0.0 0.3 3.1 >>> 00:05 112 >>> 14 >>> 15 >>> 16 >>> 17 >>> 18 >>> 19 >>> 20 >>> 21 >>> 22 >>> 23 >>> 24 >>> 25 >>> 26 >>> 27 >>> 28 >>> 29 >>> 30 >>> 31 >>> --------------------------------------------------------------------------------------- >>> 8.6 14.8 02 -67.8 11 71.6 0.0 26.9 0.7 9.4 >>> 07 253 >>> >>> >>> Thanks >>> >>> >>> Roberto >>> >>> -- 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.
