I know that this is a very old thread dating all the way back to 2021 but I have a very important update on the availability of online past weather data which I believe would be much better dealt with by bringing this particular thread back to life, rather than starting a brand new thread from scratch on which will basically just be the same subject.
The reason why I started this particular thread is because back in 2021, we lost what was a very good site in weathercast.co.uk which led to quite a good discussion on here about the fact that it was becoming more difficult as a result, to get available data for stations such as Kew Gardens in London or the botanic gardens in Edinburgh which had (and still has) a WMO number which starts with 99 rather than 03.
Over the years, I have continued to be able to get such data from weatherobs.com but even that site only gives you nothing more than the last week's worth of data which is very difficult to scrape by using a python script (I was eventually able to overcome that, but that was a very difficult task to achieve).
However, I am seeing signs now that we are starting to turn the corner in regards to that data being harder to get because with recent developments, I am starting to find that this is no longer the case now to the same extent. That all started when I noticed just recently that the site at roostweather.com which has been previously mentioned by others on this thread, now gives us quite extensive data for stations such as Kew Gardens or the botanic gardens in Edinburgh. For the botanic gardens in Edinburgh, that data still only goes back to 2011 and since that particular station has been around since around 1956, you are still only getting a small fraction of all of the available data from there even with that. Nevertheless, even that is still a vast improvement on the 7 days worth of data which you get for there from weatherobs.com, and is therefore very clearly a big step in the right direction.
However, I have just discovered one other thing which I believe to be so important that I thought that it was enough for this thread to be revived as a result. When you go onto ogimet.com, you can do a search for a particular station if you know at least part of its name. I did that search entering EDINBURGH as the search term which gave me a list of stations here in Edinburgh. To my astonishment, I discovered that the botanic gardens in Edinburgh was actually on that list despite it not having a WMO number which began with 03. What I discovered though, is that every major station has what is known as WIGOS ID which consists of 4 different parts to it. The first and third part of that is always '0' with the second part of that being a number which identifies which country that particular station is in. For here in the UK, that number is always 826 and this means that the WIGOS-ID for all of the major SYNOP stations in the UK is always "0-826-0-" followed by a number which uniquely identifies the station itself.
For Edinburgh Gogarbank, the WIGOS-ID is "0-826-0-88" whilst the WIGOS-ID for the botanic gardens in Edinburgh is "0-826-89". As another example, the WIGOS-ID for Kew Gardens in London is "0-826-0-127". It turns out in fact that instead of entering the WMO Code when you are looking up data on ogimet.com, you can enter the WIGOS-ID. When I did that for Edinburgh Gogarbank, I still got exactly the same data as I get whenever I'm entering its WMO code of 03166. In addition to that though, I then entered the WIGOS ID for the botanic gardens and to my astonishment, I discovered that I was actually able to get the data for there as a result. There wasn't as much data for there as there was for Gogarbank but the important thing here nevertheless, is that there was some data there and that I'm no longer limited to just a week's worth of that data.
That to me is quite a big breakthrough because this shows that you can now get data for stations such as the botanic gardens in Edinburgh or Kew Gardens on ogimet.net just in the same way that I can for stations such as Gogarbank even if that station doesn't have a WMO code that starts with 03, as long as you can find its WIGOS-ID. I then tried that at meteomanz.com and couldn't actually get any data from there for the botanic gardens in Edinburgh, but the record for that particular does exist on meteomanz.com, so my guess is that I might only be a matter of time before we start to get some data on that site as well for those particular stations.
As for ogimet.com, I found that with the data for the botanic gardens in Edinburgh, I could also link back to the raw SYNOP/BUFR data for that in the same way that I could for Gogarbank and for both of those stations, it turns out that the raw SYNOP/BUFR data is actually very similar with the only difference being that for the SYNOP data, '00000' is shown instead of any WMO code with those positions where there isn't the equivalent data being taken up by a series of forward slashes. Nevertheless, that should still be easy enough to decode with my python scripts so with that, I am hoping that I will be able to make more use of that by reporting more data on here for the botanic gardens as a result, especially as it is my actual local station here in Edinburgh.
The north of Edinburgh, usually always missing out on snow events which occur not just within the rest of Scotland or the UK, but also within the rest of Edinburgh.