Baselight

311 Service Requests - Street Lights - One Out - Historical

City of Chicago

@usgov.city_of_chicago_311_service_requests_street_lights_one_ad077086

Loading...
Loading...

About this Dataset

311 Service Requests - Street Lights - One Out - Historical

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.

This dataset contains all open 311 reports of one or two lights out on metal poles on a residential or arterial street and all completed requests since January 1, 2011. Whenever CDOT receives a report of a street light outage, the electrician assigned to make the repair looks at all the lights in a group (circuit) to make sure that they are working properly. If two requests regarding the same group are made within 30 calendar days of each other, the newest CSR is automatically given the status of “Duplicate (Open).” Since the electrician will be looking at all the lights in a group to verify that they are all working the “Duplicate (Open)” address will also be observed and repaired. Once the street lights are repaired, the CSR status will read “Completed” for the original request and “Duplicate (Closed)” for any duplicate requests. Data is updated daily.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:18.765838
Tags: 311, historical, lights, service-requests, streets

Tables

Table 1

@usgov.city_of_chicago_311_service_requests_street_lights_one_ad077086.table_1
  • 33.5 MB
  • 490937 rows
  • 15 columns
Loading...

CREATE TABLE table_1 (
  "creation_date" TIMESTAMP,
  "status" VARCHAR,
  "completion_date" TIMESTAMP,
  "service_request_number" VARCHAR,
  "type_of_service_request" VARCHAR,
  "street_address" VARCHAR,
  "zip_code" DOUBLE,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "ward" DOUBLE,
  "police_district" DOUBLE,
  "community_area" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);

Share link

Anyone who has the link will be able to view this.