Alley Lights Out Service Request

$447.50 / 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-12-25

Version

2018-12-25

Update Frequency

Daily

Temporal Coverage

2001-2018

Spatial Coverage

Chicago United States

Source

John Snow Labs; Data City of Chicago;

Source License URL

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

NameDescriptionTypeConstraints
Creation_DateService Request Created Datedate-
Request_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
Ward_NumberThe ward number used in the street.integerlevel : Nominal
Police_DistrictIndicates the police district where the lights out service was requested.integerlevel : Nominal
Community_AreaIndicates the community area where the lights out service was requested. Chicago has 77 community areas.integerlevel : Nominal
LatitudeLatitude Location of Service Requestednumber-
LongitudeLongitude Location of Service Requestednumber-
Creation_DateRequest_StatusCompletion_DateService_Request_NumberStreet_AddressZIP_CodeWard_NumberPolice_DistrictCommunity_AreaLatitudeLongitude
2012-12-31Completed2012-12-3112-02054762
2012-12-31Completed2012-12-3112-02054764
2012-09-18Completed2012-09-1812-01630621
2013-04-08Completed2013-04-0813-003940621 S YATES
2013-06-20Completed2013-06-2013-00792289520 W 66TH
2013-02-08Completed2013-02-0813-001515701 W IRVING
2013-06-03Completed2013-06-0313-006822541 W LAKE42132
2013-04-26Completed2013-04-2613-004917231 W LAKE42132
2013-04-25Completed2013-04-2513-004853831 W LAKE42132
2013-04-24Completed2013-04-2413-004793741 W LAKE42132
Related Data Packages