About this Dataset

Rotherham Brownfield Land Register

Rotherham Brownfield Land Register. Produced to satisfy the requirements of The Town and Country Planning (Brownfield Land Register) Regulations 2017.
Publisher name: Rotherham Metropolitan District Council
Last updated: 2022-07-01T04:02:41Z

Tables

Rotherham Brownfield Land Register

@ukgov.rotherham_brownfield_land_register.rotherham_brownfield_land_register

28.42 KB
62 rows
29 columns


CREATE TABLE rotherham_brownfield_land_register (
  "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,
  "alternativereference" VARCHAR
);

Rotherham Brownfield Land Register 2019

@ukgov.rotherham_brownfield_land_register.rotherham_brownfield_land_register_2019

22.37 KB
68 rows
21 columns


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