cityofchicago/311-service-requests-pot-holes-reported-historical-7as2-ds3y
 
Readme
Updated almost 3 years ago
Indexed 2 hours ago

311 Service Requests - Pot Holes Reported - Historical

As described in http://bit.ly/311HistoricalPost, 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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
LONGITUDElongitudelongitudeNumber
LATITUDElatitudelatitudeNumber
X COORDINATEx_coordinatex_coordinateNumber
ZIPzipzipNumber
STREET ADDRESSstreet_addressstreet_addressText
MOST RECENT ACTIONmost_recent_actionmost_recent_actionText
CURRENT ACTIVITYcurrent_activitycurrent_activityText
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumber
Historical Wards 2003-2015:@computed_region_awaf_s7ux:@computed_region_awaf_s7uxNumber
LOCATIONlocationlocationPoint
Police Districtpolice_districtpolice_districtNumber
STATUSstatusstatusText
TYPE OF SERVICE REQUESTtype_of_service_requesttype_of_service_requestText
COMPLETION DATEcompletion_datecompletion_dateCalendar date
CREATION DATEcreation_datecreation_dateCalendar date
WardwardwardNumber
SERVICE REQUEST NUMBERservice_request_numberservice_request_numberText
NUMBER OF POTHOLES FILLED ON BLOCKnumber_of_potholes_filled_on_blocknumber_of_potholes_filled_on_blockNumber
Census Tracts:@computed_region_bdys_3d7i:@computed_region_bdys_3d7iNumber
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumber
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumber
LOCATION (city)location_citylocation_cityText
LOCATION (address)location_addresslocation_addressText
LOCATION (zip)location_ziplocation_zipText
Community Areacommunity_areacommunity_areaNumber
SSAssassaTextSpecial 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
LOCATION (state)location_statelocation_stateText
Y COORDINATEy_coordinatey_coordinateNumber
Upstream Metadata