Alley Lights Out Service Request

$199 / year

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.

Complexity

Most city alleys are illuminated with 250-watt lights. Over the past decade the number of these alley lights has increased significantly – from 46, 000 in 1989 to more than 67,000 today. Requests for additional alley lights from block clubs and other community organizations—including participants in Chicago’s Alternative Policing Strategy (CAPS) groups are a priority. The request must be made through Alderman and approved by them. The Department of Transportation has implemented several group relamping programs to reduce outages and lower maintenance costs.

If two requests regarding the same address are made within 30 calendar days of each other, the newest CSR (Customer Sales Representative) 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.

Date Created

2015-02-04

Last Modified

2018-06-01

Version

2018-06-01

Update Frequency

Daily

Temporal Coverage

2001-2018

Spatial Coverage

Chicago United States

Source

John Snow Labs => Data City of Chicago

Source License URL

John Snow Labs Standard License

Source License Requirements

N/A

Source Citation

N/A

Keywords

Lights Out, Alley Lights Out, Lights Out Service Request, Watch Lights, Light Pole, Street Lights

Other Titles

Chicago Lights Out Service Request, 311 Reports Service Request

Name Description Type Constraints
Creation_DateService Request Created Datedate-
StatusStatus of Service Requeststring-
Completion_DateService Request Completion Datedate-
Service_Request_NumberA Unique Number Assigned to Service Requeststring-
Street_AddressAddress of the Requesting citizenstring-
ZIP_CodeZip Codeintegerlevel : Nominal
X_CoordinateX Coordinate of Service Requestednumberlevel : Nominal
Y_CoordinateY Coordinate of Service Requestednumberlevel : Nominal
WardWard Numberintegerlevel : Nominal
Police_DistrictPolice Districtintegerlevel : Nominal
Community_AreaCommunity Areaintegerlevel : Nominal
LatitudeLatitude Location of Service Requested-
LongitudeLongitude Location of Service Requested-
Creation_DateStatusCompletion_DateService_Request_NumberStreet_AddressZIP_CodeX_CoordinateY_CoordinateWardPolice_DistrictCommunity_AreaLatitudeLongitude
2018-05-09Open18-01467523
2018-05-03Open18-01408573
2018-03-05Open18-00831766
2018-02-27Open18-00783158
2012-09-18Completed2012-09-1812-01630621
2012-12-31Completed2012-12-3112-02054762
2012-12-31Completed2012-12-3112-02054764
2013-04-08Completed2013-04-0813-003940621 S YATES
2013-02-08Completed2013-02-0813-001515701 W IRVING
2013-06-20Completed2013-06-2013-00792289520 W 66TH