Historical Air Quality

This dataset makes historical air quality data accessible for various parameters at Calgary monitoring stations. The data is collected by the Calgary Region Airshed Zone and submitted to Alberta Environment and Parks (AEP). The data is delivered to the airdata warehouse, a central repository for Alberta's ambient air quality data via a web service provided by AEP. In this way, AEP provides access to quality controlled historical air quality data at its air quality stations.

In addition to air quality monitoring data, an Air Quality Health Index (AQHI) is calculated hourly at certain monitoring stations. The AQHI is a simple way to interpret air quality conditions: it provides a number from 1 to 10+ which indicates the relative health risk associated with local air quality. The higher the number, the greater the health risk. Further information on the AQHI calculation is available at: https://www.alberta.ca/air-quality-health-index--calculation.aspx

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/historical-air-quality-uqjm-jxgp\".\"historical_air_quality\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.