Requests for clearing streets of snow
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 | 98290 7438 174832 18779 33276 view top 100 |
requested_datetime | requested_datetime | calendar_date | The date and time when the service request was made | 2004-12-29T05:00:00.000 2011-01-25T05:00:00.000 2009-02-02T05:00:00.000 2010-02-19T05:00:00.000 2011-01-13T05: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-09T12:11:20.000 2020-10-09T12:11:19.000 2020-10-09T12:11:26.000 view top 100 |
closed_date | closed_date | calendar_date | Date and time the request record was closed | 2004-12-29T05:00:00.000 2011-01-25T05:00:00.000 2009-02-02T05:00:00.000 2010-02-19T05:00:00.000 2011-01-13T05: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 | Street Snow Removal view top 100 |
description | description | text | The text of the request | Have not shoveled sidewalk Snow on the sidewalks icy sidewalks Have not shoveled sidewalks SNOW ON SIDEWALK view top 100 |
agency_responsible | agency_responsible | text | City department responsible for handling the request | HAND Street Department Engineering Parking Services Parks and Recreation view top 100 |
address | address | text | x 400 S High ST 1817 E 2nd ST 619 N Washington ST 415 W 7th ST view top 100 | |
city | city | text | Bloomington view top 100 | |
state | state | text | IN view top 100 | |
zip | zip | number | 47401 47404 47403 47408 view top 100 | |
lat | lat | number | 39.16287994 39.16120148 39.16896057 39.17238235 39.16835403 view top 100 | |
long | long | number | -86.51124573 -86.50881958 -86.53256989 -86.53392792 -86.53817749 view top 100 | |
Georeference | geocoded_column | point | {"coordinates":[-86.50881958,39.16287994],"type":"Point"} {"coordinates":[-86.51124573,39.16120148],"type":"Point"} {"coordinates":[-86.53817749,39.16835403],"type":"Point"} {"coordinates":[-86.53256989,39.17238235],"type":"Point"} {"coordinates":[-86.53392792,39.16896057],"type":"Point"} view top 100 |