About this Dataset

Fenceline VOC Measurements Using Mobile Platforms SDMP.FY25.74.0

This dataset contains final data for the manuscript titled "Comparing short-term volatile organic compound measurements in fenceline environments using multiple mobile air monitoring platforms and methods", Coughlin et al. This dataset and manuscript describes a two-week field campaign where a team cross-compared air monitoring instrumentation in a mobile monitoring format. The scripts included in the data repository process raw data, generate visualizations, and compare measurements from various instruments including a PTR-ToF-MS, UV-DOAS, GC-MS, and SIFT-MS. Different sampling resolutions are handled within the scripts using rolling averages The Methods and Materials within the article describes the monitoring instrumentation that was used and the sampling methodology.
A description of the variables in each column of the data files is contained in the file "metadata.xlsx"

Auto GC Clean_final.xlsx: Cleaned Automated GC data for analysis from the MDNR site.
Canister-PTRMS Comparison_final.xlsx: Data for comparing Canister and PTR-ToF-MS measurements.
Canister_final.xlsx: Summary data from canister measurements analyzed by an offline GC-MS.
DUVAS_BEN_reprocessed_final.xlsx: Reprocessed UV-DOAS data for comparison.
Location_summary.xlsx: Summary of PTR-ToF-MS concentrations during canister collections.
monoterpene_final.xlsx: Monoterpene concentration data for interference analysis.
PTRMS-GMAP Comparison_final.xlsx: PTRMS and GMAP comparison data from different facilities.
PTRMS_canister_stats_summary.csv: Processed summary of PTRMS Canister data.
PTRMS_canister_stats_summary_final.csv: Final processed statistics for PTRMS Canister data.
PTRMS_concentration_gps_final.xlsx: Joined PTRMS concentration and GPS data.
PTRMS_GPS_final.xlsx: Finalized GPS data for PTRMS analysis.
siftms_mz_45_comparison_final.xlsx: Data for comparing SIFT-MS at for potential acetaldehyde/EtO interference.

This dataset is associated with the following publication:
Coughlin, J., A. Tasoglou, K. Haile, L. Silva, S. Hamilton, M. Fuoco, S. Porter, A. Liangou, and E. Thoma. Comparing short-term volatile organic compound measurements in fenceline environments using multiple mobile air monitoring methods. ACS ES&T Air. American Chemical Society, Washington, DC, USA, 2(3): 295–308, (2025).
Organization: U.S. Environmental Protection Agency
Last updated: 2025-04-06T21:41:58.460569
Tags: air-monitoring, air-pollution, environmental-justice, fenceline, gmap, haps, mobile-sensors, ngem, ptr-tof-ms, sift-ms, vocs

Tables

Daily VOCS 2021

@usgov.epa_gov_fenceline_voc_measurements_using_mobile_platfo_f1ee9046.daily_vocs_2021

3.4 MB
706,081 rows
29 columns

CREATE TABLE daily_vocs_2021 (
  "state_code" BIGINT,
  "county_code" BIGINT,
  "site_num" BIGINT,
  "parameter_code" BIGINT,
  "poc" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "datum" VARCHAR,
  "parameter_name" VARCHAR,
  "sample_duration" VARCHAR,
  "pollutant_standard" VARCHAR,
  "date_local" TIMESTAMP,
  "units_of_measure" VARCHAR,
  "event_type" VARCHAR,
  "observation_count" BIGINT,
  "observation_percent" DOUBLE,
  "arithmetic_mean" DOUBLE,
  "n_1st_max_value" DOUBLE  -- 1st Max Value,
  "n_1st_max_hour" BIGINT  -- 1st Max Hour,
  "aqi" VARCHAR,
  "method_code" BIGINT,
  "method_name" VARCHAR,
  "local_site_name" VARCHAR,
  "address" VARCHAR,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "city_name" VARCHAR,
  "cbsa_name" VARCHAR,
  "date_of_last_change" TIMESTAMP
);

PTRMS Canister Stats Summary

@usgov.epa_gov_fenceline_voc_measurements_using_mobile_platfo_f1ee9046.ptrms_canister_stats_summary

6.44 kB
10 rows
8 columns

CREATE TABLE ptrms_canister_stats_summary (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "parameter" VARCHAR,
  "rmse" VARCHAR,
  "n" BIGINT,
  "r_squared" VARCHAR,
  "p_value" VARCHAR,
  "slope" DOUBLE,
  "intercept" DOUBLE
);