Inspection Stops
This dataset was created to calculate the "Inspection Stops" performance measure. A "stop" is defined as when an inspector "stops" at a physical location and may conduct a variety of different "inspections" at the location. See the complete "Inspections" dataset at https://citydata.mesaaz.gov/Development-Services/Inspections/sqxq-7rdw for more information about those inspections.
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/inspection-stops-fgki-ge37\".\"inspection_stops\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.