About this Dataset

Bureau Of Street Lighting (BSL) - Performance Metrics

This dataset contains metrics that measure the operational performance of the Bureau of Street Lighting. These metrics are used on a regular basis by the department and the Mayor to evaluate progress and inform decision making. Performance management forms the foundation of a data-driven culture of innovation and excellence in the City of Los Angeles.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:07.208118
Tags: bsl, bureau-of-street-lighting, metrics, performance

Tables

Table 1

@usgov.city_of_los_angeles_bureau_of_street_lighting_bsl_perf_a2c19da6.table_1

16.41 kB
70 rows
14 columns

CREATE TABLE table_1 (
  "date_value" VARCHAR,
  "month_year" VARCHAR,
  "quarter_fy" VARCHAR,
  "annual_fy" VARCHAR,
  "cumulative_of_street_lights_converted_to_led_annual_fy" DOUBLE  -- Cumulative # Of Street Lights Converted To LED (Annual FY),
  "projected_cumulative_of_street_lights_converted_to_led_2c11bf1e" DOUBLE  -- PROJECTED: Cumulative # Of Street Lights Converted To LED (Annual FY),
  "cumulative_of_street_lights_converted_to_led_monthly" DOUBLE  -- Cumulative # Of Street Lights Converted To LED (Monthly),
  "projected_cumulative_of_street_lights_converted_to_led_monthly" DOUBLE  -- PROJECTED: Cumulative # Of Street Lights Converted To LED (Monthly),
  "n__of_streetlights_operating_annual_fy" DOUBLE  -- % Of Streetlights Operating (Annual FY),
  "projected_of_streetlights_operating_annual_fy" DOUBLE  -- PROJECTED: % Of Streetlights Operating (Annual FY),
  "average_of_streetlights_operating_citywide_monthly" DOUBLE  -- Average % Of Streetlights Operating Citywide (Monthly),
  "projected_average_of_streetlights_operating_citywide_monthly" DOUBLE  -- PROJECTED: Average % Of Streetlights Operating Citywide (Monthly),
  "street_lighting_maintenance_assessment_fund_revenue_in_3aa8e592" DOUBLE  -- Street Lighting Maintenance Assessment Fund Revenue In Millions (Annual FY),
  "projected_street_lighting_maintenance_assessment_fund__1ba34f6b" DOUBLE  -- PROJECTED: Street Lighting Maintenance Assessment Fund Revenue In Millions (Annual FY)
);