Welcome to the Cumulus Support forum.

Latest Cumulus MX release v3.0.0 build 3050 - 1 May 2019.
Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014

See the Wiki for downloading either version.

Yearly records table

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

Post Reply
User avatar
billy
Posts: 53
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: Oregon WMR200
Operating System: RPi jessie
Location: Perth, Australia

Yearly records table

Post by billy » Tue 13 Aug 2019 10:39 am

On my wish-list are some tables that are similar to the standard "this year's highs and lows" but document the values for this and each previous year. The rows would be years and the columns various max, min or totals. I'm guessing there would need to be separate tables for the various sorts of measures - eg temperature/humidity, rainfall, wind and pressure. And I would include some measures not in the "this year's" table, such as total rainfall and number of wet days.

The data would be extracted from a SQL database.

What I have in mind would be complementary to beletjuice's dayfile reader, but rather than focussing on days, months and seasons, it would focus on yearly records/values.

Before I go any further with this idea, I want to make sure I wouldn't be reinventing the wheel and therefore wasting my time. So do such tables/scripts already exist? That would be my preference :D but so far my searching hasn't discovered them.

User avatar
beteljuice
Posts: 2710
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: ex XP SP3 - now W10 laptop grr
Location: Dudley, West Midlands, UK

Re: Yearly records table

Post by beteljuice » Tue 13 Aug 2019 3:05 pm

It sounds rather like Yet Another Dayfile Reader

This isn't mysql, although Mark Crossley does have a version ...
Image
......................Imagine, what you will KNOW tomorrow !

User avatar
PaulMy
Posts: 1922
Joined: Sun 28 Sep 2008 11:54 pm
Weather Station: Davis Vantage Pro 2+ w/Envoy USB
Operating System: Windows-8
Location: Komoka, ON Canada
Contact:

Re: Yearly records table

Post by PaulMy » Tue 13 Aug 2019 4:03 pm

I have figured out how to get the data from mysql dayfile but getting it pretty is another thing www.komokaweather.com/mysql/yearly-data-test1.php

Enjoy,
Paul

User avatar
billy
Posts: 53
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: Oregon WMR200
Operating System: RPi jessie
Location: Perth, Australia

Re: Yearly records table

Post by billy » Wed 14 Aug 2019 9:23 am

beteljuice wrote:
Tue 13 Aug 2019 3:05 pm
It sounds rather like Yet Another Dayfile Reader
Yes exactly - except a focus on yearly extremes as the output rather than for days/months/seasons. I guess it could be done by adding a third page ("yearly") but the column formatting would be fundamentally different to the "daily" and "seasonal" pages which both have columns classifying months. Would adapting the current dayfile reader to deal with a different set of column classifications (eg all temperature related or rainfall or wind etc) be a step too far?
PaulMy wrote:
Tue 13 Aug 2019 4:03 pm
I have figured out how to get the data from mysql dayfile but getting it pretty is another thing www.komokaweather.com/mysql/yearly-data-test1.php
That's what I had in mind - and yes, extracting the values is the easy bit, the formatting being the real challenge - at least for the learning amateur.

I guess these two replies are really telling me there isn't anything out there "off the shelf" ;) . I am mainly driven by rainfall statistics that have useful/interesting yearly summaries which are not produced by the dayfile reader, so I will probably have a go at that first.

sutne
Posts: 16
Joined: Sun 14 Oct 2012 4:23 pm
Weather Station: Oregon Scientific WMR100
Operating System: Raspbian Jessie
Location: Mjølfjell, Voss, Norway

Re: Yearly records table

Post by sutne » Wed 14 Aug 2019 2:55 pm

billy wrote:
Wed 14 Aug 2019 9:23 am
I am mainly driven by rainfall statistics that have useful/interesting yearly summaries which are not produced by the dayfile reader, so I will probably have a go at that first.
I am also missing total rainfall for each year. With the latest version of Yet Another Dayfile Reader we have total for every month but not total for each year.
In fact there is nowhere in Cumulus we have this total, it only accumulates during the year, but at the end of the year it is reset for next year.

User avatar
beteljuice
Posts: 2710
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: ex XP SP3 - now W10 laptop grr
Location: Dudley, West Midlands, UK

Re: Yearly records table

Post by beteljuice » Wed 14 Aug 2019 3:39 pm

Re. YADR ...

It would be a bit of headache to code for Min / Max ALL data concurrently (and I've had enough headaches with it recently !) - perhaps in another eight years time :groan:

Presentation-wise I think it would be a new page / table and ....

... what's wrong with scrolling horizontally (can be done by scroll-bar AND / OR grab and swipe) ;)
Image
......................Imagine, what you will KNOW tomorrow !

User avatar
PaulMy
Posts: 1922
Joined: Sun 28 Sep 2008 11:54 pm
Weather Station: Davis Vantage Pro 2+ w/Envoy USB
Operating System: Windows-8
Location: Komoka, ON Canada
Contact:

Re: Yearly records table

Post by PaulMy » Wed 14 Aug 2019 4:00 pm

In fact there is nowhere in Cumulus we have this total, it only accumulates during the year, but at the end of the year it is reset for next year.
It is available from the Cumulus console [View] [This Year] and select the year in the year pull down, at least up to 2020 ;)
I presume the only way to get the yearly totals in a script or website is by extracting and calculating from dayfile or Mmyylog files.

Enjoy,
Paul

Post Reply