Welcome to the Cumulus Support forum.

Latest Cumulus MX release 3.6.10 (build 3086) - 24 June 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)

See the Wiki to download the software or click on the Downloads link in the Forum Banner.

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: 6583
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: 2950
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: ex XP SP3 - now W10 laptop grr
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: 759
Joined: Mon 19 May 2014 10:45 pm
Weather Station: Davis VPro2 Plus +DFARS
Operating System: MeteoBridge Nano SD
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 - Meteobrige Nano SD + CumulusMX + Saratoga Templates

User avatar
mcrossley
Posts: 6583
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: 762
Joined: Wed 08 Jun 2011 11:19 am
Weather Station: Davis Vantage Pro 2
Operating System: Ubuntu 18.04 (LXC container)
Location: Dorrington, 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: 747
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: 6583
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: 747
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