LED Streetlight Conversion
This data set identifies the specific locations of street lights, and the type of bulb and wattage of each light.
Light-emitting diode (LED) light bulbs are more energy efficient than other types of light bulbs, and are designed to have a longer lifespan, lower maintenance costs, and to save energy.
Conversion of Edmonton's street and alley lights from conventional bulbs to LED technology is reducing Edmonton's overall power consumption, contributing to the City's goal to reduce energy use by 25% relative to 2005 by 2035.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"edmonton-ca/led-streetlight-conversion-rxke-mcvd\".\"led_streetlight_conversion\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.