About this Dataset

RBKC Brownfield Land Register

RBKC is required to prepare and maintain a register of previously developed land, known as a Brownfield Land Register. Government regulations and guidance sets out criteria to inform production of the register. The register must be updated at least annually.
Publisher name: Royal Borough of Kensington and Chelsea
Last updated: 2022-07-01T04:04:31Z

Tables

RBKC Brownfield Land Register

@ukgov.rbkc_brownfield_land_register.rbkc_brownfield_land_register

37.18 KB
61 rows
28 columns


CREATE TABLE rbkc_brownfield_land_register (
  "organisation_uri" VARCHAR,
  "organisation_label" VARCHAR,
  "site_reference" VARCHAR,
  "previously_part_of" VARCHAR,
  "site_name_address" VARCHAR,
  "siteplan_url" VARCHAR,
  "coordinate_reference_system" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "hectares" DOUBLE,
  "ownership_status" VARCHAR,
  "deliverable" VARCHAR,
  "planning_status" VARCHAR,
  "permission_type" VARCHAR,
  "permission_date" VARCHAR,
  "planning_history" VARCHAR,
  "proposed_for_pip" VARCHAR,
  "minimum_net_dwellings" BIGINT,
  "development_description" VARCHAR,
  "non_housing_development" VARCHAR,
  "part2" VARCHAR,
  "net_dwellings_range_from" BIGINT,
  "net_dwellings_range_to" BIGINT,
  "hazardous_substances" VARCHAR,
  "site_information" VARCHAR,
  "notes" VARCHAR,
  "first_added_date" TIMESTAMP,
  "last_updated_date" TIMESTAMP
);