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.