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 | 1280606021 1134811063 1197862834 1301902484 1219790545 view top 100 |
Service Request | service_request | text | The case number assigned by the 311 system | 14-00122137 13-00514422 17-00318820 16-00056997 14-00143517 view top 100 |
Str Num | str_num | number | A verified street address | 2700 2300 100 3000 2400 view top 100 |
Str Prefix | str_prefix | text | Street Direction | S N W E EAST view top 100 |
Str Nam | str_nam | text | Street Name | ILLINOIS BUCKNER HAMPTON LEDBETTER ROYAL view top 100 |
Str Suffix | str_suffix | text | Street suffix: Place, court, circle, etc. | DR AVE ST RD LN view top 100 |
Zone | zone | text | Zip Code | 75216 75217 75228 75211 75227 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 | High Weeds - CCS Litter - CCS Obstruction Alley/Sidewalk/Street - CCS Garage Sale Tracking - CCS Bulky Trash Violations - 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-07-30T00:00:00.000 2015-07-17T00:00:00.000 2015-07-11T00:00:00.000 2014-11-01T00:00:00.000 2014-07-26T00:00:00.000 view top 100 |
Completed Date | completed_date | calendar_date | Date the case was closed | 2013-10-21T10:23:00.000 2014-09-26T08:00:00.000 2015-12-07T08:21:00.000 2014-07-26T00:00:00.000 2014-11-01T00:00:00.000 view top 100 |
Method Received Description | method_received_description | text | How 311 received the complaint | Proactive Phone Web Mobile Apps Mass Entry view top 100 |
X_Value | x_value | number | Geo coordinate | 0 2465181.544 2436319.623 2535408.212 2477913.545 view top 100 |
Y_Value | y_value | number | Geo coordinate | 0 7002286.725 6935909.841 6968655.09 6925060.399 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 | 2015-07-10T00:00:00.000 2015-05-02T00:00:00.000 2014-02-21T00:00:00.000 2014-11-01T00:00:00.000 2014-06-03T00:00:00.000 view top 100 |