Facilities Work Orders
Temporary dataset summarizing annual number of work orders by trade type, repair and preventative maintenance performed by the Facilities group on city-owned facilities. Note: This temporary dataset is used only for Fall 2020 MesaSTAT discussion. It will be replaced by a more detailed work order dataset in the future.
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/facilities-work-orders-f5wg-74q9\".\"facilities_work_orders\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.