|
|
|
|
|
|
by gideonparanoid
3348 days ago
|
|
|
That's great! I find cycling & its place in society to be a really interesting subject, & one which I take part in (cycling is my main mode of transport), encourage & engage (member of Leeds cycling campaign) with in a fair few ways. As a software dev, I'm particularly interested in the ways in which you found to apply your techical skills to the subject. What other ways do you you see of using those to further improve matters? |
|
|
From which I derived this spreadsheet (ongoing) : https://docs.google.com/spreadsheets/d/1zSLXKO0zRBHeHcunKv5B...
I then downloaded WU03EW MSOA data into this fusion table: https://fusiontables.google.com/DataSource?docid=1sNyIr6EGEE...
From which I've extracted values I am interested in.
However I find it painful to work with.
I now have a city to msoa lookup as well as the population centroids from the datashine commute site (thanks to them for providing them to me)
I am now looking at commuters within a city, those coming from the outside, as well as those travelling across the city.
In particular I'm seeing modal split analysis which indicates 100%+ levels of cycling than being used by the council for transport policy. This may be down to the fact Bath and North East Somerset is a mixed urban/rural county.
I need to find MSOA population densities per km2 (have a source please link!) to be able to determine if there is a correlation between low density and car use. (I suspect it is true given our poor public transport.)
I've now downloaded all the data into a Postgres db to allow me to play with it better and want to paint a national picture.
Once I have this done at MSOA level I want to look at doing this at LSOA level as the accuracy is that much better.