Code Compliance
Information about city code compliance cases. This dataset includes only the most recent workflow status, and each record/row represents a unique code compliance case. To learn more about code compliance in the City of Mesa, visit the <b><a href="https://www.mesaaz.gov/residents/code-compliance" target="_blank" rel="noopener noreferrer">Code Compliance Office</b></a>. To see all workflow status changes associated with a case, see <b> <a href="https://data.mesaaz.gov/Code-Compliance/Code-Compliance-Case-Workflow-And-Inspections/2mnr-j6un" target="_blank" rel="noopener noreferrer">Code Compliance Case Workflow and Inspections</a></b>. See also the following related datasets: <b> <a href="https://data.mesaaz.gov/Code-Compliance/Code-Enforcement-Case-Turn-Around-Time-TAT-/k9hp-cy2s" target="_blank" rel="noopener noreferrer">Code Enforcement Case Turn Around Time</a></b>, <b><a href="https://data.mesaaz.gov/Code-Compliance/Code-Cases-by-Officer/akj6-u9kt" target="_blank" rel="noopener noreferrer">Code Cases by Officer</a></b>, and <b><a href="https://data.mesaaz.gov/Code-Compliance/Code-Compliance-Investigation-Response/8t34-hz58" target="_blank" rel="noopener noreferrer">Code Compliance Investigation Response</a></b>.
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 \"citydata-mesaaz-gov/code-compliance-hgf6-yenu\".\"code_compliance\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
