Buddleholes In Devon

CREATE TABLE buddleholes_in_devon (
  "item_uid" BIGINT,
  "item_type_uid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "item_identity_code" VARCHAR,
  "comments" VARCHAR,
  "location_description" VARCHAR,
  "last_inspected_date" VARCHAR,
  "inspect_uid" BIGINT,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "end_dated" BOOLEAN,
  "parish_uid" BIGINT,
  "local_service_group_uid" BIGINT,
  "area_office_uid" BIGINT,
  "hims_reference" VARCHAR,
  "last_edit_date" VARCHAR,
  "last_edit_user_uid" BIGINT,
  "blce" DOUBLE,
  "blcn" DOUBLE,
  "trce" DOUBLE,
  "trcn" DOUBLE,
  "points" VARCHAR,
  "parent_uid" BIGINT,
  "family_uid" BIGINT,
  "previous_street" BIGINT,
  "buddlehole_uid" BIGINT,
  "hims_ulr_id" BIGINT,
  "hims_hi_sq" BIGINT,
  "hims_hi_chn" BIGINT,
  "hiposcd_uid" BIGINT,
  "owner_of_inventory_item_uid" BIGINT,
  "maintenance_responsibility_uid" BIGINT,
  "digital_length" DOUBLE,
  "digital_area" DOUBLE,
  "shape_geometry" VARCHAR,
  "shape_geography" VARCHAR,
  "import_uid_number" BIGINT,
  "maintenance_policy_exception" BOOLEAN,
  "cw_maintenance_hierarchy_name" VARCHAR,
  "salted_route_name" VARCHAR
);