Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

average monthly temperature

Discussion of version 3 of Cumulus, which runs on Windows, Linux, and OS X. All Cumulus MX queries in here, please.
raffi79
Posts: 7
Joined: Wed Aug 02, 2017 4:04 pm
Weather Station: Davis
Operating System: Mac Os

average monthly temperature

Postby raffi79 » Mon Feb 05, 2018 10:34 am

Hi all of you,

could you please tell me where I can find the average monthly temperature in the cumulus files?

thanks in advance for your help!

dazza1223
Posts: 241
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: average monthly temperature

Postby dazza1223 » Mon Feb 05, 2018 11:57 am

what the tag files?

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

Re: average monthly temperature

Postby PaulMy » Mon Feb 05, 2018 2:22 pm

I don't believe the monthly average temperature is saved in a file by Cumulus. However, the Cumulus NOAA reports that you can set Cumulus to save daily and monthly have the mean temp. There are scripts to calculate average temp from the dayfile.txt file such as http://www.komokaweather.com/weather/be ... maryCU.php Or if you have your data in a MySQL file you can then also extract averages i.e. http://www.komokaweather.com/mysql/monthly-data.php

Enjoy,
Paul

raffi79
Posts: 7
Joined: Wed Aug 02, 2017 4:04 pm
Weather Station: Davis
Operating System: Mac Os

Re: average monthly temperature

Postby raffi79 » Tue Feb 06, 2018 11:49 am

I found that file dayfile.txt but could you paste overhere the script that helps me in showing the table like in the links you put in your reply?

Thanks for your help!

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

Re: average monthly temperature

Postby PaulMy » Tue Feb 06, 2018 12:26 pm

Hi Raffi,
I am just heading out the door until this evening and will then take a better look at the scripts. In the meantime. the Data Summary is by bettlejuice and you should be able to find it here on the forum. The monthly data is from my MySQL database where I import dayfile.txt once a day. Do you have that?

Regards,
Paul

sfws
Posts: 390
Joined: Fri Jul 27, 2012 11:29 am
Weather Station: Customised Fine Offset
Operating System: off-line Vista and W10 PCs
Location: UK

Re: average monthly temperature

Postby sfws » Tue Feb 06, 2018 7:38 pm

For Paul's http://www.komokaweather.com/weather/betel_datasummaryCU.php, the forum topic Paul (in his latest post) means is http://sandaysoft.com/forum/viewtopic.php?f=14&t=11397 - this PHP script works from Cumulus log 'dayfile.txt'. Latest Download on first post dated 01 Feb 2014 11:46.

An alternative, using Cumulus NOAA reports (Paul mentioned those in his earlier post) as the source for the figures, is available at http://weather.wildwoodnaturist.com/downloadsCVW.php, the relevant zip, readme, and example are dated March 11, 2015. Other alternative using NOAA reports is described on forum at http://sandaysoft.com/forum/viewtopic.php?f=14&t=5754 (Choose either PHP script or JavaScript version).

As Paul says, he also uses an alternative at http://www.komokaweather.com/mysql/dayfile/datatables/examples/server_side/dayfile-sql.php - that PHP script uses a database as source. For download source on forum see http://sandaysoft.com/forum/viewtopic.php?f=14&t=15983, you will see from my comments in that topic, that some of the total line in that output is not correctly populated in the official download. My database schema is unique to me, so I won't share my version of that day by day output script, nor my other script that shows various statistics output month by month, but simply say that if you become expert in programming in future, then you can do other options.

I leave Paul to respond on what he used for his http://www.komokaweather.com/mysql/monthly-data.php table output.

raffi79
Posts: 7
Joined: Wed Aug 02, 2017 4:04 pm
Weather Station: Davis
Operating System: Mac Os

Re: average monthly temperature

Postby raffi79 » Sat Mar 17, 2018 5:56 pm

Thank you very much for your help. It's done and works great!
I have one more question - do you think it's possible in some way to take the datas from Raspberry from January and Fabruary?
You do not have the required permissions to view the files attached to this post.


Return to “Cumulus MX”

Who is online

Users browsing this forum: No registered users and 5 guests