Icon for Socrata external plugin
Open repository in Console
Updated 2 years ago
Indexed 6 hours ago

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" \
{"sql": "
    SELECT *
    FROM \"dallasopendata/code-violations-x9pz-kdq9\".\"code_violations\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • code_violations
Upstream Metadata