Requests for snow removal that came in through uReport
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 | 130101 116676 73030 162294 116746 view top 100 |
requested_datetime | requested_datetime | calendar_date | The date and time when the service request was made | 1998-07-08T05:00:00.000 1998-07-10T05:00:00.000 1998-07-09T05:00:00.000 1998-07-07T05:00:00.000 1970-01-01T00: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-09T13:27:39.000 2013-05-09T17:08:41.000 2020-10-09T13:28:18.000 view top 100 |
closed_date | closed_date | calendar_date | Date and time the request record was closed | 1998-07-08T05:00:00.000 1998-07-09T05:00:00.000 1998-07-10T05:00:00.000 1998-07-07T05:00:00.000 1970-01-01T00: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 | Phone Call Other Email Web Form Walk In view top 100 |
service_name | service_name | text | Category in uReport | Sidewalk Snow Removal view top 100 |
description | description | text | The text of the request | STORM DRAIN IS CLOGGED Snow on sidewalk CLOGGED STORM DRAIN Have not shoveled sidewalk. Unsafe walking conditions on sidewalk due to lack of snow and ice removal view top 100 |
agency_responsible | agency_responsible | text | City department responsible for handling the request | HAND Street Department Engineering Utilities Engineering Parks and Recreation view top 100 |
address | address | text | E 1ST N 1ST W 3rd ST 309 N Walnut ST 4100 E Saratoga DR 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.16896057 39.16505051 39.16228485 39.16064453 39.16748428 view top 100 | |
long | long | number | -86.53392792 -86.47867584 -86.51392365 -86.55043030 -86.53092194 view top 100 | |
Georeference | geocoded_column | point | {"coordinates":[-86.47867584,39.16505051],"type":"Point"} {"coordinates":[-86.53392792,39.16896057],"type":"Point"} {"coordinates":[-86.51392365,39.16228485],"type":"Point"} {"coordinates":[-86.5504303,39.16748428],"type":"Point"} {"coordinates":[-86.53092194,39.13237762],"type":"Point"} view top 100 |