Welcome to the Cumulus Support forum.

Latest Cumulus MX release v3.4.0 (build 3064) - 19 February 2020.
    Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014

    See the Wiki for downloading either version.

    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: 2149

    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: Cumulus MX
    Topic: Some Old Data Is Incorrect
    Replies: 8
    Views: 1393

    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: Cumulus MX
    Topic: Some Old Data Is Incorrect
    Replies: 8
    Views: 1393

    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: 1953

    Re: Tobys Pond?

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

    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: 4466

    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: Cumulus MX
    Topic: need some mysql help
    Replies: 3
    Views: 987

    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: 1996

    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: 3889

    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: 1944

    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: 5271

    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: 5271

    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: 5271

    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: 5271

    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: 5271

    Re: Monthly Records - Spot the additions...

    Hi Mark,

    I think your queries are just fine.

    Kerry