cityofchicago/311-service-requests-street-lights-one-out-3aav-uy2v
Icon for Socrata external plugin
 
Readme
Updated 2 years ago
Indexed 2 hours ago

311 Service Requests - Street Lights - One 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.

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
LongitudelongitudelongitudeNumber
WardwardwardNumber
Community Areacommunity_areacommunity_areaNumber
LatitudelatitudelatitudeNumber
Creation Datecreation_datecreation_dateCalendar date
LocationlocationlocationPoint
StatusstatusstatusText
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumber
Census Tracts:@computed_region_bdys_3d7i:@computed_region_bdys_3d7iNumber
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumber
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumber
Boundaries - ZIP Codes:@computed_region_rpca_8um6:@computed_region_rpca_8um6Number
Street Addressstreet_addressstreet_addressText
ZIP Codezip_codezip_codeNumber
X Coordinatex_coordinatex_coordinateNumber
Y Coordinatey_coordinatey_coordinateNumber
Police Districtpolice_districtpolice_districtNumber
Type of Service Requesttype_of_service_requesttype_of_service_requestText
Service Request Numberservice_request_numberservice_request_numberText
Completion Datecompletion_datecompletion_dateCalendar date
 
Preview
  • 311_service_requests_street_lights_one_out
     
Upstream Metadata