311 Service Requests - Street Lights - All Out - Historical
data.cityofchicago.org | Last Updated 26 Jul 2024As described in https://data.cityofchicago.org/stories/s/311-Dataset-Changes-12-11-2018/d7nq-5g7t, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only. All open reports of "Street Lights - All Out" (an outage of 3 or more lights) made to 311 and all requests completed since January 1, 2011.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 of an “All Out” 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. If a second request of lights out in the same circuit is made within four calendar days of the original request, the newest request is automatically given the status of “Duplicate (Open).” Since CDOT's electrician will be looking at all the lights in a circuit to verify that they are all working, any “Duplicate (Open)” address will automatically be observed and repaired. Once the street lights are repaired, the status in CSR will read “Completed” for the original request and “Duplicate (Closed)” for any duplicate requests. A service request also receives the status of “Completed” when the reported lights are inspected but found to be in good repair and functioning; when the service request is for a non-existent address; or when the lights are maintained by a contractor. Data is updated daily.
This dataset has the following 15 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Creation Date | creation_date | calendar_date | 2011-10-24T00:00:00.000 2011-08-01T00:00:00.000 2012-08-06T00:00:00.000 2013-09-23T00:00:00.000 2013-11-19T00:00:00.000 view top 100 |
Status | status | text | Completed - Dup Completed Open Open - Dup view top 100 |
Completion Date | completion_date | calendar_date | 2011-10-05T00:00:00.000 2013-09-26T00:00:00.000 2011-07-13T00:00:00.000 2011-07-15T00:00:00.000 2013-09-25T00:00:00.000 view top 100 |
Service Request Number | service_request_number | text | 13-01289061 13-01669141 17-01947515 13-00608155 13-00390614 view top 100 |
Type of Service Request | type_of_service_request | text | Street Lights - All/Out view top 100 |
Street Address | street_address | text | 8300 S YATES BLVD 6900 S DR MARTIN LUTHER KING JR DR 8700 S BUFFALO AVE 7900 S YATES BLVD 8700 S ESCANABA AVE view top 100 |
ZIP Code | zip_code | number | 60617 60628 60619 60620 60643 view top 100 |
X Coordinate | x_coordinate | number | 1193619.84429437 1190840.1078806 1180109.47760927 1193567.0049083 1199551.46892087 view top 100 |
Y Coordinate | y_coordinate | number | 1850406.12066755 1855634.64613103 1859355.63059068 1853053.74848975 1847912.54767486 view top 100 |
Ward | ward | number | 6 10 34 9 21 view top 100 |
Police District | police_district | number | 4 8 22 16 6 view top 100 |
Community Area | community_area | number | 25 49 71 53 69 view top 100 |
Latitude | latitude | number | 41.7444613173406 41.758876405510804 41.769339631024586 41.75172791959732 41.73747159508171 view top 100 |
Longitude | longitude | number | -87.56612547505442 -87.57614198401998 -87.6153548636415 -87.56623259336205 -87.54447553989242 view top 100 |
Location | location | location | view top 100 |