Brownfield Land Register
Plymouth City Council
@ukgov.brownfield_register17
Plymouth City Council
@ukgov.brownfield_register17
Plymouth City Council's register of Brownfield Land suitable for housing development in accordance with legislation and Government guidance https://www.gov.uk/guidance/brownfield-land-registers. You can see the Data Standard used here https://www.gov.uk/government/publications/brownfield-land-registers-data-standard.
Publisher name: Plymouth City Council
Last updated: 2025-02-05T04:02:27Z
CREATE TABLE plymouth_brownfield_land_register_2023_2024 (
"organisation_url" VARCHAR,
"organisation_label" VARCHAR,
"site_reference" VARCHAR,
"previously_part_of" VARCHAR,
"sitenameaddress" VARCHAR,
"site_plan_url" VARCHAR,
"coordinate_reference_system" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownership_status" VARCHAR,
"deliverable" VARCHAR,
"planning_status" VARCHAR,
"permission_type" VARCHAR,
"permission_date" TIMESTAMP,
"planning_history" VARCHAR,
"proposed_for_pip" DOUBLE,
"min_net_dwellings" BIGINT,
"development_description" VARCHAR,
"non_housing_development" VARCHAR,
"part2" VARCHAR,
"net_dwellings_range_from" DOUBLE,
"net_dwellings_range_to" DOUBLE,
"hazardous_substances" VARCHAR,
"site_information" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"end_date" TIMESTAMP,
"easting" BIGINT,
"northing" BIGINT,
"shlaareference" VARCHAR,
"jlppolicyreference" VARCHAR,
"housing_survey_site_reference" VARCHAR,
"application_and_policy_reference" VARCHAR
);CREATE TABLE plymouth_brownfield_land_register_december_2017 (
"organsiationuri" VARCHAR,
"organsiationlabel" VARCHAR,
"sitereference" VARCHAR,
"previouslypartof" VARCHAR,
"sitenameaddress" VARCHAR,
"siteplanurl" VARCHAR,
"coordinatereferencesystem" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownershipstatus" VARCHAR,
"deliverable" VARCHAR,
"planningstatus" VARCHAR,
"permissiontype" VARCHAR,
"permissiondate" VARCHAR,
"planninghistory" VARCHAR,
"proposedforpip" VARCHAR,
"minnetdwellings" BIGINT,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" VARCHAR,
"lastupdateddate" VARCHAR,
"easting" BIGINT,
"northing" BIGINT,
"shlaareference" VARCHAR,
"jlppolicyreference" VARCHAR
);CREATE TABLE plymouth_brownfield_land_register_december_2018 (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"sitereference" VARCHAR,
"previouslypartof" VARCHAR,
"sitenameaddress" VARCHAR,
"siteplanurl" VARCHAR,
"coordinatereferencesystem" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownershipstatus" VARCHAR,
"deliverable" VARCHAR,
"planningstatus" VARCHAR,
"permissiontype" VARCHAR,
"permissiondate" TIMESTAMP,
"planninghistory" VARCHAR,
"proposedforpip" VARCHAR,
"minnetdwellings" BIGINT,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"easting" BIGINT,
"northing" BIGINT,
"shlaareference" VARCHAR,
"jlppolicyreference" VARCHAR,
"housingsurveysitereference" VARCHAR
);CREATE TABLE plymouth_brownfield_land_register_december_2020 (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"sitereference" VARCHAR,
"previouslypartof" VARCHAR,
"sitenameaddress" VARCHAR,
"siteplanurl" VARCHAR,
"coordinatereferencesystem" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownershipstatus" VARCHAR,
"deliverable" VARCHAR,
"planningstatus" VARCHAR,
"permissiontype" VARCHAR,
"permissiondate" TIMESTAMP,
"planninghistory" VARCHAR,
"proposedforpip" DOUBLE,
"minnetdwellings" BIGINT,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"easting" DOUBLE,
"northing" DOUBLE,
"shlaareference" VARCHAR,
"jlppolicyreference" VARCHAR,
"housingsurveysitereference" VARCHAR,
"applicationandpolicyref" VARCHAR
);CREATE TABLE plymouth_brownfield_land_register_december_2021 (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"sitereference" VARCHAR,
"previouslypartof" VARCHAR,
"sitenameaddress" VARCHAR,
"siteplanurl" VARCHAR,
"coordinatereferencesystem" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownershipstatus" VARCHAR,
"deliverable" VARCHAR,
"planningstatus" VARCHAR,
"permissiontype" VARCHAR,
"permissiondate" TIMESTAMP,
"planninghistory" VARCHAR,
"proposedforpip" DOUBLE,
"minnetdwellings" BIGINT,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"easting" DOUBLE,
"northing" DOUBLE,
"shlaareference" VARCHAR,
"jlppolicyreference" VARCHAR,
"housingsurveysitereference" VARCHAR,
"applicationandpolicyref" VARCHAR
);CREATE TABLE plymouth_brownfield_land_register_december_2022 (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"sitereference" VARCHAR,
"previouslypartof" VARCHAR,
"sitenameaddress" VARCHAR,
"siteplanurl" VARCHAR,
"coordinatereferencesystem" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownershipstatus" VARCHAR,
"deliverable" VARCHAR,
"planningstatus" VARCHAR,
"permissiontype" VARCHAR,
"permissiondate" TIMESTAMP,
"planninghistory" VARCHAR,
"proposedforpip" DOUBLE,
"minnetdwellings" DOUBLE,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"easting" DOUBLE,
"northing" DOUBLE,
"shlaareference" VARCHAR,
"jlppolicyreference" VARCHAR,
"housingsurveysitereference" VARCHAR,
"applicationandpolicyref" VARCHAR
);CREATE TABLE plymouth_brownfield_land_register_december_2024 (
"organisation_url" VARCHAR,
"organisation_label" VARCHAR,
"site_reference" VARCHAR,
"previously_part_of" VARCHAR,
"sitenameaddress" VARCHAR,
"site_plan_url" VARCHAR,
"coordinate_reference_system" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownership_status" VARCHAR,
"deliverable" VARCHAR,
"planning_status" VARCHAR,
"permission_type" VARCHAR,
"permission_date" TIMESTAMP,
"planning_history" VARCHAR,
"proposed_for_pip" DOUBLE,
"min_net_dwellings" DOUBLE,
"development_description" VARCHAR,
"non_housing_development" VARCHAR,
"part2" VARCHAR,
"net_dwellings_range_from" DOUBLE,
"net_dwellings_range_to" DOUBLE,
"hazardous_substances" VARCHAR,
"site_information" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"end_date" TIMESTAMP,
"easting" BIGINT,
"northing" BIGINT,
"shlaareference" VARCHAR,
"jlppolicyreference" VARCHAR,
"housing_survey_site_reference" VARCHAR,
"application_and_policy_reference" VARCHAR
);CREATE TABLE plymouth_brownfield_land_register_january_2018 (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"sitereference" VARCHAR,
"previouslypartof" VARCHAR,
"sitenameaddress" VARCHAR,
"siteplanurl" VARCHAR,
"coordinatereferencesystem" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownershipstatus" VARCHAR,
"deliverable" VARCHAR,
"planningstatus" VARCHAR,
"permissiontype" VARCHAR,
"permissiondate" TIMESTAMP,
"planninghistory" VARCHAR,
"proposedforpip" VARCHAR,
"minnetdwellings" BIGINT,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"easting" BIGINT,
"northing" BIGINT,
"shlaareference" VARCHAR,
"jlppolicyreference" VARCHAR
);CREATE TABLE plymouth_brownfield_land_register_july_2019 (
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"sitereference" VARCHAR,
"previouslypartof" VARCHAR,
"sitenameaddress" VARCHAR,
"siteplanurl" VARCHAR,
"coordinatereferencesystem" VARCHAR,
"geox" DOUBLE,
"geoy" DOUBLE,
"hectares" DOUBLE,
"ownershipstatus" VARCHAR,
"deliverable" VARCHAR,
"planningstatus" VARCHAR,
"permissiontype" VARCHAR,
"permissiondate" TIMESTAMP,
"planninghistory" VARCHAR,
"proposedforpip" VARCHAR,
"minnetdwellings" DOUBLE,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"easting" DOUBLE,
"northing" DOUBLE,
"shlaareference" VARCHAR,
"jlppolicyreference" VARCHAR,
"housingsurveysitereference" VARCHAR,
"applicationandpolicyref" VARCHAR
);Anyone who has the link will be able to view this.