Performance Metrics - Transportation - Street Lights All Out
The Chicago Department of Transportation (CDOT) oversees approximately 250,000 street lights that illuminate arterial and residential streets in Chicago. CDOT performs repairs and bulb replacements in response to residents’ reports of street light outages. Whenever CDOT receives a report from 311’s Customer Service Requests (CSR) system of an “All Out” (an outage of 3 or more lights) the electrician assigned to make the repair looks at all the lights in that circuit (each circuit has 8-16 lights) to make sure that they are all working properly. This metric tracks the average number of days CDOT takes to complete street lights “All Out” requests. Total number of requests fulfilled per week is also available by mousing over columns. The target response time for street light “All Out” repairs is within 4 days. To report a street light outage, call 311 or see http://www.cityofchicago.org/city/en/depts/cdot/provdrs/traffic_signals_andstreetlights/svcs/request_street_lights.html
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 \"cityofchicago/performance-metrics-transportation-street-lights-phrs-x2nm\".\"performance_metrics_transportation_street_lights\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.