Code Violations

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.

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-x9pz-kdq9\".\"code_violations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.