311 Service Requests - Pot Holes Reported - Historical
Attribution: City of Chicago · source
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. The Chicago Department of Transportation (CDOT) oversees the patching of potholes on over 4,000 miles of arterial and residential streets in Chicago. CDOT receives reports of potholes through the 311 call center and uses a computerized mapping and tracking system to identify pothole locations and efficiently schedule crews. One call to 311 can generate multiple pothole repairs. When a crew arrives to repair a 311 pothole, it fills all the other potholes within the block. Pothole repairs are generally completed within 7 days from the first report of a pothole to 311. Weather conditions, particularly frigid temps and precipitation, influence how long a repair takes. On days when weather is cooperative and there is no precipitation, crews can fill several thousand potholes. If a previous request is already open for a buffer of 4 addresses the request is given the status of "Duplicate (Open)". For example, if there is an existing CSR for 6535 N Western and a new request is received for 6531 N Western (which is within four addresses of the original CSR) then the new request is given a status of "Duplicate (Open)". Once the street is 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 address is inspected but no potholes are found or have already been filled. If another issue is found with the street, such as a “cave-in” or “failed utility cut”, then it is directed to the appropriate department or contractor. Data Owner: Transportation. Time Period: All open requests and all completed requests since January 1, 2011. Frequency: Data is updated daily.
Dataset Profile
Popularity
Freshness & Tracking
No files attached
Upload a file to get started
Owner & Attribution
Metadata
Schema (24 columns)
Column metadata from the source provider's own profiling
| Column | Type | Cardinality | Nulls | Top Values | Range |
|---|---|---|---|---|---|
CREATION DATE | calendar_date | 3.0K | 0 | 2014-03-10T00:00:00.2014-01-13T00:00:00.2014-02-24T00:00:00. | 2009-01-12T0 … 2018-12-18T0 |
STATUS | text | 4 | 0 | CompletedCompleted - DupOpen | Completed … Open - Dup |
COMPLETION DATE | calendar_date | 2.1K | 7.3K | 2015-04-29T00:00:00.2015-04-23T00:00:00.2014-08-09T00:00:00. | 2011-01-03T0 … 2018-12-31T0 |
SERVICE REQUEST NUMBER | text | 559.1K | 0 | 16-0457177314-0032218814-00626464 | 09-00061329 … 18-03389580 |
TYPE OF SERVICE REQUEST | text | 2 | 0 | Pothole in StreetPot Hole in Street | Pothole in S … Pot Hole in |
CURRENT ACTIVITY | text | 12 | 166.9K | Final OutcomeDispatch CrewFollow-on SR Update | Complaint Cr … Work Assigne |
MOST RECENT ACTION | text | 34 | 168.5K | Pothole PatchedNo Potholes FoundCompleted Upon Arriv | Area Inspect … WM Water Man |
NUMBER OF POTHOLES FILLED ON BLOCK | number | 270 | 161.3K | 012 | 0 … 320 |
STREET ADDRESS | text | 250.6K | 2 | 55 W JACKSON BLVD1800 S WESTERN AVE8300 S VINCENNES AVE | 0 S MIDWAY A … 9 W SCHILLER |
ZIP | number | 64 | 2.3K | 606296061760628 | 0 … 60827 |
X COORDINATE | number | 231.9K | 474 | 1175844.683589041188504.434302771160643.96316663 | 1092430.2049 … 1205133.2339 |
Y COORDINATE | number | 233.3K | 474 | 1898976.818191751842299.316714881891326.66991828 | 1813891.893 … 1951593.3212 |
Ward | number | 51 | 333 | 414519 | 0 … 50 |
Police District | number | 27 | 334 | 81625 | 0 … 31 |
Community Area | number | 78 | 333 | 252422 | 0 … 77 |
SSA Special Service Areas are local tax districts that fund expanded services and programs, to foster commercial and economic development, through a localized property tax. In other cities these areas are sometimes called Business Improvement Districts (BIDs). This portal contains a map of all Chicago SSAs | text | 53 | 472.9K | 33350 | 1 … 8 |
LATITUDE | number | 247.2K | 876 | 41.8780498425030241.8574743709677941.743504557606016 | 0 … 42.022960452 |
LONGITUDE | number | 247.2K | 876 | -87.62984030496821-87.68596860468548-87.63666279812614 | -87.93613218 … 0 |
LOCATION | location | — | — | — | — |
Historical Wards 2003-2015 | number | — | — | — | — |
Zip Codes | number | — | — | — | — |
Community Areas | number | — | — | — | — |
Census Tracts | number | — | — | — | — |
Wards | number | — | — | — | — |
Resources
Direct links to downloads, APIs, and related pages.