Page 1 of 1

Met Office Regional Data

Posted: Sun 25 Nov 2018 5:44 pm
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

Re: Met Office Regional Data

Posted: Sun 25 Nov 2018 7:01 pm
by beteljuice
Very good Mark (as usual) :clap: :clap:

... but - the Met Office giving away free data :o
How long will that last ?

Re: Met Office Regional Data

Posted: Sun 25 Nov 2018 8:48 pm
by ConligWX
Nice one Mark, are you going to make this available to download at some point?

Re: Met Office Regional Data

Posted: Sun 25 Nov 2018 9:02 pm
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!

Re: Met Office Regional Data

Posted: Sun 25 Nov 2018 9:07 pm
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.

Re: Met Office Regional Data

Posted: Sun 25 Nov 2018 11:48 pm
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?

Re: Met Office Regional Data

Posted: Mon 26 Nov 2018 7:46 pm
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.