City of Los Angeles

Close
Author
Miguel Sangalang
Description
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.
Category
A Livable and Sustainable City
Tags
bureau of street lighting, bsl, performance, metrics
Rating
Current value: 0 out of 5
Data Provided By
Bureau of Street Lighting
License
1.0 Universal (Public Domain Dedication)
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Date Value
date_value
Month-Year
month_year
Quarter-FY
quarter_fy
Annual-FY
annual_fy
Cumulative # of street lights converted to LED (Annual FY)
cumulative_of_street_lights_converted_to_led_annual_fy
PROJECTED: Cumulative # of street lights converted to LED (Annual FY)
projected_cumulative_of_street_lights_converted_to_led_annual_fy
Cumulative # of street lights converted to LED (Monthly)
cumulative_of_street_lights_converted_to_led_monthly
PROJECTED: Cumulative # of street lights converted to LED (Monthly)
projected_cumulative_of_street_lights_converted_to_led_monthly
% of streetlights operating (Annual FY)
of_streetlights_operating_annual_fy
PROJECTED: % of streetlights operating (Annual FY)
projected_of_streetlights_operating_annual_fy
Average % of streetlights operating Citywide (Monthly)
average_of_streetlights_operating_citywide_monthly
PROJECTED: Average % of streetlights operating Citywide (Monthly)
projected_average_of_streetlights_operating_citywide_monthly
Street Lighting Maintenance Assessment Fund revenue in millions (Annual FY)
street_lighting_maintenance_assessment_fund_revenue_in_millions_annual_fy
PROJECTED: Street Lighting Maintenance Assessment Fund revenue in millions (Annual FY)
projected_street_lighting_maintenance_assessment_fund_revenue_in_millions_annual_fy

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.