Code Violations Neighborhood Code Fiscal Year 2020 - 2021

There are over 80,000 Code Concerns that are reported in the 311 system every fiscal year. These concerns affect the quality of life for the citizens and visitors of our city. A Code Concern reported at a specific addressed location may contain anywhere from one (1) to multiple violation types. The most common are bulk trash, high weeds, litter, parking on an unapproved surface, and substandard structures. Others may include environmental concerns such as water conservation and mosquito related issues. For the purpose of the data set provided, violations are those issues both found and reported related to the Code Concern case type. On average Code will address 116,000 violations per fiscal year.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"dallasopendata/code-violations-neighborhood-code-fiscal-year-2020-jn7x-kfwx\".\"code_violations_neighborhood_code_fiscal_year_2020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.