Snow map - help fill it in! « Singletrack Forum

Bike Forum

Snow map - help fill it in!

19 posts & 13 voices | Started 3 months ago by gee | Latest reply from gee

Tags:

No tags yet.

gee - Member

Hi

I'm a Geography teacher and would really appreciate your help if you live in the UK.

Please go outside and measure the depth of the snow at your house in cm.

Open this spreadsheet:

https://docs.google.com/spreadsheet/ccc?key=0Agsl0Wd0Ys37dDhhRXZyY1gwbUwwVVEzdDBkTVljZ3c

Fill in the first bit of your postcode as shown, then the snow depth at your house in cm. It will automatically fill in the lat/long column.

It saves automatically, so you can then just close it.

I am going to use the data to make a pretty map!

Thanks for your help,

GB

Posted 3 months ago #
munrobiker - Member

Have you enabled editing? I had a go and can't change it.

Posted 3 months ago #
gee - Member

I've now enabled editing....

Apologies.

GB

Posted 3 months ago #
Duffer - Member

Done, and done!

Posted 3 months ago #
theflatboy - Member

done

Posted 3 months ago #
lipseal - Member

done

Posted 3 months ago #
kitebikeski - Member

Done.

Where did the postcode/lat long lookup come from?

Posted 3 months ago #
gee - Member

There is a .csv file of postcode "first bits" and their corresponding lat/long on the internet somewhere - I googled it and found something and just wrote the vlookup.

GB

Posted 3 months ago #
Simwit - Member

Great idea, 'tis done

Posted 3 months ago #
mintimperial - Member

Clever!

Done.

Posted 3 months ago #
valleydaddy - Member

done

Posted 3 months ago #
cheez0 - Member

iv added a couple of observed locations where i was yesterday, but the snow has gone now.

needs a specific time snapshot to make it 'really geeky and scientific'

Posted 3 months ago #
bruk - Member

Done, can we see the final result?

Posted 3 months ago #
richmars - Member

Yes, done, and can we see the results (Really neat idea by the way).

Posted 3 months ago #
cheez0 - Member

can we do the same for orange five coverage of the uk?

i think i can see the picture in my head now!

Posted 3 months ago #
gee - Member

Here is the work in progress as of about 30mins ago:

Red = lots, green = none.

Posted 3 months ago #
Jase - Member

Done for MK7

Posted 3 months ago #
cheez0 - Member

hey that looks great!

how'd you plot that then plz?

Posted 3 months ago #
gee - Member

Using Google Fusion - I worked out how to do it using their tutorial. I had no idea that Google Fusion even existed at 8am today so the tutorials must be alright.

Posted 3 months ago #