Melton Mowbray Brownfield Land Register

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