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.


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


Last Modified




Update Frequency


Temporal Coverage


Spatial Coverage

Chicago United States


John Snow Labs; Data City of Chicago;

Source License URL

Source License Requirements


Source Citation



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

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
2018-12-18Open - Duplicate18-033873598144 S WOODLAWN AVE60619844541.74664278-87.59537685
2018-12-18Open - Duplicate18-033887326529 S ARTESIAN AVE606291686641.77506586-87.6847483
2018-12-18Open - Duplicate18-033883574841 N MEADE AVE6063045161141.96924009-87.78073002
2018-12-18Open18-033876535141 N ST LOUIS AVE6062539171341.97465617-87.71597355
2018-12-18Open18-033885486622 W FOSTER AVE6065645161041.97560547-87.79358383
2018-12-18Completed - Duplicate2019-02-0918-033885338532 S ASHLAND AVE606202167141.73884413-87.66314202
2018-12-18Open - Duplicate18-033877507244 S RHODES AVE60619636941.7631377-87.61157444
2018-12-18Open - Duplicate18-033875439148 S PAXTON AVE60617744841.72894333-87.57065793
2018-12-18Open - Duplicate18-033869557300 S DR MARTIN LUTHER KING JR DR60619636941.76205941-87.61520553
2018-12-18Open18-033874325075 W MONROE ST6064428152541.87941013-87.75251558
Related Data Packages