311 Service Requests for Fiscal Year 2020 - 2021 Litter
www.dallasopendata.com | Last Updated 13 Oct 2021There are over 400 service requests types that are reported in the 311 system that affect the quality of life of our citizens, neighborhoods, and communities. The most popular service requests include but are not limited to animal services requests, high weeds, junk motor vehicles, and a number of other code compliance-related issues. Requests regarding streets and mobility (such as street and pot hole repair) are also common as well as requests to address environmental issues such as water conservation and air quality concerns. This dataset represents all Service Requests related to litter for the fiscal year time period of October 1, 2020 to September 30, 2021.
This dataset has the following 17 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| SERVICE_REQUEST_NUMBER | service_request_number | text | Tracking number associated with a service request beginning with the last two digits of the year the service request was created. |
| ADDRESS | address | text | The location where the service will take place |
| CITY_COUNCIL_DISTRICT | city_council_district | number | The number of the City Council District where the service will take place |
| DEPARTMENT | department | text | The City Department responsible to responding to the request for service |
| SERVICE_REQUEST_TYPE | service_request_type | text | The type of service being requested |
| ERT(ESTIMATED_RESPONSE_TIME) | ert_estimated_response_time | text | The estimated amount of time it will take the City Department to begin their investigation/response to the request for service |
| ERT_MEASURED_IN | ert_measured_in | text | Defines the increments of time the ERT is measured in (I.E. Hours, Calendar Days, Business Days, Etc.) |
| OVERALL_SERVICE_REQUEST_DUE_DATE | overall_service_request_due | calendar_date | The date the request the department must have the service request completed by for the request to be on time. Requests completed after this date are considered late. |
| STATUS | status | text | Describes the status of the request for service (I.E. New, In Progress, Closed) |
| CREATED_DATE | created_date | calendar_date | The date the service request was submitted |
| UPDATED_DATE | updated_date | calendar_date | The last date an update was made to the request |
| CLOSED_DATE | closed_date | calendar_date | The date the request was completed and closed |
| OUTCOME | outcome | text | A brief statement describing the outcome of the request for service |
| PRIORITY | priority | text | Describes the priorty of the request (Standard, Urgent, Dispatch, etc.) |
| METHOD_RECEIVED_DESC | method_received_desc | text | Describes the method the service request was received (I.E. Phone, Web, Mobile Device, etc.) |
| LAT_LONG_VALUE | lat_long_value | text | The numeric value of the location's latitude and longitude coordinates |
| UNIQUE_KEY | unique_key | text | Internal Key |