{"id":512,"date":"2017-04-24T01:50:13","date_gmt":"2017-04-24T01:50:13","guid":{"rendered":"http:\/\/www.macs.hw.ac.uk\/SWeL\/?p=512"},"modified":"2017-04-25T09:13:03","modified_gmt":"2017-04-25T09:13:03","slug":"does-open-scottish-government-data-justify-the-proposed-edinburgh-tram-extension","status":"publish","type":"post","link":"https:\/\/www.macs.hw.ac.uk\/SWeL\/2017\/04\/24\/does-open-scottish-government-data-justify-the-proposed-edinburgh-tram-extension\/","title":{"rendered":"Does Open Scottish Government Data Justify the Proposed Edinburgh Tram Extension?"},"content":{"rendered":"

The Scottish government provides open access to a range of official statistics about Scotland across 17 themes<\/a>, including crime, the economy, housing, and population growths. The portal is accessible at\u00a0http:\/\/statistics.gov.scot<\/a>.<\/p>\n

This post uses open Scottish government data to measure\u00a0the 5 year population growth in areas in close proximity to the proposed completion of phase 1a<\/a> of the tram extension, from York Place to Newhaven.<\/em><\/p>\n

The tram infrastructure business case<\/h3>\n

The original business case for the tram infrastructure was set out in a document Edinburgh Tram Draft Final Business Case<\/a> (<\/em>The City of Edinburgh Council, December 2006). It justifies the need for a tram system using two broad arguments:<\/p>\n

    \n
  1. The predicted growth in housing demands<\/strong> for a growing population in the areas on the proposed lines:<\/li>\n<\/ol>\n

    “Huge new developments are in the pipeline, especially on the city\u2019s waterfront in Leith Docks and Granton.\u00a0Edinburgh Waterfront is the largest brownfield development in\u00a0Scotland, equivalent to a major new town in scale, with the two major development sites able to accommodate up to 29,000 new homes in the longer term (Section 3.3, Why Tram).”<\/p><\/blockquote>\n

    2. The tram system will encourage economic regeneration <\/strong>and social inclusion<\/strong>:<\/p>\n

    “Without the tram, access to the major Waterfront developments will simply not be good enough. The Leith Docks proposals would have to be scaled down and the development prospects at Granton would be damaged (Section 3.3, Why Tram). Areas of [..] a zone around Leith Walk [..]\u00a0are areas where socio economic status is considerably less affluent than surrounding areas and where employment, income levels and car ownership tend to be comparatively low. Opportunities for people living in these areas will be improved by direct connection via tram to the City Centre and other employment areas, including the new development in Granton, Leith and the West of the City at Edinburgh Park and the Airport (Section 1.18,\u00a0Accessibility and Social Inclusion).”<\/p><\/blockquote>\n

    This document, written 11 years ago, made various projections of population growths, particularly in the north and north east of Edinburgh. For example, it states that 24,000 new houses will be needed in Edinburgh by 2015 (Section 3.3, Why Tram). The Scottish government open data portal can be used to assess the accuracy of those projections.<\/p>\n

    Party political views on the proposed extension<\/h3>\n

    Due to well documented economic costs and major project\u00a0problems, the tram stretches only as far as York Place. Edinburgh City Council are considering an extension from York Place down Leith Walk, to Newhaven. It could be partly funded by a City Deal<\/a>. A definitive yes\/no decision on the extension will be made after the local council elections take place on 4th May 2017. The Labour party are in favour<\/a>, the SNP have recently set conditions<\/a> on their backing of the extension, whilst\u00a0the Conservative party have promised to reject the business case for the extension in their\u00a0council election manifesto<\/a>.<\/p>\n

    Zones along the proposed tram extension<\/h3>\n

    The long term proposed route connects Granton to the west end and Newhaven to York Place, and a line between Granton and Newhaven to complete the ring. The route is available on the Edinburgh Local Development Plan <\/a>:<\/p>\n

    \"Proposed<\/p>\n

    Below I focus on the 5 year plan of extending the line from York Place to Newhaven. In the Scottish government open dataset, there are 1279 “intermediate geographical zones”<\/em>. Below depicts the intermediate zones in close proximity to the proposed extension down Leith Walk and to Newhaven:<\/p>\n\n\n\n\n\n\n
    \"Broughton\"
    \nBroughton South<\/td>\n    		\"Broughton\"
    \nEaster Road and Hawkhill Avenue<\/td>\n<\/tr>\n
    \"Broughton\"
    \nGreat Junction Street<\/td>\n    		\"Broughton\"
    \nNorth Leith and Newhaven<\/td>\n<\/tr>\n
    \"Broughton\"
    \nPilrig<\/td>\n    		\"Broughton\"
    \nThe Shore and Constitution Street<\/td>\n<\/tr>\n
    \"Western
    \nWestern Harbour and Leith Docks<\/td>\n    		<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Population growth along the proposed extension<\/h3>\n

    The Scottish government open data portal allows us to query the population growth in each Scottish city, and also within each intermediate zone. Below shows the rate of growth from 2011 to 2015, first at the city level and then at the intermediate zone level.<\/p>\n\n\n\n\n
    \"\"
    \nNational population growth<\/td>\n<\/tr>\n
    \"\"
    \nTram extension proximity population growth<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Here are 3 observations about these graphs:<\/p>\n

      \n
    1. The population of Edinburgh city is growing faster than Glasgow, Dundee, Stirling and Aberdeen<\/strong><\/em>. Between 2011 and 2015, the population of Edinburgh has grown by 4.4%.<\/li>\n
    2. The population of the intermediate zones in close proximity to the proposed Edinburgh tram extension is growing quickly<\/strong><\/em>. Of the 7 identified zones, the population of 5 zones is\u00a0growing at a faster rate than the average growth rate across\u00a0Edinburgh.<\/li>\n
    3. The population of the\u00a0Western Harbour and Leith Docks\u00a0zone is growing at a very rapid pace<\/strong><\/em>, where the population grew\u00a0by 22.7% between 2011 and 2015.<\/li>\n<\/ol>\n

      Reproducing this analysis<\/h3>\n

      These graphs are generated by<\/p>\n

        \n
      1. Running a SPARQL query against the Scottish government dataset service.<\/li>\n
      2. Plotting graphs from the CSV result set using R.<\/li>\n<\/ol>\n

        The SPARQL queries and plotting scripts used for the material in this post are available online at https:\/\/github.com\/robstewart57\/edinburgh-trams<\/a> .<\/p>\n

        Summary<\/h3>\n

        This post uses the open Scottish government data to show that the population growth along the proposed tram route extension from York Place to Newhaven is greater than the average for Edinburgh between 2011 and 2015 (zonal growths of up to 23%), a city which itself has the fastest growing population compared to\u00a04 other Scottish cities.<\/p>\n

        This data validates the 2006 projection that growth in housing demands will increase in the north east of Edinburgh, although\u00a0measuring\u00a0any discrepancies in exact numbers is difficult because the 2006 projections were not cross referenced to the intermediate zones that the open dataset uses.<\/p>\n

        The population data used here is only one of the 17 themes in the Scottish government’s dataset. An extension to this study would explore the other business cases for the tram, namely economic regeneration and social inclusion<\/em>\u00a0using the other 16 themes, to evaluate\u00a0the completeness\u00a0and granularity of economic and societal data at local levels in the Scottish government dataset.<\/p>\n","protected":false},"excerpt":{"rendered":"

        The Scottish government provides open access to a range of official statistics about Scotland across 17 themes, including crime, the economy, housing, and population growths. The portal is accessible at\u00a0http:\/\/statistics.gov.scot. This post uses open Scottish government data to measure\u00a0the 5 year population growth in areas in close proximity to the proposed completion of phase 1a … Continue reading “Does Open Scottish Government Data Justify the Proposed Edinburgh Tram Extension?”<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-512","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/posts\/512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/comments?post=512"}],"version-history":[{"count":71,"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/posts\/512\/revisions"}],"predecessor-version":[{"id":590,"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/posts\/512\/revisions\/590"}],"wp:attachment":[{"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/media?parent=512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/categories?post=512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.macs.hw.ac.uk\/SWeL\/wp-json\/wp\/v2\/tags?post=512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}