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 | 1165293563 1165295588 1165296393 1165297252 1165298812 view top 100 |
Service Request | service_request | text | The case number assigned by the 311 system | 15-00354241 15-00354275 15-00354292 15-00354308 15-00354332 view top 100 |
Str Num | str_num | number | A verified street address | 827 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 | Junk Motor Vehicle - CCS 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 | 2015-08-04T12:04:00 2015-08-04T12:14:00 2015-08-04T12:19:00 2015-08-04T12:24:00 2015-08-04T12:31:00 view top 100 |
Completed Date | completed_date | calendar_date | Date the case was closed | 2015-08-04T09:00:00 2015-08-04T12:18:00 2015-08-04T09:04:00 2015-08-04T09:06:00 2015-08-04T09:10: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 | 2500870.746 2500870.745 view top 100 |
Y_Value | y_value | number | Geo coordinate | 6971988.615 6971988.616 view top 100 |
Type | type | text | Shows the stage of the case: complaint, investigation, resolution | Zoning Nuisance Structural view top 100 |
Location | location | location | Geo coded location | view top 100 |
Updated | updated | calendar_date | Date the information was updated | 2015-08-10T11:33:00 2015-08-10T11:32:00 2015-08-10T14:45:00 2015-08-13T09:32:00 2015-08-13T09:31:00 view top 100 |