Air Quality Continuous Emission Monitoring System (CEMS) 1986 -Current Quarterly Environmental Protection

CEMS is a database used by the Pennsylvania Department of Environmental Protection to monitor key pollutants and/or operational parameters to demonstrate compliance with emissions standards or operational criteria as stipulated in a plan approval, operating permit, or order.

The owner or operator of a source may be required to install and operate a PA DEP certified continuous emission monitoring system (CEMS) to satisfy a condition in a plan approval, operating permit, or order. CEMS data is used to demonstrate compliance with emissions and data availability standards. Generally speaking, a CEMS is the total equipment necessary for the determination, collection, and reporting of a pollutant or parameter in the applicable units of measurement. It includes the measurement interface, all necessary measurement devices and associated calibration and data handling apparatus and procedures. Systems are evaluated on an individual basis and the PA DEP does not maintain an approved list of equipment.

Most of the CEMS related activity takes place in the CEM Data Processing System (CEMDPS). Regulated entities construct work items in the CEMDPS that are submitted to the PA DEP for review. The owners or operators of PA DEP certified CEMS are required to submit emissions data to the Department through the CEMDPS each calendar quarter. The PA DEP reviews the emissions data and generates a report which is provided to the owners or operators of the regulated source. The hourly emissions data submitted by the owners or operators of the source will be reviewed by the PA DEP and ultimately provided to the public through the Open Data Porta on the www.pa.gov website. This data will be updated quarterly.

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 \"pa-gov/air-quality-continuous-emission-monitoring-system-5s9f-3bq4\".\"air_quality_continuous_emission_monitoring_system\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.