311 Service Requests - Street Lights - One Out - Historical

data.cityofchicago.org | Last Updated 7 Mar 2019

As described in http://bit.ly/311HistoricalPost, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only. This dataset contains all open 311 reports of one or two lights out on metal poles on a residential or arterial street and all completed requests since January 1, 2011. Whenever CDOT receives a report of a street light outage, the electrician assigned to make the repair looks at all the lights in a group (circuit) to make sure that they are working properly. If two requests regarding the same group are made within 30 calendar days of each other, the newest CSR is automatically given the status of “Duplicate (Open).” Since the electrician will be looking at all the lights in a group to verify that they are all working the “Duplicate (Open)” address will also be observed and repaired. Once the street lights are repaired, the CSR status will read “Completed” for the original request and “Duplicate (Closed)” for any duplicate requests. Data is updated daily.

Tags: streets, lights, historical

This dataset has the following 15 columns:

Column NameAPI Column NameData Type
Creation Datecreation_datecalendar_date
Statusstatustext
Completion Datecompletion_datecalendar_date
Service Request Numberservice_request_numbertext
Type of Service Requesttype_of_service_requesttext
Street Addressstreet_addresstext
ZIP Codezip_codenumber
X Coordinatex_coordinatenumber
Y Coordinatey_coordinatenumber
Wardwardnumber
Police Districtpolice_districtnumber
Community Areacommunity_areanumber
Latitudelatitudenumber
Longitudelongitudenumber
Locationlocationtext