Transportation Work Orders, Public View (Mesa, AZ)
Transportation work orders raised and closed by the City of Mesa, with location, category, cost, status and dates.
npx keepset fetch mesa-transportation-work-orders-public-view
- Nodes
- 214,933
Fetch and preview this dataset on this page, or download the result as JSON. The command line fetches it without a browser.
Overview
Sources and provenance
Recipe
| Source | #1 |
|---|
| Archive | none |
|---|
| Parser format | "csv-table" |
|---|
| Parser encoding | "utf-8" |
|---|
| Parser delimiter | "comma" |
|---|
| Parser skipLines | 0 |
|---|
| Parser idColumn | "work_order_id" |
|---|
| Parser numericColumns | [{"column":"latitude","factor":1},{"column":"longitude","factor":1},{"column":"work_order_cost","factor":1}] |
|---|
| Parser columns | ["date_work_order_closed","project_finish_date","latitude","longitude","initiated_date","work_order_cost","work_order_category","status"] |
|---|
Crosswalk
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[].date_work_order_closed | nodes[].closed | both |
| move | nodes[].project_finish_date | nodes[].deadline | both |
| move | nodes[].latitude | nodes[].lat | both |
| move | nodes[].longitude | nodes[].lon | both |
| move | nodes[].initiated_date | nodes[].opened | both |
| move | nodes[].work_order_cost | nodes[].prize | both |
| move | nodes[].work_order_category | nodes[].skill | both |
| move | nodes[].status | nodes[].status | both |
Properties
| Probed nodes | 214,933 |
|---|
| Survey id | or-12 |
|---|