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 | 1340328507 1340334024 1340347593 1340348302 1340350072 view top 100 |
Service Request | service_request | text | The case number assigned by the 311 system | 18-00383157 18-00383251 18-00383492 18-00383504 18-00383535 view top 100 |
Str Num | str_num | number | A verified street address | 5427 6924 1811 2903 1519 view top 100 |
Str Prefix | str_prefix | text | Street Direction | E N EAST W S view top 100 |
Str Nam | str_nam | text | Street Name | NORTHWEST HARMONY CONKLIN BRIERFIELD GARLAND view top 100 |
Str Suffix | str_suffix | text | Street suffix: Place, court, circle, etc. | ST AVE DR RD LN view top 100 |
Zone | zone | text | Zip Code | 75210 75241 75216 75215 75233 view top 100 |
Department | department | text | Code Compliance | Code Compliance District Group Quality Citywide Group view top 100 |
Nuisance | nuisance | text | Type of nuisance violation such as Litter, High Weeds | Litter - CCS Bulky Trash Violations - CCS High Weeds - CCS Sidewalk Violations Hazardous - CCS Obstruction Alley/Sidewalk/Street - 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 | 2018-07-30T09:47:00 2018-07-30T14:31:00 2018-07-30T14:32:00 2018-07-30T14:33:00 2018-07-30T14:34:00 view top 100 |
Completed Date | completed_date | calendar_date | Date the case was closed | 2018-07-31T08:10:00 2018-07-31T13:08:00 2018-07-31T13:03:00 2018-07-30T11:23:00 2018-07-31T12:03:00 view top 100 |
Method Received Description | method_received_description | text | How 311 received the complaint | Proactive Web Phone Mobile Apps Mass Entry view top 100 |
X_Value | x_value | number | Geo coordinate | 2505170.062 2482644.686 2476959.251 2530362.436 2499336.478 view top 100 |
Y_Value | y_value | number | Geo coordinate | 6976938.911 6929229.382 6943175.085 6998283.537 6924339.98 view top 100 |
Type | type | text | Shows the stage of the case: complaint, investigation, resolution | Nuisance Zoning Structural Other view top 100 |
Location | location | location | Geo coded location | view top 100 |
Updated | updated | calendar_date | Date the information was updated | 2018-07-30T15:47:00 2018-07-31T12:00:00 2018-07-31T12:26:00 2018-07-31T12:36:00 2018-07-31T12:37:00 view top 100 |