Code Violation Activities

Activities are actions taken by code staff regarding violations reported. They are grouped into four categories: complaints, investigation and resolution. When a complaint is received it is assigned to an inspector who visits the location and determines if there is a violation. If found, the property owner is notified and ask to correct the problem. If the problem persists, the property owner can receive a citation; or the city will abate the violation and charge the owner for the cost of the services. Either way, violations are eventually abated.

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-violation-activities-hqes-3ct4\".\"code_violation_activities\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.