This document details how the _transportation/data-raw/epa/ folder is organized and lists the associated processing scripts for each dataset.

Altogether, this folder comes to nearly 200 GB. If you plan to replicate these downloads on your machine, account for space accordingly.

All download links and essential description information is documented in epa_downloads.xlsx

Keep in mind that URLs are relatively fragile and may change at any time.

All datasets are processed from their unzipped locations in processing scripts. At the top of each script, there is a helper that looks for all the input datasets necessary. Ensure you have all the appropriate downloads unzipped and in the correct locations and run the scripts.

If you want to preview any of the CSVs, open them using your machine’s text editor (TextEdit on Mac, Notepad on Windows). Do NOT open using Excel - it will crash.

Copies of the intermediary datasets are available in our MS Team/OneDrive.

Summary of direct inputs and outputs of all data in epa_onroad_emissions_compile

data_source dataset moves_edition emissions_year process_source file_location
EQUATES equates_cmas_mn_wi.RDS MOVES3 2002 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2002/inputs/onroad_inv_diesel/diesel_MYR_2002_SMOKE_MOVES_MOVES3_AQstyle_06jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2002 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2002/inputs/onroad_inv_gas/gas_MYR_2002_SMOKE_MOVES_MOVES3_AQstyle_28may2021_nf_v1.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2003 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2003/inputs/onroad_inv_diesel/diesel_MYR_2003_SMOKE_MOVES_MOVES3_AQstyle_17jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2003 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2003/inputs/onroad_inv_gas/gas_MYR_2003_SMOKE_MOVES_MOVES3_AQstyle_27may2021_nf_v1.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2004 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2004/inputs/onroad_inv_diesel/diesel_MYR_2004_SMOKE_MOVES_MOVES3_AQstyle_21jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2004 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2004/inputs/onroad_inv_gas/gas_MYR_2004_SMOKE_MOVES_MOVES3_AQstyle_21jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2005 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2005/inputs/onroad_inv_diesel/diesel_MYR_2005_SMOKE_MOVES_MOVES3_AQstyle_13jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2005 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2005/inputs/onroad_inv_gas/gas_MYR_2005_SMOKE_MOVES_MOVES3_AQstyle_13jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2006 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2006/inputs/onroad_inv_diesel/diesel_MYR_2006_SMOKE_MOVES_MOVES3_AQstyle_25jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2006 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2006/inputs/onroad_inv_gas/gas_MYR_2006_SMOKE_MOVES_MOVES3_AQstyle_25jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2007 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2007/inputs/onroad_inv_diesel/diesel_MYR_2007_SMOKE_MOVES_MOVES3_AQstyle_29jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2007 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2007/inputs/onroad_inv_gas/gas_MYR_2007_SMOKE_MOVES_MOVES3_AQstyle_29jan2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2008 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2008/inputs/onroad_inv_diesel/diesel_MYR_2008_SMOKE_MOVES_MOVES3_AQstyle_30oct2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2008 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2008/inputs/onroad_inv_gas/gas_MYR_2008_SMOKE_MOVES_MOVES3_AQstyle_30oct2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2009 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2009/inputs/onroad_inv_diesel/diesel_MYR_2009_SMOKE_MOVES_MOVES3_AQstyle_06nov2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2009 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2009/inputs/onroad_inv_gas/gas_MYR_2009_SMOKE_MOVES_MOVES3_AQstyle_06nov2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2010 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2010/inputs/onroad_inv_diesel/diesel_MYR_2010_SMOKE_MOVES_MOVES3_AQstyle_11nov2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2010 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2010/inputs/onroad_inv_gas/gas_MYR_2010_SMOKE_MOVES_MOVES3_AQstyle_30apr2021_v1.csv
National Emissions Inventory epa_nei_smoke_ff.RDS MOVES2014a 2011 _transportation/data-raw/epa_nei_smoke_ff.R _transportation/data-raw/epa/air_emissions_modeling/2011/2011el_cb6v2_v6_11g/inputs/onroad/2011el_onroad_SMOKE_MOVES_MOVES2014a_forOTAQ_31aug2016_v1_part1.csv
National Emissions Inventory epa_nei_smoke_ff.RDS MOVES2014a 2011 _transportation/data-raw/epa_nei_smoke_ff.R _transportation/data-raw/epa/air_emissions_modeling/2011/2011el_cb6v2_v6_11g/inputs/onroad/2011el_onroad_SMOKE_MOVES_MOVES2014a_forOTAQ_31aug2016_v1_part2.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2011 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2011/inputs/onroad_inv_diesel/diesel_MYR_2011_SMOKE_MOVES_MOVES3_AQstyle_20apr2021_nf_v1.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2011 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2011/inputs/onroad_inv_gas/gas_MYR_2011_SMOKE_MOVES_MOVES3_AQstyle_20apr2021_nf_v1.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES2014a 2011 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2011/2011el_cb6v2_v6_11g/inputs/onroad/2011el_onroad_SMOKE_MOVES_MOVES2014a_forOTAQ_31aug2016_v1_part1.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2012 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2012/inputs/onroad_inv_diesel/diesel_MYR_2012_SMOKE_MOVES_MOVES3_AQstyle_11mar2021_nf_v1.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2012 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2012/inputs/onroad_inv_gas/gas_MYR_2012_SMOKE_MOVES_MOVES3_AQstyle_11mar2021_nf_v1.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2013 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2013/inputs/onroad_inv_diesel/diesel_MYR_2013_SMOKE_MOVES_MOVES3_AQstyle_22dec2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2013 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2013/inputs/onroad_inv_gas/gas_MYR_2013_SMOKE_MOVES_MOVES3_AQstyle_22dec2020_v0.csv
National Emissions Inventory epa_nei_smoke_ff.RDS MOVES2014a 2014 _transportation/data-raw/epa_nei_smoke_ff.R _transportation/data-raw/epa/air_emissions_modeling/2014/2014fd_cb6_14j/inputs/onroad/2014fd_nata_onroad_SMOKE_MOVES_MOVES2014a_AQstyle_06feb2018_v0.csv
National Emissions Inventory epa_nei_smoke_ff.RDS MOVES2014a 2014 _transportation/data-raw/epa_nei_smoke_ff.R _transportation/data-raw/epa/nei/2014NEI/CO_CO2_2014fd_nata_onroad_SMOKE_MOVES_MOVES2014a_forNATA_12jan2018_v1.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2014 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2014/inputs/onroad_inv_diesel/diesel_MYR_2014_SMOKE_MOVES_MOVES3_AQstyle_23nov2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2014 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2014/inputs/onroad_inv_gas/gas_MYR_2014_SMOKE_MOVES_MOVES3_AQstyle_23nov2020_v0.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES2014a 2014 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2014/2014fd_cb6_14j/inputs/onroad/2014fd_nata_onroad_SMOKE_MOVES_MOVES2014a_AQstyle_06feb2018_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2015 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2015/inputs/onroad_inv_diesel/diesel_MYR_2015_SMOKE_MOVES_MOVES3_AQstyle_23dec2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2015 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2015/inputs/onroad_inv_gas/gas_MYR_2015_SMOKE_MOVES_MOVES3_AQstyle_23dec2020_v0.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES2014a 2015 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2015/2015fd_cb6_15j/inputs/onroad/2015fd_onroad_SMOKE_MOVES_MOVES2014a_AQstyle_28sep2018_nf_v1.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2016 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2016/inputs/onroad_inv_diesel/diesel_MYR_2016_SMOKE_MOVES_MOVES3_AQstyle_28dec2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2016 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2016/inputs/onroad_inv_gas/gas_MYR_2016_SMOKE_MOVES_MOVES3_AQstyle_28dec2020_v0.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES3 2016 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2016/2016gf_16j/inputs/onroad/2016gf_onroad_SMOKE_MOVES_MOVES3_30jun2022_v0.csv
National Emissions Inventory epa_nei_smoke_ff.RDS MOVES2014b 2017 _transportation/data-raw/epa_nei_smoke_ff.R _transportation/data-raw/epa/air_emissions_modeling/2017/2017gb_17j/inputs/onroad/2017gb_nata_onroad_SMOKE_MOVES_NATAstyle_14may2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2017 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2017/inputs/onroad_inv_diesel/diesel_MYR_2017_SMOKE_MOVES_MOVES3_AQstyle_15dec2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2017 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2017/inputs/onroad_inv_gas/gas_MYR_2017_SMOKE_MOVES_MOVES3_AQstyle_15dec2020_v0.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES2014b 2017 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2017/2017gb_17j/inputs/onroad/2017gb_nata_onroad_SMOKE_MOVES_NATAstyle_14may2020_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2018 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2018/inputs/onroad_inv_diesel/diesel_MYR_EQUATES_2018_SMOKE_MOVES_MOVES3_AQstyle_26oct2021_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2018 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2018/inputs/onroad_inv_gas/gas_MYR_EQUATES_2018_SMOKE_MOVES_MOVES3_AQstyle_26oct2021_v0.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES3 2018 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2018/2018gc_cb6_18j/inputs/onroad/2018gc_SMOKE_MOVES_MOVES3_AQ_fullHAP_29sep2021_v1.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2019 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2019/inputs/onroad_inv_diesel/diesel_MYR_EQUATES_2019_SMOKE_MOVES_MOVES3_AQstyle_18feb2022_v0.csv
EQUATES equates_cmas_mn_wi.RDS MOVES3 2019 _transportation/data-raw/epa_equates_read.R _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse//EQUATES_2019/inputs/onroad_inv_gas/gas_MYR_EQUATES_2019_SMOKE_MOVES_MOVES3_AQstyle_18feb2022_v0.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES3 2019 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2019/2019ge_cb6_19k/inputs/onroad/2019ge_SMOKE_MOVES_MOVES3_AQ_fullHAP_30nov2021_v0.csv
National Emissions Inventory epa_nei_smoke_ff.RDS MOVES3 2020 _transportation/data-raw/epa_nei_smoke_ff.R _transportation/data-raw/epa/nei/2020NEI/SmokeFlatFile_ONROAD_20230330.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES3 2020 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2020/2020ha2_cb6_20k/inputs/onroad/2020ha2_onroad_SMOKE_MOVES_MOVES3_HAPCAP_style_30may2023_v0.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES4 2021 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2021/2021hb_cb6_21k/inputs/onroad/2021hb_onroad_SMOKE_MOVES_MOVES4_hapcap_04dec2023_v0.csv
Air Emissions Modeling onroad_mn_wi.RDS MOVES4 2022 _transportation/data-raw/epa_air_emissions_modeling_onroad.R _transportation/data-raw/epa/air_emissions_modeling/2022v1/2022hc_cb6_22m/inputs/onroad/2022hc_onroad_SMOKE_MOVES_MOVES4_forAQ_27jun2024_v0.csv

