Code compliance cases (Mesa)

Name: Code compliance cases (Mesa)
License: https://data.mesaaz.gov/stories/s/2dcd-j2nx/

Code compliance cases handled by the City of Mesa, with location, district, workflow, status, fees and dates.

npx keepset fetch mesa-code-compliance-cases

Fetch and preview this dataset on this page, or download the result as JSON. The command line fetches it without a browser.

Overview

Id	`mesa-code-compliance-cases`
Namespace	`mesa`
Aliases	`code-compliance-cases`
Category	`tasks/v1`
Kind	tasks
Domain	Case records
Subjects	operations-research
Tags	prize, deadline, location, territory, skills, lifecycle
Licence	City of Mesa Open Data Terms of Use License Agreement
Catalogue	`keepset` 1.33.0

#	URL	Status	Retrieved	Read by recipe	Pinned snapshot	SHA-256
0	https://citydata.mesaaz.gov/Code-Compliance/Code-Compliance/hgf6-yenu	live	2026-10-19		20260404200241raw	`c11dbb45f4fa`
1	https://citydata.mesaaz.gov/api/views/hgf6-yenu/rows.csv?accessType=DOWNLOAD	live	2026-10-19	yes	20261020231655raw	`7f576376c5a3`

Source	#1
Archive	none
Parser format	`"csv-table"`
Parser encoding	`"utf-8"`
Parser delimiter	`"comma"`
Parser skipLines	`0`
Parser idColumn	`null`
Parser numericColumns	`[{"column":"Latitude","factor":1},{"column":"Longitude","factor":1},{"column":"Total_Fee","factor":1}]`
Parser columns	`["Closed_Date","Latitude","Longitude","Opened_Date","Total_Fee","Workflow","Status","Council_District"]`

csv-table to tasks/v1, as a crossmap crosswalk.

Rule	From	To	Direction
move	`meta`	`meta`	both
move	`nodes[].id`	`nodes[].id`	both
move	`nodes[].Closed_Date`	`nodes[].closed`	both
move	`nodes[].Latitude`	`nodes[].lat`	both
move	`nodes[].Longitude`	`nodes[].lon`	both
move	`nodes[].Opened_Date`	`nodes[].opened`	both
move	`nodes[].Total_Fee`	`nodes[].prize`	both
move	`nodes[].Workflow`	`nodes[].skill`	both
move	`nodes[].Status`	`nodes[].status`	both
move	`nodes[].Council_District`	`nodes[].territory`	both