cityofchicago/311-service-requests-street-lights-all-out-zuxi-7xem
Icon for Socrata external plugin
 
Readme
Updated over 3 years ago
Indexed 1 hour ago

311 Service Requests - Street Lights - All Out - Historical

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.

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Location (city)location_citylocation_cityText
LocationlocationlocationPoint
Historical Wards 2003-2015:@computed_region_awaf_s7ux:@computed_region_awaf_s7uxNumber
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumber
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumber
Census Tracts:@computed_region_bdys_3d7i:@computed_region_bdys_3d7iNumber
Location (address)location_addresslocation_addressText
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumber
StatusstatusstatusText
Service Request Numberservice_request_numberservice_request_numberText
Type of Service Requesttype_of_service_requesttype_of_service_requestText
ZIP Codezip_codezip_codeNumber
WardwardwardNumber
Completion Datecompletion_datecompletion_dateCalendar date
Street Addressstreet_addressstreet_addressText
Location (zip)location_ziplocation_zipText
Creation Datecreation_datecreation_dateCalendar date
X Coordinatex_coordinatex_coordinateNumber
Y Coordinatey_coordinatey_coordinateNumber
Police Districtpolice_districtpolice_districtNumber
Community Areacommunity_areacommunity_areaNumber
LatitudelatitudelatitudeNumber
LongitudelongitudelongitudeNumber
Location (state)location_statelocation_stateText
 
Preview
  • 311_service_requests_street_lights_all_out
     
Upstream Metadata