311 Service Requests - Rodent Baiting

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id 97t6-zrhs
Name 311 Service Requests - Rodent Baiting
Attribution City of Chicago
Category Service Requests
Tags rodents, rats
Created 2011-09-30T09:07:40Z
Publication Date 2017-04-21T09:00:51Z

Description

All open rodent baiting requests and rat complaints made to 311 and all requests completed since January 1, 2011. 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.” 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      | numeric metric | number_of_premises_baited       | Number of Premises Baited       | number        | number        |
| Yes      | numeric metric | number_of_premises_with_garbage | Number of Premises with Garbage | number        | number        |
| Yes      | numeric metric | number_of_premises_with_rats    | Number of Premises with Rats    | number        | number        |
| Yes      | series tag     | current_activity                | Current Activity                | text          | text          |
| Yes      | series tag     | most_recent_action              | Most Recent Action              | 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:97t6-zrhs d:2011-01-01T00:00:00.000Z t:ward=3 t:police_district=9 t:zip_code=60609 t:most_recent_action="Inspected and baited" t:status=Completed t:service_request_number=11-00000992 t:current_activity="Dispatch Crew" t:community_area=37 t:type_of_service_request="Rodent Baiting/Rat Complaint" t:street_address="437 W ROOT ST" m:number_of_premises_baited=2 m:number_of_premises_with_garbage=1 m:longitude=-87.63695396416237 m:latitude=41.81904110375691 m:number_of_premises_with_rats=2

series e:97t6-zrhs d:2011-01-01T00:00:00.000Z t:ward=29 t:police_district=15 t:zip_code=60644 t:most_recent_action="Area inspected, no cause and no baiting" t:status=Completed t:service_request_number=11-00001321 t:current_activity="Dispatch Crew" t:community_area=25 t:type_of_service_request="Rodent Baiting/Rat Complaint" t:street_address="5545 W MADISON ST" m:number_of_premises_baited=0 m:number_of_premises_with_garbage=0 m:longitude=-87.7639495188141 m:latitude=41.88025817420532 m:number_of_premises_with_rats=0

series e:97t6-zrhs d:2011-01-01T00:00:00.000Z t:ward=50 t:police_district=24 t:zip_code=60645 t:most_recent_action="Area inspected, no cause and no baiting" t:status=Completed t:service_request_number=11-00001629 t:current_activity="Dispatch Crew" t:community_area=2 t:type_of_service_request="Rodent Baiting/Rat Complaint" t:street_address="2540 W ESTES AVE" m:number_of_premises_baited=0 m:number_of_premises_with_garbage=0 m:longitude=-87.69371292873835 m:latitude=42.01039236610359 m:number_of_premises_with_rats=0

Meta Commands

metric m:number_of_premises_baited p:long l:"Number of Premises Baited" t:dataTypeName=number

metric m:number_of_premises_with_garbage p:long l:"Number of Premises with Garbage" t:dataTypeName=number

metric m:number_of_premises_with_rats p:long l:"Number of Premises with Rats" t:dataTypeName=number

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

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

entity e:97t6-zrhs l:"311 Service Requests - Rodent Baiting" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/97t6-zrhs

property e:97t6-zrhs t:meta.view v:id=97t6-zrhs v:category="Service Requests" v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="311 Service Requests - Rodent Baiting" v:attribution="City of Chicago"

