North Norfolk Brownfield Land Register
North Norfolk District Council
@ukgov.north_norfolk_brownfield_land_register
North Norfolk District Council
@ukgov.north_norfolk_brownfield_land_register
This data set provides a comprehensive list of brownfield sites across the North Norfolk District Council administrative area that are considered suitable for residential development regardless of their planning status. The data set was produced in accordance with the Town & Country Planning (Brownfield Land Register) Regulations 2017 which introduced a new duty for local planning authorities to prepare, maintain and publish a register of brownfield land (previously developed land) which is suitable for residential development. The register was first published on 18 December 2017 and must be reviewed and updated at least once a year.
Publisher name: North Norfolk District Council
Last updated: 2024-09-14T12:08:22Z
CREATE TABLE north_norfolk_brownfield_land_register_2017 (
"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
);CREATE TABLE north_norfolk_brownfield_land_register_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,
"unnamed_28" VARCHAR -- Unnamed: 28
);CREATE TABLE north_norfolk_brownfield_land_register_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" BIGINT,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"unnamed_28" VARCHAR -- Unnamed: 28
);CREATE TABLE north_norfolk_brownfield_land_register_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" VARCHAR,
"minnetdwellings" BIGINT,
"developmentdescription" VARCHAR,
"nonhousingdevelopment" VARCHAR,
"part2" VARCHAR,
"netdwellingsrangefrom" DOUBLE,
"netdwellingsrangeto" DOUBLE,
"hazardoussubstances" VARCHAR,
"siteinformation" VARCHAR,
"notes" VARCHAR,
"firstaddeddate" TIMESTAMP,
"lastupdateddate" TIMESTAMP,
"unnamed_28" VARCHAR -- Unnamed: 28
);Anyone who has the link will be able to view this.