Turn Around Time - Permits

Subset of Permits and Permits Work Flow History Datasets and was created to find, calculate Turn Around Time for processing Residential, Commercial and Sign Permits. The column "Turn Around Time" contains the result of the calculation. For information about all permits see https://citydata.mesaaz.gov/Development-Services/Permits-Commercial-Residential-and-Signs-/dzpk-hxfb

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/turn-around-time-permits-fhtq-vpmm\".\"turn_around_time_permits\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.