Edmonton's Open Data Portal

Close
Author
opendata@edmonton.ca
Description
The City’s 100,000 street lights are in the early stages of conversion from high pressure sodium vapour lamps to LED luminaires. About 17,000 are converted now; the goal is to have the rest done within five years. Sodium vapour lamps ranged from 70 to 1,000 watts. The LED lamps, which use 16 to 200 watts, save about 35% in both energy costs and greenhouse gas emission spin-off. It is believed that the total saving could reach 50% by 2020 with technological improvements.
Category
Transportation
Tags
streetlight, led
Rating
Current value: 0 out of 5
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:

Type
type
Watts
watts
Start Date
start_date
Ownership
ownership
Latitude
latitude
Longitude
longitude
Location
location
Wards
:@computed_region_da6r_6gkw
Edmonton Public School Board Ward Boundaries
:@computed_region_uxfu_uxx8
Edmonton Catholic School District Ward Boundaries
:@computed_region_ive2_3q52
Roadway Maintenance Area Polygon
:@computed_region_ecxu_fw7u
City of Edmonton - Neighbourhood Boundaries
:@computed_region_bhid_jnzh

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.