You Bet - See Attached.....
On Thursday, March 16, 2017 at 7:29:20 AM UTC-7, Luc Heijst wrote: > > Hi Richard, > > Can you please share with us your script to export data frrom weewx to > meteotemplate? I don't like reinventing the wheel! -:) > > Luc > > On Monday, 11 April 2016 03:58:01 UTC-3, Richard Sears wrote: >> >> hank you both, it is clear to me now. I wrote a script that exports data >> from weewx to meteotemplate and today was the first time it has rained >> since I wrote it and no rain was showing up...now I understand why! >> >> Thanks Again >> >> On Sunday, April 10, 2016 at 11:46:46 PM UTC-7, gjr80 wrote: >>> >>> Yes, drop the 'highest'. wsum holds the running sum for the observation >>> concerned. It is updated every archive period. So for archive_day_rain, >>> wsum holds sum of the rain seen in all the archive records for that day. >>> The dateTime values used in the archive_day_xxxx tables is the dateTime of >>> midnight at the start of the day concerned. If you select the 'greatest' >>> dateTime value in the table then you have today's rainfall since midnight. >>> If you select some other dateTime then you have the total rainfall for the >>> day that started at dateTime. wsum for archive_day_rain is useful as it is, >>> but wsum for say archive_day_outTemp usually requires something like count >>> to work out an average outTemp for the day etc (ie wsum for outTemp is a >>> fairlly meaningless number by itself). >>> >>> Gary >>> >>> On Monday, 11 April 2016 15:54:49 UTC+10, Richard Sears wrote: >>>> >>>> humm...maybe I should not say highest, but instead this would give me >>>> the total daily rainfall since midnight... >>>> >>>> On Sunday, April 10, 2016 at 10:49:16 PM UTC-7, Richard Sears wrote: >>>>> >>>>> Andrew - >>>>> >>>>> Thanks! I got it now.... >>>>> >>>>> so this would always give me the highest rainfall since midnight: >>>>> >>>>> >>>>> mysql> SELECT wsum FROM weemx_archive_day_rain ORDER by dateTime >>>>> DESC LIMIT 1; >>>>> >>>>> >>>>> >>>>> >>>>> Correct? >>>>> >>>> -- 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.
<<attachment: weewx_to_meteo-zeus.php>>
