Welcome to the Cumulus Support forum.
Latest Cumulus release v1.9.4 (build 1099) - 28 November 2014
Latest Cumulus MX release v3.0.0 build 3047 - 03 February 2019. See the Wiki for download
Latest Cumulus release v1.9.4 (build 1099) - 28 November 2014
Latest Cumulus MX release v3.0.0 build 3047 - 03 February 2019. See the Wiki for download
Met Office Regional Data
Moderator: daj
- mcrossley
- Posts: 5374
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2
- Operating System: Stretch Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Met Office Regional Data
I've been having a play at displaying the Met Office historic data for my region - NW England and N Wales - and comparing it to my station data.
It's still a work in progress (like everything!) but what do you think?
https://weather.wilmslowastro.com/graphs_regional.php
It's still a work in progress (like everything!) but what do you think?
https://weather.wilmslowastro.com/graphs_regional.php
- beteljuice
- Posts: 2555
- Joined: Tue 09 Dec 2008 1:37 pm
- Weather Station: None !
- Operating System: XP SP3 - honest
- Location: Dudley, West Midlands, UK
Re: Met Office Regional Data
Very good Mark (as usual)
... but - the Met Office giving away free data
How long will that last ?


... but - the Met Office giving away free data

How long will that last ?
......................Imagine, what you will KNOW tomorrow !
- ConligWX
- Posts: 747
- Joined: Mon 19 May 2014 10:45 pm
- Weather Station: Davis Vantage Pro2 Plus
- Operating System: MeteoBridge Nano SD
- Location: Bangor, NI
- Contact:
Re: Met Office Regional Data
Nice one Mark, are you going to make this available to download at some point?
Regards Simon
https://www.conligwx.org - @conligwx
Davis Vantage Pro2 Plus - Meteobrige Nano SD + Saratoga Templates
https://www.conligwx.org - @conligwx
Davis Vantage Pro2 Plus - Meteobrige Nano SD + Saratoga Templates
- mcrossley
- Posts: 5374
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2
- Operating System: Stretch Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Met Office Regional Data
All the source should be viewable - no support on this one though. You can work out the regional data table structure I think!
-
- Posts: 366
- Joined: Wed 08 Jun 2011 11:19 am
- Weather Station: Davis Vantage Pro 2
- Operating System: GNU/Linux (Ubuntu 18.04)
- Location: Ystrad, Rhondda, Wales
- Contact:
Re: Met Office Regional Data
You can get a fair bit of data through their datapoint API. It's generated with public money so will always be free.beteljuice wrote: ↑Sun 25 Nov 2018 7:01 pmthe Met Office giving away free data![]()
How long will that last ?
-
- Posts: 559
- Joined: Sat 17 Dec 2011 11:55 am
- Weather Station: null
- Operating System: null
- Location: null
Re: Met Office Regional Data
This is brilliant - nice work, Mark!
I presume daydata is my Dayfile?
I presume you manually made the regional table and added in the data? Did it take long?
I presume daydata is my Dayfile?
I presume you manually made the regional table and added in the data? Did it take long?
- mcrossley
- Posts: 5374
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2
- Operating System: Stretch Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Met Office Regional Data
I cut and paste the data from the PDF into an Excel workbook (a sheet per data type), then "text to columns", then convert to table (and named each one)
I then added a summary sheet, and created a new table to list a year/month per row, with each dataset as a column.
Once you have that it is simple to insert into SQL using the bulk import CSV data feature - just make sure your columns are in the same order as the SQL table.
I then added a summary sheet, and created a new table to list a year/month per row, with each dataset as a column.
Once you have that it is simple to insert into SQL using the bulk import CSV data feature - just make sure your columns are in the same order as the SQL table.