{"id":5914,"date":"2021-08-12T19:18:00","date_gmt":"2021-08-12T19:18:00","guid":{"rendered":"https:\/\/davelevy.info\/wiki\/?p=5914"},"modified":"2024-08-15T08:55:57","modified_gmt":"2024-08-15T08:55:57","slug":"visualising-london-data","status":"publish","type":"post","link":"https:\/\/davelevy.info\/wiki\/visualising-london-data\/","title":{"rendered":"Visualising London data"},"content":{"rendered":"

I wanted to say something simple about the cost of desk space in London and made it complicated. I made a map showing relative costs, this is how. <\/p>\n

Desk Rental<\/h3>\n

First get some data, here’s realla<\/a> with 2019 data from which I have made a spreadsheet and chart<\/a>.<\/p>\n

\"\"<\/a><\/p>\n

I think these costs are ground rent only, inc. of basic utilities but not including IT or Telco costs. (Let’s say \u00a335 p.m. for the telco and \u00a350 pm for the laptop, but these are not included in the charts).<\/p>\n

Then the Mayor & GLA have made a mapping display tool, this is available here<\/a>. I have transcribed my data to a sheet<\/a> using this as a template. It has the instructions within the sheet and I have produced this map.<\/p>\n

\"\"<\/a>
Cost of office desk rental (London 2018)<\/figcaption><\/figure>\n

\"\"<\/a><\/p>\n

It doesn’t really tell you anything that’s not obvious, except perhaps that Southbank is more expensive than you’d think.<\/p>\n

Income<\/h3>\n

And while I was at it, I made one about income,<\/p>\n

\"\"<\/a>
Household income by Borough<\/figcaption><\/figure>\n

\"\"<\/a> <\/a><\/p>\n

Living Rent<\/h3>\n

I went from income to the London Living Rent and I made one showing the London Living Rent by ward!<\/p>\n

The GLA Template is here<\/a>. The GLA\u2019s data is here<\/a>. I am using the figure for a three bedroom property.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

And I have enlarged Lewisham,<\/p>\n

\"\"<\/a><\/p>\n

Let’s remember that the LLR is as much a proxy for income as it is for land value, which is itself driven by the effective demand for housing.<\/p>\n

Green Party Vote<\/h3>\n

I did one for the London Green Vote<\/a>. With the modern versions of excel, i needed to make the folder a ‘trusted location’<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

I wanted to say something simple about the cost of desk space in London and made it complicated. I made a map showing relative costs, this is how.<\/p>\n","protected":false},"author":1,"featured_media":7907,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_share_on_mastodon":"0"},"categories":[84,137],"tags":[85,1037,1674,138,56,1675,473],"class_list":["post-5914","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business","category-economics","tag-business-2","tag-data-visualisation","tag-desk-rental","tag-economics-2","tag-london","tag-london-living-rent","tag-rent"],"share_on_mastodon":{"url":"","error":""},"jetpack_featured_media_url":"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2021\/08\/LondonDusk-jaanusjagomagi-unsplash-w1280.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/5914","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/comments?post=5914"}],"version-history":[{"count":3,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/5914\/revisions"}],"predecessor-version":[{"id":11279,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/5914\/revisions\/11279"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media\/7907"}],"wp:attachment":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media?parent=5914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/categories?post=5914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/tags?post=5914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}