Streetlight Upgrade Project
This dataset contains information regarding Dominion Energy owned (city leased) streetlights that are designated for upgrades to LED bulbs, to improve dependability, light emission, reduce energy consumption, and improve nighttime public safety. The prioritization of the upgrades was determined using public safety information including calls for service and traffic accidents, as well as vehicular and pedestrian traffic levels.
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 \"norfolk-gov/streetlight-upgrade-project-tvwm-pv9f\".\"streetlight_upgrade_project\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.