I'm currently logging grass temp, soil temp, soil moisture and leaf wetness to an SQL table, just for recent graphing purposes.
Does anyone know of a script, or have a way to log and extract daily highs/lows for that particular data?
Welcome to the Cumulus Support forum.
Latest Cumulus MX V4 release 4.0.0 (build 4022) - 11 May 2024
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.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 V4 release 4.0.0 (build 4022) - 11 May 2024
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.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
Do any exist?
-
- Posts: 2493
- Joined: Wed 08 Jun 2011 11:19 am
- Weather Station: Davis Vantage Pro 2 + Ecowitt
- Operating System: GNU/Linux Ubuntu 22.04 LXC
- Location: Alcaston, Shropshire, UK
- Contact:
Re: Do any exist?
I log the realtime values of some of those elements, and run a query at rollover to save values with their respective date/times to the day summary table.
- BeaumarisWX
- Posts: 376
- Joined: Mon 09 Apr 2012 2:38 pm
- Weather Station: Davis VP2 Plus - 24hr FARS
- Operating System: Windows 10 Pro Hades Canyon
- Location: Beaumaris, Tasmania, AU
- Contact:
Re: Do any exist?
Hi Freddie,
I do the same as Mapantz just upload to MySql (I do have some views I have off the main upload, however your rollover query day summary sounds perfect, any chance you could share same, would be greatly appreciated.
Kindest Regards,
Tony
Tony Beaumaris, Tasmania (AUS)
CMX Mobile : https://beaumaris-weather.com/BWX/
CMX Default: https://beaumaris-weather.com/cumulusmx_default/
Colour Dashboard : https://beaumaris-weather.com/dashborad_color.php
Click below for Saratoga Template :
CMX Mobile : https://beaumaris-weather.com/BWX/
CMX Default: https://beaumaris-weather.com/cumulusmx_default/
Colour Dashboard : https://beaumaris-weather.com/dashborad_color.php
Click below for Saratoga Template :
-
- Posts: 2493
- Joined: Wed 08 Jun 2011 11:19 am
- Weather Station: Davis Vantage Pro 2 + Ecowitt
- Operating System: GNU/Linux Ubuntu 22.04 LXC
- Location: Alcaston, Shropshire, UK
- Contact:
Re: Do any exist?
Hi Tony,BeaumarisWX wrote: ↑Mon 18 Apr 2022 12:44 amHi Freddie,
I do the same as Mapantz just upload to MySql (I do have some views I have off the main upload, however your rollover query day summary sounds perfect, any chance you could share same, would be greatly appreciated.
This is my end-of-day query:
Code: Select all
INSERT IGNORE INTO ExtraDayfile (LogDate,GrassMin,GrassMinTime,Depth30cmTemp) Values(str_to_date('<#metdateyesterday>', '%m/%d/%Y'), (select min(GrassTemp) from ExtraRealtime where LogDateTime >= str_to_date('<#metdateyesterday> 09:00:00', '%m/%d/%Y %H:%i:%s') and LogDateTime < str_to_date('<#shortyear>-<#month>-<#day> 09:00', '%Y-%m-%d %H:%i')), (select min(LogDateTime) from ExtraRealtime where GrassTemp = (select min(GrassTemp) from ExtraRealtime where LogDateTime >= str_to_date('<#metdateyesterday> 09:00:00', '%m/%d/%Y %H:%i:%s') and LogDateTime < str_to_date('<#shortyear>-<#month>-<#day> 09:00', '%Y-%m-%d %H:%i')) and LogDateTime >= str_to_date('<#metdateyesterday> 09:00:00', '%m/%d/%Y %H:%i:%s') and LogDateTime < str_to_date('<#shortyear>-<#month>-<#day> 09:00', '%Y-%m-%d %H:%i')), (select Depth30cmTemp from ExtraMonthly where LogDateTime = str_to_date('<#metdateyesterday> 09:00:00', '%m/%d/%Y %H:%i:%s')));
You may not wish to do exactly the same operations, but this code could be used as a starting point.