There are over 200 violations that are reported in the 311 system that affect the quality of neighborhood life. The most common are high weeds, litter, junk motor vehicles, and bulky trash. Some are more health related like mosquitoes. Others are environmental such as water conservation. The annual volume of reported code violations is approximately 200,000 annually. For the purpose of this data set, cases are grouped into four categories: structure, nuisance, zoning and other.
This dataset has the following 18 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Service Request ID | service_request_id | number | A unique system assigned number | 1114173340 1165153783 1175617526 1253125458 view top 100 |
| Service Request | service_request | text | The case number assigned by the 311 system | 14-00053216 15-00352051 15-00511521 17-00074652 view top 100 |
| Str Num | str_num | number | A verified street address | 829 view top 100 |
| Str Prefix | str_prefix | text | Street Direction | view top 100 |
| Str Nam | str_nam | text | Street Name | EXPOSITION view top 100 |
| Str Suffix | str_suffix | text | Street suffix: Place, court, circle, etc. | AVE view top 100 |
| Zone | zone | text | Zip Code | 75226 view top 100 |
| Department | department | text | Code Compliance | Code Compliance District Group view top 100 |
| Nuisance | nuisance | text | Type of nuisance violation such as Litter, High Weeds | Graffiti Private Property - Residential/Commercial - CCS view top 100 |
| Status | status | text | Open or closed | CLOSED view top 100 |
| Created | created | calendar_date | Date the case was created in the system | 2014-02-18T14:27:00 2015-08-03T11:52:00 2015-11-05T12:45:00 2017-02-21T14:03:00 view top 100 |
| Completed Date | completed_date | calendar_date | Date the case was closed | 2014-02-18T14:30:00 2015-08-03T09:50:00 2015-11-12T13:31:00 2017-02-23T15:42:00 view top 100 |
| Method Received Description | method_received_description | text | How 311 received the complaint | Proactive Mobile Apps Phone view top 100 |
| X_Value | x_value | number | Geo coordinate | 2500881.443 view top 100 |
| Y_Value | y_value | number | Geo coordinate | 6971985.472 view top 100 |
| Type | type | text | Shows the stage of the case: complaint, investigation, resolution | Nuisance Structural view top 100 |
| Location | location | location | Geo coded location | view top 100 |
| Updated | updated | calendar_date | Date the information was updated | 2014-02-18T14:31:00 2015-08-03T11:55:00 2016-01-19T15:54:00 2017-04-08T15:17:00 view top 100 |