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.