[old format] Daily Air Quality Data...
URL: https://data.wprdc.org/datastore/dump/967f1285-f8fb-4785-9673-64a8ae47588d
Air-quality measurements aggregated by day.
ISSUES WITH THIS DATA: The Hourly and Daily Air Quality Data tables in this dataset were updated to support a previously missing measurement (see the field "black_carbon") which is measured at the Parkway East site. These tables have data for black carbon from 2020-04-24 through the present, but not for prior dates. Also: 1) The new "Pittsburgh" measurement site is missing measurements as the new measurements have not been added to the table yet. 2) The barometric pressure reading at the Lawrenceville site was last reported in the "BP" field on 2020-12-16. It switched to a new field ("BP2"), but this has not been added to the table yet.
Old Data Notes for this data: The Lawrenceville station reports SO2 measurements in parts per billion (ppb), while all other stations report SO2 measurements in parts per million (ppm). Similarly, the units for CO and NO2 measurements vary from station to station and may change over time. In particular, Flag Plaza measured CO in ppm until 6/21/2019, when a new monitor measuring CO in ppb was installed (Lawrenceville, Parkway East, and Parkway East (Near Road) measure CO in ppb). Harrison Township measures NO2 in ppm, while Parkway East measures NO2 in ppb. As of 2019-05-01, the records in the Hourly Air Quality Data and Daily Air Quality Data have been modified to standardize these units across all stations for each measurement, using the EPA standard (CO: ppm, SO2: ppm, NO*: ppb).
Data Dictionary
Column | Type | Label | Description |
---|---|---|---|
site | text | ||
datetime | timestamp | ||
stat | text | ||
bcstat | float8 | ||
bcstat_txt | text | ||
black_carbon | float8 | ||
black_carbon_txt | text | ||
bp | float8 | ||
bp_txt | text | ||
co | float8 | ||
co_txt | text | ||
h2s | float8 | ||
h2s_txt | text | ||
int_t | float8 | ||
int_t_txt | text | ||
no | float8 | ||
no_txt | text | ||
no2 | float8 | ||
no2_txt | text | ||
nox | float8 | ||
nox_txt | text | ||
noy | float8 | ||
noy_txt | text | ||
noydif | float8 | ||
noydif_txt | text | ||
out_rh | float8 | ||
out_rh_txt | text | ||
out_t | float8 | ||
out_t_txt | text | ||
ozone | float8 | ||
ozone_txt | text | ||
ozone2 | float8 | ||
ozone2_txt | text | ||
per_f | float8 | ||
per_f_txt | text | ||
per_f2 | float8 | ||
per_f2_txt | text | ||
pm10 | float8 | ||
pm10_txt | text | ||
pm10_fl | float8 | ||
pm10_fl_txt | text | ||
pm10b | float8 | ||
pm10b_txt | text | ||
pm25 | float8 | ||
pm25_txt | text | ||
pm25(2) | float8 | ||
pm25(2)_txt | text | ||
pm25_fl | float8 | ||
pm25_fl_txt | text | ||
pm25b | float8 | ||
pm25b_txt | text | ||
pm25t | float8 | ||
pm25t_txt | text | ||
rwd | float8 | ||
rwd_txt | text | ||
rws | float8 | ||
rws_txt | text | ||
sigtheta | float8 | ||
sigtheta_txt | text | ||
so2 | float8 | ||
so2_txt | text | ||
sonicwd | float8 | ||
sonicwd_txt | text | ||
sonicws | float8 | ||
sonicws_txt | text | ||
uvpm | float8 | ||
uvpm_txt | text | ||
rainfall | float8 | ||
rainfall_txt | text | ||
solarrad | float8 | ||
solarrad_txt | text | ||
uv_rad | float8 | ||
uv_rad_txt | text |
Additional Information
Field | Value |
---|---|
Data last updated | March 3, 2022 |
Metadata last updated | May 21, 2023 |
Created | January 22, 2016 |
Format | CSV |
License | Creative Commons CCZero |
Datastore active | True |
Has views | True |
Id | 967f1285-f8fb-4785-9673-64a8ae47588d |
Mimetype | text/csv |
Package id | c7b3266c-adc6-41c0-b19a-8d4353bfcdaf |
Position | 7 |
Revision id | c2860a79-69ea-4706-a27a-d43174c4b286 |
State | active |
Url type | datapusher |