Create a new field for 'countyID'

None of the MOVES lookup tables contain a countyID field solely dedicated to a state-county FIPS code, but SMOKE needs this information. For this reason, Moves2smkEF.pl creates a county field by extracting it from other fields that include county codes as part of their value. The RPD table has a linkID field that contains countyID in the leading five digits followed by more numbers to allow for future implementation of link modeling. The RPV table has a zoneID field that is countyID with a trailing zero. The RPP table has a TemperatureProfileID field, which also leads with countyID and is trailed by other numbers to indicate month and other identification. The postprocessing script parses countyID from linkID, zoneID and TemperatureProfileID and stores it as a separate field.

Cross-tab pollutantID to reduce output table size

Each of the three MOVES lookup tables contains a pollutantID field, and associated emission rates for each are listed in the ratePerDistance field or ratePerVehicle filed (depending on lookup table). This table structure repeats the leftmost fields (e.g., MOVESRunID, yearID, monthID) for each pollutantID, which greatly increases the total number of rows. The cross-tabbing postprocessing step replaces the column for 'ratePerDistance' (or 'ratePerVehicle', 'ratePerProfile') with additional pollutant-specific columns containing values of emission rates. For example, new field headings would include 'CO_ratePerDistance', 'NO_X_ratePerDistance', 'BENZENE_ratePerDistance', etc. Performing this cross-tab on the pollutant emission rates significantly reduces the size of the tables for use by SMOKE.

Estimate HONO based on NO and NO2 from MOVES using equations developed by U.S. EPA

Augment the MOVES speciated PM emission factors to reflect the PM species needed for SMOKE modeling

The following information developed by U.S. EPA to speciate the partially speciated PM2.5 exhaust emissions from MOVES2010. The advantage of using this approach over the approach used for speciating total PM2.5 is that it allows the speciated emissions from MOVES; i.e., elemental carbon and particulate sulfate to be retained and only the remainder of the PM2.5 to rely on speciation profiles.

MOVES PM2.5 species are related as follows:

CMAQ PM2.5 species are related as follows:

The five CMAQ species Primary or Particulate Organic Carbon (POC), Primary Elemental Carbon (PEC), Primary Nitrate (PNO₃), Primary Sulfate (PSO₄), and other primary 2.5 particulate matter (PMFINE) also sum to total PM2.5:

The purpose of the equations given above is to fully speciate the MOVES2010 partially speciated exhause PM2.5 to create the model species needed for CMAQ. These equations are only used when there are exhause-related emissions (e.g. Running Exhaust, Start Exhaust, Creankcase Start/Running Exhaust, and Idle Exhaust). The equations utilize the following MOVES2010 outputs:

insert PEC_72 discussion from SMOKE-MOVES Integration tool 3.2.4 here

The Equations are as follows:

Table 5.4, “Values and basis for fractions used to compute PNO₃, METAL, and PMC” gives the values for FNO3, FEC and FMETAL and R_PM10-to-PM25. They are based on the vehicle type (first seven digits of the SCC), except that R_{PM10-to- PM25} is based soley on fuel type.

Create final emission rate lookup tables in SMOKE format

In addition to the changes specified above sections(put in reference), a few minor cosmetic changes (described in this section) are made to each table. The three postprocessed tables named rateperdistance_smoke, ratepervehicle_smoke, and rateperprofile_smoke are exported from MySQL into ASCII files for their use in SMOKE. The fields are listed by lookup table type (refer to final lookup table - section2).

In the directory specified by InputDBlist, SmkEFsum.pl will read the three MRCLIST files created by Moves2smkEF.pl

It then opens each emission factor files listed in the MRCLIST files that were created by Moves2smkEF.pl and sums the emissions.

It will write new emission factor files to the OutputPath directory and create a new MRCLIST file.

The new files are all named with ".summed.lst" or ".summed.csv" to avoid any confusion with the original emission factor files. SmkEFsum.pl will work with files created by earlier versions of Moves2smkEF.pl (where the evaporative permeation emissions were named EVP - prior to renaming to EPM) and with the latest version.