About this Dataset

Summary Of Evaluation Of Commercially Available Air Sensor Performance In Biomass Burning Plumes (Revised Version)

Reference and sensor data from grassland prescribed burn experiments in 2017 and chamber burn experiments in 2018 used in the paper "Summary of Evaluation of Commercially Available Air Sensor Performance in Biomass Burning Plumes" by Whitehill et al.
Organization: U.S. Environmental Protection Agency
Last updated: 2022-06-03T02:23:17.056700
Tags: carbon-dioxide, carbon-monoxide, sensors, wildland-fire

Tables

March2017studydata

@usgov.epa_gov_summary_of_evaluation_of_commercially_availabl_ed4e4a55.march2017studydata

67.44 kB
1,182 rows
17 columns

CREATE TABLE march2017studydata (
  "site" VARCHAR,
  "date" VARCHAR,
  "date_time_local" TIMESTAMP,
  "reference_co_ppmv" DOUBLE,
  "reference_co2_ppmv" DOUBLE,
  "reference_no2_ppbv" DOUBLE,
  "reference_o3_ppbv" DOUBLE,
  "aeroqual_1_1_no2_ppbv" DOUBLE,
  "aeroqual_1_7_no2_ppbv" DOUBLE,
  "aeroqual_1_8_co_ppmv" DOUBLE,
  "aeroqual_1_9_co_ppmv" DOUBLE,
  "cairpol_2041_o3no2_ppbv" DOUBLE,
  "cairpol_2042_o3no2_ppbv" DOUBLE,
  "cairpol_2057_no2_ppbv" DOUBLE,
  "cairpol_2058_no2_ppbv" DOUBLE,
  "cairpol_2617_co_ppmv" DOUBLE,
  "cairpol_2618_co_ppmv" DOUBLE
);

Missoula 2018

@usgov.epa_gov_summary_of_evaluation_of_commercially_availabl_ed4e4a55.missoula_2018

233.65 kB
3,187 rows
27 columns

CREATE TABLE missoula_2018 (
  "datetime" TIMESTAMP,
  "ref_co_ppmv" DOUBLE,
  "ref_co2_ppmv" DOUBLE,
  "ref_no2_ppbv" DOUBLE,
  "photolytic_no2_ppbv" DOUBLE,
  "ref_thc_ppmv" DOUBLE,
  "burn" VARCHAR,
  "aeroqual_co_1_ppmv" DOUBLE,
  "aeroqual_co_2_ppmv" DOUBLE,
  "aeroqual_co2_1_ppmv" DOUBLE,
  "aeroqual_co2_2_ppmv" DOUBLE,
  "aeroqual_voc_1" DOUBLE,
  "aeroqual_voc_2" DOUBLE,
  "aeroqual_nhmc_1" DOUBLE,
  "aeroqual_nmhc_2" DOUBLE,
  "aeroqual_nh3_1" DOUBLE,
  "aeroqual_h2s_1" DOUBLE,
  "aeroqual_h2s_2" DOUBLE,
  "aeroqual_h2s_3" DOUBLE,
  "cairpol_co_1_ppmv" DOUBLE,
  "cairpol_co_2_ppmv" DOUBLE,
  "cairpol_no2_1_ppbv" DOUBLE,
  "cairpol_no2_2_ppbv" BIGINT,
  "cairpol_h2s_1" DOUBLE,
  "cairpol_nh3_1" DOUBLE,
  "cairpol_nh3_2" BIGINT,
  "cairpol_nmvoc_1" DOUBLE
);

November2017studydata

@usgov.epa_gov_summary_of_evaluation_of_commercially_availabl_ed4e4a55.november2017studydata

126.55 kB
848 rows
33 columns

CREATE TABLE november2017studydata (
  "site" VARCHAR,
  "date" VARCHAR,
  "date_time_local" TIMESTAMP,
  "temperature_degrees_celcius" DOUBLE,
  "relative_humidity_percent" DOUBLE,
  "pressure_millibar" DOUBLE,
  "reference_co_ppmv" DOUBLE,
  "reference_co2_ppmv" DOUBLE,
  "reference_no2_ppbv" DOUBLE,
  "aeroqual_2_1_voc" DOUBLE,
  "aeroqual_2_2_nmhc" DOUBLE,
  "aeroqual_2_3_o3_ppbv" DOUBLE,
  "aeroqual_2_4_no2_ppbv" DOUBLE,
  "aeroqual_2_5_co2_ppmv" DOUBLE,
  "aeroqual_2_6_co2_ppmv" DOUBLE,
  "aeroqual_2_7_h2s" DOUBLE,
  "aeroqual_2_8_co_ppmv" DOUBLE,
  "aeroqual_2_9_voc" DOUBLE,
  "aeroqual_2_10_co_ppmv" DOUBLE,
  "aeroqual_2_11_nh3" DOUBLE,
  "aeroqual_2_12_o3_ppbv" DOUBLE,
  "aeroqual_2_13_h2s" DOUBLE,
  "aeroqual_2_14_nh3" DOUBLE,
  "aeroqual_2_15_nmhc" DOUBLE,
  "cairpol_2043_o3no2_ppbv" BIGINT,
  "cairpol_2046_o3no2_ppbv" DOUBLE,
  "cairpol_2059_no2_ppbv" DOUBLE,
  "cairpol_2061_no2_ppbv" DOUBLE,
  "cairpol_2062_no2_ppbv" DOUBLE,
  "cairpol_2617_co_ppmv" DOUBLE,
  "cairpol_2618_co_ppmv" DOUBLE,
  "cairpol_3168_h2s_ppbv" BIGINT,
  "cairpol_3192_nh3_ppbv" BIGINT
);