property e:97t6-zrhs 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:97t6-zrhs 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      | number_of_premises_baited | number_of_premises_with_garbage | number_of_premises_with_rats | current_activity | most_recent_action                      | street_address       | zip_code | x_coordinate     | y_coordinate     | ward | police_district | community_area | latitude           | longitude          | 
| =================== | ========= | =================== | ====================== | ============================ | ========================= | =============================== | ============================ | ================ | ======================================= | ==================== | ======== | ================ | ================ | ==== | =============== | ============== | ================== | ================== | 
|                     | STATUS    |                     | SERVICE REQUEST NUMBER | TYPE OF SERVICE REQUEST      |                           |                                 |                              | CURRENT ACTIVITY | MOST RECENT ACTION                      | STREET ADDRESS       |          |                  |                  |      |                 |                |                    |                    | 
| 2011-01-01T00:00:00 | Completed | 2011-01-05T00:00:00 | 11-00000992            | Rodent Baiting/Rat Complaint | 2                         | 1                               | 2                            | Dispatch Crew    | Inspected and baited                    | 437 W ROOT ST        | 60609    | 1174070.65202445 | 1877418.09150898 | 3    | 9               | 37             | 41.81904110375691  | -87.63695396416237 | 
| 2011-01-01T00:00:00 | Completed | 2011-01-05T00:00:00 | 11-00001321            | Rodent Baiting/Rat Complaint | 0                         | 0                               | 0                            | Dispatch Crew    | Area inspected, no cause and no baiting | 5545 W MADISON ST    | 60644    | 1139305.86986935 | 1899470.3932844  | 29   | 15              | 25             | 41.88025817420532  | -87.7639495188141  | 
| 2011-01-01T00:00:00 | Completed | 2011-01-05T00:00:00 | 11-00001629            | Rodent Baiting/Rat Complaint | 0                         | 0                               | 0                            | Dispatch Crew    | Area inspected, no cause and no baiting | 2540 W ESTES AVE     | 60645    | 1158079.07002097 | 1947026.37998249 | 50   | 24              | 2              | 42.01039236610359  | -87.69371292873835 | 
| 2011-01-01T00:00:00 | Completed | 2011-01-05T00:00:00 | 11-00002551            | Rodent Baiting/Rat Complaint | 3                         | 6                               | 3                            | Dispatch Crew    | Inspected and baited                    | 7039 S NORMAL BLVD   | 60621    | 1174168.26431373 | 1858240.98502664 | 6    | 7               | 68             | 41.76641494684121  | -87.63716556232575 | 
| 2011-01-01T00:00:00 | Completed | 2011-01-05T00:00:00 | 11-00002697            | Rodent Baiting/Rat Complaint | 1                         | 3                               | 1                            | Dispatch Crew    | Inspected and baited                    | 1111 E 93RD ST       | 60619    | 1185291.74371894 | 1843539.75029876 | 8    | 4               | 47             | 41.72581895961811  | -87.59685549830274 | 
| 2011-01-01T00:00:00 | Completed | 2011-01-05T00:00:00 | 11-00003085            | Rodent Baiting/Rat Complaint | 1                         | 3                               | 1                            | Dispatch Crew    | Inspected and baited                    | 7756 S TROY ST       | 60652    | 1156723.83741961 | 1852989.47198156 | 18   | 8               | 70             | 41.752373627738436 | -87.70124765768429 | 
| 2011-01-01T00:00:00 | Completed | 2011-01-05T00:00:00 | 11-00003145            | Rodent Baiting/Rat Complaint | 0                         | 0                               | 0                            | Dispatch Crew    | Area inspected, no cause and no baiting | 2511 W AUGUSTA BLVD  | 60622    | 1159481.71357182 | 1906571.08907416 | 26   | 13              | 24             | 41.89935190229656  | -87.68967006324442 | 
| 2011-01-01T00:00:00 | Completed | 2011-01-05T00:00:00 | 11-00003368            | Rodent Baiting/Rat Complaint | 2                         | 9                               | 2                            | Dispatch Crew    | Inspected and baited                    | 6700 S HERMITAGE AVE | 60636    | 1165830.09768491 | 1860263.98562895 | 15   | 7               | 67             | 41.77214745780087  | -87.66767067184314 | 
| 2011-01-01T00:00:00 | Completed | 2011-01-05T00:00:00 | 11-00003411            | Rodent Baiting/Rat Complaint | 0                         | 5                               | 0                            | Dispatch Crew    | No contact, left door hanger            | 1241 N LOCKWOOD AVE  | 60651    | 1140795.50647215 | 1907858.97237715 | 37   | 25              | 25             | 41.90325020713387  | -87.75827322161487 |