Folder structure

Note that to save space, some unzipped data irrelevant to our region (like EPA regions outside of MN and WI, Texas, and California datasets) have been deleted.

#> .
#> ├── air_emissions_modeling
#> └── nei

nei

The NEI is available from the EPA in multiple places at different aggregation levels

NEI should only be compared directly for years 2011 onward. Between 2008 and 2011, there were significant changes in the underlying source classification codes (SCCs).

Within the epa/ folder, create folders for each NEI release year: 2008, 2011, 2014, 2017, and 2020.

#> ./nei
#> ├── 2008NEI
#> ├── 2011NEI
#> ├── 2014NEI
#> ├── 2017NEI
#> ├── 2020NEI
#> └── SmokeFlatFile_MN_WI

Next, navigate to the links provided in the epa_downloads. These are data summaries broken out by on-road and non-road by EPA region.

When prompted to download, save each download its the corresponding folder.

NEI data are then compiled in a three locations

NEI summary data are also fetched directly from the EnviroFacts API in epa_nei_envirofacts.R.

On-road activity data and non-road emissions are not currently processed and saved. See GitHub for relevant Issues.

group inventory_year measurement category slug download_location direct_link
NEI 2008 emissions nonroad 2008neiv3 _transportation/data-raw/epa/nei/2008NEI https://gaftp.epa.gov/air/nei/2008/data_summaries/2008neiv3_nonroad_byregions.zip
NEI 2011 emissions nonroad 2011neiv2 _transportation/data-raw/epa/nei/2011NEI https://gaftp.epa.gov/air/nei/2011/data_summaries/2011v2/2011neiv2_nonroad_byregions.zip
NEI 2014 emissions nonroad 2014neiv2 _transportation/data-raw/epa/nei/2014NEI https://gaftp.epa.gov/air/nei/2014/data_summaries/2014v2/2014neiv2_nonroad_byregions.zip
NEI 2017 emissions nonroad 2017neiApr _transportation/data-raw/epa/nei/2017NEI https://gaftp.epa.gov/air/nei/2017/data_summaries/2017v1/2017neiApr_nonroad_byregions.zip
NEI 2017 emissions nonroad 2017NEI _transportation/data-raw/epa/nei/2017NEI https://gaftp.epa.gov/Air/nei/2017/doc/flat_files/2017NEI_nonroad_20200427.zip
NEI 2020 emissions nonroad 2020nei _transportation/data-raw/epa/nei/2020NEI https://gaftp.epa.gov/air/nei/2020/data_summaries/2020nei_nonroad_byregion.zip
NEI 2008 smoke_flat_file nonroad 2008NEIv3 _transportation/data-raw/epa/nei/2008NEI https://gaftp.epa.gov/Air/nei/2008/flat_files/2008NEIv3_NONROAD_20130224.zip
NEI 2011 smoke_flat_file nonroad Unavailable _transportation/data-raw/epa/nei/2011NEI NA
NEI 2014 smoke_flat_file nonroad 2014NEI _transportation/data-raw/epa/nei/2014NEI https://gaftp.epa.gov/Air/nei/2014/flat_files/SmokeFlatFile_NONROAD_20160917.csv.zip
NEI 2020 smoke_flat_file nonroad 2020NEI _transportation/data-raw/epa/nei/2020NEI https://gaftp.epa.gov/Air/nei/2020/doc/flat_files/SmokeFlatFile_NONROAD_20230330.zip
NEI 2008 emissions onroad 2008NEIv3 _transportation/data-raw/epa/nei/2008NEI https://gaftp.epa.gov/air/nei/2008/data_summaries/2008neiv3_onroad_byregions.zip
NEI 2011 emissions onroad 2011NEIv2 _transportation/data-raw/epa/nei/2011NEI https://gaftp.epa.gov/air/nei/2011/data_summaries/2011v2/2011neiv2_onroad_byregions.zip
NEI 2014 emissions onroad 2014neiv2 _transportation/data-raw/epa/nei/2014NEI https://gaftp.epa.gov/air/nei/2014/data_summaries/2014v2/2014neiv2_onroad_byregions.zip
NEI 2017 emissions onroad 2017neiApr _transportation/data-raw/epa/nei/2017NEI https://gaftp.epa.gov/air/nei/2017/data_summaries/2017v1/2017neiApr_onroad_byregions.zip
NEI 2017 emissions onroad 2017NEI _transportation/data-raw/epa/nei/2017NEI https://gaftp.epa.gov/Air/nei/2017/doc/flat_files/2017NEI_onroad_20200427.zip
NEI 2020 emissions onroad 2020nei _transportation/data-raw/epa/nei/2020NEI https://gaftp.epa.gov/air/nei/2020/data_summaries/2020nei_onroad_byregion.zip
NEI 2008 smoke_flat_file onroad 2008NEIv3 _transportation/data-raw/epa/nei/2008NEI https://gaftp.epa.gov/Air/nei/2008/flat_files/2008NEIv3_ONROAD_20130225.zip
NEI 2011 smoke_flat_file onroad 2011ek _transportation/data-raw/epa/air_emissions_modeling/2011 https://gaftp.epa.gov/air/emismod/2011/v3platform/2011emissions/2011ek_onroad_SMOKE_MOVES_MOVES2014a_forOTAQ_21jan2016_v2_AL_to_MO.zip
NEI 2011 smoke_flat_file onroad NA _transportation/data-raw/epa/air_emissions_modeling/2011 https://gaftp.epa.gov/air/emismod/2011/v3platform/2011emissions/2011ek_onroad_SMOKE_MOVES_MOVES2014a_forOTAQ_21jan2016_v2_MT_to_WY.zip
NEI 2014 smoke_flat_file onroad 2014NEI _transportation/data-raw/epa/nei/2014NEI https://gaftp.epa.gov/Air/nei/2014/flat_files/SmokeFlatFile_ONROAD_20160910.csv.zip
NEI 2014 smoke_flat_file onroad 2014fd _transportation/data-raw/epa/nei/2014NEI https://gaftp.epa.gov/air/nei/2014/data_summaries/2014v2/CO_CO2_2014fd_nata_onroad_SMOKE_MOVES_MOVES2014a_forNATA_12jan2018_v1.zip
NEI 2017 smoke_flat_file onroad 2017NEI _transportation/data-raw/epa/nei/2017NEI https://gaftp.epa.gov/Air/nei/2017/doc/flat_files/onroad_by_state/2017NEI_onroad_FF10_SMOKE_MOVES_FIPS_27.zip
NEI 2017 smoke_flat_file onroad 2017NEI _transportation/data-raw/epa/nei/2017NEI https://gaftp.epa.gov/Air/nei/2017/doc/flat_files/onroad_by_state/2017NEI_onroad_FF10_SMOKE_MOVES_FIPS_55.zip
NEI 2020 smoke_flat_file onroad 2020NEI _transportation/data-raw/epa/nei/2020NEI https://gaftp.epa.gov/Air/nei/2020/doc/flat_files/SmokeFlatFile_ONROAD_20230330.zip

