About this Dataset

Street Lights (unmetered)

This dataset provides a list of all street lighting apparatus in Leeds that is unmetered (e.g. without an electricty meter). This forms the vast majority of our apparatus. Further information -------------------- For information on street lighting including reporting faults visit: http://www.leeds.gov.uk/residents/Pages/StreetLighting.aspx
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:43:08Z

Tables

12/04/2016

@ukgov.street_lights_unmetered.n_12_04_2016

3.16 MB
106,145 rows
8 columns

CREATE TABLE n_12_04_2016 (
  "unit_number" VARCHAR,
  "ward_name" VARCHAR,
  "road_name" VARCHAR,
  "location" VARCHAR,
  "unit_type" VARCHAR,
  "number_of_lamps" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE
);

15/04/2019

@ukgov.street_lights_unmetered.n_15_04_2019

3.24 MB
108,217 rows
8 columns

CREATE TABLE n_15_04_2019 (
  "unit_number" VARCHAR,
  "ward_name" VARCHAR,
  "road_name" VARCHAR,
  "location" VARCHAR,
  "unit_type" VARCHAR,
  "number_of_lamps" BIGINT,
  "easting" DOUBLE,
  "northing" DOUBLE
);