I believe that weewx updates the daily tables for each and every archive record processed rather than just doing a calculation once per day. Tom will correct me if I am wrong!! The end result should indeed equal the sum of the archive records. If you look at the day tables during the course of the day you will see that they contain the partial sums up to the point in time that you look at the table.
The number of 'rainy' records should not be affecting the counts - unless your system is behaving differently to mine - possibly because your station emits partial records. Do the other daily tables have counts of 95 or 96? Is it only rain which seems to count 'rainy' records rather than total records? Does your archive contain null when there is no rain during that archive period - or does it contain zero? This could explain the counting 'issue' if the archive contains null and not 0. On Thursday, 5 January 2017 14:04:20 UTC+2, [email protected] wrote: > The configuration of my station is base on a record every 15min, this > gives 96 records à day. > The archive_day_Rain shows a sum of 28 records for the 11/25, in the xls > file I also calculated the number of records in the day (95), the number of > 'rainy' records in the day (14). I never find the 28 records. > This is nbecause your weather statot explain the wrong dayliy Rain sum. > Normaly to have the rain quantity for a day, the system just do the sum of > Rain quantity of each record included in this day. > > Nb: i am sorry if m'y english is not so correct. I am french. > Lio > Envoyé de mon smartphone BlackBerry 10. > *De: *Andrew Milner > *Envoyé: *jeudi 5 janvier 2017 12:33 > *À: *weewx-user > *Répondre à: *[email protected] <javascript:> > *Objet: *[weewx-user] Re: Rain dailly total and NOAA rain total wrong > value > > Looking at my archive_day_rain table the count is usually = 288 which is > the number of archive records per day. I archive every 5 minutes (= 12/.hr > = 12*24/day = 288 per day) The sum = the total of the data from the > archive records for that day which starts at dateTime column > > > > On Thursday, 5 January 2017 13:22:46 UTC+2, [email protected] wrote: > >> >> >> Le jeudi 5 janvier 2017 10:49:44 UTC+1, Andrew Milner a écrit : >>> >>> So you are saying that the sum of the archived data in the archive table >>> for the calendar day does not equal the value in the sum column in >>> the archive_day-rain table? >>> >> Yes. >> >>> >>> Does the value in he count column of archive_day_rain contain the >>> correct number of archive records for the day which have been totalled to >>> form the sum value?? >>> >> No I get 14 then archive_day_rain gives 28. See in the xls files in >> attached. >> What is the link between the sum of rain in a day and the number of rain >> recorded in this day ? >> >> rds >> Lio >> >>> >>> >>> >>> >>> >>> On Thursday, 5 January 2017 10:41:03 UTC+2, [email protected] wrote: >>> >>>> Hello, >>>> Ok for this part of configuration. >>>> >>>> And concerning the sum of of the rain for a day, have you seen my >>>> remarks in my last post? >>>> in summary, the SQL file (weewx.sdb), is made of different tables. One >>>> is all the stored data (called archive), and others which are statistics >>>> calculated by weewx. >>>> >>>> When I calculate the rain fallen during a day from the stored data, >>>> this result which is closed to the other local weather station, is the >>>> half >>>> of the value calculated by weewx which is stored in the archive_day_rain >>>> table. From my point of view there is a mistake when weewx calculates the >>>> rain fallen during a day. >>>> >>>> rds >>>> lio >>>> >>>> >>>> >>>> Le jeudi 5 janvier 2017 04:46:38 UTC+1, Andrew Milner a écrit : >>>>> >>>>> If your database is metric then rain is in cm >>>>> If your database is metricwx then rain is mm >>>>> >>>>> Your NOAA report is, according to the title line above the table, in >>>>> mm - but the units are determined by the contents of the template and so >>>>> can easily be changed to other units by changing the template >>>>> appropriately. >>>>> >>>>> http://weewx.com/docs/customizing.htm#units >>>>> <http://www.google.com/url?q=http%3A%2F%2Fweewx.com%2Fdocs%2Fcustomizing.htm%23units&sa=D&sntz=1&usg=AFQjCNHIPWGJUzXyeLDRewYXGmH3AhHQZg> >>>>> >>>>> >>>>> >>>>> On Thursday, 5 January 2017 00:19:57 UTC+2, [email protected] wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> Le mercredi 4 janvier 2017 00:38:20 UTC+1, mwall a écrit : >>>>>>> >>>>>>> On Tuesday, January 3, 2017 at 5:47:04 PM UTC-5, lionel.sylvie wrote: >>>>>>> >>>>>>> This is the same corrections in the weewx.conf between versions. >>>>>>>> Where I can find the commits? >>>>>>>> >>>>>>> >>>>>>> the change to rain multiplier happened on 11 jun 2015: >>>>>>> >>>>>>> >>>>>>> https://github.com/weewx/weewx/commit/0bb7db1edc806caebe68357bc315ccf8674eea52 >>>>>>> >>>>>>> so it has been part of the ws23xx driver for some time now. >>>>>>> >>>>>>> the divide-by-ten happens only to data from the logger, so if you >>>>>>> are using record_generation=hardware you will definitely see a >>>>>>> difference, >>>>>>> but if you are using record_generation=software you will see a >>>>>>> difference >>>>>>> only when weewx has to do catchup. >>>>>>> >>>>>>> I compare all the versions of the WS23xx I used since 2.7, all are >>>>>> similar concerning the formula. The x10 in the commit above concern the >>>>>> wind speed which is included after the 2.7 version. >>>>>> >>>>>> To come back to my original question, it's concern not the generated >>>>>> data but the values shown in the NOAA files. >>>>>> In the file attached in this post NOAA of November, when we take the >>>>>> rain value for the 24 November 2016, this is 24.9mm. When we take the >>>>>> value >>>>>> in the database (weewx.sdb) for the same date ("1479942000" : Sat Nov 24 >>>>>> 2016 00:00:00 GMT+0100), the value is 2.486. Is it the same units? >>>>>> From a report of an official station close to mine (4-5kms), the >>>>>> cumul was 11.2mm. >>>>>> >>>>>> http://www.infoclimat.fr/observations-meteo/archives/24/novembre/2016/saint-martin-d-heres/00014.html >>>>>> >>>>>> When I do the sum of the rain falls during this same day (data taken >>>>>> in the archive table of weewx.sdb), I get 1.243 which is the half value >>>>>> form the archive_day_rain. Is it normal ? >>>>>> When I sum all the rain data for November 2016 coming from the >>>>>> archive (= 8.029) and compare to the sum of the archive_day_rain for >>>>>> November (=16.058) and the NOAA of November (=160.6mm), I get a double >>>>>> value for the archive_day_rain and NOAA. Is there any issue during the >>>>>> calculation of the archive ? >>>>>> >>>>>> rds >>>>>> Lio >>>>>> PS : After these all analysis, the archive_day_rain is in cm and the >>>>>> NOAA is in mm. True? then I get the explanation for the x10 between >>>>>> values >>>>>> of archive_day_rain and NOAA. >>>>>> >>>>>> -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/weewx-user/8bF5k9TlSZI/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected] <javascript:>. > 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]. For more options, visit https://groups.google.com/d/optout.