air_emissions_modeling

EPA teams continually work on air emissions modeling. These emissions modeling platforms support the development of emissions inputs for air quality modeling supporting efforts across government agencies. Platforms include everything from model-ready datasets for models like CMAQ, MOVES, and SMOKE, scripts, output datasets, shapefiles, tables, and documentation.

The organizing body for air emissions modeling is Community Modeling and Analysis System (CMAS). CMAS offers a discussion forum for folks to collaborate and ask questions. Staff scientists from the EPA, air quality monitoring agencies, and other organizations answer questions and respond to bug reports.

County-level data are only available at the continental US (CONUS) level; these datasets include all counties in the US and are very large.

The data available for each platform year varies. Data is much more consistently available and standardized from 2014 onward.

Create a folder for each year (2011, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022v1), plus EQUATES and air_emissions_modeling_mn_wi.

Air emissions modeling data are compiled in two locations

#> ./air_emissions_modeling/
#> ├── 2007
#> ├── 2008
#> ├── 2011
#> ├── 2014
#> ├── 2015
#> ├── 2016
#> ├── 2017
#> ├── 2018
#> ├── 2019
#> ├── 2020
#> ├── 2021
#> ├── 2022v1
#> ├── EQUATES
#> └── air_emissions_modeling_mn_wi
group inventory_year measurement category slug download_location direct_link
emismod 2012 emissions nonroad NA NA NA
emismod 2013 emissions nonroad NA NA NA
emismod 2014 emissions nonroad 2014fd _transportation/data-raw/epa/air_emissions_modeling/2014 https://gaftp.epa.gov/Air/emismod/2014/v2/2014fd/emissions/by_sector/2014fd_nonroad.zip
emismod 2015 emissions nonroad NA NA NA
emismod 2016 emissions nonroad 2016gf _transportation/data-raw/epa/air_emissions_modeling/2016 https://gaftp.epa.gov/Air/emismod/2016/v3/2016emissions/2016gf_nonroad_inventory_15dec2022.zip
emismod 2017 emissions nonroad 2017gb_17j _transportation/data-raw/epa/air_emissions_modeling/2017 https://gaftp.epa.gov/Air/emismod/2017/2017emissions/2017gb_inventory_nonroad_29jun2020.zip
emismod 2018 emissions nonroad 2018gg_18j _transportation/data-raw/epa/air_emissions_modeling/2018 https://gaftp.epa.gov/Air/emismod/2018/v2/2018emissions/2018gg_inventory_nonroad_04apr2023.zip
emismod 2019 emissions nonroad 2019ge _transportation/data-raw/epa/air_emissions_modeling/2019 https://gaftp.epa.gov/Air/emismod/2019/2019emissions/2019ge_nonroad_inventory_10mar2023.zip
emismod 2020 emissions nonroad 2020ha2_cb6_20k _transportation/data-raw/epa/air_emissions_modeling/2020 https://gaftp.epa.gov/Air/emismod/2020/2020emissions/2020ha2_nonroad_inventory_22sep2023.zip
emismod 2021 emissions nonroad 2021hb _transportation/data-raw/epa/air_emissions_modeling/2021 https://gaftp.epa.gov/Air/emismod/2021/2021emissions/nonroad_inventory_2021hb_24may2024.zip
emismod 2022 emissions nonroad 2022hc _transportation/data-raw/epa/air_emissions_modeling/2022v1 https://gaftp.epa.gov/Air/emismod/2022/v1/2022emissions/nonroad_inventory_2022hc_17jul2024.zip
emismod 2011 emissions onroad 2011el _transportation/data-raw/epa/air_emissions_modeling/2011 https://gaftp.epa.gov/Air/emismod/2011/v3platform/2011emissions/2011el_onroad_SMOKE_MOVES2014a_ff10_part2.zip
emismod 2011 emissions onroad 2011el _transportation/data-raw/epa/air_emissions_modeling/2011 https://gaftp.epa.gov/Air/emismod/2011/v3platform/2011emissions/2011el_onroad_SMOKE_MOVES2014a_ff10_part1.zip
emismod 2012 emissions onroad NA NA NA
emismod 2013 emissions onroad NA NA NA
emismod 2014 emissions onroad 2014fd_cb6_14j _transportation/data-raw/epa/air_emissions_modeling/2014 https://gaftp.epa.gov/Air/emismod/2014/v2/2014fd/emissions/2014fd_SMOKE_MOVES_onroad_ff10.zip
emismod 2015 emissions onroad 2015fd _transportation/data-raw/epa/air_emissions_modeling/2015 https://gaftp.epa.gov/Air/emismod/2015/alpha/2015fd/emissions/2015fd_SMOKE_MOVES_onroad_ff10.zip
emismod 2016 emissions onroad 2016gf_16j _transportation/data-raw/epa/air_emissions_modeling/2016 https://gaftp.epa.gov/Air/emismod/2016/v3/2016emissions/2016gf_onroad_SMOKE-MOVES_MOVES3_emissions_FF10_30jun2022_v0.zip
emismod 2017 emissions onroad 2017gb _transportation/data-raw/epa/air_emissions_modeling/2017 https://gaftp.epa.gov/Air/emismod/2017/2017emissions/2017gb_onroad_SMOKE-MOVES_emissions_FF10_29jun2020.zip
emismod 2018 emissions onroad 2018v2/2018gc_cb6_18j _transportation/data-raw/epa/air_emissions_modeling/2018 https://gaftp.epa.gov/Air/emismod/2018/v2/2018emissions/2018gc_onroad_SMOKE-MOVES_emissions_FF10_fullHAP_29sep2021.zip
emismod 2019 emissions onroad 2019ge_cb6_19k _transportation/data-raw/epa/air_emissions_modeling/2019 https://gaftp.epa.gov/Air/emismod/2019/2019emissions/2019ge_onroad_SMOKE-MOVES_emissions_FF10_allHAPs_30nov2021_v0.zip
emismod 2020 emissions onroad 2020ha2_cb6_20k _transportation/data-raw/epa/air_emissions_modeling/2020 https://gaftp.epa.gov/Air/emismod/2020/2020emissions/2020ha2_onroad_SMOKE-MOVES_emissions_FF10_22sep2023.zip
emismod 2021 emissions onroad 2021hb _transportation/data-raw/epa/air_emissions_modeling/2021 https://gaftp.epa.gov/Air/emismod/2021/2021emissions/onroad_emissions_SMOKE-MOVES_FF10_2021hb_26mar2024.zip
emismod 2022 emissions onroad 2022hc _transportation/data-raw/epa/air_emissions_modeling/2022v1 https://gaftp.epa.gov/Air/emismod/2022/v1/2022emissions/onroad_emissions_SMOKE-MOVES_FF10_2022hc_17jul2024.zip

