311 Service Requests - Alley Lights Out
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | t28b-ys7j |
| Name | 311 Service Requests - Alley Lights Out |
| Attribution | City of Chicago |
| Category | Service Requests |
| Tags | streets, alleys, lights |
| Created | 2012-04-05T20:07:54Z |
| Publication Date | 2017-04-20T10:29:43Z |
Description
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. If two requests regarding the same address are made within 30 calendar days of each other, the newest CSR 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. 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 |
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:t28b-ys7j d:2011-01-01T00:00:00.000Z t:ward=14 t:zip_code=60632 t:police_district=9 t:status="Completed - Dup" t:service_request_number=11-00001814 t:type_of_service_request="Alley Light Out" t:community_area=58 t:street_address="4316 S SACRAMENTO AVE" m:longitude=-87.69933194705028 m:latitude=41.81517646745516
series e:t28b-ys7j d:2011-01-01T00:00:00.000Z t:ward=34 t:zip_code=60643 t:police_district=5 t:status="Completed - Dup" t:service_request_number=11-00002131 t:type_of_service_request="Alley Light Out" t:community_area=53 t:street_address="12256 S THROOP ST" m:longitude=-87.65386985854649 m:latitude=41.67114764355224
series e:t28b-ys7j d:2011-01-01T00:00:00.000Z t:ward=18 t:zip_code=60629 t:police_district=8 t:status="Completed - Dup" t:service_request_number=11-00002721 t:type_of_service_request="Alley Light Out" t:community_area=66 t:street_address="6949 S ROCKWELL ST" m:longitude=-87.68820480368018 m:latitude=41.76717991767958
Meta Commands
metric m:latitude p:long l:Latitude t:dataTypeName=number
metric m:longitude p:long l:Longitude t:dataTypeName=number
entity e:t28b-ys7j l:"311 Service Requests - Alley Lights Out" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/t28b-ys7j
property e:t28b-ys7j t:meta.view v:id=t28b-ys7j v:category="Service Requests" v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="311 Service Requests - Alley Lights Out" v:attribution="City of Chicago"
property e:t28b-ys7j 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:t28b-ys7j 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 |
| =================== | =============== | =================== | ====================== | ======================= | ===================== | ======== | ================ | ================ | ==== | =============== | ============== | ================== | ================== |
| | STATUS | | SERVICE REQUEST NUMBER | TYPE OF SERVICE REQUEST | STREET ADDRESS | | | | | | | | |
| 2011-01-01T00:00:00 | Completed - Dup | 2011-01-02T00:00:00 | 11-00001814 | Alley Light Out | 4316 S SACRAMENTO AVE | 60632 | 1157077.82962754 | 1875878.20800447 | 14 | 9 | 58 | 41.81517646745516 | -87.69933194705028 |
| 2011-01-01T00:00:00 | Completed - Dup | 2011-01-02T00:00:00 | 11-00002131 | Alley Light Out | 12256 S THROOP ST | 60643 | 1169885.18988818 | 1823490.1964662 | 34 | 5 | 53 | 41.67114764355224 | -87.65386985854649 |
| 2011-01-01T00:00:00 | Completed - Dup | 2011-01-02T00:00:00 | 11-00002721 | Alley Light Out | 6949 S ROCKWELL ST | 60629 | 1160242.32740792 | 1858411.16951698 | 18 | 8 | 66 | 41.76717991767958 | -87.68820480368018 |
| 2011-01-01T00:00:00 | Completed - Dup | 2011-01-02T00:00:00 | 11-00002731 | Alley Light Out | 5300 S WASHTENAW AVE | 60632 | 1159271.90601236 | 1869409.61562889 | 14 | 9 | 63 | 41.797381114669676 | -87.69146089039006 |
| 2011-01-01T00:00:00 | Completed - Dup | 2011-01-02T00:00:00 | 11-00003144 | Alley Light Out | 12442 S LA SALLE ST | 60628 | 1177527.17909801 | 1822448.27412904 | 9 | 5 | 53 | 41.66811969055759 | -87.62593190085083 |
| 2011-01-01T00:00:00 | Completed - Dup | 2011-01-02T00:00:00 | 11-00003188 | Alley Light Out | 9410 S RACINE AVE | 60620 | 1169976.96250524 | 1842378.65757736 | 21 | 22 | 73 | 41.722978614106935 | -87.65298790565937 |
| 2011-01-01T00:00:00 | Completed - Dup | 2011-01-02T00:00:00 | 11-00003273 | Alley Light Out | 10531 S AVENUE E | 60617 | 1203823.48118116 | 1835742.52229254 | 10 | 4 | 52 | 41.70396765780105 | -87.52924094215103 |
| 2011-01-01T00:00:00 | Completed - Dup | 2011-01-03T00:00:00 | 11-00001316 | Alley Light Out | 5132 S NASHVILLE AVE | 60638 | 1133247.0698825 | 1869829.87361304 | 23 | 8 | 56 | 41.79902799484382 | -87.78688959608697 |
| 2011-01-01T00:00:00 | Completed - Dup | 2011-01-03T00:00:00 | 11-00002259 | Alley Light Out | 5400 N NEVA AVE | 60656 | 1127676.79528426 | 1935426.03580553 | 41 | 16 | 10 | 41.97912874964131 | -87.80583880940901 |