Map of Latitude

Open Data Incubator

Welcome to our Open Data Incubator! Here we’ll show you how to create a data visualisation using Met Office Open Data.


In this exercise you will create an interactive map of recent weather observations using Met Office open data. You can decide what data to display and how it should be displayed. When you have finished you can also publish your map on the web or send it to your friends.

To do this you will be using Google Fusion and you will need an Internet connection, a web browser, Microsoft Excel or equivalent, and a Google account. You can create your own free account if you do not already have one: https://accounts.google.com/SignUp.

1. Download Met Office observation data

To download Met Office observation data go to the data.gov.uk website http://data.gov.uk/metoffice-data-archive. This data is licenced using an Open Government Licence. This means that anyone is free to download, use, and re-use it for any purpose.

In the Query Type drop down box select “Observation Data”. This will automatically update Site Code to “All Observation Sites” and Date of Issue to today’s date.

Next click Search and the data will automatically download to your computer as a CSV file that you can open in Excel. Rename this file “Recent Weather Observations UK”.

Screenshot of data entry fields for Download Met Office Data

2. Create a Google Fusion table

Open a web browser and go to https://www.google.com/fusiontables/. (Create a free Google Account if you do not already have one https://accounts.google.com/SignUp.)

Click on “Create A Fusion Table

Screenshot of Create a Google Fusion table

Select “From This Computer” and click “Browse” to find the “Recent Weather Observations UK” file that you saved to your computer. Make sure that Separator Character “Comma” and Character Encoding “UTF-8” are selected, and then click Next.

Screenshot of data entry fields for Google Fusion Import New Table

Click “Next” again.

Screenshot of Google Fusion Import New Table screen 2

In the Table Name field add the title “Recent Weather Observations UK” and then click “Finish”.

3. Display weather observation data on a map

Select the “Map of Latitude” tab.

You can now:

  • Zoom in using the tool on the left of the map, then click on one of the red circles. See what information is being displayed about that weather station.
  • Click “Change Info Window” and select all the weather observation variables that you would like to see when you click on a station.
  • Click on “Change feature styles” and select how you would like each of the weather stations to appear on the map.

Now click on one of the weather station icons and see if it is how you want it to appear. Once you are finished click “Done” in the top right of the screen.

Screenshot of Map of Latitude

4. Publish your weather observation map

Congratulations you have just created an interactive map of recent weather observations. If you would like to share this with other people you can publish the map to the web by clicking “Tools” on the menu bar, and then select “Publish”.

5 thoughts on “Open Data Incubator”

  1. ณ บัดนาว การทำ seo กับทาง
    google นั้น ลำบากกว่าแต่ก่อนมาก จากที่แต่เดิมลำบากแค่ยิงลิ้งค์ เข้าบล็อกเยอะและเร็ว ก็ติดอันดับกูเกิ้ลแล้ว แต่ขณะนี้ มันไม่ได้เป็นแบบเดิมแล้ว เทคนิคการทำ seoกับ
    Google ได้เปลี่ยนไป การยิงลิ้งค์ เข้าblogไซต์แบบแต่ก่อน ไม่ส่งผลดีต่ออันดับ
    กลับส่งผลเสียหายอย่างมาก ทำให้อันดับหายไปจากระบบ และการทำให้กลับมานั้น แทบจะเป็นไปไม่ได้

  2. Wow look at you then yes there is a difference you look better and happier for sure but you were a looker then and are still now but i prefer you now in all your vintage glory -Seen the pic on Facebook about the fair, can not wait to see the post about it Have a good weekend Ariane xxxx

  3. "son frère musicien qui joue du triangle dans une fanfare du nord de Londres" T'as la grande forme Marc,ça te fait du bien le soleil australien :-) Et moi, je me retrouve avec des crampes d'estomac et des glandes lacrimales vidées… :-) Forza Rodger, Stan & Marco !!!

Leave a Reply to Velvet Cancel reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>