About this Dataset

Royal Borough Of Greenwich Brownfield Land Register

The brownfield land register is a list of previously developed land within the Royal Borough of Greenwich that is suitable for housing. All local planning authorities are required by the government to produce a register.
Publisher name: Royal Borough of Greenwich
Last updated: 2024-09-15T01:08:54Z

Tables

Royal Borough Of Greenwich Brownfield Land Register

@ukgov.royal_borough_of_greenwich_brownfield_land_register.royal_borough_of_greenwich_brownfield_land_register

47.59 KB
123 rows
60 columns


CREATE TABLE royal_borough_of_greenwich_brownfield_land_register (
  "organisationuri" VARCHAR,
  "sitereference" VARCHAR,
  "sitenameaddress" VARCHAR,
  "siteplanurl" VARCHAR,
  "geoy" VARCHAR,
  "geox" VARCHAR,
  "hectares" DOUBLE,
  "ownershipstatus" VARCHAR,
  "planningstatus" VARCHAR,
  "permissiontype" VARCHAR,
  "permissiondate" VARCHAR,
  "planninghistory" VARCHAR,
  "deliverable" VARCHAR,
  "netdwellingsrangefrom" BIGINT,
  "netdwellingsrangeto" BIGINT,
  "hazardoussubstances" VARCHAR,
  "notes" VARCHAR,
  "firstaddeddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR
);