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

65.86 KB
1182 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

228.18 KB
3187 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

123.58 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
);