Icon for Socrata external plugin
Open repository in Console
Updated 2 days ago
Indexed 2 hours ago

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" \
{"sql": "
    SELECT *
    FROM \"edmonton-ca/led-streetlight-conversion-rxke-mcvd\".\"led_streetlight_conversion\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • led_streetlight_conversion
Upstream Metadata