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

About this Dataset

Brownfield Register

Tables

Table 1

@ukgov.brownfield_register45.table_1

192.53 kB
176 rows
28 columns

CREATE TABLE table_1 (
  "geo_point_2d" VARCHAR,
  "geo_shape" VARCHAR,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "sitereference" VARCHAR,
  "sitenameaddress" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "siteplanurl" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "hectares" DOUBLE,
  "ownershipstatus" VARCHAR,
  "planningstatus" VARCHAR,
  "permissiontype" VARCHAR,
  "permissiondate" TIMESTAMP,
  "planninghistory" VARCHAR,
  "deliverable" VARCHAR,
  "netdwellingsrangefrom" DOUBLE,
  "netdwellingsrangeto" DOUBLE,
  "part2" VARCHAR,
  "hazardoussubstances" VARCHAR,
  "notes" VARCHAR,
  "firstaddeddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "shelaa_ref" BIGINT,
  "application_number" DOUBLE,
  "pprn" VARCHAR
);