EQUATES

EQUATES data is located on the EPA FTP site and the CMAS Data Warehouse Google Drive. Direct links are provided for both locations.

EQUATES only has on-road data from 2002 to 2019.

Within /air_emissions_modeling/EQUATES, create a folder for each EQUATES year (2002, 2005, 2008, 2011, 2014, 2017) with the prefix “EQUATES_”, plus two additional folders named “EQUATES_MN_WI” and “CMAS_Data_Warehouse”. Download the data for each of the given links and save in the appropriate location. If the direct Google Drive links are not working for you, download each one from the directory page.

All EQUATES data is processed in epa_equates_read.R

#> ./air_emissions_modeling/EQUATES/
#> ├── CMAS_Data_Warehouse
#> ├── EQUATES_2002
#> ├── EQUATES_2005
#> ├── EQUATES_2008
#> ├── EQUATES_2011
#> ├── EQUATES_2014
#> ├── EQUATES_2017
#> └── EQUATES_MN_WI
group inventory_year measurement category slug download_location direct_link
EQUATES 2002 emissions onroad EQUATES_2002 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/EQUATES_2002 https://gaftp.epa.gov/Air/emismod/MOVES3/CONUS/EQUATES_2002_inventory_onroad_01jun2021.zip
EQUATES 2002 smoke_flat_file onroad EQUATES_INV_2002_version1.0 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1jw_0216cTDSw-FrojrgGbKU5myl23ybv&export=download&authuser=0&confirm=t&uuid=fccfb764-8849-44fc-b506-7de81bbdd4e8&at=AO7h07e29Tc-CjdVA7IphIHXaT1L:1727277124697
EQUATES 2002 smoke_flat_file onroad EQUATES_2002_inventory_onroad_01jun2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1eSgTweGuX3xdP1ZZioyNufgHmmooPOcG&export=download&authuser=0&confirm=t&uuid=971b95d9-b965-44c9-b91a-6f3436495f86&at=AN_67v2yl5IR2QHPYuNd5Gxsv9y-:1727793725340
EQUATES 2003 smoke_flat_file onroad EQUATES_2003_inventory_onroad_01jun2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1r3B4TIKy5cestvKygL-2IMRD6OIq47XD&export=download&authuser=0&confirm=t&uuid=2a280431-7bdc-428a-963f-ddf0703dac60&at=AN_67v2ascXZJsERRs76veVFW1-L:1727793829937
EQUATES 2004 smoke_flat_file onroad EQUATES_2004_inventory_onroad_01jun2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1o1JpcQFMfgGZtE5EJpd5K9Aaj0E2EQso&export=download&authuser=0&confirm=t&uuid=f72e8f04-4107-4579-8d9a-c28f8984147b&at=AN_67v0wITHCuhqWPNOHXGD-Lnoq:1727793840527
EQUATES 2005 emissions onroad EQUATES_2005 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/EQUATES_2005 https://gaftp.epa.gov/Air/emismod/MOVES3/CONUS/EQUATES_2005_inventory_onroad_23jun2021.zip
EQUATES 2005 smoke_flat_file onroad EQUATES_INV_2005_version1.0 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1W1QBtNB89FfWdSE3RQdnFoedwjgn0ctB&export=download&authuser=0&confirm=t&uuid=9768171e-056f-45b5-aba8-71f4a69146dc&at=AO7h07eZwuW4OJnGLz83u0LU7rHi:1727277818221
EQUATES 2005 smoke_flat_file onroad EQUATES_2005_inventory_onroad_23jun2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1N4Gsoi6mZWzsawyZiRAgtpB53w27IyIl&export=download&authuser=0&confirm=t&uuid=a7749fd5-4e3f-46de-8c9d-469b496816d3&at=AN_67v2vgmnRnUReCWDDCwrIVEFD:1727793849201
EQUATES 2006 smoke_flat_file onroad EQUATES_2006_inventory_onroad_21may2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1ySYl3sEFylupdOo3O-lO4ff6lUJVtM-q&export=download&authuser=0&confirm=t&uuid=e75a3b7c-ee4c-4550-b510-55af812beac5&at=AN_67v0pMPGPYnfI1qi1_FyOGD1R:1727793857681
EQUATES 2007 smoke_flat_file onroad EQUATES_2007_inventory_onroad_11may2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1tZL5rR-ZeIJttsWYyz8_Sz5GmujetebL&export=download&authuser=0&confirm=t&uuid=09c0dce8-fd7a-41cf-8ef0-53cfac5dbff1&at=AN_67v10MQMcSgXyaOURK-oCc641:1727793865552
EQUATES 2008 emissions onroad EQUATES_2008 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/EQUATES_2008 https://gaftp.epa.gov/Air/emismod/MOVES3/CONUS/EQUATES_2008_inventory_onroad_11may2021.zip
EQUATES 2008 smoke_flat_file onroad EQUATES_INV_2008_version1.0 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1Y6D0YJuMy97hlhG58R5LjmVrVqucNlgy&export=download&authuser=0&confirm=t&uuid=0bf155e4-d9e9-44a9-ab43-8d93505a6b9b&at=AO7h07eoLdEncM7sZJSEMmhw7bBE:1727277879290
EQUATES 2008 smoke_flat_file onroad EQUATES_2008_inventory_onroad_11may2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1vwoNDVHsoJ2i9bUYUv18nfumwBVvnE8U&export=download&authuser=0&confirm=t&uuid=e59e6ce8-8b03-4e25-943a-14d48baec665&at=AN_67v2vBvr4k_A42rZ9noWSi_KN:1727793881049
EQUATES 2009 smoke_flat_file onroad EQUATES_2009_inventory_onroad_07may2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1bw603SJviRhJAD4VmEfEg2ZDDiwMhLoL&export=download&authuser=0&confirm=t&uuid=213983a2-399a-41e6-b259-8f6682ce2005&at=AN_67v07yRNYtmAtaT3uIaFesahd:1727793891635
EQUATES 2010 smoke_flat_file onroad EQUATES_2010_inventory_onroad_23jun2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1khWYlCPnD7Vf0v6Y_K0TsJ39UlW20UdA&export=download&authuser=0&confirm=t&uuid=02133a20-210d-40d8-af82-849dda15c500&at=AN_67v0DrQDKTYPDQ0YIHRy-DesS:1727793899974
EQUATES 2011 emissions onroad EQUATES_2011 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/EQUATES_2011 https://gaftp.epa.gov/Air/emismod/MOVES3/CONUS/EQUATES_2011_inventory_onroad_20apr2021.zip
EQUATES 2011 smoke_flat_file onroad EQUATES_INV_2011_version1.0 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=17qLqwJllqX-XloScSNaxdviQDspTufep&export=download&authuser=0&confirm=t&uuid=d6b82ccf-f5c3-41d2-9b2b-b7bfbf731eeb&at=AO7h07cjoWUwZU0ju9kc4N35ZFQ6:1727278302203
EQUATES 2011 smoke_flat_file onroad EQUATES_2011_inventory_onroad_20apr2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1gxcSlNO9pMkkZMiHgAXB8CfG4kMDaBR3&export=download&authuser=0&confirm=t&uuid=49517128-e290-4414-ae8b-83a3ccc57027&at=AN_67v38elmXKqBFIQw9ghzJIamv:1727793909205
EQUATES 2012 smoke_flat_file onroad EQUATES_2012_inventory_onroad_20apr2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=13ecUVPuqBNhavP7MmDR399Bfa1oFO1mo&export=download&authuser=0&confirm=t&uuid=6ade43ee-13dc-48f4-8603-c7ee91e31a28&at=AN_67v3gMpG_p2qTzJ_fAVWXlP5N:1727793922912
EQUATES 2013 smoke_flat_file onroad EQUATES_2012_inventory_onroad_20apr2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1lVMOGchs1y8xhmYMlQU1AxHkCXmsHn_Z&export=download&authuser=0&confirm=t&uuid=38e90001-5a6b-46c9-af59-884936353192&at=AN_67v2reTXHjuEzzYgKPASyn1cx:1727793930880
EQUATES 2014 emissions onroad EQUATES_2014 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/EQUATES_2014 https://gaftp.epa.gov/Air/emismod/MOVES3/CONUS/EQUATES_2014_inventory_onroad_01mar2021.zip
EQUATES 2014 smoke_flat_file onroad EQUATES_INV_2014_version1.0 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1TTzPa0vse1_z0On-82uBF53IQ6zY5DIX&export=download&authuser=0&confirm=t&uuid=33810c7d-2a28-4d52-bfc2-68598662f428&at=AO7h07cwKOMiDUnr7tirwMaGCb8t:1727277945324
EQUATES 2014 smoke_flat_file onroad EQUATES_2014_inventory_onroad_01mar2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=10754IBAsNO0pMSLL-pjYRZP1jFVitCZ5&export=download&authuser=0&confirm=t&uuid=04b50b5c-b127-4343-854d-e48a1f972081&at=AN_67v2XHRgCFDCmt9VSP70SYF4G:1727793940011
EQUATES 2015 smoke_flat_file onroad EQUATES_2015_inventory_onroad_22feb2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1BVhx3YBkrDxh9w2nw1tuU6iPAUJoIDDY&export=download&authuser=0&confirm=t&uuid=fe805a21-871a-4080-a335-807b329e1e1d&at=AN_67v0urjQ-RZX0V6A71JJh63WP:1727793949180
EQUATES 2016 smoke_flat_file onroad EQUATES_2016_inventory_onroad_18feb2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1Nn0fgVXD044N1jdBR9vrSm77EpA-oWSO&export=download&authuser=0&confirm=t&uuid=ae90a5a0-3ff0-4d2f-b603-83e4db1e6161&at=AN_67v1e5kYNTorFsXQWt1kL1P4P:1727793957895
EQUATES 2017 emissions onroad EQUATES_2017 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/EQUATES_2017 https://gaftp.epa.gov/Air/emismod/MOVES3/CONUS/EQUATES_2017_inventory_onroad_inv_25jan2021.zip
EQUATES 2017 smoke_flat_file onroad EQUATES_INV_2017_version1.0 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1QIaSG3kyReCLUJXXgHubUZKuo1Q5pAsl&export=download&authuser=0&confirm=t&uuid=348fa232-1e5b-445c-9c37-5b49be9819ae&at=AO7h07e7A3qXQiUtgm2L4-zYU3Io:1727277967596
EQUATES 2017 smoke_flat_file onroad EQUATES_2017_inventory_onroad_25jan2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1rDc0aLDcY8fUErsuYkXlAiNUSghm1pA7&export=download&authuser=0&confirm=t&uuid=0d211734-cbca-419a-b5a7-5ddb3bf60c59&at=AN_67v2i0tKobmmJNZk-w9WI3-si:1727793966840
EQUATES 2018 smoke_flat_file onroad EQUATES_2018_inventory_onroad_31aug2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1NyQk-V6o4eXBIfaqLh3Xx6wUH8ClCGhu&export=download&authuser=0&confirm=t&uuid=badc02cc-0f5e-4a17-9bf1-22b84065f3e5&at=AN_67v35iuoZ8QylrSlQj9ylu6xe:1727793975063
EQUATES 2019 smoke_flat_file onroad EQUATES_INV_2019_version1.0 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1ZCAzfSxfzehgKT3RdDO3K6MOko8heOii&export=download&authuser=0&confirm=t&uuid=e597b786-efbb-4922-8161-0af94006d6f0&at=AO7h07cjDkT1iJ9hgSwJ7nIxUY1V:1727277988258
EQUATES 2019 smoke_flat_file onroad EQUATES_2019_inventory_onroad_31aug2021 _transportation/data-raw/epa/air_emissions_modeling/EQUATES/CMAS_Data_Warehouse https://drive.usercontent.google.com/download?id=1IK7FMUs-Pu_h_XZYc6VeV6LVpA63plLS&export=download&authuser=0&confirm=t&uuid=1bf0d0da-1f66-431b-a160-dc5108a400fe&at=AN_67v3Xx0zfbdHzuhmYlNJWtso4:1727793979481