311 Service Requests - Street Lights - One Out

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id 3aav-uy2v
Name 311 Service Requests - Street Lights - One Out
Attribution City of Chicago
Category Service Requests
Tags streets, lights
Created 2012-04-05T20:04:10Z
Publication Date 2017-04-21T07:18:14Z

Description

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.

Columns

| Included | Schema Type    | Field Name              | Name                    | Data Type     | Render Type   |
| ======== | ============== | ======================= | ======================= | ============= | ============= |
| Yes      | time           | creation_date           | Creation Date           | calendar_date | calendar_date |
| Yes      | series tag     | status                  | Status                  | text          | text          |
| No       |                | completion_date         | Completion Date         | calendar_date | calendar_date |
| Yes      | series tag     | service_request_number  | Service Request Number  | text          | text          |
| Yes      | series tag     | type_of_service_request | Type of Service Request | text          | text          |
| Yes      | series tag     | street_address          | Street Address          | text          | text          |
| Yes      | series tag     | zip_code                | ZIP Code                | text          | number        |
| No       |                | x_coordinate            | X Coordinate            | number        | number        |
| No       |                | y_coordinate            | Y Coordinate            | number        | number        |
| Yes      | series tag     | ward                    | Ward                    | text          | number        |
| Yes      | series tag     | police_district         | Police District         | text          | number        |
| Yes      | series tag     | community_area          | Community Area          | text          | number        |
| Yes      | numeric metric | latitude                | Latitude                | number        | number        |
| Yes      | numeric metric | longitude               | Longitude               | number        | number        |
| Yes      | series tag     | location                | Location                | text          | text          |

Time Field

Value = creation_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = completion_date,x_coordinate,y_coordinate

Data Commands

series e:3aav-uy2v d:2013-01-09T00:00:00.000Z t:ward=5 t:zip_code=60619 t:police_district=4 t:location=(41.75828320385884,-87.59322411776203) t:status=Completed t:service_request_number=13-00036629 t:type_of_service_request="Street Light - 1/Out" t:community_area=43 t:street_address="7514 S KIMBARK AVE" m:longitude=-87.59322411776203 m:latitude=41.75828320385884

series e:3aav-uy2v d:2013-01-09T00:00:00.000Z t:ward=9 t:zip_code=60628 t:police_district=5 t:location=(41.71150624166045,-87.62962423539825) t:status=Completed t:service_request_number=13-00036712 t:type_of_service_request="Street Light - 1/Out" t:community_area=49 t:street_address="10057 S YALE AVE" m:longitude=-87.62962423539825 m:latitude=41.71150624166045

series e:3aav-uy2v d:2013-01-09T00:00:00.000Z t:ward=10 t:zip_code=60617 t:police_district=4 t:location=(41.689898813235565,-87.5401022889258) t:status=Completed t:service_request_number=13-00032399 t:type_of_service_request="Street Light - 1/Out" t:community_area=52 t:street_address="11308 S AVENUE O" m:longitude=-87.5401022889258 m:latitude=41.689898813235565

Meta Commands

metric m:latitude p:long l:Latitude t:dataTypeName=number

metric m:longitude p:long l:Longitude t:dataTypeName=number

entity e:3aav-uy2v l:"311 Service Requests - Street Lights - One Out" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/3aav-uy2v

property e:3aav-uy2v t:meta.view v:id=3aav-uy2v v:category="Service Requests" v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="311 Service Requests - Street Lights - One Out" v:attribution="City of Chicago"

property e:3aav-uy2v t:meta.view.owner v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:displayName=cocadmin v:privilegesDisabled=false

property e:3aav-uy2v t:meta.view.tableauthor v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:roleName=administrator v:displayName=cocadmin v:privilegesDisabled=false

Top Records

| creation_date       | status          | completion_date     | service_request_number | type_of_service_request | street_address      | zip_code | x_coordinate     | y_coordinate     | ward | police_district | community_area | latitude           | longitude          | location                               | 
| =================== | =============== | =================== | ====================== | ======================= | =================== | ======== | ================ | ================ | ==== | =============== | ============== | ================== | ================== | ====================================== | 
|                     | STATUS          |                     | SERVICE REQUEST NUMBER | TYPE OF SERVICE REQUEST | STREET ADDRESS      |          |                  |                  |      |                 |                |                    |                    | LOCATION                               | 
| 2013-01-09T00:00:00 | Completed       | 2013-01-14T00:00:00 | 13-00036629            | Street Light - 1/Out    | 7514 S KIMBARK AVE  | 60619    | 1186181.29271973 | 1855377.9278059  | 5    | 4               | 43             | 41.75828320385884  | -87.59322411776203 | (41.75828320385884,-87.59322411776203) | 
| 2013-01-09T00:00:00 | Completed       | 2013-01-14T00:00:00 | 13-00036712            | Street Light - 1/Out    | 10057 S YALE AVE    | 60628    | 1176389.19789488 | 1838249.52283384 | 9    | 5               | 49             | 41.71150624166045  | -87.62962423539825 | (41.71150624166045,-87.62962423539825) | 
| 2013-01-09T00:00:00 | Completed       | 2013-01-15T00:00:00 | 13-00032399            | Street Light - 1/Out    | 11308 S AVENUE O    | 60617    | 1200904.76567377 | 1830588.4890165  | 10   | 4               | 52             | 41.689898813235565 | -87.5401022889258  | (41.689898813235565,-87.5401022889258) | 
| 2013-01-09T00:00:00 | Completed       | 2013-01-15T00:00:00 | 13-00036769            | Street Light - 1/Out    | 5100 S STATE ST     | 60609    | 1177137.85443359 | 1871213.28607877 | 3    | 2               | 40             | 41.8019457977942   | -87.62588976253781 | (41.8019457977942,-87.62588976253781)  | 
| 2013-01-09T00:00:00 | Completed       | 2013-01-18T00:00:00 | 13-00036754            | Street Light - 1/Out    | 9400 S EWING AVE    | 60617    | 1201315.87190145 | 1843355.64351312 | 10   | 4               | 52             | 41.72492255854294  | -87.53816565542006 | (41.72492255854294,-87.53816565542006) | 
| 2011-01-10T00:00:00 | Completed - Dup | 2011-01-10T00:00:00 | 11-00040726            | Street Light - 1/Out    | 504 S LARAMIE AVE   | 60644    | 1141805.69327098 | 1897171.84208577 | 29   | 15              | 25             | 41.87390478023467  | -87.75482720289442 | (41.87390478023467,-87.75482720289442) | 
| 2011-01-10T00:00:00 | Completed - Dup | 2011-01-10T00:00:00 | 11-00045711            | Street Light - 1/Out    | 6024 W FLETCHER ST  | 60634    | 1135678.45182563 | 1920316.30008648 | 36   | 25              | 19             | 41.93752716036715  | -87.77677255497987 | (41.93752716036715,-87.77677255497987) | 
| 2011-01-10T00:00:00 | Completed - Dup | 2011-01-10T00:00:00 | 11-00046826            | Street Light - 1/Out    | 4900 S HALSTED ST   | 60609    | 1171799.94262892 | 1872291.50600304 | 3    | 9               | 61             | 41.80502343693148  | -87.64543428405335 | (41.80502343693148,-87.64543428405335) | 
| 2011-01-10T00:00:00 | Completed - Dup | 2011-01-11T00:00:00 | 11-00043524            | Street Light - 1/Out    | 5226 W SCHUBERT AVE | 60639    | 1141078.47442537 | 1917455.97897947 | 31   | 25              | 19             | 41.9295802328296   | -87.7569969091612  | (41.9295802328296,-87.7569969091612)   |