Rodent Baiting Requested by 311 Service

$79 / year

This dataset shows the rodent baiting request reported by the 311 Service. It includes all open requests and all completed requests since January 1, 2011.

Complexity

The Department of Streets & Sanitation investigates reported rat sightings. Alley conditions are examined. If any damaged carts are identified, Sanitation Ward Offices, which distribute the carts are notified. Rodenticide is placed in rat burrows to eradicate nests. 311 sometimes receives duplicate rat complaints and requests for rodent baiting. Requests that have been labeled as Duplicates are in the same geographic area and have been entered into 311’s Customer Service Requests (CSR) system at around the same time as a previous request. Duplicate reports/requests are labeled as such in the Status field, as either “Open – Dup” or “Completed – Dup.”

Date Created

2011-09-30

Last Modified

2018-06-11

Version

2018-06-11

Update Frequency

Daily

Temporal Coverage

2011-2018

Spatial Coverage

United States

Source

John Snow Labs => Chicago Data Portal

Source License URL

John Snow Labs Standard License

Source License Requirements

N/A

Source Citation

N/A

Keywords

Rodent Baiting, 311 Service Request, Rodent Baiting Request, Rat Sightings, Distribution of Carts, Rat Complaints, Rodent Baiting and Rat Complaints

Other Titles

Rodent Baiting in Chicago, Rat Complaints in Chicago

Name Description Type Constraints
Creation_DateDate Service Request was receiveddate-
StatusStatus of the Service Request (Completed, Completed-Dup, Open, Open-Dup)string-
Completion_DateDate Service Request was receiveddate-
Service_Request_NumberA unique Service Request Number for reportingstring-
Number_of_Premises_BaitedTotal number of request for premises baitednumberlevel : Ratio
Number_of_Premises_with_GarbageTotal number of Premises with Garbageintegerlevel : Ratio
Number_of_Premises_with_RatsTotal number of Premises with Ratsnumberlevel : Ratio
Current_ActivityLocation of the requested baitingstring-
Most_Recent_ActionLocation of the requested baitingstring-
Street_AddressAddress Street Number of the baiting requeststring-
ZIP_CodeZip Code of baiting requestintegerlevel : Nominal
Ward_NumberWard Number assigned with physical addressintegerlevel : Nominal
Police_DistrictPolice District Number of physical addressintegerlevel : Nominal
Community_AreaIndicates the community area where the rodent baiting was requested. Chicago has 77 community areas.integerlevel : Nominal
LatitudeLatitude Location from where the request was made-
LongitudeLongitude Location from where the request was made-
Creation_DateStatusCompletion_DateService_Request_NumberNumber_of_Premises_BaitedNumber_of_Premises_with_GarbageNumber_of_Premises_with_RatsCurrent_ActivityMost_Recent_ActionStreet_AddressZIP_CodeWard_NumberPolice_DistrictCommunity_AreaLatitudeLongitude
2016-06-14Completed2016-06-1416-04137216741 O
2011-06-29Completed2011-07-2011-032710626762920 N BRIDGEWAY
2018-06-08Open18-017497982147 W OHIO ST6061226122441.89221-87.680558
2018-06-08Open18-01756128222 W 31ST ST606161193441.83822491-87.6325342
2018-06-08Open18-01751450829 W 34TH PL606081196041.8317682-87.64684244
2018-06-08Open18-01752891508 W ELM ST606102718841.90269079-87.64151419
2018-06-07Open18-01741198427 E 41ST ST60653323841.82025353-87.61558473
2018-06-07Open18-01743125313 W 48TH PL60609393741.80601576-87.63378672
2018-06-10Open18-017680622800 W FULTON ST27122741.88653796-87.69643256
2018-06-10Open18-017691651332 W 77TH ST606201767141.75409162-87.656702