cityofchicago/311-service-requests-alley-lights-out-historical-t28b-ys7j
Icon for Socrata external plugin
 
Readme
Updated over 3 years ago
Indexed 5 hours ago

311 Service Requests - Alley Lights 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 more lights out on a wooden pole in the alley and all completed requests since January 1, 2011. If two requests regarding the same address are made within 30 calendar days of each other, the newest CSR is automatically given the status of “Duplicate (Open)”. Once the alley light is 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
Census Tracts:@computed_region_bdys_3d7i:@computed_region_bdys_3d7iNumber
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumber
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumber
Historical Wards 2003-2015:@computed_region_awaf_s7ux:@computed_region_awaf_s7uxNumber
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumber
Location (zip)location_ziplocation_zipText
Street Addressstreet_addressstreet_addressText
Type of Service Requesttype_of_service_requesttype_of_service_requestText
StatusstatusstatusText
Police Districtpolice_districtpolice_districtNumber
LongitudelongitudelongitudeNumber
LatitudelatitudelatitudeNumber
WardwardwardNumber
Y Coordinatey_coordinatey_coordinateNumber
X Coordinatex_coordinatex_coordinateNumber
ZIP Codezip_codezip_codeNumber
Service Request Numberservice_request_numberservice_request_numberText
Completion Datecompletion_datecompletion_dateCalendar date
Creation Datecreation_datecreation_dateCalendar date
LocationlocationlocationPoint
Community Areacommunity_areacommunity_areaNumber
Location (address)location_addresslocation_addressText
Location (state)location_statelocation_stateText
Location (city)location_citylocation_cityText
 
Preview
  • 311_service_requests_alley_lights_out_historical
     
Upstream Metadata