Go to an accessible version of this page

Chicago
Close
Author
cocadmin
Description
As described in https://data.cityofchicago.org/stories/s/311-Dataset-Changes-12-11-2018/d7nq-5g7t, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only. All open reports of "Street Lights - All Out" (an outage of 3 or more lights) made to 311 and all requests completed since January 1, 2011.The Chicago Department of Transportation (CDOT) oversees approximately 250,000 street lights that illuminate arterial and residential streets in Chicago. CDOT performs repairs and bulb replacements in response to residents’ reports of street light outages. Whenever CDOT receives a report of an “All Out” the electrician assigned to make the repair looks at all the lights in that circuit (each circuit has 8-16 lights) to make sure that they are all working properly. If a second request of lights out in the same circuit is made within four calendar days of the original request, the newest request is automatically given the status of “Duplicate (Open).” Since CDOT's electrician will be looking at all the lights in a circuit to verify that they are all working, any “Duplicate (Open)” address will automatically be observed and repaired. Once the street lights are repaired, the status in CSR will read “Completed” for the original request and “Duplicate (Closed)” for any duplicate requests. A service request also receives the status of “Completed” when the reported lights are inspected but found to be in good repair and functioning; when the service request is for a non-existent address; or when the lights are maintained by a contractor. Data is updated daily.
Category
Service Requests
Tags
streets, lights, historical, service requests, 311
Rating
Current value: 0 out of 5
Data Provided By
City of Chicago
Source Link
http://www.cityofchicago.org
License
See Terms of Use
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size

  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Creation Date
creation_date
Status
status
Completion Date
completion_date
Service Request Number
service_request_number
Type of Service Request
type_of_service_request
Street Address
street_address
ZIP Code
zip_code
X Coordinate
x_coordinate
Y Coordinate
y_coordinate
Ward
ward
Police District
police_district
Community Area
community_area
Latitude
latitude
Longitude
longitude
Location
location
Historical Wards 2003-2015
:@computed_region_awaf_s7ux
Zip Codes
:@computed_region_6mkv_f3dw
Community Areas
:@computed_region_vrxf_vc4k
Census Tracts
:@computed_region_bdys_3d7i
Wards
:@computed_region_43wa_7qmu

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.