Channels In Devon
Devon County Council
@ukgov.channels_in_devon
Devon County Council
@ukgov.channels_in_devon
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
);
Anyone who has the link will be able to view this.