It's possible the errant values are in the daily summaries, but not the main archive table. The former is used for the NOAA reports, the latter for the WU posts.
I don't know your timezone, but I imagine something like this: select dateTime, datetime(dateTime, 'unixepoch', 'localtime'), rain from archive where dateTime > 1694822400 and dateTime <= 1694908800; select dateTime, datetime(dateTime, 'unixepoch', 'localtime'), sum from archive_day_rain where dateTime > 1694822400 and dateTime <= 1694908800; -tk On Sat, Jan 6, 2024 at 6:32 PM Ξ <fckyou...@gmail.com> wrote: > Hello Tom, > > I've posted above a link to the exact date I was comparing: > https://www.wunderground.com/dashboard/pws/I5302/table/2023-09-16/2023-09-16/daily > You can see there on September 16, 2023 the total precipitation is 9.14 mm > whereas WeeWx is showing "Today's Rain: 59,2mm" > > Here's also the PWS link for the same date: > https://www.pwsweather.com/station/pws/dolniokol?timespan=day&date=2023-09-16 > It's showing a total of 9.1mm > > If we look for the month of December: > PWS shows total of 41.7mm > https://www.pwsweather.com/station/pws/dolniokol?timespan=month&date=2023-12-01 > WU shows a total of 41.67mm > https://www.wunderground.com/dashboard/pws/I5302/graph/2023-12-7/2023-12-7/monthly > > However if I look at the weewx report it's over 100mm: > > MONTHLY CLIMATOLOGICAL SUMMARY for Dec 2023 > NAME: Dolni Okol > ELEV: 1010 meters LAT: 42-29.40 N LONG: 023-29.70 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 9.4 14.7 13:30 -1.1 00:18 8.6 0.0 0.0 0.6 6.6 > 11:58 326 > 02 7.6 17.5 15:23 2.7 20:58 10.4 0.0 0.0 0.1 3.3 > 14:38 325 > 03 4.9 12.0 00:26 -2.0 23:56 13.1 0.0 13.2 0.1 3.3 > 13:02 33 > 04 -2.3 11.7 15:39 -6.3 07:48 20.3 0.0 0.0 0.0 2.3 > 03:53 117 > 05 -0.8 1.4 14:51 -2.5 07:23 18.8 0.0 0.0 0.0 1.4 > 11:35 303 > 06 0.7 1.3 14:03 -0.1 00:00 17.3 0.0 0.4 0.0 0.6 > 02:03 307 > 07 0.3 3.7 11:02 -2.0 23:16 17.7 0.0 0.0 0.1 3.0 > 13:48 56 > 08 -2.3 -0.9 13:18 -3.8 22:07 20.3 0.0 0.0 0.0 0.0 > 00:00 90 > 09 -2.1 1.0 14:38 -4.4 05:04 20.1 0.0 0.0 0.0 0.9 > 14:42 161 > 10 -0.8 10.6 15:17 -4.0 05:44 18.8 0.0 4.0 0.0 2.3 > 13:02 316 > 11 0.3 7.2 14:56 -3.6 07:52 17.7 0.0 0.8 0.0 2.0 > 12:04 138 > 12 3.8 13.6 15:35 0.1 21:58 14.2 0.0 0.8 0.0 3.0 > 05:10 14 > 13 3.2 11.1 14:28 0.4 04:02 14.8 0.0 0.0 0.0 1.2 > 15:36 302 > 14 5.7 11.7 10:36 0.6 02:20 12.3 0.0 7.2 0.1 3.1 > 04:20 41 > 15 1.1 2.1 03:06 -0.7 23:56 16.9 0.0 42.0 0.0 2.8 > 05:17 56 > 16 -2.0 -0.5 13:54 -3.7 23:59 20.0 0.0 0.0 0.0 0.0 > 00:00 90 > 17 -5.7 0.5 13:58 -10.5 07:32 23.7 0.0 0.0 0.0 0.0 > 00:00 90 > 18 -3.0 9.9 15:34 -8.1 01:40 21.0 0.0 18.8 0.0 0.0 > 00:00 90 > 19 -0.9 12.1 15:20 -4.6 07:04 18.9 0.0 4.8 0.0 0.0 > 00:00 90 > 20 1.4 9.2 15:04 -5.2 06:31 16.6 0.0 5.2 0.1 2.6 > 16:48 315 > 21 1.0 10.6 15:13 -3.5 20:04 17.0 0.0 0.8 0.1 2.5 > 22:09 47 > 22 1.9 3.7 03:57 0.1 23:01 16.1 0.0 4.0 0.2 4.4 > 00:41 320 > 23 2.4 5.3 11:23 -0.5 17:43 15.6 0.0 0.8 0.3 4.5 > 21:58 348 > 24 6.4 13.5 15:33 3.1 06:08 11.6 0.0 0.0 0.2 4.2 > 16:06 337 > 25 8.7 17.6 15:33 2.6 23:45 9.3 0.0 0.0 0.2 3.2 > 14:08 331 > 26 6.8 16.6 15:18 -0.3 05:13 11.2 0.0 0.0 0.1 2.2 > 09:18 330 > 27 4.3 16.0 15:26 -1.4 23:57 13.7 0.0 0.0 0.0 2.8 > 01:21 51 > 28 2.6 18.6 15:55 -2.7 07:19 15.4 0.0 0.0 0.1 2.3 > 14:41 169 > 29 2.7 15.1 15:49 -2.0 05:40 15.3 0.0 0.0 0.0 2.0 > 13:05 162 > 30 1.9 8.7 13:26 -2.4 04:34 16.1 0.0 0.0 0.1 2.7 > 14:40 35 > 31 2.3 15.5 15:20 -1.2 08:30 15.7 0.0 0.0 0.0 1.8 > 11:30 177 > > ---------------------------------------------------------------------------------------- > 2.0 18.6 28 -10.5 17 498.6 0.0 102.8 0.1 6.6 > 01 342 > > Even though I know nothing I have the gut feeling the WS6in1 driver for > Bresser doesn't handle well buffered data or the station itself passes on > buffered data wrongly (but in either case PWS and WU discard those values)?! > > Also so sorry for the late reply here as well. > > Thanks, > Ivo > > On Thursday, September 21, 2023 at 2:45:20 AM UTC+3 Tom Keffer wrote: > > No. That's not enough clues to narrow it down. > > But, you say the "spike" is in the database, but not being uploaded to PWS > or Wunderground? Can you post your station ID for either/both? > > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/ff31b148-8915-4284-8585-b4e0cfdcf1c8n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/ff31b148-8915-4284-8585-b4e0cfdcf1c8n%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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEA%3DDrA%2BtdHtrf37nLF3ZEjKNLT76%2Bp1GPo4p5ycfnUe_g%40mail.gmail.com.
