Litter 311 Service Requests January 1 2017 to June 30 2018
www.dallasopendata.com | Last Updated 30 Jan 2024There 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 that deal with streets and mobility such as street and pot hole repair are also very common. 311 also receives requests to address environmental issues such as water conservation and air quality complaints. This dataset represents all Service Requests for the fiscal year time period of October 1, 2016 to September 30, 2017.
This dataset has the following 18 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| Service Request Number | service_request_number | text | Unique ID given to each documented request for a city service; the first two digits designate the last two digits of the calendar year the service request was created (e.g., 16 = 2016) |
| Address | address | text | Street Address |
| City Council District | city_council_district | number | Geographical borderlines for legislative representation throughout the city |
| Department | department | text | City Departments and Offices |
| Service Request Type | service_request_type | text | Type of complaint submitted by customer or service offered by the City |
| ERT (Estimated Response Time) | ert_estimated_response_time | number | The time allotted for the initial inspection and/or assessment. (There may be variance from department to department concerning calendar versus business days.) |
| Overall Service Request Due Date | overall_service_request_due_date | calendar_date | The service request and all activities should be completed by the listed date |
| Status | status | text | Denotes whether a service request is currently being actively worked or has been resolved |
| Created Date | created_date | calendar_date | Date the service request was created |
| Update Date | update_date | calendar_date | Date the service request was last updated with new information or activity |
| Closed Date | closed_date | calendar_date | Date the service request was completed |
| Outcome | outcome | text | Documents the action taken on a service request |
| Priority | priority | text | Denotes the precedence of how a service request will be handled |
| Method Received Description | method_received_description | text | Mode in which 311 receives the request for service |
| X Coordinate | x_coordinate | number | Denotes a point where (x axis) horizontal lines intersect on a map |
| Y Coordinate | y_coordinate | number | Denotes a point where vertical (y axis) lines intersect on a map |
| Lat Long Location | lat_long_location | location | Denotes a location point on a longitude line (perpendicular to the equator) and latitude line (parallel to the equator) |
| Unique Key | unique_key | text | Internal Key |