Dataset: WirralBrownfield

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

Wirral Brownfield Part1 Sites 2022

@ukgov.wirralbrownfield.wirral_brownfield_part1_sites_2022

27.95 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
);

WirralBrownfield

@ukgov.wirralbrownfield.wirralbrownfield

30.87 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
);