Tandridge Brownfield Register

CREATE TABLE tandridge_brownfield_register (
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "sitereference" VARCHAR,
  "previouslypartof" VARCHAR,
  "sitenameaddress" VARCHAR,
  "siteplanurl" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "hectares" DOUBLE,
  "ownershipstatus" VARCHAR,
  "deliverable" VARCHAR,
  "planningstatus" VARCHAR,
  "permissiontype" VARCHAR,
  "permissiondate" VARCHAR,
  "planninghistory" VARCHAR,
  "proposedforpip" VARCHAR,
  "minnetdwellings" BIGINT,
  "developmentdescription" VARCHAR,
  "nonhousingdevelopment" VARCHAR,
  "part2" VARCHAR,
  "netdwellingsrangefrom" BIGINT,
  "netdwellingsrangeto" BIGINT,
  "hazardoussubstances" VARCHAR,
  "siteinformation" VARCHAR,
  "notes" VARCHAR,
  "firstaddeddate" TIMESTAMP,
  "lastupdateddate" TIMESTAMP
);