About this Dataset

In Situ Carbon Dioxide, Methane, And Carbon Monoxide Mole Fractions From The Los Angeles Megacity Carbon Project

NOTE: please see the latest (April 2025) update at https://doi.org/10.18434/mds2-3814 . Hourly observations of carbon dioxide (CO2) and methane (CH4) mole fractions in dry air from tower- and rooftop-based sites in the Los Angeles Megacity Carbon Project network. Carbon monoxide (CO) observations exist at several stations in this network but are not included in this data release pending additional calibration verification. Please contact the authors for higher frequency data, which are available on request. Data files are comma delimited (CSV). Measurements of each species may be from two or more different heights above ground. Site locations, heights, and other information are in a separate ASCII (CSV) file (LAM_sites.csv). Data are currently reported for the years 2015-2023. An ASCII Readme file (LAM_Readme_2024) is also posted. CO2 data are reported on the NOAA/WMO X2007 calibration scale. A full revision on the NOAA/WMO X2019 scale for CO2 is forthcoming, and will be linked here. CH4 data are reported on the NOAA/WMO X2004A calibration scale. Current update: May 17, 2024.
Organization: Department of Commerce
Last updated: 2025-09-30T04:51:22.097518
Tags: carbon-dioxide, ghg-measurements, greenhouse-gases, methane, urban-emissions-modeling

Tables

2020/CIT-2020-ch4-all-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_cit_2020_ch4_all_1_hour_20220517

551.1 kB
8,784 rows
21 columns

CREATE TABLE n_2020_cit_2020_ch4_all_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/CIT-2020-ch4-upwind-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_cit_2020_ch4_upwind_1_hour_20220517

551.8 kB
8,784 rows
21 columns

CREATE TABLE n_2020_cit_2020_ch4_upwind_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/CIT-2020-co2-all-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_cit_2020_co2_all_1_hour_20220517

473.25 kB
8,784 rows
21 columns

CREATE TABLE n_2020_cit_2020_co2_all_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/CIT-2020-co2-upwind-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_cit_2020_co2_upwind_1_hour_20220517

481.66 kB
8,784 rows
21 columns

CREATE TABLE n_2020_cit_2020_co2_upwind_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/CNP-2020-ch4-all-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_cnp_2020_ch4_all_1_hour_20220517

508.32 kB
8,784 rows
21 columns

CREATE TABLE n_2020_cnp_2020_ch4_all_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/CNP-2020-ch4-upwind-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_cnp_2020_ch4_upwind_1_hour_20220517

512.88 kB
8,784 rows
21 columns

CREATE TABLE n_2020_cnp_2020_ch4_upwind_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/CNP-2020-co2-all-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_cnp_2020_co2_all_1_hour_20220517

440.79 kB
8,784 rows
21 columns

CREATE TABLE n_2020_cnp_2020_co2_all_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/CNP-2020-co2-upwind-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_cnp_2020_co2_upwind_1_hour_20220517

449.04 kB
8,784 rows
21 columns

CREATE TABLE n_2020_cnp_2020_co2_upwind_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/COM-2020-ch4-25m-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_com_2020_ch4_25m_1_hour_20220517

556.62 kB
8,784 rows
21 columns

CREATE TABLE n_2020_com_2020_ch4_25m_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/COM-2020-ch4-45m-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_com_2020_ch4_45m_1_hour_20220517

562.74 kB
8,784 rows
21 columns

CREATE TABLE n_2020_com_2020_ch4_45m_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/COM-2020-co2-25m-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_com_2020_co2_25m_1_hour_20220517

482.95 kB
8,784 rows
21 columns

CREATE TABLE n_2020_com_2020_co2_25m_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/COM-2020-co2-45m-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_com_2020_co2_45m_1_hour_20220517

479.39 kB
8,784 rows
21 columns

CREATE TABLE n_2020_com_2020_co2_45m_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/FUL-2020-ch4-all-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_ful_2020_ch4_all_1_hour_20220517

499.95 kB
8,784 rows
21 columns

CREATE TABLE n_2020_ful_2020_ch4_all_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/FUL-2020-ch4-upwind-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_ful_2020_ch4_upwind_1_hour_20220517

