Reports related to City of Bloomington yard waste pickup
This dataset has the following 16 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
service_request_id | service_request_id | number | The unique ID of the service request | 87431 97169 140161 113917 96448 view top 100 |
requested_datetime | requested_datetime | calendar_date | The date and time when the service request was made | 2010-06-03T04:00:00.000 1998-06-29T05:00:00.000 2005-07-08T05:00:00.000 2008-04-11T04:00:00.000 2005-04-05T05:00:00.000 view top 100 |
updated_datetime | updated_datetime | calendar_date | The date and time when the service request was last modified | 2016-09-11T22:02:05.000 2020-10-05T14:42:52.000 2020-10-09T14:03:04.000 2020-10-09T12:57:15.000 2020-10-09T14:40:56.000 view top 100 |
closed_date | closed_date | calendar_date | Date and time the request record was closed | 2010-06-03T04:00:00.000 1998-06-29T05:00:00.000 2008-04-11T04:00:00.000 2005-04-05T05:00:00.000 2005-07-08T05:00:00.000 view top 100 |
status_description | status_description | text | A single-word indicator of the current state of the service request | closed view top 100 |
source | source | text | Mechanism or path by which the service request was received | Other Phone Call Web Form Email Walk In view top 100 |
service_name | service_name | text | Category in uReport | Yard Waste view top 100 |
description | description | text | The text of the request | no sticker no stickers Exceeds weight limit of 40 lbs. Yard waste is over the 40 lb max too heavy must have stickers view top 100 |
agency_responsible | agency_responsible | text | City department responsible for handling the request | Sanitation Department HAND Street Department Planning and Transportation Animal Control view top 100 |
address | address | text | 1008 S Meadowbrook DR 4405 E Walpole LN 1311 E Allendale DR 2837 N Blue Slopes DR 322 W Dodds ST view top 100 | |
city | city | text | Bloomington view top 100 | |
state | state | text | IN view top 100 | |
zip | zip | number | 47401 47408 47404 47403 view top 100 | |
lat | lat | number | 39.18274307 39.15761185 39.15420914 39.17294693 39.16185379 view top 100 | |
long | long | number | -86.54434204 -86.48755646 -86.54319763 -86.53003693 -86.53735352 view top 100 | |
Georeference | geocoded_column | point | {"coordinates":[-86.54434204,39.18274307],"type":"Point"} {"coordinates":[-86.48755646,39.15420914],"type":"Point"} {"coordinates":[-86.47344971,39.17294693],"type":"Point"} {"coordinates":[-86.53735352,39.15761185],"type":"Point"} {"coordinates":[-86.53379059,39.19645309],"type":"Point"} view top 100 |