cityofchicago/performance-metrics-transportation-street-lights-phrs-x2nm
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 10 years ago
Indexed 1 month ago

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.

 
Preview
  • performance_metrics_transportation_street_lights
     
     
     
     
     
Upstream Metadata