Others titles
- Chicago Lights Out Service Request
- 311 Reports Service Request
Keywords
- Lights Out
- Alley Lights Out
- Lights Out Service Request
- Watch Lights
- Light Pole
- Street Lights
Alley Lights Out Service Request
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.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
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.
About this Dataset
Data Info
Date Created | 2015-02-04 |
---|---|
Last Modified | 2019-03-08 |
Version | 2019-03-08 |
Update Frequency |
Quarterly |
Temporal Coverage |
2001-2019 |
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 |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Creation_Date | Service Request Created Date | date | - |
Request_Status | Status of Service Request | string | - |
Completion_Date | Service Request Completion Date | date | - |
Service_Request_Number | A Unique Number Assigned to Service Request | string | - |
Street_Address | Address of the Requesting citizen | string | - |
ZIP_Code | Zip Code | integer | level : Nominal |
Ward_Number | The ward number used in the street. | integer | level : Nominal |
Police_District | Indicates the police district where the lights out service was requested. | integer | level : Nominal |
Community_Area | Indicates the community area where the lights out service was requested. Chicago has 77 community areas. | integer | level : Nominal |
Latitude | Latitude Location of Service Requested | number | - |
Longitude | Longitude Location of Service Requested | number | - |
Data Preview
Creation Date | Request Status | Completion Date | Service Request Number | Street Address | ZIP Code | Ward Number | Police District | Community Area | Latitude | Longitude |
2018-12-18 | Open - Duplicate | 18-03387359 | 8144 S WOODLAWN AVE | 60619 | 8 | 4 | 45 | 41.74664278 | -87.59537685 | |
2018-12-18 | Open - Duplicate | 18-03388732 | 6529 S ARTESIAN AVE | 60629 | 16 | 8 | 66 | 41.77506586 | -87.6847483 | |
2018-12-18 | Open - Duplicate | 18-03388357 | 4841 N MEADE AVE | 60630 | 45 | 16 | 11 | 41.96924009 | -87.78073002 | |
2018-12-18 | Open | 18-03387653 | 5141 N ST LOUIS AVE | 60625 | 39 | 17 | 13 | 41.97465617 | -87.71597355 | |
2018-12-18 | Open | 18-03388548 | 6622 W FOSTER AVE | 60656 | 45 | 16 | 10 | 41.97560547 | -87.79358383 | |
2018-12-18 | Completed - Duplicate | 2019-02-09 | 18-03388533 | 8532 S ASHLAND AVE | 60620 | 21 | 6 | 71 | 41.73884413 | -87.66314202 |
2018-12-18 | Open - Duplicate | 18-03387750 | 7244 S RHODES AVE | 60619 | 6 | 3 | 69 | 41.7631377 | -87.61157444 | |
2018-12-18 | Open - Duplicate | 18-03387543 | 9148 S PAXTON AVE | 60617 | 7 | 4 | 48 | 41.72894333 | -87.57065793 | |
2018-12-18 | Open - Duplicate | 18-03386955 | 7300 S DR MARTIN LUTHER KING JR DR | 60619 | 6 | 3 | 69 | 41.76205941 | -87.61520553 | |
2018-12-18 | Open | 18-03387432 | 5075 W MONROE ST | 60644 | 28 | 15 | 25 | 41.87941013 | -87.75251558 |