About this Dataset

Culvert Maintenance

Effective, well maintained grids and inlets to culverts are an essential flood prevention measure. The Flood Risk Management section implements a maintenance schedule, clearing grids of debris at specific 'hot-spots'. These datasets show the schedule for clearing these grids and the actual dates when clearance took place. Information ----------- * The common unique identifier for both datasets is 'Grid_ID'.
Publisher name: Leeds City Council
Last updated: 2024-09-10T23:25:26Z

Tables

Grid Maintenance 2018 Aug

@ukgov.culvert_maintenance.grid_maintenance_2018_aug

14.06 kB
165 rows
10 columns

CREATE TABLE grid_maintenance_2018_aug (
  "id" DOUBLE,
  "watercourse" VARCHAR,
  "location" VARCHAR,
  "asset_type" VARCHAR,
  "description" VARCHAR,
  "eastings" VARCHAR,
  "northings" VARCHAR,
  "frequency" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

29-09-2008 To 25-06-2018

@ukgov.culvert_maintenance.n_29_09_2008_to_25_06_2018

23.45 kB
20,763 rows
2 columns

CREATE TABLE n_29_09_2008_to_25_06_2018 (
  "grid_id" DOUBLE,
  "date_inspection" TIMESTAMP
);