Welcome to the Cumulus Support forum.

Latest Cumulus MX release v3.2.3 build 3059 - 04 December 2019.
    Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014

    See the Wiki for downloading either version.

    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: 5801
    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

    Post by mcrossley » Sun 25 Nov 2018 5:44 pm

    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: 2790
    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 » Sun 25 Nov 2018 7:01 pm

    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: 750
    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 » Sun 25 Nov 2018 8:48 pm

    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 + Saratoga Templates

    User avatar
    mcrossley
    Posts: 5801
    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

    Post by mcrossley » Sun 25 Nov 2018 9:02 pm

    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: 521
    Joined: Wed 08 Jun 2011 11:19 am
    Weather Station: Davis Vantage Pro 2
    Operating System: GNU/Linux (Ubuntu 18.04)
    Location: Dorrington, Shropshire
    Contact:

    Re: Met Office Regional Data

    Post by freddie » Sun 25 Nov 2018 9:07 pm

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

    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: 5801
    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

    Post by mcrossley » Mon 26 Nov 2018 7:46 pm

    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: 636
    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 » Sun 15 Sep 2019 3:15 pm

    Delete - wrong place.
    Image

    Post Reply