Baselight

Channels In Devon

Devon County Council

@ukgov.channels_in_devon

Loading...
Loading...

About this Dataset

Channels In Devon

Channels in Devon forming part of the highway drainage system
Publisher name: Devon County Council
Last updated: 2022-07-01T04:07:03Z

Tables

Channels In Devon

@ukgov.channels_in_devon.channels_in_devon
  • 2.77 MB
  • 11528 rows
  • 43 columns
Loading...

CREATE TABLE channels_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,
  "channel_uid" BIGINT,
  "hims_ulr_id" BIGINT,
  "hims_hi_sq" BIGINT,
  "st_chainage" BIGINT,
  "end_chainage" BIGINT,
  "actual_length" BIGINT,
  "material_type_uid" 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,
  "maintenance_policy_exception" BOOLEAN,
  "cw_maintenance_hierarchy_name" VARCHAR,
  "salted_route_name" VARCHAR
);

Share link

Anyone who has the link will be able to view this.