About this Dataset

WirralBrownfield

Brownfield Land Register updated December 2022 showing previously developed sites within Wirral Council, published in accordance with the Town and Country Planning (Brownfield Land Register) Regulations 2017 and the Town and Country Planning (Permission in Principle) Order 2017.
Publisher name: Wirral Metropolitan Borough Council
Last updated: 2024-11-21T04:00:14Z

Tables

WirralBrownfield

@ukgov.wirralbrownfield.wirralbrownfield

31.61 kB
83 rows
29 columns

CREATE TABLE wirralbrownfield (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "sitereference" BIGINT,
  "previouslypartof" VARCHAR,
  "sitenameaddress" VARCHAR,
  "siteplanurl" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "hectares" DOUBLE,
  "ownershipstatus" VARCHAR,
  "deliverable" VARCHAR,
  "planningstatus" VARCHAR,
  "permissiontype" VARCHAR,
  "permissiondate" TIMESTAMP,
  "planninghistoryurl" VARCHAR,
  "planninghistory" VARCHAR,
  "proposedforpip" VARCHAR,
  "minnetdwellings" BIGINT,
  "developmentdescription" VARCHAR,
  "nonhousingdevelopment" VARCHAR,
  "part2" VARCHAR,
  "netdwellingsrangefrom" VARCHAR,
  "netdwellingsrangeto" VARCHAR,
  "hazardoussubstances" VARCHAR,
  "siteinformation" VARCHAR,
  "notes" VARCHAR,
  "firstaddeddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP
);

Wirral Brownfield Part1 Sites 2022

@ukgov.wirralbrownfield.wirral_brownfield_part1_sites_2022

28.62 kB
170 rows
20 columns

CREATE TABLE wirral_brownfield_part1_sites_2022 (
  "organisationuri" VARCHAR,
  "sitereference" DOUBLE,
  "sitenameaddress" VARCHAR,
  "geoy" DOUBLE,
  "geox" DOUBLE,
  "siteplanurl" VARCHAR,
  "hectares" DOUBLE,
  "ownershipstatus" VARCHAR,
  "planningstatus" VARCHAR,
  "permissiontype" VARCHAR,
  "permissiondate" VARCHAR,
  "planninghistory" VARCHAR,
  "deliverable" VARCHAR,
  "netdwellingsrangefrom" DOUBLE,
  "netdwellingsrangeto" DOUBLE,
  "hazardoussubstances" VARCHAR,
  "notes" VARCHAR,
  "firstaddeddate" VARCHAR,
  "lastupdateddate" VARCHAR,
  "enddate" VARCHAR
);