491.48 kB
8,784 rows
21 columns

CREATE TABLE n_2020_ful_2020_ch4_upwind_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/FUL-2020-co2-all-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_ful_2020_co2_all_1_hour_20220517

425.61 kB
8,784 rows
21 columns

CREATE TABLE n_2020_ful_2020_co2_all_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/FUL-2020-co2-upwind-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_ful_2020_co2_upwind_1_hour_20220517

423.08 kB
8,784 rows
21 columns

CREATE TABLE n_2020_ful_2020_co2_upwind_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/GRA-2020-ch4-31m-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_gra_2020_ch4_31m_1_hour_20220517

538.1 kB
8,784 rows
21 columns

CREATE TABLE n_2020_gra_2020_ch4_31m_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/GRA-2020-ch4-51m-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_gra_2020_ch4_51m_1_hour_20220517

543.12 kB
8,784 rows
21 columns

CREATE TABLE n_2020_gra_2020_ch4_51m_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/GRA-2020-co2-31m-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_gra_2020_co2_31m_1_hour_20220517

447.87 kB
8,784 rows
21 columns

CREATE TABLE n_2020_gra_2020_co2_31m_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/GRA-2020-co2-51m-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_gra_2020_co2_51m_1_hour_20220517

444.38 kB
8,784 rows
21 columns

CREATE TABLE n_2020_gra_2020_co2_51m_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/IRV-2020-ch4-all-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_irv_2020_ch4_all_1_hour_20220517

591.93 kB
8,784 rows
21 columns

CREATE TABLE n_2020_irv_2020_ch4_all_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/IRV-2020-ch4-upwind-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_irv_2020_ch4_upwind_1_hour_20220517

590.85 kB
8,784 rows
21 columns

CREATE TABLE n_2020_irv_2020_ch4_upwind_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" VARCHAR,
  "ch4_uncertainty" VARCHAR,
  "ch4_sd_raw" VARCHAR,
  "ch4_n_raw" VARCHAR,
  "ch4_sd_minutes" VARCHAR,
  "ch4_n_minutes" VARCHAR,
  "ch4_min" VARCHAR,
  "ch4_max" VARCHAR,
  "ch4_flags" VARCHAR
);

2020/IRV-2020-co2-all-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_irv_2020_co2_all_1_hour_20220517

490.07 kB
8,784 rows
21 columns

CREATE TABLE n_2020_irv_2020_co2_all_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/IRV-2020-co2-upwind-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_irv_2020_co2_upwind_1_hour_20220517

499.64 kB
8,784 rows
21 columns

CREATE TABLE n_2020_irv_2020_co2_upwind_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "co2_ppm" VARCHAR,
  "co2_uncertainty" VARCHAR,
  "co2_sd_raw" VARCHAR,
  "co2_n_raw" VARCHAR,
  "co2_sd_minutes" VARCHAR,
  "co2_n_minutes" VARCHAR,
  "co2_min" VARCHAR,
  "co2_max" VARCHAR,
  "co2_flags" VARCHAR
);

2020/LJO-2020-ch4-13m-1-hour-20220517

@usgov.doc_gov_in_situ_carbon_dioxide_methane_and_carbon_mono_3badd653.n_2020_ljo_2020_ch4_13m_1_hour_20220517

567.24 kB
8,784 rows
21 columns

CREATE TABLE n_2020_ljo_2020_ch4_13m_1_hour_20220517 (
  "datetime_utc" TIMESTAMP,
  "yyyy" BIGINT,
  "mm" BIGINT,
  "dd" BIGINT,
  "hh" BIGINT,
  "first_valid_minute" TIMESTAMP,
  "last_valid_minute" TIMESTAMP,
  "average_measurement_time" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation_m" BIGINT,
  "intake_height_m" BIGINT,
  "ch4_ppb" DOUBLE,
  "ch4_uncertainty" DOUBLE,
  "ch4_sd_raw" DOUBLE,
  "ch4_n_raw" DOUBLE,
  "ch4_sd_minutes" DOUBLE,
  "ch4_n_minutes" BIGINT,
  "ch4_min" DOUBLE,
  "ch4_max" DOUBLE,
  "ch4_flags" VARCHAR
);