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
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
- 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. ...
- 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...
- 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
- Wed 24 Feb 2016 1:27 am
- Forum: General
- Topic: Tobys Pond?
- Replies: 8
- Views: 3503
Re: Tobys Pond?
Thanks Paul.
- 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...
- 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...
- 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
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
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
Kerry
- 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
I'll give it a go.
Kerry
Re: 3D Moon
That is really neat!
- 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
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
- 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...
- 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...
- 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 ...
- 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
I think your queries are just fine.
Kerry