Optimal land use allocation for the Heathrow opportunity area using multi-objective linear programming

The London Plan, the Greater London Authority's spatial development strategy for London, has defined Heathrow as an Opportunity Area - an area with the capacity to support additional homes and jobs - since 2004, but progress on developing the area has been minimal. Uncertainty around the expansion of Heathrow Airport appears to have adversely affected progress. Nevertheless, the most recent London Plan stipulates that the Heathrow Opportunity Area should accommodate 13,000 new homes and 11,000 new jobs. In this article, multi-objective linear programming is used to investigate whether these figures are achievable given constraints on land availability and land use mix. How land uses might best be assigned to maximise home, job and gross value added (GVA) creation within the Heathrow Opportunity Area is also explored. The main contributions are to provide independent scrutiny of London's development strategy and to present a mathematical framework for land use allocation planning decisions in urban areas. Findings show that given 700 ha of available land, as indicated in the London Plan, home and job creation figures can be met. However, there is insufficient brownfield land to meet these targets, and development on Green Belt land would very likely be necessary. Strong land use allocations for the area are found to more heavily feature financial and professional services, other office-based businesses, and shops. Rather than presenting a single land use "solution", results are presented using a wide range of visualisations to illustrate key trade-offs between different goals, with the secondary aim of promoting multi-objective linear programming to planners as a valuable tool to support spatial decisions and policy making

Creating a new dataset to analyse house prices in England

House price data deficiencies hinder UK housing market research. House price research in the UK is limited by lack of an open and comprehensive house price database that contains transaction price alongside individual property characteristics. This research outlines one approach which addresses this deficiency in England. Land Registry Price Paid Data (PPD) is the official house price dataset in England covering residential transactions in the housing market. It has two main disadvantages: first it is not geo-referenced and second, it lacks accurate information on housing size. We create two data linkage methods to overcome these two shortcomings, first by linking the Land Registry PPD with Ordnance Survey (OS) MasterMap and OS AddressBase Plus, second by linking the resulting data with total floor area information from Domestic Energy Performance Certificates (EPCs). This new linked dataset offers greater flexibility for the exploration of house price variation in England over different scales. A strong positive relationship is observed between house price and total floor area. This relationship varies at different geographic scales and over different property types across England

Aspects actuels de la psychologie du raisonnement

Evans Jonathan St. B. T., Oléron Pierre. Aspects actuels de la psychologie du raisonnement. In: Bulletin de psychologie, tome 32 n°340, 1979. L'intelligence. pp. 643-653

House Price per Square Metre in England and Wales, 1995-2021

This house price per square metre dataset was created on 1/4/2021 and is based on the LR PPD, Domestic EPCs and NSPL downloaded on the same day. It covers over 18 million transactions with 104 variables in England and Wales between 1/1/1995 and 26/2/2021. 16 of the 104 variables come from the LR PPD, 84 variables come from Domestic EPCs, one variable (lad21cd) from NSPL and three variables (i.e.id, classt, priceper) are created by the first author. Before the data linkage, a unique identifier (id) is created for all the unique EPCs after removing the individual lodgement identifier (i.e. LMK_KEY variable). During the data linkage, a variable named classt is created to identify 1:1 and 1:n linkage relationships. After the data linkage, a derived house price per square metre variable (i.e. priceper) is obtained through dividing the transaction price paid in the LR PPD with the total floor area variable in the EPC dataset. The NSPL (May 2021 version) is used to assign the local authority unit (lad21cd) to the house price per square metre dataset. During the data linkage process, the transactions in the LR PPD assigned as category B (Additional Price Paid entry) and other property types are removed. This version of the dataset unlike the previous version can be described as ‘uncorrected’ as we have not removed transactions with any improbable price per square metre values (e.g. total floor area values are null, 0). This uncorrected version of the data will offer the most flexibility for researchers. Researchers are recommended to clean the uncorrected version according to their research need.This repository covers an updated but uncorrected version of the attribute-linked residential property price dataset in UK Data Service ReShare 854240 (https://reshare.ukdataservice.ac.uk/854240/). It is also the entire uncorrected version of the open access (limited attribute) house price per square metre dataset published by local authority in the Greater London Authority (GLA) London Datastore (https://data.london.gov.uk/dataset/house-price-per-square-metre-in-england-and-wales). This linked dataset contains individual property transactions and associated variables from the Land Registry Price Paid Dataset (LR PPD) linked at address level to all attributes, other than the individual lodgement identifier, address and postcode attributes, contained in Version VI of the Domestic Energy Performance Certificate (EPC) data published by the Ministry for Housing, Communities and Local Government (MHCLG). The linked data in this repository is the uncorrected version, recording over 18 million transactions with 104 variables in England and Wales between 1/1/1995 and 26/2/2021. We have offered technical validation and data cleaning code in UKDA ReShare 854240 to help users evaluate the representation of the linked data for a given time period. The data cleaning code shows our methods for cleaning up unlikely floor size records before using this data in analysis. Users can create their own rules and undertake this clean-up process based on their own experience and research aims. This repository also covers the original LR PPD and Domestic EPCs for the linked data (house price per square metre dataset). The LR PPD in this repository has been added in the field header in the open access LR PPD. Domestic EPCs in this repository has had removed the six variables (individual lodgement identifier, address, address 1, address 2, address 3, postcode) with a newly created unique identifier (id). This id column is newly created for Version VI Domestic EPCs, which is not the same id as in the Domestic EPCs from UK Data Service ReShare 854240.</p

A new attribute-linked residential property price dataset for England and Wales 2011-2019

Land Registry Price Paid Data (PPD) have been published as open data since 2013. These data have been transformative for house price variation research in the UK as they are a comprehensive record of residential transactions at address level and cover the whole of England and Wales over a period dating back to 1995. Despite the utility of these data, a lack of attribute information relating to the properties, such as total floor area information, is identified as one of the major shortcomings of the PPD data. This means that the impacts of stock mix on broader price patterns cannot be fully accounted for. This research outlines one approach which addresses this deficiency by combining transaction information from the official open Land Registry Price Paid Data (PPD) with property size information form the official open Domestic Energy Performance Certificates (EPCs). A four-stage data linkage is created to generate a new linked dataset, representing 79% of the full market sales in the Land Registry PPD. This new linked dataset details 5,732,838 transactions in England and Wales between 2011 and 2019, along with each property's total floor area and the number of habitable rooms. Codes for other commonly used spatial units from Output Area to Local Authority are also included in the dataset. This offers greater flexibility for the exploration of house price variation in England and Wales at different spatial scales. The data collection includes the scripts used for linkage, as well as the resulting dataset.Current residential house price variation research in the UK is limited by lack of an open and comprehensive house price database that contains both transaction price alongside dwelling attributes such as size. This research outlines one approach which addresses this deficiency in England and Wales through combining transaction information from the official open Land Registry Price Paid Data (PPD) and property size information form the official open Domestic Energy Performance Certificates (EPCs). A four-stage data linkage is created to generate a new linked data, representing 79% of the full market sales in Land Registry PPD. This new linked dataset offers greater flexibility for the exploration of house price (house price per square metre) variation in England and Wales at different spatial scales over postcode unit between 2011 and 2019.</p