Welcome to the Cumulus Support forum.

Latest Cumulus MX release 3.7.0 (build 3089) - 28 July 2020 (please see important announcement regarding releases since 3.5.0)
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 the NOAA report and Snow Index drop-down menus to 2030)

Use this link to Download the Software (Cumulus MX / Cumulus 1 and other related items). Software

Met Office Regional Data

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

Post Reply
User avatar
mcrossley
Posts: 6752
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Buster Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Met Office Regional Data

Post by mcrossley »

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

User avatar
beteljuice
Posts: 2974
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: W10 - Threadripper 16core, etc
Location: Dudley, West Midlands, UK

Re: Met Office Regional Data

Post by beteljuice »

Very good Mark (as usual) :clap: :clap:

... but - the Met Office giving away free data :o
How long will that last ?
Image
......................Imagine, what you will KNOW tomorrow !

User avatar
ConligWX
Posts: 796
Joined: Mon 19 May 2014 10:45 pm
Weather Station: Davis vPro2 Plus +DFARS
Operating System: Ubuntu / Windows 10
Location: Bangor, NI
Contact:

Re: Met Office Regional Data

Post by ConligWX »

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 + DFARS • WeatherLink Live • CumulusMX • Saratoga Templates •

User avatar
mcrossley
Posts: 6752
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Buster Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Met Office Regional Data

Post by mcrossley »

All the source should be viewable - no support on this one though. You can work out the regional data table structure I think!

freddie
Posts: 799
Joined: Wed 08 Jun 2011 11:19 am
Weather Station: Davis Vantage Pro 2
Operating System: GNU/Linux Ubuntu 18.04 LXC
Location: Alcaston, Shropshire, UK
Contact:

Re: Met Office Regional Data

Post by freddie »

beteljuice wrote:
Sun 25 Nov 2018 7:01 pm
the Met Office giving away free data :o
How long will that last ?
You can get a fair bit of data through their datapoint API. It's generated with public money so will always be free.
Freddie
Image

Mapantz
Posts: 766
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 10 x64
Location: Dorset - UK
Contact:

Re: Met Office Regional Data

Post by Mapantz »

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?
Image

User avatar
mcrossley
Posts: 6752
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Buster Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Met Office Regional Data

Post by mcrossley »

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.

Mapantz
Posts: 766
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 10 x64
Location: Dorset - UK
Contact:

Re: Met Office Regional Data

Post by Mapantz »

Delete - wrong place.
Image

Post Reply