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.