Name: Catchpits In Devon
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Catchpits In Devon

Catch pits in Devon. Catch pits are pits on the highway drainage system in which matter that might otherwise block a sewer is collected so that it may periodically be removed.
Publisher name: Devon County Council
Last updated: 2022-07-01T04:07:03Z

Tables

Catchpits In Devon

@ukgov.catchpits_in_devon.catchpits_in_devon

75.86 kB
284 rows
40 columns

CREATE TABLE catchpits_in_devon (
  "catchpit_uid" BIGINT,
  "item_uid" BIGINT,
  "item_type_uid" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "item_identity_code" BIGINT,
  "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,
  "previous_street" BIGINT,
  "family_uid" BIGINT,
  "hims_ulr_id" BIGINT,
  "hims_hi_sq" BIGINT,
  "hims_hi_chn" BIGINT,
  "hiposcd_uid" BIGINT,
  "digital_length" DOUBLE,
  "digital_area" DOUBLE,
  "shape_geometry" VARCHAR,
  "shape_geography" VARCHAR,
  "maintenance_policy_exception" BOOLEAN,
  "maintenance_responsibility_uid" BIGINT,
  "owner_of_inventory_item_uid" BIGINT,
  "salted_route_name" VARCHAR,
  "cw_maintenance_hierarchy_name" VARCHAR
);