Gas Permits and Inspections

Gas permits are issued for the installation, addition or alteration of a gas system. Permits must be obtained, and inspections completed by Development, Business & Building Services before using the system. If a gas inspection has been completed, the inspection results will be identified in this dataset.

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 \"calgary-ca/gas-permits-and-inspections-tg24-jt7r\".\"gas_permits_and_inspections\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.