Name: Brownfield Land Register
Creator: UK Government
License: https://data.europa.eu/en/copyright-notice

About this Dataset

Brownfield Land Register

Tables

Table 1

@ukgov.brownfield_land_register28.table_1

32.33 kB
21 rows
35 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "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" VARCHAR,
  "netdwellingsrangeto" VARCHAR,
  "hazardoussubstances" VARCHAR,
  "siteinformation" VARCHAR,
  "notes" VARCHAR,
  "firstaddeddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP,
  "easting" BIGINT,
  "northing" BIGINT,
  "licence" VARCHAR,
  "licenceurl" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);