Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024

Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

Search found 252 matches

by tobyspond
Fri 15 Apr 2016 12:01 am
Forum: General
Topic: Moving Home what have other people done?
Replies: 9
Views: 3861

Re: Moving Home what have other people done?

Hi David, We moved almost 300 miles (~480 km) north late last year and I started from scratch, no website up and running yet. I had five years of data too and hate not to be able to use it. I'm afraid with the difference in weather conditions, you will have to start again. Good luck with your move. ...
by tobyspond
Sun 10 Apr 2016 3:34 pm
Forum: CumulusMX Beta (releases up to b3043 ONLY)
Topic: Some Old Data Is Incorrect
Replies: 8
Views: 2880

Re: Some Old Data Is Incorrect

Hi Mark, Try this: SELECT year(x.LogDateTime) as year, month(x.LogDateTime) as month, day(x.LogDateTime) as day, q.hour, x.hrlyRain FROM ( SELECT a.LogDateTime, max(a.Raincounter - b.RainCounter) as hrlyRain FROM Monthly a, Monthly b WHERE a.raincounter-b.raincounter>0 AND b.LogDateTime = Date_Sub(a...
by tobyspond
Sun 03 Apr 2016 6:46 pm
Forum: CumulusMX Beta (releases up to b3043 ONLY)
Topic: Some Old Data Is Incorrect
Replies: 8
Views: 2880

Re: Some Old Data Is Incorrect

Mark, change the group by to group by hour(x.logdatetime) SELECT x.LogDateTime, Max(x.hrlyRain) FROM ( SELECT a.LogDateTime, a.Raincounter - b.RainCounter as hrlyRain FROM Monthly a, Monthly b WHERE b.LogDateTime = Date_Sub(a.LogDateTime, Interval 1 HOUR) ) AS x GROUP BY hour(x.logdatetime ) Kerry
by tobyspond
Wed 24 Feb 2016 1:27 am
Forum: General
Topic: Tobys Pond?
Replies: 8
Views: 3503

Re: Tobys Pond?

Thanks Paul.
by tobyspond
Wed 24 Feb 2016 12:41 am
Forum: General
Topic: Tobys Pond?
Replies: 8
Views: 3503

Re: Tobys Pond?

Hi Mark, Thanks for asking. I'm still on this planet:). We moved from Massachusetts to Maine, two degrees of latitude north, a couple of months ago. As you may imagine, we have been busy with the move, packing and unpacking, and just settling in. I do have my weather station up and running and repor...
by tobyspond
Tue 08 Sep 2015 12:54 pm
Forum: Web site - General
Topic: Climatology for a given day
Replies: 17
Views: 8910

Re: Climatology for a given day

Is this what your are looking for? SELECT year(logdate) as year, month(logdate) as month, day(logdate) as day, maxtemp, tmaxtemp, mintemp, tmintemp, round(avgtemp,1) as avgtemp, lowwindchill, tlowwindchill, highheatind, thighheatind, highhum, thighhum, lowhum, tlowhum, highdewpoint, thighdewpoint, l...
by tobyspond
Sat 20 Jun 2015 11:40 pm
Forum: CumulusMX Beta (releases up to b3043 ONLY)
Topic: need some mysql help
Replies: 3
Views: 1927

Re: need some mysql help

Beau,

This should get you started:

SELECT maxtemp, monthname(logdate), day(logdate), year(logdate) from dayfile order by maxtemp desc limit 1

You will need a query for each variable. Mark may have a more elegant method.

Kerry
by tobyspond
Tue 27 Jan 2015 10:53 am
Forum: Weather
Topic: Snow
Replies: 8
Views: 4049

Re: Snow

As of 5:30 am (EST), we have approx. 14 inches of snow here in eastern Massachusetts. An accurate measurement is difficult due to drifting, so the 14 inches represents an average.

Kerry
by tobyspond
Sun 07 Dec 2014 9:53 pm
Forum: SteelSeries Gauges
Topic: Brave Souls Required
Replies: 21
Views: 8227

Re: Brave Souls Required

Hi Mark,

I'll give it a go.

Kerry
by tobyspond
Wed 05 Nov 2014 12:31 am
Forum: General
Topic: 3D Moon
Replies: 8
Views: 3488

Re: 3D Moon

That is really neat!
by tobyspond
Mon 29 Sep 2014 4:13 pm
Forum: Web site - General
Topic: Monthly Records - Spot the additions... And New Wind Rose
Replies: 31
Views: 9765

Re: Monthly Records - Spot the additions...

Hi Mark,

Your windrose is looking good!

Yes, MySQL does not handle crosstabs well at all! You may not need the windbearingsym IN but in order to get jpgraphs to display the windrose properly, I need to include it in my query.

Kerry
by tobyspond
Mon 29 Sep 2014 1:19 pm
Forum: Web site - General
Topic: Monthly Records - Spot the additions... And New Wind Rose
Replies: 31
Views: 9765

Re: Monthly Records - Spot the additions...

Mark, You are correct, you do not need the grouping day(logdatetime) This should do it: Select ws, sum(if(windbearing >=348.75 and windbearing <=360 or windbearing >=0 and windbearing <11.25,percent,0)) as 'N', sum(if(windbearing >=11.25 and windbearing <33.75,percent,0)) as 'NNE', sum(if(windbearin...
by tobyspond
Mon 29 Sep 2014 12:16 pm
Forum: Web site - General
Topic: Monthly Records - Spot the additions... And New Wind Rose
Replies: 31
Views: 9765

Re: Monthly Records - Spot the additions...

Hi Mark, I'll take a look at what you need. If I understand, you want to reverse the columns and rows in my query such that the wind speeds are rows and the directions are the columns and you want to have the directions in numeric order (I think and order by should take care of that). Yes, the count...
by tobyspond
Sun 28 Sep 2014 9:33 pm
Forum: Web site - General
Topic: Monthly Records - Spot the additions... And New Wind Rose
Replies: 31
Views: 9765

Re: Monthly Records - Spot the additions...

The windrose looks nice. One of these days I'll have to make the switch from JPgraphs to HighCharts or RGraph. To deal with missing data, I set the default in the MySQL table to NULL. I have not revisited this code in awhile and it is built for JPGraph, but here's the code I use (I use mph): Select ...
by tobyspond
Sun 28 Sep 2014 4:16 pm
Forum: Web site - General
Topic: Monthly Records - Spot the additions... And New Wind Rose
Replies: 31
Views: 9765

Re: Monthly Records - Spot the additions...

Hi Mark,

I think your queries are just fine.

Kerry