-------
MOVES2010 User Guide
January 2010
File Edit Pre Processing Action Post Processing Tools Settings Help
2.3.3 Pre Processing
The Pre Processing menu contains four active options, IM Importer, Data Importer,
County Data Manager, and Project Domain Manager. Each option enables the user to access
importers for individual tables in order to create user-supplied databases for direct entry of data
into MOVES. The Project Domain Manager, in particular, requires the user to provide
virtually all of the data required to model a specific project.
MOVES - ID 0
File Edit Preprocessing Action PC
Execute Data Importer...
I.M Importer
Data Importer
County Data Manager
Project Domain Manager
The County Data Manager (CDM) and the Project Domain Manager (PDM)are
means by which the user can define the county-specific or project-specific data required if the
user selects County Domain/Scale or Project Domain/Scale when defining the Scale parameter
of the RunSpec. Neither the County Data Manager nor the Project Domain Manager menu
options will be enabled unless the user has made the County Domain/Scale or Project
Domain/Scale choice. The I/M Importer also provides users with the ability to define county-
specifc data by allowing the user to edit the inspection and maintenance programs in an area.
The I/M Importer can be used at any Scale.
The County Data Manager and Project Domain Manager are designed to specify all
the inputs required for certain kinds of runs and the I/M importer only allows I/M programs to
be modified. The Data Importer, on the other hand, allows the user to select individual
importers "ala carte" from the importer menu.
XCaution! All tabs/fields in the County Data Manager and Project Domain Manager
should be completed to ensure the output generated is correct. In some cases, a
RunSpec may execute even though all the tabs in the County Data Manager or
Project Domain Manager were not completed; however, the results from such
United States Environmental Protection Agency
Page 51
-------
January 2010
MOVES2010 User Guide
RunSpecs may populate the incomplete tabs with default data, which may not be
appropriate due to how MOVES generates, calculates, and allocates various data.
The user does not have to specify a database containing county or project data that was
created with the County Data Manager or Project Domain Manager in the Manage
Input Data Sets panel. These databases only have to be selected in the Domain Input
Database pane of the Geographic Bounds panel. However, databases created with the
Data Importer or I/M Importer should be input using the Manage Input Data Sets
panel.
From the user perspective, there are three major differences between working with
importers through the Data Importer and working with the same importers through the County
Data Manager and the Project Domain Manager (leaving the I/M Importer aside, for the
moment). First, as "domain managers" the County Data Manager and Project Domain
Manager indicate whether the user has imported all of the data that is needed to establish a new
domain To this end, the County Data Manager and the Project Domain Manager will
identify the parameters where data is needed by displaying red "x-circles" on the importer tabs
(see screenshot below). Green checks indicate where data has been properly and completely
imported. The Data Importer does not display such information.
O MOVES County Data Manager
© Fuel Supply
Q Fuel Formulation
@ Meteorology Data
O Road Type Distribution
RunSpec Summary
Database
& Age Distribution
_L
© Average Speed Distribution
localhost
Select or create a database to hold the imported data.
Server:
Database:
Log:
M Create Database
Refresh
Clear All Imported Data
Database
Done
Secondly, because of the level of detail required and the structure of the underlying data
tables, the County Data Manager restricts the RunSpec to a single county and single calendar
year, and the Project Domain Manager restricts the RunSpec to a single hour, daytype, month
and county. The Data Importer can be used with any RunSpec.
Page 52
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Thirdly, the Data Importer is generally used to import data for a RunSpec at the
National Domain/Scale. Therefore, when importing Population or Vehicle Type VMT at the
National Domain/Scale, these inputs should be national values even if only a small number of
counties are selected. MOVES will use the default allocation factors for the counties selected in
the RunSpec to apportion data to each county.
This user guide will use the Data Importer screens to explain functionality of individual
importers. Specific instructions associated with using the County Data Manager or the
Project Domain Manager to establish a new domain are included where appropriate. The
sections below will also provide additional detail for the I/M Importer, as necessary.
When the user selects one of the data manager options, the manager window will open.
This window contains several tabs to aid the user in defining the data source, destination, and
database structure for the imported data. Importer tabs provide templates for collecting user-
provided data.
2.3.3.1 Database
The Database tab is the default initial tab for the Data Importer menu option. It
contains: a text box where the user can select an input database from a drop-down list or name a
new database; three buttons to aid in the creation and management of the database; and a
scrollable log detailing the success of the data import and other helpful diagnostics.
7 Note Data cannot be imported until an input database is identified.
D MOVES County Data Manager
@ Source Type Population [ @ Vehicle Type VMT [ @ I/M Programs [Tools
U Fuel Supply
O Fuel Formulation
© Meteorology Data
O Road Type Distribution
RunSpec Summary
Database
@ Age Distribution
O Average Speed Distribution
Select or create a database to hold the imported data.
Server:
Database:
Log:
rH Create Database
Refresh
Clear All Imported Data
Database
Done
United States Environmental Protection Agency
Page 53
-------
January 2010 MOVES2010 User Guide
By default, the host server for the receiving database is "localhost" (generally the user's
own machine). The user can specify a different host server by entering the name of the alternate
server in the Server box. The input database can be identified by clicking on the drop-down
arrow adjacent to the Database box and making a selection from the list. Alternatively, the user
can create a new database by typing a database name in the Database box and clicking the
"Create Database" button. Clicking the "Refresh" button will clear the database selection from
the Database box display, refresh the list of databases in the drop-down list, and clear the Log.
The final button is the "Clear All Imported Data" button, which clears all the imported data
(but not all the tables in the input tables as some are "core" tables that are populated based on the
selections in the RunSpec at the time the database was created).
The input database should follow a naming convention to differentiate it from other
databases; typically, using "_in" at the end of the database name is recommended.
The Database tab also contains a Log panel. This panel is used by the system to display
the results of the import process. Once the user chooses either the Tools or an Importer tab to
import data into the selected database, the user can refer to the Log panel in the Database
window to view the results of the import process. The Log panel also includes the description of
the imported file, if one was entered.
2.3.3.2 RunSpec Summary
The RunSpec Summary provides a summary of RunSpec parameters defined by the
user. The user cannot view the Navigation panels of the GUI without closing the Importer, but
doing so may impact the user's ability to effectively employ "Generate Importer XML File" in
the Tools tab. Therefore, the user should choose this tab to see an overview of the RunSpec. In
setting up the RunSpec, the user defines modeling parameters that limit the scope of the
modeling process; templates and export files created with the Data Importer will be limited by
choices the user made in defining the RunSpec.
Page 54 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
^^^^^1 H MO V ES Co u n ly Data Ma nage r X
f 9 Source Type Population | & Vehicle Type VMT | @ liM Programs | Tools
& Fuel Supply [ © Fuel Formulation @ Meteorology Data Q Ftoad Type Distribution
FuinSpec Summary Database @ Age Distribution U Average Speed Distribution
Output Database Server Name: [using default]
Output Database Name: [using default]
Time Spans:
Aggregate By: Hour
Years:
1999
Months:
Days:
Hours:
Begin Hour:
End Hour:
Geographic Bounds:
COUNTY geography
Selection: ARIZONA- Apache County
On Road Vehicle Equipment:
Road Types:
Pollutants And Processes:
Rate of Progress:
Rate of Progress calculations are disabled
-•
-
.
T.
RunSpec Summary
Done
The RunSpec Summary panel of the Data Importer displays the geographic, time span, road
type, vehicle, pollutant and process, and input data set choices made by the user. The panel is
auto-generated and does not accept user input.
2.3.3.3 Tools
The Tools tab is provided to facilitate batch input of imported data into the MOVES
system, such as a series of data import files representing all the counties in a state. When the
user clicks the "Generate Importer XML File" button after completing an import, the system
will write an importer instruction file in Extensible Markup Language (XML), containing a
statement that replicates the import done through the GUI. Note, the XML file only includes
files that have been imported during the active session so the XML must be generated before the
user closes the Data Importer.
United States Environmental Protection Agency
Page 55
-------
January 2010
MOVES2010 User Guide
H MOVES County Data Manager
® Source Type Population ! @ Vehicle Type VMT I & VNI Programs
I Fuel Supply
1 Fuel Ffu mi iki! ion
I Meteorology Data
O Road Type Distribution
RunSpec Summary
@ Age Distribution
O Average Speed Distribution
MOVES Data Importers can be run via the command line using an
XML-based description file similar to the MOVES RunSpec file.
Generate Importer XML File
Using an XML or text editing program, the user then can copy and edit the importer
XML file to create a series of similar, but not identical import statements; therefore, naming
conventions are important to use this tool effectively. The resulting XML files can be called
from the command line, generating a series of user-input databases. For more information on
running MOVES from the command line, see Appendix C.
2.3.3.4 Data Managers (Importers)
The remaining tabs in the Data Importer menu option are Data Manager or Importer
tabs. These tabs contain templates and rules that aid the user in bringing specific types of data
into the model and ensuring it has the correct format. By choosing a Manager or Importer, the
user gains access to several tools that will help create a successful data import.
The user should be sure to fill out all fields in defining the RunSpec before using the
County Data Manager or the Project Domain Manager, as a filter is used when
exporting default data that depends on selections the user makes when defining the
RunSpec. Only the county, year, months, vehicles, road types, etc. that have been selected
are exported. Some data may not be exported if the "Export Default Data" button is used
before fully defining the Run Spec.
EPA has developed MOBILE6 converters to help users prepare import-ready data files
from their existing MOBILE6 files. These converters are available on the MOVES
website.
Page 56
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
The user should select a Manager or Importer tab to choose a specific importer to assist
with specialized data file structure definition and to complete the import process. Importers for
the following tables are included in MOVES2010:
MOVES Table
RampFraction
RoadTypeDistribution
SourceTypePopulation
VehicleTypeVMT
Z oneRoad Activity
AgeDistribution
AverageSpeedDistribution
Fuel Supply
FuelF ormul ati on
MeteorologyData
I/M Coverage
OperatingModeDistribution
LinkSourceType
LinkDri ve S chedul e s
Off-Network
Data Importer
X
X
X
X
X (Custom
Domain Only)
X
X
X
X
X
X
County Data
Manager
X
X
X
X
X (Custom
Domain Only)
X
X
X
X
X
X
Project Domain
Manager
X
X
X
X
X
X
X
X
X
Table 2.3.3.4a
When the user selects one of these tabs, a panel opens allowing the user to define the import
parameters. Each Importer tab is organized in the same way, with a place for the user's
description of the data; a place where the corresponding MOVES default database table and the
user's input file are identified; buttons to browse for data files, create templates, clear, import,
and export data; and a space for messages informing the user of the success or potential errors
with the import process.
United States Environmental Protection Agency
Page 57
-------
January 2010
MOVES2010 User Guide
1
B MOVES Data Importer X
' Road Type Distribution (' Source Type Population | ' Vehicle Type VMT [ I/M Programs [ Tools
U Fuel Supply Fuel Formulation | Meteorology Data [ Ramp Fraction
RunSpec Summary | Database Age Distribution | Average Speed Distribution
Description of Imported Data:
sourceTypeAgeDistribution Data Source:
:ile: (please select a file) Browse...
Clear Imported Data Create Template...
Import
Messages:
Export Imported Data
Age Distribution
Done
1
Near the top of each impoter panel is a text box that allows users to enter a description of
the data or file being imported. Any text entered here will be reported and saved in the Database
Log. Just below the Description box is the Data Source section of the window. Along the left
side of this section is text that states: [MOVESTable] Data Source:. The [MOVESTable]
corresponds to the name of the table in the MOVES default database for which the tab will
import data. In most cases, the tab header and MOVESTable name are similar, but in some cases
they are not (e.g. Meteorology Data corresponds to the ZoneMonthHour table because
temperatures are defined for each zone, month, and hour). Users can refer to the MOVESTable
in the MOVES default database to learn more about that table, its structure, and the data
contained within it.
7 Note The default database table may contain more fields than the template or exported
default files (described below). There are several reasons why these additional fields
may exist in the default table (e.g., the population and VMT tables each include a
growth factor that is not used in the County Domain/Scale because only a single year
can be modeled). Users should be aware that if the fields do not exist in the template or
exported default data file, then these fields should not be added or populated.
Also in the Data Source section of the window are the Browse, Clear Imported Data,
and Create Template buttons. After clicking the Browse button, the user can search through
the computer's (or network's) drives to identify the file containing the data to be imported.
Upon selecting a file, users may be prompted to select a worksheet:
Page 58
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Choose XLS Worksheet
Select the Worksheet to read:
HPMSVTypeYear
monthVMTFraction-calculated
[JayVMTFraction-calculated
liourVMTFraction-manual
nstructions
mport HPMS AADVMT and Factors
Daily VMT by HPMS and Month
Monthly VMT
monthVMTFraction-default
OK
Cancel
The correct worksheet should be highlighted before the "OK" button becomes active.
The user can click the "Create Template" button to create an import template file and a
set of reference files. After selecting the "Create Template" button, the user must define the
file, file path and extension (e.g., .xls for an Excel file) and click the Save button. The template
and reference files will be specific to the RunSpec. The template will include required data field
names and often will be populated with the required key fields, as specified in the Run Spec.
The reference files will provide lists and descriptions of the relevant MOVES ID fields (i.e.,
countylD codes, fuelformulationID codes, roadtypelD codes, hourDaylD codes, and
sourcetypelD codes). The user can then edit the template with a spreadsheet application or other
tool before importing the data files into MOVES2010.
Although the meaning of many data element names may seem clear, the user should
consult the reference tables provided with the template to determine appropriate content for the
fields. For example, although fuelYearlD might seem to refer to the calendar year, it actually
refers to "fuelyear" and does not have a one-to-one mapping with calendar year (the latest
fuelyear in MOVES2010 is 2012).
In many cases, users can import duplicate information by using "wildcards" in the input files.
See Table 2.3.3.4b. For example, using the word "ALL" in a sourceTypelD column of the input
file will result in records with the same information for each source type selected in the runspec.
XCaution! "ALL" produces inputs only for all the sourcetypes in the RunSpec rather than all
the sourcetypes in the default database. For this reason, users are strongly urged to
create a comprehensive RunSpec prior to using the importers.
The hourDaylD column supports a special form of the "ALL" wildcard. It allows the
user to populate all 48 hour intervals (24 x 2 day types) or just the hours in a given day type.
Remember, these are constrained by the runspec's day and hour selections.
United States Environmental Protection Agency
Page 59
-------
January 2010
MOVES2010 User Guide
The affected fields are:
Column
daylD
hourlD
hourDaylD
monthID
yearlD
roadTypelD
sourceTypelD
hpmsVTypelD
county ID
zonelD
Wildcard
ALL
ALL
ALL
ALL Weekday
ALLS
5*
*5
ALL Weekend
ALL 2
2*
*2
ALL
ALL Note: Only one year is allowed in the CDM.
ALL
ALL
1 * - Applies to
2* - Applies to
3* -Applies to
4* - Applies to
5* - Applies to
6* - Applies to
all motorcycles
all passenger cars
all passenger trucks
all buses
all single unit trucks
all combination trucks
ALL
ALL Note:
Only one county is allowed in the CDM.
ALL
Table 2.3.3.4b
In the receiving database, wildcard data is fully expanded. Importing a file that uses
wildcards and then exporting again will produce a file with the full data set.
Once a correctly formatted source file is created, the user should use the "Browse"
button to find and open the source file. The file path and name of the selected import file will
appear in the panel.
Make sure to save any changes made to a source file before you import it.
^ Note "Warning" messages do not necessarily mean that the imported data is incorrect. For
example, users may receive a "Warning" if data for a source types, month, etc. are
imported, but that source type or month is not selected in the RunSpec. On the other
hand, "Error" messages indicate situations where the source file should be amended to
correct the problem, the data should be cleared, and the file re-imported.
Once a file has been selected for import, the user may click the "Import" button to bring
the data into MOVES via the file and path defined in the Database window. If the file contains
multiple worksheets, the user is prompted to select the appropriate worksheet as well. The user
Page 60
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
should refer to the Messages box in the Importer tab or the Log panel in the Database window
to determine the status of data import.
See the Messages box for information on import problems and basic information for
fixing problematic import files.
Imported data can be cleared from the database by clicking the "Clear Imported Data"
button, which is in the Data Source section of the window. When the "Clear Imported Data"
button is clicked, the message box shown below pops up.
Are you sure you want to clear the data?
Clicking "Yes" clears the data, while clicking "No" cancels the action and allows the user to
export the imported data, as described below.
Users should "Clear Imported Data" before reattempting to import a file that resulted in
an error message.
Data files can be exported to an Excel spreadsheet or text file using either the "Export
Default Data" or "Export Imported Data" button; however, not all tabs in the County Data
Manager have the "Export Default Data" button. These exceptions are noted in the sections
below. Also, some tabs in the Project Domain Manager include an additional export button,
"Export Most Recent Execution Data". Use of this button requires a previous execution of the
MOVES model in order to generate the data which is to be exported.
Clicking on an "Export" button will cause the Export [Importer] Data window to open.
The user defines the file path, file name and file extension in the Export Data window, and
clicks the "Save" button, to export the data to the specified location.
Occasionally, clicking an "Export" buttons may result in the following pop-up window:
No data was retrieved. Consult the user guide for more options.
This message simply means that there were no data available to export.
United States Environmental Protection Agency
Page 61
-------
January 2010 MOVES2010 User Guide
2.3.3.4.1 Meteorology Data Importer
The Meteorology Data Importer allows the user to import temperature and humidity
data for months, zones, counties, and hours that are included in the RunSpec. While the MOVES
model contains 30-year average temperature and humidity data for each county, month, and
hour, the user should enter data specific to the modeled location and time.
2.3.3.4.2 Source Type Population Importer
The Source Type Population Importer allows the user to input the number of vehicles
in the geographic area which is to be modeled for each vehicle or "source type" selected in the
RunSpec. While the MOVES table that this importer populates (SourceTypeYear) includes
fields for sales growth rate and migration factor, neither of these fields should be imported. They
are extraneous because the importer sets the selected year as a base year and defines the
population.
This tab does not have the "Export Default Data" button and the user is required to
acquire/generate this data independently if the County Domain/Scale is chosen. Data must be
supplied for each source type (e.g., passenger car, passenger trucks, light commercial trucks,
etc.) selected in the RunSpec.
2.3.3.4.3 Age Distribution Importer
The Age Distribution Importer allows the user to enter data that provides the
distribution of vehicle counts by age for each calendar year (yearlD) and vehicle type
(sourceTypelD). The distribution of agelDs (the variable for age) must sum to one for each
vehicle type and year.
This tab does not have the "Export Default Data" button and the user is required to
acquire/generate this data independently if either the County or Project Domain/Scale are
chosen.
2.3.3.4.4 Vehicle Type VMT and VMT Fractions
The Vehicle Type VMT importer allows the user to enter yearly vehicle miles traveled
(VMT) and the monthly, type of day, and hourly VMT fractions. These values will represent
Page 62 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
national values for the general Data Importer and county-specific values for the County Data
Manager. MOVES requires that "yearly" VMT be imported regardless of the time span selected
for the run, although the VMT Fraction tables can be modified such that the value does not have
to actually represent the VMT for the entire year in the area being modeled. Note that the
appearance of this table differs from other tabs as multiple data sources are listed in the data
source section. Users can expand the size of the CDM window or use the scroll bar to view all
the data sources and buttons.
The MOVES website has spreadsheet tools to calculate yearly VMT from Average Annual
Weekday VMT (AADVMT) and to convert MOBILE6 formatted VMT data into MOVES
format.
XCaution! Vehicle Type VMT, Source Type Population, and Age Distribution are the three
tables that MOVES needs to define a base year. If any one of these tables is
imported, then all three must be imported, otherwise MOVES may not generate
output. However, this requirement does not apply to the Project Domain/Scale.
E MOVES Data Importer
Road Type Distribution [ Source Type Population Vehicle Type VMT liM Programs [Tools
Q Fuel Supply
Fuel Formulation
Meteorology Data
Ftamp Fraction
RuuSpec Summary
Database
Age Distribution
Average Speed Distribution
Description of Imported Data:
HPMSVTypeYear Data Source:
File: (please select a file)
Browse-
Clear Imported Data Create Template...
i i"i itl iVMTFi ,n. ti»N Data Source:
- fnleagg select a file 1
Import
Messages:
Export Default Data
Export Imported Data
ehicle Type VMT
Done
The "Export Default Data" button for this tab exports the default monthVMTFraction,
dayVMTFraction, and hour VMTFraction tables. An FIPMSVTypeYear table with values of zero
for all FtPMS classes is also exported, which can serve as a template that the user can edit before
importing, but the user is required to acquire/generate the VMT data indepently if the County
Domain/Scale is chosen. Data must be supplied for each HPMSVType (e.g., passenger cars,
combination trucks, etc.) implied by the Source Use Types selected in the RunSpec.
United States Environmental Protection Agency
Page 63
-------
January 2010 MOVES2010 User Guide
Each of the VMT Fraction tables must sum to 1 across a varying set of fields. The
monthVMTFraction table must sum to 1 for each sourcetype. The day VMTFraction table must
sum to 1 for each source type-month-road type combination. The hourVMTFraction must sum
to 1 for each source type-road type-type of day combination. In the month VMTFraction table,
users must also correctly identify whether the year being modeling is (Y) or is not (N) a leap year
in the 'isLeapYear' field.
The Import button will import the file identified for each data source at once. Therefore,
users can, but are not required to, select all four files before importing. Users can also clear one
data source file at a time by clicking the Clear Imported Data button associated with each data
source.
2.3.3.4.5 Average Speed Distribution Importer
The Average Speed Distribution Importer allows the user to input average speed data
specific to vehicle type (sourceTypelD), road type (roadTypelD), and time of day/type of day
(hourdaylD). MOVES defines 16 "speed bins" which describe the average driving speed on a
roadtype or link. The user must enter the fraction of driving time in each speed bin
(avgSpeedFraction) for each hour/day type, vehicle type, road type, and average speed
(avgspeedbinid), where the fractions sum to one for each combination of vehicle type, road type,
and hour/day type specified in the RunSpec. If desired, the user can use wildcards to apply one
set of fractions for all hour/day combinations for a specific vehicle type and road type. Note that
MOVES uses a time-based distribution, whereas MOBILE6.2 used a VMT-based speed
distribution. Users may need to adjust their travel model post-processing code in order to
generate the new distributions. See Section 2.3.3.4.12 for information on entering average speed
information for Project level modeling.
2.3.3.4.6 Road Type Distribution Importer
The Road Type Distribution Importer allows the user to enter data relating to the
vehicle miles traveled by road type (roadTypeVMTFraction) for the domain being modeled.
This data is entered as a distribution across road types (roadTypelD), where only road types
Page 64 United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
selected by the user in the RunSpec are included in the distribution. The distribution must sum
to one for each source type.
^ Note When comparing input roadtype distributions to the VMT output in the
MOVESActivityOutput table, it may not appear that the road type distribution was
applied properly if the user looks only at individual hourly or daily VMT results.
However, users must compare the input road type distribution to the total weekly VMT
by weighting the VMT results by the number of each type of day (5 weekdays, 2
weekend days). The VMT should be compared at a weekly level because of the effect
of the dayVMTFraction table on the VMT output. For example, in the default
DayVMTFraction table, the weekend fraction for rural roads is slightly higher than the
weekend fraction for urban roads. If these default dayVMTFraction values are applied,
the VMT in MOVES output by daytype will show a slightly higher-than-average
fraction of total VMT on urban roads on weekdays, and on rural roads on weekends.
This tab does not have the "Export Default Data" button and the user is required to
acquire/generate this data independently if the County Domain/Scale is chosen.
2.3.3.4.7 Ramp Fraction Importer
The Ramp Fraction Importer allows the user to modify the fraction of ramp driving
time on selected road types. Only limited access roadtypes (freeways and interstates) may have
their ramp fractions modified. Thus, this Importer is only active if the user selects a limited
access road type when defining the RunSpec.
For Inventory calculations, the County Data Manager automatically applies default
values of 0.08 (8%) for this parameter if the user does not provide input, so importing ramp
fractions is optional when County Domain/Scale is chosen.
? Note The Ramp Fraction tab will only become available if an unrestricted road type (i.e. 2
or 4) is selected in the RunSpec.
For Rate calculations, which output running emissions by speed bin, the ramp fraction
imported here is ignored. The ramp fraction is automatically set to zero (0) for all roadtypes in
all Rate calculations.
2.3.3.4.8 Fuel Formulation Importer
The Fuel Formulation importer and the Fuel Supply importer should be used together
to input appropriate fuel data. The Fuel Formulation importer allows the user to select an
existing fuel in the MOVES database and change its properties, or create a new fuel formulation
with different fuel properties. All fuel formulations imported in the Fuel Supply importer must
exist in the MOVES default FuelFormulation table or be imported. If the user defines a new
fuel, all of the fields except the last three (i.e., BioDiesel, Cetane and PAHContent) are required.
Biodiesel may be modeled by entering and biodiesel volume in the Fuel Formulation table and a
marketshare for the new biodiesel fuel in the Fuel Supply table. The inputs for the Cetane and
PAHContent variables are currently inactive in MOVES.
United States Environmental Protection Agency Page 65
-------
January 2010
MOVES2010 User Guide
The Fuel Formulation importer allows the user to change the following fuel properties.
Property
FuelF ormul ati onID
Fuel Sub-Type
RVP
Sulfur Level
ETOH Volume
MTBE Volume
ETBE Volume
TAME Volume
Aromatic Content
Olefm Content
Benzene Content
E200
E300
VolToWtPercentOxy
BioDieselEsterVolume
Cetane Index
PAHContent
Description
Fuel formulation identification number.
be greater than 100 and less than 25000
Must
Fuel Sub-type coding — see Template File
Reid vapor pressure in psi
Fuel sulfur level in ppm Sulfur
Ethanol Volume (% vol)
MTBE Volume (% vol)
ETBE Volume (% vol)
TAME Volume (% vol)
Aromatic content (% wt)
Olefm content (% wt)
Benzene content (% wt)
Lower volatility percentage (%)
Upper volatility percentage (%)
Constant based on oxygenate type
BioDiesel Ester Volume (%)
Not Implemented - NULL
Not Implemented - NULL
Table 2.3.3.4.2
2.3.3.4.9 Fuel Supply Importer
The Fuel Supply importer allows the user to assign existing fuels to counties, months,
and years, and to assign the associated market share for each fuel. The market share for a given
fuel type (gasoline, diesel, etc.) must sum to one for each county, fuelyear (i.e., calendar year),
and month. In MOVES2010, the user may select fuels from those available in the default
database or create their own fuel inputs. Any new fuels which are added to the Fuel Supply
importer must either be added in the Fuel Formulation importer or must already exist in the
default MOVES database. Users must be sure to identify a fuel formulation for all vehicle-fuel
type combinations selected in the On Road Vehicle Equipment panel
This importer also allows the user to supply a data element, "marketShareCV", which is
the coefficient of variation for the market share. This would be used if uncertainty calculations
were enabled. For MOVES2010 the value is not required and may be left blank.
Modeling different fuels in different years (2012-and later) can be done with a separate
run for each year, assigning different fuels to the "2012" fuelyearid for each run.
2.3.3.4.10 I/M Importer
Page 66
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
The I/M Importer allows the user to import information describing inspection and
maintenance programs. When defining I/M programs in an area, users should refer to the
supporting information tables to identify the numeric codes for the pollutant-process, source
type, and test standard for the program being described. I/M programs can only be applied to
gasoline vehicles (fueltypelD of 1) and only annual or biennial inspection frequency should be
used (inspectFreq of 1 and 2, respectively).
ION! I/M emission effects are not currently available for diesel fuel or continuous I/M
,
A field that requires more detailed explanation is the IMProgramlD. This identifier is an
arbitrary number that is serves as a substitute for unique combinations of test standard, test
frequency, begin model year, and end model year. Therefore, the same IMProgramlD can be
associated with multiple source types and pollutant-processes, but not with different test
standards, frequencies, or model year ranges.
7 Note Only one I/M program can apply to each pollutant-process, source type, fuel type,
model year combination. If the user imports a file that has programs that overlap for
any of these parameters, an "Error" message will notify the user that there are
"duplicate active programs". The user can resolve the "Error" message by either
ignoring one of the programs that created the error or modifying the programs so that
they do not overlap.
For the I/M tab header to be changed from a red X to a green check, the user must
account for all the default I/M programs in some way. This can be done by simply importing the
defaults; however, if the user believes the default information is not correct, then a file with
modified data should be entered. The preferred method for entering modified data is to enter a
value of "N" for No in the "UselMYN" field for all the default I/M programs for which the user
will provide new data. Then the user should add to the file new entries with "Y"s in the
"UselMYN" field and new IMProgramlD values; this approach ensures that all the default
programs are accounted for and the user has full control of the new programs. Another method
is to attempt to edit the default programs, but then the user runs a higher risk of creating
programs with the same IMProgramlD, but different test standards, frequencies, or model year
ranges, and thus a higher likelihood of introducing errors.
7 Note ASM and IM240 programs can only apply to 1981 and later model years; Exhaust and
Evaporative On-Board Diagnostics (OBD) programs can only apply to 1996 and later
model years.
The complianceFactor is a value (0 to 100 scale) that defines the percentage of vehicles
that participate in the I/M program. Users should consult the MOVES Technical Guidance for
more information.
The "Export Default Data" button provides I/M coverage data for many programs
throughout the United States, but users should review the default programs as current local data
may be more accurate and up-to-date.
United States Environmental Protection Agency Page 61
-------
January 2010 MOVES2010 User Guide
7 Note This is the only importer tab in the I/M Importer, although that tool also has the
Database, RunSpec Summary, and Tools tabs.
2.3.3.4.11 Zone Road Activity Importer
The Zone Road Activity Importer is used only if the Custom Domain option is chosen
in the County Domain Manager. Currently, MOVES only has the capability to model one zone
at a time within a Custom Domain. The Zone Road Activity tab erroneously shows a green
check, but data MUST be imported for MOVES to calculate results properly; a value of 1 should
be entered for the SHOAllocFactor for each road type so that all of the VMT input by the user is
assigned to the custom domain.
• " ION!
This tab does not have the "Export Default Data" button, so users should create a
template to populate the SHOAllocF actor field with a value of 1 for each road type..
2.3.3.4.12 Links Importer
The Links Importer is used only in the Project Domain Manager. It allows the user to
define individual roadway links. The MOVES links need not correspond to traffic modeling
"links" but each link should be uniform in its activity as described its MOVES parameters. Each
link requires a linkID (i.e., a unique integer between 1 and 99999 that is used to reference the
link in the program). Other required inputs for each link are countylD, zonelD, and roadTypelD
(these same entries must be specified in the Runspec or an error will occur), the length of the
roadway link in units of miles, the traffic volume on the roadway link in units of vehicles per
hour, the average speed of all of the vehicles on the roadway link in the given hour, and the
average road grade of a particular link. The link description field is a text field included for
reference and has no impact on the calculations.
In addition to roadway links, a project may include a single "off-network" (parking lot or
other non-road) link. For an off-network link, the user should enter a value of zero for link
length, link volume, link average speed and link average grade (percent grade).
For Project level modeling, users have a choice of ways to describe the speed,
acceleration and power of the vehicles being modeled. Depending on the information available
for each roadway link, a user may enter an operating mode distribution, a drive schedule or an
average speed. For a given roadway link, a user-supplied operating mode distribution input will
take calculational precedence over an imported drive schedule, which will take calculational
precedence over an average link speed input when more than one is entered for a given link.
Use of a link average speed input in the Links Importer requires the least amount of
road link data to be provided by the user. All that is required is an average link speed and an
average link road grade (in units of percent grade). The model will use built-in driving schedules
and an interpolation algorithm to produce a default operating mode distribution.
Page 68 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Table 2.3.3.4.12 shows the allowable range for the average speed input in Project level
by source type. The user may enter any speed in units of miles per hour (mph) within the
minimum and maximum range as the average speed input for a given link. Average link speed
inputs outside of the minimum and maximum speed range may produce no output records for the
given link. No warning or error message is provided.
These average speed ranges exist in MOVES project level because these ranges represent
the extent of the available driving cycle data in the MOVES model. The MOVES model does
not extrapolate beyond its built-in data. Should the user desire to model a link with an average
speed that is less than the minimum or greater than the maximum, they must supply the second
by second driving schedule or an equivalent operating mode distribution.
Allowable Average Speed Input Range for Project Level Input
By Source Type
sourcetypeid
11
21
31
32
41
42
43
51
52
53
54
61
62
sourcetypename
Motorcycle
Passenger Car
Passenger Truck
Light Commercial Truck
Intercity Bus
Transit Bus
School Bus
Refuse Truck
Single Unit Short-haul Truck
Single Unit Long-haul Truck
Motor Home
Combination Short-haul
Truck
Combination Long-haul
Truck
Minimum Speed
(mph)
2.5
2.5
2.5
2.5
4.6
4.6
4.6
2.2
4.6
4.6
4.6
5.8
5.8
Maximum Speed
(mph)
73.8
73.8
73.8
73.8
72.8
72.8
72.8
71.7
72.8
72.8
72.8
71.7
71.7
Table 2.3.3.4.12
2.3.3.4.13 Link Source Types Importer
The Link Source Types Importer is used only in the Project Domain Manager. It is
used to enter the fraction of the link traffic volume which is driven by each source type. It is not
used to enter off-network data, and is not required if the Project contains only an off-network
link. For each linkID, the sourceTypeHourFraction must sum to one across all source types. If
the user enters data for source types which are not selected in the Runspec, MOVES will ignore
that data. The Project level calculator will not re-normalize the fractions to omit the contribution
of source types which are not selected in the Runspec.
United States Environmental Protection Agency
Page 69
-------
January 2010 MOVES2010 User Guide
2.3.3.4.14 Operating Mode Distribution Importer
The Operating Mode Distribution Importer is used only in the Project Domain
Manager. It allows the user to import operating mode fraction data for source types, hour / day
combinations, roadway links and pollutant / process combinations that are included in the
RunSpec and Project domain. These data are entered as a distribution across operating modes.
Operating modes are "modes"of vehicle activity that each have a distinct emission rate. For
example, "running" activity has modes that are distinguished by their Vehicle Specific Power
and instantaneous speed. "Start" activity has modes that are distinguished by the time the vehicle
has been parked prior to the start ("soak time"). See EPA technical reports for additional
information on operating modes. For a given source type, hour/day combination, roadway link
and pollutant / process combination, the operating mode distribution must sum to one.
The Operating Mode Distribution Importer is required for the Project Domain Manager
when modeling any 'non-running emission' process, and for modeling 'running emission'
processes when either the Link Drive Schedules Importer is not used, or the link average speed
input is not entered in the Links Importer. Operating Mode Importer data has precedent over
data entered in the Link Drive Schedules Importer and the Links Importer if conflicting data
are entered.
2.3.3.4.15 Link Drive Schedules Importer
The Link Drive Schedules Importer is used only in the Project Domain Manager. It
allows the user to define the precise speed and grade as a function of time (seconds) on a
particular roadway link. The time domain is entered in units of seconds, the speed variable in
miles per hour and the grade variable in percent grade (i.e., vertical distance / lateral distance;
100% grade equals a 45 degree slope).
This Importer is used for the Project Domain Manager only when modeling 'running
emission' processes when the Link Drive Schedules Importer is used. For a given roadway
link, an operating mode distribution input will take calculational precedence an imported drive
schedule. An imported drive schedule will take calculational precedence over an average link
speed input when more than one is entered for a given link. However, at least one of three (an
operating mode distribution, a link drive schedule or a link average speed) must be entered for
each of the user's defined roadway links.
2.3.3.4.16 Off Network Importer
The Off Network Importer is used only in the Project Domain Manager. It provides
information about vehicles which are not driving on the project links, but still contribute to the
project emissions. For each source type in the RunSpec, 'vehicle population' is the average
number of "off network" vehicles during the hour being modeled. The 'start fraction' field is a
number from 0 to 1.0 which specifies the fraction of this population which has a 'start' operation
in the given hour. The 'extendedldle fraction' field is a number from 0 to 1.0 which specifies
the fraction of the population which has had an 'extended idle' operation in the given hour.
Finally, the 'parked vehicle fraction' field is a number from 0 to 1.0 which specifies the fraction
of the 'vehicle population' which have been parked in the given hour.
Page 70 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
For example, a vehicle population of 10 long-haul combination trucks with a start
fraction of 0.5, an extended idle fraction of 0.25 and a parked vehicle fraction of 0.5 implies that
the project includes the emissions associated with 5 starts, 150 minutes of extended idling (10
vehicles * 60 minutes *0.25) and 300 minutes of parking (10 vehicles * 60 minutes * 0.5) for
this sourcetype.
^ Note MOVES2010 computes extended idle emissions only for long-haul combination trucks,
not for other sourcetypes; thus the extendedldleFraction is ignored for sourcetypeids
other than 62.
7 Note MOVES2010 does not compute evaporative emissions at the Project Domain/Scale;
thus, the "parked vehicle fraction" is ignored.
2.3.4 Action
Action provides a drop-down menu with the choices Execute, Stop, Pause, Resume, and
MOVES Run Error Log.
MOVES - C:\EpaWovesWOVESGHGSource\MOVES2009Example.mrs - ID
File Edit Pre Processing
Description
Scale
Time Spans
Action Postprocessing Jpols Settings Help
Execute
Stop
Pause
Resume
MOVES Run Error Log-
After satisfying the RunSpec input requirements (all check marks in the Navigation Panel
must be set to green checks or yellow tildes - see 2.2 Navigation Panel for an explanation of
these marks), choose Execute to begin the MOVES simulation. Choose Stop or Pause in the
Action menu to stop or pause the execution of the MOVES program. These two items will only
be active if the MOVES program is running. The user may also resume a paused MOVES
simulation by clicking the Resume item.
7 Note A program that has been stopped cannot be resumed.
7 Note Note that, depending where the MOVES program is in its processing, the Stop
command may not end a MOVES run immediately. If necessary, MOVES can be
terminated by clicking the X in the upper right hand corner of the MOVES GUI or the
MOVES command line window.
Click MOVES Run Error Log to display information on the processing outcome of the
execution in the MOVES Run Error Log window. Alternatively, the log can be displayed by
selecting the ALT and R keys when the Action menu option is open.
United States Environmental Protection Agency
Page 11
-------
January 2010
MOVES2010 User Guide
? Note The MOVES Run Error Log option is available only if a MOVES Output database
has been created.
Typically, the user should select MOVES Run Error Log immediately after the
MOVES program has completed its execution. The window (shown below) will contain either a
message stating that the run was successful and that no errors occurred, or it will report a brief
error message. The example shows a successful run, indicating the run number (Run 5) and the
time and date of the run. The user can also view the Run Error Log for the error status of
previous runs by clicking the down arrow on the right side of the "Select Run" button.
7 Note Not all error log messages indicate invalid results. For example, "Warning: RunSpec
doesn't have all the RoadTypes", indicates a problem with the RunSpec only if the user
had intended to include all roadtypes.
MOVES Run Error Log
Select Run:
Run: 5-2004-07-19 11:06:11 ^
OK
No MOVESError log entries for RunID = 5
2.3.5 Post Processing
MOVES output databases can be viewed and processed directly using MYSQL Query
Browser or other database tools. In addition, MOVES provides a few simple options to post-
process and view the MOVES results. Post Processing contains three menu options, Run
MySQL Script on Output Database, Produce Summary Report, and Produce State/County
Map. These features can be used after a successful execution of a MOVES RunSpec to further
process the MOVES results into more aggregate or easy-to-use formats.
O MOVES - C:\Epa\MovesWOVESGHGSouice\MOVES2009Example.mrs - ID 45i
File Edit Pre Processing Action
Postprocessing lools Settings Help
Run MySQL Script on Output Database
Produce Summary Report
Produce State/County Map
2.3.5.1 Run MySQL Script on Output Database
Page 72
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
The Run MySQL Script on Output Database menu option enables the user to select
from a set of MySQL scripts to further process the MOVES output databases stored in the
MySQL database format. After selecting this menu option, the user clicks on the arrow in the
scroll down box to view all the available scripts. The user selects a post-processing script by
clicking to highlight it. To execute the script, the user clicks the "OK" button.
Several scripts are distributed with MOVES2010. The first script,
MOVESOutputDecodeExample.sql" is an example script that decodes the SourceUseType and
FuelType fields from numerical code classification to the full text description. The script
produces two new output tables with the expanded text descriptions:
decodedmovesactivityoutput and decodedmovesoutput.
The second script "TabbedOutputsql" takes three MOVES MySQL output tables
(MOVESOutput, MOVESActivityOutput and MOVESRun) and converts them into tab-
delimited text files that can be read by a spreadsheet program such as Excel or Lotusl23. This is
useful if the user does not want to work with the results in the MySQL relational database
format. In MOVES2010, this can also be done with the Summary Reporting feature. Both
scripts work with Inventory output, not Emission Rate output.
The Run MySQL Script on Output Database Post Processing feature of MOVES also
allows the user to run user-created MySQL scripts. Each user-created post-processing
script must be a text file containing Structured Query Language (SQL) commands, and
containing a .sql file extension. Detailed instructions on writing a MySQL script are
beyond the scope of this document. To access a user-created script from the tool bar, the
completed script must be saved to the OutputProcessingScripts subfolder of the Database
subfolder of the MOVES program folder. In other words, the path should be similar to the
following: C:\.. .\MOVES\Database\OutputProcessingScripts.
2.3.5.2 Produce Summary Report
The Produce Summary Report menu option allows the user to summarize and report
the output of one or more MOVES runs in a variety of ways. Reports can be viewed on the
screen, printed, or saved in an ASCII text form that is easily imported into other software formats
such as Microsoft Excel. The Summary Reporter makes it easy to display and print summary
reports of MOVES Output information and convert them to ASCII text files. For the Summary
Reporter to operate properly, the run specification which produced the output, or one sufficiently
similar to it, needs to be loaded in MOVES.
When Produce Summary Report is selected and suitable run specification has been
loaded, a popup appears asking the user to specify an emission process to be reported. The
default option (which is the only option if the run did not distinguish results by emission process)
is to combine the output results for all emission processes included in the run specification. But
in many cases the user will want to select an emission process from the drop down list.
United States Environmental Protection Agency Page 73
-------
January 2010
MOVES2010 User Guide
Emission Process Selection
Select Emission Process to Report
All Processes
All Processes
Extended Idle Exhaust
Running Exhaust
County do Start Exhaust
tie
Clicking "OK" allows the user to specify the content and level of report aggregation.
fi Specify Parameters for Summary Report
Specify Report for Emission Process: Total of *jj
teport Title: Summary Report
Report File N.iine: GiumrnatyRepoit
Pun Number(s)
Run: 22 Time: 2009-10-22 15:03:40.0 MOVES2009Example
Run: 23 Time: 2009-10-22 15:12:59.0 MOVES2009Example
Run: 24 Time: 2009 10 22 15:40:41.0 MOVES2009Example
Run: 25 Time: 2009-10-26 09:22:51.0 MOVES2009Example
Run: 26 Time: 2009-10-27 13:57:12.0 MOVES2009Example
Run: 27 Time: 2009-10-29 08:08:33.0 MOVES2009Example
Run: 28 Time: 2009-10-29 10:11:09.0 MOVES2009Example
Run: 29 Time: 2009 10 29 10:13:13.0 MOVES2009Example
Run: 30 Time: 2009-10-30 15:04:40.0 MOVES2009Example
Run: 31 Time: 2009-11-02 13:58:52.0 MOVES2009Example
Run: 32 Time: 2009-11-02 15:02:37.0 MOVES2009Example
Run: 33 Time: 2009-11 02 15:03:52.0 MOVES2009Example
Order/Choose Categories
yearlD
sourceTypelD
fuelTypelD
MOVESRllllID
Data Items
Distance
Methane (CH4)
Nitrous Oxide (N20)
Total Energy Consumption
Move To Top of List
LI Display on Screen D Produce tabbed output
Estimate Report Width
Not Calculated
OK Cancel
This screen allows the user to:
1. Give the report a title. The default title is "Summary Report" but the user may change
this in the text field.
1. Specify the base portion of the file names which will be used to store various portions of
the report. The default file name root is "SummaryReport" but the user should change
this in the text field.
XCaution! Files which already have this base file name will be overwritten without warning if
reports are generated with the same base file name.
3. Select one or more runs to be reported. Their output must have been stored in the same
output database named in the active run specification. The twelve most recent runs are
available for selection. In the example shown, two runs have been selected. Note that
these two runs were made with the same run specification.
XCaution! Care should be taken to compare runs with the same scope and level of output
detail.
Page 74
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
4. Choose the categories to be distinguished in the report. At least one category must be
selected. The category list is based on the run specification. The fewer categories
selected, the more aggregate the report will be. Dimensions not distinguished when the
run was made are not included. The "Move to Top of List" button may be used to
reorder the category list. The order of the list determines the sort order and the column
order used in the report. In this example, several categories, including "MOVESRunID"
have been selected.
If multiple runs are included in the report, the user may wish to select the
"MOVESRunID" category. Otherwise, the results of the multiple runs will be combined
in the report. Conversely, if only a single run is included in the report, there is little reason
to select the "MOVESRunID" category.
5. Select the data items to be included in the report. At least one data item besides
"Distance" must be selected.
6. Select the forms of output desired. The report always produces a set of three MySQL
tables placed in the output database. There is no selection governing this. If a screen
display of the report is desired, the user checks the "Display on Screen" box. If ASCII
tab-separated variable file output is desired, the user checks the "Produce Tabbed
Output" box. Note that choosing the Display on Screen option may cause MOVES to
fail, if the selection criteria yields an extremely large set of data.
Because the width of a report can be a constraining factor (for example, when printing the
report) the "Estimate Report Width" button can be used to estimate of the width of a report
with the currently selected items. Printed report output is obtained by producing a screen report
and then choosing to print.
In the example shown above, all report options have been selected. When "OK" is
clicked, the screen report, if requested, appears:
United States Environmental Protection Agency Page 75
-------
January 2010
MOVES2010 User Guide
^? Screen Report
tJ
| Header | Body ( Decode ^^^^^^^^H
Year County Source
2010 34021 11
2010 34021 11
2010 34021 21
2010 34021 21
2010 34021 31
2010 34021 31
2010 34021 32
2010 34021 32
Print and Close Report
Run
222
229
222
229
222
229
222
229
TotalHC
10656
10656
564766
564766
217737
217787
66898
66898
Close Report
7 Note The Screen Report shown here is not consistent with the "Specify Parameters" panel
shown above, but it does illustrate the type of results a user can expect to see.
Note that the report consists of three tabs: Header, Body, and Decode. The Body tab is
the default view; the other tabs are accessed by clicking on them. The body of the report
contains columns for each of the category and data items selected. Clicking on the Header tab
displays the report title, date and time the report was made, several items of information about
the run specification, and the emission process covered by the report. Clicking on the Decode
tab displays the decoded numeric codes included in the report.
Report
I Header | Body f Decode
Category Field Value
countylD 34021
sourceTypelD 11
sourceTypelD 21
sourceTypelD 31
sourceTypelD 32
Description
Mercer County
Motorcycle
Passenger Car
Passenger Truck
Light Commercial Truck
Print and Close Report
Close Report
When the user is done viewing the screen report, the user may click on "Print and Close
Report" to print. Printing is in landscape format. Clicking on "Close Report" closes the report
without printing it.
XCaution! Both buttons close the report. The Summary Reporter does not store reporting
options, other than the last report title and base file name used. Because
information is not remembered between Summary Reporter runs, the user should
not close the report until the user is done viewing it.
Page 76
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Once any screen report has been closed, and if ASCII tab-separated reporting has been
selected, the user is prompted for a file directory in which to place the report output, and these
files are written.
2.3.5.3 Produce State/County Map
The Produce State/County Map menu option allows the user to see the RunSpec output
depicted in color-coded or gray-scaled maps. The maps can illustrate output at the county level,
and represent value ranges of a single numerical variable which can be selected from a list by the
user. It should be noted that this is a very basic mapping tool with very specific input
requirements. For more sophisticated mapping options, you may want to apply GIS tools or
other software to the MOVES database output.
For the Produce State/County Map tool to operate properly, the run specification which
produced the output, or one that points to the same output file, needs to be loaded in MOVES.
When the user chooses the Produce State/County Map menu option, the Generate
State/County Map window opens and displays the name of the source database for the map
generation at the top of the window. (The source database for the map generation is the database
containing the output of the RunSpec.)
atabase: test2008
able:
State or County FIPS Column
To view RunSpec output on a map, the user must first choose a table contained in the
output database that has "CountylD" or "StatelD" as a column and associates each emission
quantity with each county or state selected only once; in other words, if there are multiple entries
for the same pollutant in the same county, then the Produce State/County Map tool cannot be
used. For example, if all 24 hours were modeled and the level of output detail was chosen to be
"Hour", then there are at least 24 values for each pollutant in each county and the
"MovesOutput" table cannot be used. It is possible for the "MovesOutput" table to be used if
the user has appropriately defined or aggregated their RunSpec; however, it is more likely that
the user will have to use the Summary Reporter to generate a table that fits the necessary
criteria and save it into the output database indicated by the currently loaded RunSpec.
Once a table with the attributes described above is created, it can be selected in the
"Table" drop-down menu. The State or County FIPS Column box will be automatically
populated with "CountylD" or "StatelD", instructing the mapping tool to consider output data at
the county or state level. Next, the user should specify data to depict by selecting an output
parameter in the Data Column dropdown menu. By choosing a column from the selected table,
United States Environmental Protection Agency
Page 77
-------
January 2010
MOVES2010 User Guide
the user instructs the mapping tool to use results from the RunSpec to generate the map output.
After making selections in this window, the user should click "Next".
A window allowing the user to define map attributes opens. The user can choose "Full
Color" or "Grayscale" using the Colors drop-down box, and can customize the map using the
check boxes and defining minimum and maximum data values for the emissions output data.
When the user clicks "Next", the map output is generated.
iei ate State/County Map
Colors:
Full Color
0 Show FIPS codes [->
@ Show legend colors
[•j Show legend text
Number of colors: 16
Minimum Data Value: 1
Maximum Data Value: 1 0
2.3.6 Tools
Tools provides a drop-down menu with the choice Multiple RunSpec Creator.
MOVES - C:\Epa\Move5\MOVESGHGSource\MOVES2009Example.mrs - ID 456579!
File Edit Pre Processing Action Post Processing
Description
lools Settings Help
Multiple RunSpec Creator
This menu item contains a list of MOVES tools. In MOVES2010, the only tool on the
list is the Multiple RunSpec Creator, which creates a set of new MOVES runspec files using
the currently loaded runspec and a user-supplied control file as a template.
2.3.6.1 Multiple RunSpec Creator
The Multiple RunSpec Creator creates a set of new MOVES RunSpec files using the
currently loaded RunSpec information, and additional information in the form of a user-supplied
control file. The control file is a list of county, year and database data selections in the form of a
Microsoft Excel spreadsheet file (.xls). The tool produces a set of MOVES RunSpecs and a
batch (.BAT file) file that can execute the MOVES RunSpecs from the DOS command line
(MOVES batch files cannot be executed from inside the MOVES GUI).
Before using the Multiple RunSpec Creator, the user should load or create a viable (all
green check marks) Runspec (the tool will accept an incomplete RunSpec, but will subsequently
Page 78
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
generate a set of incomplete RunSpecs which require further manual editing). The Multiple
RunSpec Creator also requires the selection of at least one county and one year in the RunSpec.
If the menu item Multiple RunSpec Creator is selected, the "Multiple RunSpec
Creator" panel opens. The top of the panel contains some reminders about the purpose of the
tool and mentions the output .BAT file. Error messages and other feedback to the user are
provided in the messages area at the bottom of the window.
H Multiple RunSpec Creator
This tool creates new RunSpec files using the currently loaded information as a
template, making substitions for county, year, and database selections driven by a
user-supplied control file. In addition, a BAT file is generated that illustrates how to
automatically execute each created RunSpec from the command line.
Use the "Create Template..." button to get started with a a control file that uses all the
counties and years in the current RunSpec.
The final BAT file, located in your output directory, can be run as is, or can be edited
manually for distribution onto multiple MOVES master machines.
RunSpec Template Control File:
Create Template.,
Browse...
Me Name Prefix:
RunSpec Output Directory:
Messages:
Browse...
Warning: The RunSpec is incomplete and may produce other incomplete RunSpec..,
Create RunSpecs
Done
Once the panel is opened, use the "Create Template..." button to get started with a
Control File that uses all the counties and years in the current RunSpec. The Create Template
feature will fill the Control Filecf with the information available in the RunSpec. However, the
user may edit the Control Filecf and add additional rows and columns of information. The user
may add additional counties, years and database names. For each row in the Control Filecf
MOVES will create a new Runspec.
The figure below shows a template Control File (an .XLS in this case) that will create
RunSpecs for a list of counties, each with a different output database:
United States Environmental Protection Agency
Page 79
-------
January 2010
MOVES2010 User Guide
____________. J3 Lj
CountylD County Description Year
26161 MICHIGAN - Washtenaw County
26163 MICHIGAN - Wayne County
26161 MICHIGAN - Washtenaw County
26163 MICHIGAN - Wayne County
26161 MICHIGAN - Washtenaw County
26163 MICHIGAN - Wayne County
^J D | E I F
Additional Test Name Primary MOVES DB Output DB
2009 Washtenaw MOVESDB20090112 WashtenawOutput
2009 Wayne MOVESDB20090112 WayneOutput
2010 Washtenaw MOVESDB20090112 WashtenawOutput
2010 Wayne MOVESDB20090112 WayneOutput
2011 Washtenaw MOVESDB20090112 WashtenawOutput
2011 Wayne MOVESDB20090112 WayneOutput
Domain DB Advanced Features DB User DB
If the National SCALE is selected, a set of runspecs will be generated for unique
combinations of county, year and additional text name. Information from the other
columns will be inserted into the runspecs. If the County or Project SCALE are selected, a
set of runspecs will be generated only for unique combinations of county and year. Note,
in all three cases, the user must separately create the required input databases.
The Control File fields are:
Field
CountylD
County
Description
Year
Additional
Text Name
Primary
MOVES DB
Output DB
Domain DB
Advanced
Features DB
User DB
Notes
Mandatory. The FIPS ID of the county or custom domain (generic county) in the
format 99999
Describes the county. This is not mandatory but is helpful as it gets stored within
each RunSpec. It will be the label for the generic county if the Custom Domain
option is used.
Mandatory. A year contained within the current MOVES default database,
typically 1990 and 1999-2050 inclusive.
Optional, 20 characters max. Additional text to be included in both the file name
of a RunSpec file and in the RunSpec's description (which gets stored to the output
database during simulation). Since this field is used as part of a file name, it
cannot contain operating system special characters such as & : / \ * ?
Name of the primary MOVES database to be used with the RunSpec. If blank, the
created RunSpec will use the "Custom Input Database" (as set on the Advanced
Performance Features panel) of the current RunSpec, and if that is blank the
created RunSpec will use the MOVES default database configured at the time it is
executed. This input will never change the name of the Default Database in the
MOVES Configuration File as shown in the pull down menu item "Settings -
Configure MOVES".
Name of the database to store the created RunSpec's output. If blank, the created
RunSpec will use the output database of the currently loaded RunSpec, and if that
is blank an error message will be shown and processing stopped.
When using County or Project domains, MOVES requires an input database
specific to the domain. If blank, the model will use the database named in the
RunSpec. If neither is available, an error message will be shown and processing
stopped.
If the "Copy Saved Generator Data" checkbox is marked on the Advanced
Performance Features panel, this field specifies the database where the data should
be saved.
The MOVES GUI allows users to supply their own custom data using the Manage
Input Data Sets panel. On that panel, zero or more user databases are listed. Such
databases can be specified in the Control File in the User DB column and the
columns to the right of it. For example, if two databases are desired, fill the User
DB column with the first database, and fill the next column with the second.
Page 80
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
| | MOVES places no limit on the number of such user databases. |
After successfully creating a template file, populating the file and saving it as a Control
File, the user should return to the Multiple RunSpec Creator panel and browse for and select
the Control File. The name of the Control File will be echoed in the Multiple RunSpec Creator
panel to the left of the first Browse button.
The next step is for the user to enter a file name prefix in the File Name Prefix box. This
input is a mandatory, 150 character limit, field that gives a prefix to the file name of each created
RunSpec and .BAT file. Good usage of this field, perhaps with a project number or metropolitan
area name, will help preserve the usefulness of the created RunSpecs.
After setting a prefix, use the second Browse button for an output directory to hold the
created RunSpecs and .BAT file. Remember that many files may be created, so it may be best to
create a new directory to hold the new files.
The Create RunSpecs button will check input values (control file name, file prefix, and
output directory), read the control file, report errors, and if there are no errors, create the BAT
and RunSpec files. Files are only generated if there are no errors.
As an example, using the above control file and a prefix of "Test", the files created are:
|^ Test_26161 _2009_Washtenaw. mrs
|^ Test_26161 _2010_Washtena w. mrs
fgj Test_26161 _2011 _Washtena w, mrs
|?j Test_26163_2009_Way ne. mrs
1J Test_26 i 63_2010_Way ne. mrs
•-J Test_26163_2Q 11 _Way ne. mrs
,TT] Test_ExecuteRunSpecs.bat
As can be seen, the naming convention is:
__[_].mrs
_ExecuteRunSpecs.bat
^ Note If RunSpecs are for the same county and year, it is important that the additional text be
unique, otherwise, not all listed RunSpecs will be created.
The resulting BAT file from the example file is:
@echo off
rem Script generated by the MOVES Looping Tool
rem Based on control file:
C:\EPA\MOVES\MOVESGHGSource\Task910LoopingTool\ControlFile.xls
rem Command Line Notes:
rem "-e DEBUG" logs all types of messages to MOVESbatch.log
echo Changing to the MOVES folder and compiling code...
C:
cd "C:\EPA\MOVES\MOVESGHGSource"
call setenv.bat
United States Environmental Protection Agency Page 81
-------
January 2010
MOVES2010 User Guide
call ant compile
rcrn
echo Running Test_26161_2009_Washtenaw.mrs
Java gov.epa.otaq.moves.master.commandline.MOVESCommandLine -e DEBUG -r
"C:\EPA\MOVES\MOVESGHGSource\Task910LoopingTool\Test_26161_2009_Washtenaw.mrs"
echo Running Test_26163_2009_Wayne.mrs
Java gov.epa.otaq.moves.master.commandline.MOVESCommandLine -e DEBUG -r
"C:\EPA\MOVES\MOVESGHGSource\Task910LoopingTool\Test_26163_2009_Wayne.mrs"
echo Running Test_26161_2010_Washtenaw.mrs
Java gov.epa.otaq.moves.master.commandline.MOVESCommandLine -e DEBUG -r
"C:\EPA\MOVES\MOVESGHGSource\Task910LoopingTool\Test_26161_2010_Washtenaw.mrs"
echo Running Test_26163_2010_Wayne.mrs
Java gov.epa.otaq.moves.master.commandline.MOVESCommandLine -e DEBUG -r
"C:\EPA\MOVES\MOVESGHGSource\Task910LoopingTool\Test_26163_2010_Wayne.mrs"
echo Running Test_26161_201 l_Washtenaw.mrs
Java gov.epa.otaq.moves.master.commandline.MOVESCommandLine -e DEBUG -r
"C: \EPA\MOVES\MOVESGHGSource\Task91 OLoopingTool\Test_26161 _201 l_Washtenaw.mrs"
echo Running Test_26163_2011_Wayne.mrs
Java gov.epa.otaq.moves.master.commandline.MOVESCommandLine -e DEBUG -r
"C:\EPA\MOVES\MOVESGHGSource\Task910LoopingTool\Test_26163_2011_Wayne.mrs"
This .BAT file can be run as is (via the command line or by double-clicking), or can be
edited manually for distribution onto multiple MOVES master machines.
2.3.7 Settings
The Settings menu includes one option, Configure MOVES. This menu option allows
the user to set the basic MOVES operating configuration.
MOVES - C:\EpaWoves\MOVESGHGSource\HOVES2009Examplfi.mrs - ID 45657980!
File Edit Pre Processing Action Post Processing Tools
Description
Settings Help
n- Configure MOVES.,
2.3.7.1 Configure MOVES
Configure MOVES
Default Input Database
Server: localhost
Database: MOVESDB20091216
Default Output Database
Server: localhost
Shared Distributed Folder Path
|C:\EpaWQvesWIOVESGHGSource\SriaredWork
Browse...
First, the user can specify the default input database by identifying the default server on
which the MOVES input database is stored and the name of the default database. In most cases,
Page 82
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
"localhost" is the desired server, although the user may input an alternate. Next the user can
choose from a drop-down list to define the default database to be used as a data source for the
MOVES RunSpec. In most cases, the user will choose the default database distributed with
MOVES2010. The user also can select a server to house the default output database server under
the Settings-^Configure menu option; "localhost" is appropriate in most cases. The actual
output database file is named on the General Output panel to specify output parameters as part
of the MOVES RunSpec setup process.
XCaution! If the Default Input Database is changed the program should be stopped and
restarted. This is because the user interface program will have already connected to
the previously specified database in order to construct the GUI displays; thus the
GUI may not match the new input database.
Using the Settings menu option, the user also can identify the Shared Distributed
Folder Path for the MOVES Worker and MOVES Master program modules. This is the
Windows folder where all intermediate and internal MOVES work files are stored during
processing. This folder is installed as part of the MOVES program installation. The user should
browse his system to find where this folder was installed and indicate the exact location. It may
not be the same path as shown in the example above.
By changing the Shared Distributed Folder Path, the user can take advantage of
distributed processing by having the master and multiple worker computers on the same
network "point" to a drive and folder that is accessible to all the computers involved.
2.3.8 Help
Help provides access to .pdf versions of the MOVES User Guide and supplies general
information about the version of MOVES being used.
File Edit Pre Processing Action Post Processing Tools Settings
Choose MOVES User Guide to open the document in .pdf format.
Choose About MOVES in the Help menu to obtain the release date of the model. This
indicates which version of MOVES is open. In addition to the version, the EPA copyright and
GNU General Public License (GPL) information is provided. The GNU license grants the user,
free of charge, complete access to the object and source code of the MOVES program for
personal use. For specific details regarding the GNU license, the user should consult the website
http:/www.gnu.org.licenses/.
United States Environmental Protection Agency
Page 83
-------
January 2010
MOVES2010 User Guide
MOVES
This version: 2009/12/14
Computer ID: DC2756E
Copyright U.S. Environmental Protection Agency
Licensed for use pursuant to the GNU General Public License (GPL)
For information about the GPL see http: www.yiui.oi
-------
DRAFT MOVES 2009 User Guide January 2010
Appendix A - Using MOVES to Generate Lookup Tables
MOVES can calculate emission inventories (in total quantity of emissions for a given
time) or emission rates (emissions divided by distance or population), depending on the user
selection of "Inventory" or "Emission Rates" in the "Calculation Type" section of the "Scale"
panel.
When modeling a single time and place, the emission rate calculations in MOVES are
significantly more time consuming and require more computer memory than inventory
calculations. However, for large scale projects, a user may want to use the emission rate
calculations to create a lookup table of rates that—though a post-processor-can be applied to
many times and places, thereby reducing total MOVES run time. Successful application of this
approach requires a clear understanding of the rates calculations in MOVES and careful
planning. EPA is developing tools to automate the use of this feature to create inputs for EPA's
Sparse Matrix Operator Kernel Emissions (SMOKE) model. This section describes the process
more generally.
Defining a Scenario
A scenario defines the set of conditions to which the emission rates may be applied. A
scenario typically defines a specific fuel mix and set of Inspection/Maintenance (I/M) programs.
It also assumes a certain pattern of trip activity (number of trips per vehicle per day and the
distribution of those trips in time).
Some characteristics of the scenario depend on user choices: If a given age distribution is
part of the scenario definition, that is, if the lookup table is to be applied only to areas with one
particular age distribution, the lookup output can be smaller because the user does not need
output by model year. On the other hand, detailing output by model year allows users to apply
the lookup table to areas with diverse age distributions.
A scenario generally does not imply specific temperatures or speed distributions. Instead,
these characteristics are key fields in the output used to match the emission rate with the
appropriate vehicle activity.
The Emission Rate Output Tables
Selecting "Emission Rates" on the Scale panel populates three additional output tables:
RatePerDistance, RatePerVehicle and RatePerProfile. The RatePerDistance table stores
emission rates for emissions that occur while a vehicle is in regular operation. The
RatePerVehicle and RatePerProfile tables store emissions that occur while a vehicle is stationary,
on "off network" roadtypes. The latter two tables differ because the emissions in the
RatePerVehicle depend on the hour and the temperature while emissions in the RatePerProfile
table also depend on temperatures in previous hours.
1) RatePerDistance: Includes emissions for the processes that occur while vehicles are
operating: running exhaust (includes emissions during normal idle at traffic signals, etc), tire
wear, brake wear, evaporative permeation, evaporative fuel vapor venting, evaporative fuel
United States Environmental Protection Agency Page A-l
-------
leaks, crankcase running exhaust, refueling displacement and refueling spillage. The hour, day
and month will not be relevant for most uses because the emissions are normalized with regard to
activity. For national and county level runs, roadtype and avgspeedbin will be relevant. For
project-level runs, linkID will be important.
Fields:
MOVESScenarioID
MOVESRunID
yearlD
monthID
daylD
hourlD
linkID
pollutantID
processID
sourceTypelD
fueltype ID
model year ID
roadtype ID
avgSpeedBinID
temperature
relhumidity
RatePerDi stance
2)RatePerVehicle: Includes emissions for most processes that occur while vehicles are
stationary : start exhaust, start crankcase, permeation, liquid leaks, and extended idle (long haul
combination trucks only). The month will not be relevant for most uses since, in rate
calculations, it serves primarily as an identifier for the fuel mix and will be redundant with
MOVESScenarioID, but daytypeid and hourid are important key fields since start and other
activity vary per vehicle per hour.
Fields:
MOVESScenarioID
MOVESRunID
yearlD
monthID
daylD
hourlD
zonelD
pollutantID
processID
sourceTypelD
fueltype ID
model year ID
temperature
RatePerVehicle
Page A-2 United States Environmental Protection Agency
-------
DRAFT MOVES 2009 User Guide January 2010
3) RatePerProfile: Includes emissions from the vapor venting process when vehicles are
stationary. The daytypeid, hourid and temperatureprofileid are important key fields because the
vapor venting emissions vary depending on activity and previous temperatures.
Fields:
MOVES Scenario ID
MOVESRunID
TemperatureProfilelD
yearlD
monthID
daylD
hourlD
pollutantID
processID
sourceTypelD
fueltypelD
modelyearlD
temperature
RatePerVehicle
Setting Up Runs to Generate a Lookup Table
Setting up an emission rate lookup table for a single scenario requires a number of steps.
1) Define the scenario, and determine the counties, months, years and day-types in which it
applies. Using the County Data Manager, a user can set up a run for the desired county, year,
fuel supply, age distribution and I/M program.
2) Determine the temperatures and temperature profiles to be covered by the lookup table. A
"temperature profile" is a set of 24 temperatures over the course of a day. If the user is
modeling NOx, it may also make sense to include relative humidity as a variable.
United States Environmental Protection Agency Page A-3
-------
Example Temperature Profiles
10 15
Hour of Day
20
3) Determine which pollutants and processes are of interest. Note that the modeling of
hydrocarbons is more complicated than the modeling of other pollutants due to the need to
include evaporative processes, and thus the need to represent temperature profiles as well as
hourly temperatures.
4) Organize inputs to generate the most rates in the shortest total runtime, while maintaining a
manageable output size. If multiple similar calculations are required, it is generally a good idea
to combine them in the same run. However, due to the different requirements for different
emission processes, redundant calculations can often be avoided by splitting the task into
multiple runs.
For running exhaust, crankcase running exhaust, and refueling, hour doesn't matter, so 24
temperatures can be modeled as different hours in a single month If more than 24
distinct temperatures are to be modeled, additional temperatures can be modeled using
additional months (as long as the fuel characteristics are set to be the same for each
month). If this approach is used, the month field in the output essentially becomes a label
for a group of temperatures, and does not represent an actual calendar month.
For start, crankcase start exhaust, liquid leaks and evap permeation, hour and temperature
matter. Sets of temperatures can be entered as individual "months" Again, this creates
output where "month" represents a group of temperatures rather than a calendar month.
In the illustration above, the three temperature profiles could be modeled in a single run
as three nominal months, one for each profile. Note, however, that Profile 3 shares an
hour/temperature point with the each of the other profiles (in hour 8 and hour 15). For a
lookup table with greater scope, it could be efficient to design the runs to eliminate such
redundancy.
Page A-4
United States Environmental Protection Agency
-------
DRAFT MOVES 2009 User Guide January 2010
Vapor venting emissions depend on hour, temperature and previous temperatures. For
these emissions we must model each profile as a separate month. Thus, within a given
MOVES Scenario, monthid becomes equivalent to temperatureprofileid. In some cases, it
may be appropriate to "bin" similar temperature profiles and to apply the results from one
profile to a group of similar profiles.
Temperatures (and humidities) can be entered into the MOVES ZoneMonthHour table, using
MYSQL commands or through the County Data Manager. See User Guide section 2.3.3.4.1
Meteorology Data Importer for more information on entering this data.
If "Emission Rates" are chosen on the Scale panel, output should be differentiated by
"Source Use Type". Doing so allows VMT, Road Type Distribution, and Average Speed
Distribution to become placeholders (i.e., they must still be imported, but their values do
not impact the results); however, if output is not differentiated by source type, the emission
rate becomes a weighted average of the source types selected in the RunSpec and the three
inputs mentioned will impact the results.
Running MOVES to generate Lookup Tables
MOVES can generate lookup table output using the menu-driven interface, but for large-
scale modeling, users will probably want to automate execution of a series of runs. See
Appendix C for information on running MOVES from the command line. See Section
2.3.6.1 Multiple Run Spec Creator for information on a tool for creating a set of similar
run specifications.
Applying MOVES Emission Rate Output
To calculate an emissions inventory from emission rate output, rates in RatePerDistance
values need to be multiplied by the appropriate Vehicle Miles Travelled (VMT), and rates in
RatePerVehicle and RatePerProfile must be multiplied by appropriate vehicle population values.
Doing this correctly can require a number of considerations.
• Rather than simply summing all activity in a speed or temperature bin, it is usually
appropriate to do an interpolation as the rates are applied. For example, to calculate the
total emissions from 100 miles of VMT with an average speed of 17.6 mph, a simplistic
approach would be to multiply all of the VMT by the emission rate for speed bin 5 (17.5
mph-22.5 mph), however this approach is overly sensitive to even very small changes in
speed. To reduce these boundary issues, users should instead interpolate between speed
United States Environmental Protection Agency Page A-5
-------
bins (in this example, between the rates for speed bin 4 (12.5-17.5) and speed bin 5)
based on the average speeds for those speed bins. .
• Depending on how the runs were organized, the user should take care not to double-count
emissions with duplicate emission rates (for example, if the three profiles illustrated
above were each modeled as independent months, there would be duplicate values in the
ratepervehicle table for Sam at 34F, and for 3pm at 87F). A simple join of the rates and
population table using hour and temperature would create extra rows that the user would
need to be careful not to include in a sum.
• The user should be aware that evaporative emissions are stored in all three tables, and all
three need to be used to fully account for evaporative emissions that occur during both
driving and parking. The rates in RatePerDistance need to multiplied by the appropriate
VMT, and the rates in RatePerVehicle and RatePerProfile need to be multiplied by the
appropriate population. They can then be summed to calculate the total emissions.
Page A-6 United States Environmental Protection Agency
-------
DRAFT MOVES 2009 User Guide January 2010
[This page intentionally left blank.]
United States Environmental Protection Agency Page A-7
-------
-------
MOVES2010 User Guide
January 2010
Appendix B - Linking MySQL Tables from MS ACCESS or MS Excel
(includes ODBC usage)
This appendix describes in detail how the user can transform MOVES MySQL tables into
Microsoft ACCESS database tables or Microsoft Excel spreadsheets. This may be useful for
those who wish to view or manipulate these tables in an alternate format. This appendix also
explains how to use the Open Database Connectivity interface protocols and tools.
.Adding a MySQL database as an ODBC User Data Source
1. Install MySQL driver, MyODBC-3.51.06.exe. This is part of the normal MOVES
installation process and can be done by executing the MOVES2010 Installation Suite
MOVES2010 Installation Suite Release date: January 1,201C
To install MOVES, review the System Information (the left-most tab), then work through the tabs in order from left to right.
System
nformation
Inct^ll M
1 . View ste
2. Click 'Ins
Install Java
1.6.0J2
^SQLODBC
3-by-step instal
tall1 button to ins
Remove
Existing
MySQL 5.0
instructions.
Setup MySQL
E.1.32
tall MySQL ODBC driver.
Install MOVES
Application
View
install
Install Query
Browser
Install
MySQL
ODBC 3.51
Help /Contact
Info
- Installing MySQL Open DataBase Connectivity (ODBC) interface/driver is optional.
- MySQL ODBC is an interface that allows Microsoft products, e.g.. Access, Excel, etc., to access MySQL
data/databases.
- In general there's no need to remove this ODBC driver from you machine after being installed successfully.
-For programmers and application developers: There is no 64-bit OLEDB Provider for ODBC (MSDASQL) in any
Si-bit Windows operating system up to and including Windows Vista. This means that you can't use the MySQL
ODBC driver from ADO and other users of OLEDB.
Exit Installation Suite
2. Create an ODBC data source with the same name as the folder which corresponds to the
MySQL database.
a. In the Control Panel, select "Administrative Tools":
United States Environmental Protection Agency
Page B-l
-------
January 2010
MOVES2010 User Guide
C3 Control Panel
File Edit View Favorites Tools Help
• Back
& Search ^Folders
Address II-a I Control Panel
Name
| Comment
I fej Accessibility Options
5 Add/Remove Hardware
7] Add/Remove Programs
) Automatic Updates
|BDE Administrator
|!|) Date/Time
^ Display
I Find Fast
f Folder Options
lil Fonts
t^iGaming Options
^Internet Options
Customizes accessibility Features for your computer
Installs, removes, and troubleshoots hardware
Installs and removes programs and Windows components
Configures administrative settings for your computer
Configures Automatic Updates
Configures the Borland Database Engine
Sets the date, time, and time zone for your computer
Customizes your deskJtop display and screen saver
Microsoft Find Fast (tm) content indexer
Customizes the display of files and folders, changes file a...
Displays and manages fonts on your computer
Adds, removes, or changes settings for game controllers
Configure your Internet display and connection settings,
iConfigures administrative settings for your computer
Page B-2
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
b. In the "Administrative Tools" menu, select "Data Sources (ODBC)":
ffij Administrative Tools
File Edit View Favorites Tools Help <£ %
4=" Back - •+ T f^j
>ig| Search Lj^j Folders g§
Ei «B X «o
Address jhial Administrative Tools
Name
I Size | Type / |
§ Component Services 1 KB
Computer Management 2 KB
£3 Event Viewer 2 KB
feP Local Security Policy 2 KB
[^Performance 2 KB
^3 Services 2 KB
fflZI Telnet Server Administration 2 KB
Shortcut
Shortcut
Shortcut
Shortcut
Shortcut
Shortcut
Shortcut
Shortcut
H'
•'I (^Go Links >3>
Modified
2/10/2004 11:13 AM
5/23/2003 1O:28 AM
11/19/2003 12:55 PM
5/8/2002 9:06 AM
5/8/2002 1:37PM
6/16/2003 12:48 PM
3/6/2003 10:55 AM
1/20/2004 12:21 PM
J
, removeSj and configures Open Database Connectivit jl.52 KB tg=^ ^v Computer
c. In the ODBC Data Source Administrator dialog choose to "Add" a "User Data
Source."
User DSN | System DSN | File DSN ] Drivers | Tracing | Connection Pooling j About
User Data Sources:
I Driver
N ame
1 Add...
novesdb MySQL ODBC 3.51 Driver
MySQL ODBC 3.51 Driver
remove
mvodbc3-test M^SQL ODBC 3.51 Driver
Configure... |
An ODBC User data source stores information about how to connect to
the indicated data provider. A User data source is only visible to you,
and can only be used on the current machine.
OK
Cancel
Apply
Help
United States Environmental Protection Agency
Page B-3
-------
January 2010
MOVES2010 User Guide
d. The "New Data Source" should use the MySQL ODBC Driver that was installed
earlier. Scroll through the list until the MySQL ODBC driver is found, highlight it,
and click the "Finish" button.
Create New Data Source
Select a driver for which you want to set up a data source.
Name
Microsoft Paradox Driver (K.db )
Microsoft Paradox-Treiber (*.db)
Microsoft Text Driver (x.txt; *.csv)
Microsoft Text-Treiber (x.txt; x.csv)
Microsoft Visual FoxPro Driver
Microsoft Visual FoxPro-Treiber
MuSQL ODBC 3.51 Driver
Oracle ODBC Driver
SQL Server
< Back
Finish
4.
4.
4.
4.
6.
6.
3.
S.
3.
Cancel
e. Next, the database links need to be defined. The values shown below are for a
database called "movesdefault". The database name should be the name of the folder
which contains the desired MySQL database files (i.e., the MySQL database name).
Connector/ODBC 3.51 .25 - Add Data Source Name
Connector/ODBC
Login | Connect Options Advanced
Data Source Name I movesdefault
Description Current database
User
Password
Database
movesdefault
Jest j| [Diagnostics »j
Connector/ODBC Configuration
This dialog is used to add a Data Source Name
(DSN).
Ok ] [ Cancel ] [ Help
Page B-4
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
f. Once the database name and the data source name list an existing MySQL database
name, the database connection can be checked by clicking on the "Test Data Source"
button.
Connector/ODBC
Success; connection was made!
g-
The added data source will show up in the list of data sources in the ODBC Data
Source Administrator dialog. This will finish the process of creating a new ODBC
data source associated with a particular MySQL database.
0 ODBC Data Source Administrator
User DSN System DSN j
LJser Data Sources:
Name
1990NOX MOVES Out
dBASE Files
EmRatesByAge
Excel Files
MOVESDB20Q9112
iiiBSjipiPni
MS Access Database
^SJU An ODBC Use
(j^ptl the indicated c
^^ and can only b
File DSN I Drivers Tracing Connection Pooling
Driver j i-
MySQL ODBC 3.51 Driver ,
M icrosof t dB ase D river (*. dbf ) fj
MyblJL UDBL j.bl Driver
M icrosof t E xcel D river (*. xls) Cor
HuTH nnnr^Pi rv^.^r
^H J '• ' 1
About
yd...
emove
ifigure...
MyjLiL uubL J.DI Driver
MySQL ODBC 3.51 Driver
Microsoft Access Driver f.mdb)
data source stores information about how to connect to
ata provider. A User data source is only visible to you,
e used on the current machine.
OK Cancel
Help
United States Environmental Protection Agency
Page B-5
-------
January 2010
MOVES2010 User Guide
Using Microsoft Access with MySQL Tables
1. Run an Access .mdb (either a new one or an existing one).
2. On the top menu bar, look for menu items "File", "Get External Data", then "Link
Tables ..." (see picture below). Click on the item "Link Tables..."
3. On the pop-up window like the one shown below, choose "ODBC Databases()" from the
drop-down list which is located next to the label "Files of type".
-;J
E£*k
U
„;£,„
<*,<
Page B-6
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
4. Another pop-up window similar to the one below will appear. Click on the tab Machine
Data Source, to select a database of interest.
file £t$t Vjew Insert Format Becords lools Window Heip
*£• A'i j _: -y IHJ ' -3
Select the file data source thai describes the diivet thai you wish to connect to
You can use any file data source that refers to an ODBC driver whtch is installed
on your machine.
OK ] Cancel J Heip J
Datasheet View
In this example NMIM20070812 is chosen from the Data Source Name column. Select
OK to load the data into Access.
jaj " > • > r ' ' •• f ' •
' Ble Edit ifiew Insert Farraat lods Tgble \KNfW tldp
J / •" • A -j J J n M J f 10" • • »
J4 Nurnul » Time, Uc • Rur
SitaciflrtaSouTO
FfcDataGuUrj" MaihmeDaiaCruf, .*
Ddta ource Ndnie Type Descrpiion
a2^f3fi-i pa m LJ"pr
dE^.,E File U ef
HPiJ 1
U PE data ourcp' are "ppafir fo a u ernnthr ma. hne Sj tenf data
-our e Lan be u ed by al! u »r_ on Ihi ma= hme or by a jisteni wide >cr> ILP
| 01 | Cancel Help
[jaw- , AytoJuapc, - \ \ n O ±J 4 C' Si J
United States Environmental Protection Agency
Page B-7
-------
January 2010
MOVES2010 User Guide
If the Data Source Name of the file is not listed, the user must follow the instructions
provided in the section, "How to create a DSN Connection to a MySQL database"
presented later in this appendix.
5. Once the data is loaded into access, the "Link Tables" window shown below will appear.
This screen displays all of the database tables that are visible in Access. The user may
select tables to view, and click the "OK" button.
Insert Format Tools Table Window Help
^J,^^ ^ / ^ - A, J
j II [jj| yi IT
12 - B / U
baseyeai-vmt
cntycntsncd!999
cntycntsncd20Q2
coryel_Q5_temp
coryel_06_sum
coryel_09Jemp
caryell_nat_vmt
county
countymap
countymonth
County monthhou r
countymonthhourSOOS
In the screenshot shown below, the user has chosen three tables to work with in MS
Access: baseyearvmt, county, and state. The user can now work with these tables in MS
Access.
lution! Edits to the tables or data in MS
tables and cannot be used directly in IV I
; will not affect the original MySQL
Page B-8
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
B Microsoft Access
: 0te |dft Mew Insert Tools !fflndow Help
u ji .,°z j>a^<* -^ ., •
Record: Q?]
Junk : Database (Access 2000 file format!
/gQpen "^Design JNew . X i
3 Tables
^ Queries
3 Forms
H Reports
*d Pages
.^ Macros
^ Modules
Create table in Design view
Create table by using wizard
Create table by entering data
baseyearvmt
county
Groups
United States Environmental Protection Agency
Page B-9
-------
January 2010
MOVES2010 User Guide
The user can view data specific to a particular state by clicking on the StateName in the table.
: File Edit View Insert Format
ALABAMA.
2 ALASKA
4 ARIZONA
5 ARKANSAS
6 CALIFORNIA CA
S COLORADO CO
9 CONNECTICUT CT
10 DELAWARE
!1 DISTRICT OF C DC
12 FIORIDA FL
20 KANSAS
21 KENTUCKY
22 LOUISIANA
23 MAINE
24 MARYLAND
25 MASSACHUSE MA
26 MICHIGAN Ml
27 MINNESOTA MN
28 MISSISSIPPI MS
29 MISSOURI
30 MONTANA
EPAME.nlv EPACA
24000. NLV
EPAHA rihf EPACA
How to create a DSN Connection to a MySQL database.
If the user does not find the MySql database referenced in the Data Source Name listing in MS
Access, a DSN connection must be established. In order to do so, click on the Machine Data
Source tab from the Select Data Source screen. Click the "New" button, and select "Next>".
Select a t^pe of data souice:
^ User Data Source [Applies to this machine only)
Data Bo .in;.? i",Dph?c tc -iiii machine
PageB-10
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
At the Create New Data Source Dialog box, select MySQL ODBC 3.51 Driver. Click "Next >".
Create table in Design view
^U Create table by using wizard
M rroMnlMJjBL ten UracSe
Microsoft Paradox Driver (*.db
Microsoft Paradox-Treibei |'.db 1
Microsoft Text Driver (*.tKt; *.c$v]
Microsoft Text-Treiber (".txt; *.csv]
Microsoft Visual FoxPro Driver
Mcro sofH;'ici.ia!Fo:-:PFO-Treiber
Click "Finish" to begin to establish the connection.
"vpe 5 qijes'Jon for help
When ijn.j riic; F'n::-i '.ou '...'II c'ere 'he data 5t
which you have just conligured The driven may prompt you
- ;,r --,-,1.:-' ilo, malien
United States Environmental Protection Agency
Page B-11
-------
January 2010
MOVES2010 User Guide
The Connector/ODBC screen is used to establish the connection from MS Access to the
MySQL database. Use this screen to define the "Data Source Name".
7 Note Consider making the Data Source Name similar to the database name, such as
DSN DatabaseName. This will make it easier to find.
Once the Data Source Name has been created, select the "Test" button. The popup box
Connector/ODBC should open, with the message, "Success; connection was made!" Press OK,
and the popup box will disappear. Click OK to create the DSN connection.
The Data Source Name will now be listed in the Select Data Source window.
PageB-12
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Using Microsoft Excel with MySQL Tables
7 Note MYSQL Query Browser can also be used to export MYSQL database tables to Excel.
1. Follow the instructions in the section "Adding a MySQL database as an ODBC User Data
Source" for adding the desired MySQL database as an ODBC data source.
2. Open an Excel file. Click on "Data" from the top menu bar, and choose "Import
External Data". Select "New Database Query ..." from the sub-menu window. This
will open the "Choose Data Source" window.
3. From the Choose Data Source window, select the desired DSN from the list, e.g.,
"MOVESDB", then click "OK".
Choose Data Source
Databases j Queries |
MOVESDB2004K
MOVESDefault"
MQIS(notsharable)
MQIS"
MS SQL ServerS-Approach (not sharable)
MS Sybase SQL Server-Approach (not sharable)
MSODJW
MI JIL mi irni IT*
J
d
OK
Cancel
growse...
Options...
LJse the Query Wizard to create/edit queries
4. Click the "OK" button in the "mysql Driver connect" window.
This is in public domain and com
es with NO WARRANTY of any kind
Enter a database and options for connect
MySQL host (name or IP): |
MySQL database name: JMDVESDB
User: |
Password: |
Port (if not 3306): |
J.OL command on connect: 1
-Options that affects the behaviour of MjCIDBC
l~~ Don't optimize column width
|~ Return matching rows
r Trace MyODBC
r Allow BIG results
l~ Don't prompt on connect
r Simulate ODBC 1.0
r Ignore # in «. table
l~~ Use manager cursors |exp]
l~ Don't use setlocale
r Pad CHAR to full length
l~~ Return table names in SQLDescribeCol
f Use compressed protocol
l~~ Ignore space after function names
l~~ Force use of named pipes
F Change BIGINT columns to INT
F No catalog |enp)
f" Read options from C Amy.cnf
l~" Safely (Check this if you have problems)
F Disabb transactions
r~5iTn C.ncd |
5. Follow the instructions posted by the Wizard until finished.
United States Environmental Protection Agency
Page B-13
-------
-------
MOVES2010 User Guide January 2010
Appendix C - Using the Batch Command Line Interface
The MOVES command line allows MOVES to be executed without running its graphical
user interface. It is useful in situations where repeated or unattended runs are needed, or when
another computer program executes MOVES. This interface presumes that a MOVES run
specification file has been prepared and that the user is running from the DOS prompt.
These instructions presume some familiarity with DOS commands. The DOS commands
to execute the MOVES Command Line Interface are:
Java MOVESCommandLine -r runspecfile
[OR]
Java -XmxNNNm MOVESCommandLine -r runspecfile
[OR]
Java MOVESCommandLine -rl runspeclistfile
[OR]
Java XmxNNNm MOVESCommandLine -rl runspeclistfile
where
-XmxNNNm is an optional parameter and NNN is a three digit integer number. For example,
-Xmx200m specifies you are asking Java to allocate 200 megabytes of heap memory for your
runs. This optional parameter is required only if your MOVES runs need more heap memory
than the default determined automatically by Java and your machine. The actual maximum
amount of heap memory that you can ask for depends on your machine. You can increase or
decrease the amount of heap memory as your machine allows. For example,
Java -XmxSOOm MOVESCommandLine -rl runspeclistfile
or
Java -XmxlOOm MOVESCommandLine -r runspecfile
"runspecfile" is the name of a file containing a saved MOVES run specification and
"runspeclistfile" is the name of a text file containing a list of run specification file names, with
one per line. The rest of the syntax is literal. The spelling of "MOVESCommandLine" is case
sensitive because it is a Java class name. When doing a batch run, you can identify the runspec
list text file in the command line using quotes because it is located in a folder with spaces (e.g.
"C:\My Documents". However, the command line doesn't work if you put quotes in the runspec
list file itself. The command line will think the file doesn't exist.
United States Environmental Protection Agency Page C-l
-------
January 2010 MOVES2010 User Guide
By executing one of these commands, the user runs the Java interpreter (java.exe).
MOVESCommandLine is a DOS parameter tellingjava.exe what Java class file to begin
executing, and the last two tokens are parameters passed to MOVESCommandLine.
Either version of this command can be executed from a DOS batch file, and batch files
can contain multiple commands.
Prior to executing the command, the active directory should be set to the location where
MOVES is installed, typically C:\Program FilesMVIOVES, and the SETENV.BAT file should be
executed.
It can be difficult for DOS to find everything. For the command to work, three elements
must be found:
• The Java interpreter.
• The MOVESCommandLine Java class.
• Any runspeclistfile and all runspecfiles.
Running SETENV.BAT insures that the Java interpreter is found.
Running SETENV.BAT also insures that the procedure described in the next paragraph
results in the MOVESCommandLine Java class being found. Java experts can also use the
CLASSPATH environment variable more directly to locate Java class files.
If MOVES has been installed in the default location, C:\Program
FilesMVIOVESyyyymmdd, then MOVESCommandLine.class is located at C:\Program
Files\MOVESyyyymmdd\gov\epa\otaq\moves\master\commandline. This can be made the
active directory, or the command can specify whatever part of the path is needed. For example,
if the active directory is C:\Program FilesMVIOVESyyyymmdd, the command line interface class
would be specified as "gov.epa.otaq.moves.master.commandline.MOVESCommandLine".
One way to insure that the runspecfile or the runspeclistfile is found is to specify the full
path. If a simple file name is used the file should be located in the active DOS directory.
If the GUI is used to create an importer XML file (see Section 2.3.3.3), the XML file can
be edited and executed via the command line. Remember that when using the command line,
text output is not sent to the screen but instead stored in MOVESBatch.log. An example
command line is:
Java gov.epa.otaq.moves.master.commandline.MOVESCommandLine
-i importAHFromTemplates.xml
Be sure to place all of this on one line. The "-i" option directs MOVES to the XML file
that describes the import actions to occur. Note that this XML file contains a summary of the
RunSpec within it, thus allowing wildcards even when importing via the command line. For
MOVES installations on Windows 2000 platforms, there may be a problem with the DOS
command string length not allowing more than 126 characters. To resolve this, move MOVES to
Page C-2 United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
the root of C: drive (C:\MOVES\), so that the length of the command line string will be shorter.
Note that Windows2000 is not a recommended nor supported environment in which to run
MOVES.
United States Environmental Protection Agency Page C-3
-------
-------
MOVES2010 User Guide
January 2010
Appendix D - Creating an On-Road Retrofit Input File
The "On-Road Retrofit" strategy, described in Section 2.9.9 allows the user to enter
information about diesel trucks and buses that have been retrofit with emission control
equipment. An On-Road Retrofit Parameters File must be input to the MOVES model to model
on-road vehicle retrofit effects. This file can be in tab-delimited text, comma-delimited (*.csv),
or Microsoft Excel (*.XLS) format. The user must create the Retrofit Parameters File by using
either a text editor such as Wordpad or Notepad, or a spreadsheet such as Excel.
A. Header and Comment Rows
The first row of the Retrofit Parameter File must be a header row that contains the retrofit
input parameter names separated by tabs. The remaining rows of the file contain the retrofit
parameters. Comment rows are allowed if the first character in the row or the first cell in the
tabbed file or *.XLS file is the '#' character.
B. Retrofit Parameter File Format
The Retrofit Parameter File must contain the following ten parameters in the order listed.
Each parameter's possible values are provided.
1. Retrofit Pollutant
This column must contain the full MOVES pollutant name or the pollutant abbreviation
for which the user wishes to model retrofit data. (In MOVES2010 the user may not use the
MOVES PollutantID number.) The data must appear exactly as shown in Table D-l below,
except that the pollutant abbreviation and/or full name input are not case sensitive.
Table D-l
Retrofit Parameter File Pollutants
PollutantID
1
2
3
5
6
90
91
92
93
Full MOVES Pollutant Name
Total Gaseous Hydrocarbons
Carbon Monoxide (CO)
Oxides of Nitrogen
Methane (CH4)
Nitrous Oxide (N2O)
Atmospheric CO2
Total Energy Consumption
Petroleum Energy Consumption
Fossil Fuel Energy Consumption
Pollutant Abbreviation
HC
CO
NOX
CH4
N2O
ATCO2
TotEnergy
PetEnergy
FossilEnergy
(cont.)
United States Environmental Protection Agency
Page D-l
-------
January 2010
MOVES2010 User Guide
Table D-l
Retrofit Parameter File Pollutants (cont.)
PollutantID
98
101
102
105
106
107
111
112
115
116
117
Full MOVES Pollutant Name
CO2 Equivalent
Primary PM10 - Organic Carbon
Primary PM10 - Elemental Carbon
Primary PM10 - Sulfate Paniculate
Primary PM10 - Brakewear Paniculate
Primary PM10 - Tirewear Paniculate
Primary PM2.5 - Organic Carbon
Primary PM2.5 - Elemental Carbon
Primary PM2.5 - Sulfate Paniculate
Primary PM2.5 - Brakewear Paniculate
Primary PM2. 5 - Tirewear Paniculate
Pollutant Abbreviation
CO2EQ
PM10OC
PM10EC
PMlOSulfate
PMlOBrake
PMlOTire
PM25OC
PM25EC
PM25 Sulfate
PM25Brake
PM25Tire
2. Retrofit Emission Process Input
This column must contain the full MOVES process name or the ProcessID abbreviation
for which the user wishes to model retrofit data. In MOVES2010, the user should not use
MOVES ProcessID. The data must appear exactly as shown in Table D-2 below, except that the
ProcessID abbreviation and full name are not case sensitive.
Table D-2
Retrofit Parameter File Processes
ProcessID
1
2
90
9
10
Full MOVES Process Name
Running Exhaust
Start Exhaust
Extended Idle Exhaust
Brakewear
Tirewear
Process Abbreviation
Running
Start
Extended Idle
Brake
Tire
3. Retrofit Fuel Type Input
This column must contain the full MOVES fuel name or the fuel abbreviation for which
the user wishes to model retrofit data. In MOVES2010, the user should not use FuelTypelD.
The data must appear exactly as shown in Table D-3 below, except that the fuel abbreviation and
full name are not case sensitive.
Page D-2
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Table D-3
Retrofit Parameter File Fuel Types
FuelTypelD
1
2
5
Full MOVES Fuel Type
Name
Gasoline
Diesel Fuel
Ethanol (E85)
Fuel Type Abbreviation
Gas
Diesel
Ethanol
4. Retrofit Vehicle Source Type Input
This column must contain the Sourcetype abbreviation or the full MOVES Sourcetype
name for which the user wishes to model retrofit data. In MOVES2010, the user should not use
SourceTypelD number. The data must appear exactly as shown in Table D-4 below, except that
the sourcetype abbreviation and full name input are not case sensitive.
In MOVES2010, only diesel (FuelTypelD = 2) vehicles with the following
SourceTypelDs are covered by the Retrofit Calculations: 32, 41, 42, 43, 51, 52, 53, 61, and 62.
Table D-4
Retrofit Parameter File Source Types
SourceTypelD
11
21
31
32
51
52
53
54
43
42
41
61
62
Full MOVES Vehicle
Source Type Name
Motorcycle*
Passenger Car*
Passenger Truck*
Light Commercial Truck
Refuse Truck
Single Unit Short-Haul Truck
Single Unit Long-Haul Truck
Motor Home
School Bus
Transit Bus
Intercity Bus
Combination Short-haul Truck
Combination Long-haul Truck
SourceType Abbreviation
MC
Car
PTruck
ComTruck
RefuseTruck
SUShortTruck
SULongTruck
MH
SBus
TBus
IBus
CShortTruck
CLongTruck
* These sourcetypes should not be used in retrofit input files.
United States Environmental Protection Agency
Page D-3
-------
January 2010 MOVES2010 User Guide
MOVES compares the user inputs for pollutant, process, fuel type, and source type with
the stored retrofit possibilities and prompts the user if an incorrect name, abbreviation or number
for pollutant, process, fuel type, or source type is entered.
5. Initial Calendar Year of Retrofit Implementation
The Initial Calendar Year of the Retrofit Implementation is the first calendar year that a
retrofit program is administered. Initial Calendar Year input must be equal to or less than the
Final Calendar Year of Retrofit Implementation. All months within a calendar year are affected
equally by the retrofit.
6. Final Calendar Year of Retrofit Implementation
The Final Calendar Year of the Retrofit Implementation is the last calendar year that a
retrofit program is administered. Final Calendar Year input must be equal to or greater than the
Initial Calendar Year of Retrofit Implementation.
7. Initial Model Year that will be Retrofit
The Initial Model Year that will be Retrofit is the first model year of coverage for a
particular vehicle class/pollutant combination. Valid entries for initial model year must meet the
following mathematical requirement:
Initial Model Year > Initial Calendar Year - 30
The Initial Model Year cannot be greater than the Final Model Year that will be Retrofit.
8. Final Model Year that will be Retrofit
The Final Model Year that will be retrofit is the last model year of coverage for a
particular vehicle class/pollutant combination. No retrofit will be performed on Final Model
Year input which is larger than the Evaluation Calendar Year. Also, the Final Model Year input
cannot be less than the Initial Model Year that will be Retrofit.
9. Percentage of the Fleet Retrofit per Year
The Percentage of the Fleet Retrofit per Year represents the percentage of VMT of a
particular fleet of a particular vehicle class, retrofit calendar year group, model year group, and
pollutant combination that is to be rebuilt in a given calendar year. For a successful retrofit
simulation, a value greater than zero and less than or equal to 100.0% must be entered. MOVES
checks to ensure that the product of the number of calendar years of retrofit coverage (Final
Calendar Year of Retrofit Implementation - Initial Calendar Year of Retrofit Implementation)
and the Percentage of the Fleet Retrofit per Year does not exceed 100%. For example, a retrofit
simulation will be flagged as invalid, and an error message will appear, if the simulation has a
retrofit program start in calendar year 2005, a program end in calendar year 2008, and a yearly
Fleet Retrofit Percentage of 50% (3 * 50% > 100%).
Page D-4 United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
10. Percentage Effectiveness of the Retrofit
The Percentage Effectiveness of the Retrofit is the percent emission reduction achieved
by a retrofit. It is computed from a non-retrofit emission baseline. The user must enter a retrofit
effectiveness value for a particular vehicle class, retrofit calendar year group, model year group,
and pollutant combination. All values up to 100% are valid. A negative value is permitted
because it implies an emission increase as a result of retrofit, which can occur. A value greater
than 100% is not permitted because it implies negative emissions will be generated. See also
EPA's guidance on quantifying benefits from retrofits at
http://www.epa.gov/otaq/stateresources/transconf/policy.htm
United States Environmental Protection Agency Page D-5
-------
-------
MOVES2010 User Guide
January 2010
Appendix E - Best Practices
There are several "best practices" that can assist the user in managing various aspects of
the MOVES process. In particular, we have found it helpful to be careful and consistent in
naming, managing & documenting RunSpecs and files.
7 NOTE MOVES database names must be consistent with MYSQL naming conventions. In
general, this means they may contain letters, numbers, "_"(underscore) and "$"
characters. They may not contain spaces, special characters, or be "reserved words"
(SQL words such as "select", "where", "delete", etc.).
Table E-l
MOVES Best Practices
Suggestion
Rationale
Example
Name all your MOVES
output databases with a code
indicating that the database
includes MOVES output
Prevents overwriting
input files; makes it
easier to identify output
files.
Washtenaw2008_MO (for
MOVES Output) or
Washtenaw2008 out
When testing MOVES,
name output with "Temp" or
other indicator.
Mysql/data folder can get
cluttered. This allows
you to clean up more
easily
Washtenaw2008_temp_MO
Name all your MOVES
input databases and strategy
files with a code indicating
that the database contains
MOVES alternate input data.
Helps you organize your
inputs and prevents you
from inadvertently
damaging important input
information.
Washtenaw2008 IN
Name all your MOVES run
specification text files with a
code indicating that the file
contains a MOVES run spec.
Helps you organize your
input information and can
be used to locate files
using a search.
Washtenaw2008.mrs (for
MOVES Run Specification) or
Washtenaw2008 mrs.txt
Name all the files you use
for a specific run using the
same name, but with
extensions to identify the
parts (see file naming
suggestions above).
Helps you organize your
information.
Washtenaw2008_in,
Washtenaw2008.mrs,
Washtenaw2008 mo
United States Environmental Protection Agency
Page E-l
-------
January 2010
MOVES2010 User Guide
Suggestion
Rationale
Example
Keep all of your run
specifications in the same
directory as the import files
associated with that
RunSpec. This folder should
be outside the folders
installed by MOVES so that
it will not be overwritten
when installing a new
version of MOVES.
MOVES will first look in
the location of the
RunSpec when browsing
for import files, so
keeping them all in one
place keeps you from
searching for the files that
will be imported.
My Documents\MOVES\
[CountyYear]
Decide on the Scale and
Calculation Type you wish
to use before making
selections on any other
panels.
Changing the Scale or
Calculation Type option
after making choices in
other panels may require
you to re-enter data for
those panels.
Using the description panel
is helpful when trying to
discriminate between several
runs. Think about filling out
some sort of repeatable
formula such as date,
relevant important
parameters, who is doing the
run, etc.
Note that MOVES preserves
these descriptions in the
movesrun output table for
future reference.
Documentation of the
RunSpec is very
important, especially if
many scenarios are being
processed.
2010_01_01; John Doe;
Washtenaw County; 2010; July
Every run used for any
official purpose should be
archived completely. All
batch files, RunSpecs,
MOVES code and
configuration files,
supplemental code copied
into MOVES by batch files,
default database, user input
databases, etc. should be
saved. File location can be
added as the "Description"
when the file is imported.
Months or years later, the
run can be reproduced by
anyone opening the
archive.
Page E-2
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Suggestion
Rationale
Example
If they are not too large,
output related runs should be
saved to the same MySQL
database
Combined with useful
Run descriptions, you can
keep all the data, and its
description in a single
place. Looking at the
Moves Run table in that
database can be very
informative.
Always "GROUP BY"
MOVESRunID, PollutantID,
and DaylD when summing
output results.
If a table includes output
from multiple runs, it is
very easy to mistakenly
sum them together,
thereby drastically
increasing emissions.
Emissions from different
pollutants should never
be summed. The types of
day must be correctly
weighted before they can
be summed.
SELECT MOVESRunid, DaylD,
Pollutantid, sum(emissionquant)
FROM movesoutput
GROUP BY MovesRunid,
DaylD, Pollutantid;
United States Environmental Protection Agency
Page E-3
-------
-------
MOVES2010 User Guide January 2010
Appendix F - Scenario 1: Estimating Changes in CO2 using the AVFT
Explanation of Scenario 1: Estimating Changes in CO2 using the AVFT
In this example run specification (AVFT_Example_l_runspec.mrs), the EPA's Motor
Vehicle Emission Simulator (MOVES) was used to generate estimates of light-duty vehicle
greenhouse gas (GHG) emissions and fuel use. The "policy scenario" discussed here consists of
potential increases in the stringency of car and truck CO2 standards, while the baseline scenario
is similar to the MOVES defaults. To model the policy scenario, new MOVES inputs were
created to simulate potential vehicle CO2 limits.
Creating new MOVES inputs involved multiple steps. First, Alternative Vehicle Fuels
and Technologies (AVFT) files were created to model the CO2 limits. As explained below, the
same AVFT file was also used to specify the fraction of the vehicle fleet in a given calendar year
that is comprised of vehicles of a certain vehicle technology (e.g., conventional gasoline,
conventional diesel, electric vehicle, etc.).
(A) AVFT files were used to define a new baseline diesel percentage which is higher than
that shown in the MOVES 2010 default database.
(B)For simplicity, CO2 limits were simulated by shifting a fraction of the gasoline and diesel
vehicle fleets into the electric vehicle (EV) fleet; since EVs do not have tailpipe CO2
emissions, shifting vehicles to the EV fleet has the same effect as reducing the tailpipe
CO2 emissions from the overall fleet. It should be noted this approach is not predicting
that EVs will be used to meet tighter CO2 limits, it is simply the method used here to
achieve the desired overall fleet CO2 levels.
Use of the AVFT:
Incorporating potential CO2 limits into the MOVES AVFT files was achieved by shifting
a fraction of the gasoline and diesel fleets into the electric vehicle fleet. The basis of the
MOVES CO2 estimates is energy consumed and the carbon content of various fuels. By
switching a certain portion of vehicles to a fuel with zero tailpipe emissions, we reduce the
overall fleetwide tailpipe CO2 emissions.
Practically, we can model new potential CO2 limits in MOVES by modifying fuel
consumption. Because tailpipe CO2 emissions are directly proportional to liquid fuel
consumption, our discussion focuses on miles per gallon (MPG).
Table F-i shows the fuel economy assumptions for cars in the baseline and policy
scenarios. These fuel economy values are unadjusted values (i.e. the type of values used in
Corporate Average Fuel Economy (CAFE) standards), so they are higher than the actual onroad
fuel economy. Real world conditions create a gap between on-road fuel economy (calculated by
MOVES) and the CAFE values which were used to generate the percent reductions in fuel
consumption.
United States Environmental Protection Agency Page F-l
-------
January 2010
MOVES2010 User Guide
Table F-l
MPG values for Baseline and Policy Scenarios
Model Year
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020+
Cars
baseline
29.8
29.8
29.8
29.8
29.8
29.8
29.8
29.6
29.7
29.7
30.1
30.4
30.7
30.7
30.7
30.7
30.7
30.7
30.7
30.7
Policy Scenario
29.8
29.8
29.8
29.8
29.8
29.8
29.8
29.6
29.7
29.7
30.1
30.4
30.9
32.2
33.5
34.8
36.2
37.6
39.1
40.7
For simplicity, the baseline and policy scenario assumes equivalent diesel penetration, as
shown in Table F-2. The penetration set in the current example differs from that used in the
default MOVES database, and is set by the new AVFT.
Table F-2
Diesel market share (%)
Model year
2001 -2010
2011
2012
2013
2014+
Cars
1.0
1.2
1.3
1.3
1.3
For a given model year, the percentage of vehicles of each fuel type was calculated based
on the scenario fuel economy, and the diesel market share, as follows:
Page F-2
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Scenario %EV =
1
f 1 T
ScenarioFuelEconomy
1
DefaultFuelEconomy j
For example, the percentage of EVs for cars in MY 2014, for the policy scenario, was:
Scenario %EV =
1-
32.2
V30.7.
= 4.66%.
The percentages of gasoline and diesel vehicles in the car and truck fleets were then
calculated such that the percentages of diesels in the car and truck fleets, excluding the EVs,
equaled the market share percentages specified in Table F-2, as follows:
%diesel = (l - %EV) x DieselMarketShare
%gasoline = (1 - %EV) x (1 - DieselMarketShare)
were:
For example, in the MY 2014 cars policy scenario, the gasoline and diesel percentages
%diesel = (1-0.047) x .013 = 1.24%
%gasoline = (1- 0.047) x (1-0.013) = 94.10%
Analysis of Results
The following instructions assume that your results are created in the default database name of
CO2 test database, and that there is only a single run residing in this database. For simplicity,
the analysis focuses upon model year 2014.
1. You can check to see that the electric vehicles produce no CO2.
SELECT * FROM CO2_test_database.movesoutput m where yearid=2014 and
modelyearid=2014 and sourcetypeid=21 and pollutantid=90;
Look at the emissionquant column, and match it to the various fueltypes. Notice that for fuel
type 9 emissions equal 0 for both starts and running, while fuel types 1 and 2 have emission
output.
2. Go to the movesoutput table, and select pollutant id for CC>2 (90) along with the start and
running processes (1 and 2). Sum the emission quantity (emissionquant) and record this value.
United States Environmental Protection Agency
Page F-3
-------
January 2010 MOVES2010 User Guide
SELECT sum(emissionquant) FROM CO2_test_database.movesoutput m where yearid=2014
and modelyearid=2014 and sourcetypeid=21 and pollutant!d=90 and fueltypeid in (1,2);
3. Look at the movesactivityoutput table and in the year 2014, sum the VMT from the cars with
the modelyear 2014. Record this value.
SELECT sum(activity) FROM CO2_test_database.movesactivity output m where yearid=2014
and modelyearid=2014 and sourcetypeid=21;
By including the electric fueled mileage in the activity output, you can simulate a CO2 standard
for cars which is higher than the MOVES default. Dividing the emission output by the activity
provides grams of CO2 per mile. This number can be compared against a similar run without an
AVFT in order to compare the potential CO2 improvements over a baseline scenario.
Remember, the MOVES output is based on-road fuel consumption, which is higher than
indicated by CAFE standards.
Page F-4 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Appendix G - Scenario 2: MOVES Project Level Example
1. Definition of the MOVES Project
In this example MOVES Runspec, the EPA's Motor Vehicle Emission Simulator
(MOVES) was used to generate emission inventory estimates for a hypothetical scenario where
heavy-duty vehicle traffic is entering and departing a parking lot using a single roadway. Since
this example is only for illustration of the MOVES software features, it was kept simple
intentionally. It does not represent any specific real-world project.
The Project constraints are:
1. There are only two links (inbound and outbound from a parking lot)
2. The two links and the off-network link are independent of each other.
3. A single off-network link contains all of the parking, extended idle and vehicle
start operations.
4. Only heavy-duty vehicles operate on the roadway and are present in the off-
network area.
5. The project example only models nitrogen oxide (NOx).
6. One hour of operation was selected. If the user desired to model additional hours,
then additional MOVES Projects need to be created.
Figure Gl Basic Schematic of the Project
Parking Lot
Roadway Link
Figure Gl shows a basic schematic of the Project to be modeled. It consists of a parking
lot and a two-way road link leading in and out of the parking lot. The specific modeling
parameters are shown and discussed in Tables Gl, G2 and G3 below.
United States Environmental Protection Agency
PageG-1
-------
January 2010
MOVES2010 User Guide
Table Gl
Summary of On-road Project Level Parameters
Location County
Calendar Year
Month
Time
Weekday /Weekend
Temperature
Humidity
Road type of links (linkl and link 2)
Roadway Link Length (both links)
Link Traffic Volume - In (link 1)
Link Traffic Volume - Out (link 2)
Link Average Speed - In (link 1)
Link Average Speed - Out (link 2)
Number of Vehicle in Parking Lot (link 3)
Washtenaw County, Michigan
2009
January
ll:OOPMtoll:59:59PM (hour 24)
Weekday
23. 7 F
74.5 %
Rural Unrestricted Access - can
any non freeway rural road
represent
0.56 miles
100 vehicles per hour
10 vehicles per hour
33.6 miles per hour
31.6 miles per hour
200 vehicle on average
Only one county may be chosen for a given project level run. In this example,
Washtenaw County, Michigan was chosen. Any of the 3,222 counties or a custom domain
(defined by the user) may be chosen. Also, only one calendar year, one month and one hour may
be chosen for a given project level run. If the user desires to model more than one such entity
(i.e., all 24 hours), then they must perform additional and separate project level runs. It is
suggested for such runs that the user employ MOVES batch mode features. A project level run
may include either weekday activity, weekend activity or both. In this example only weekday
was run. A temperature in degrees Fahrenheit (23.7 F), and relative humidity of (74.5 %) were
also specified. These are the default MOVES values for this county, month and hour. However,
any appropriate value may be entered for these parameters.
More than one pollutant / process combination may be modeled in a given project level
run if the required inputs are entered. In MOVES, some pollutants are 'chained' to other
pollutants. This means that they require the prerequisite calculation of another pollutant(s). If
the pollutant to be modeled in the Project level is a 'chained' pollutant, then a complete set of
Project level inputs must be entered for all of the required prerequisite pollutants.
Currently, MOVES Project level cannot model evaporative emission processes.
However, this capability will be added to future model upgrades.
For each roadway link the user must specify a MOVES road type which best represents
it. In this example, the rural unrestricted access road type was chosen to represent both links.
Any of the four roadtypes may be chosen to represent each Project link. The user must also
specify a link length in miles for each roadway link they wish to model. In this case because the
example is modeling the same roadway in and out of the parking lot, both links are 0.56 miles in
length.
PageG-2
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
The traffic volume must also be specified for each link. This is the total average traffic
flow from all vehicle types on the link during the hour period. In this simple example, all of the
vehicles are heavy-duty trucks, but in general any or all of the MOVES vehicle source types may
be included at the same time in a project level run.
The average speed on each link must also be specified. In this example where drive
schedule inputs are used to represent activity of all of the roadway links, the average speed
inputs in the Links spreadsheet / input GUI tab are used only for minor internal calculations in
the project level model. However, they should match the overall average speed(s) of the
individual drive cycles as submitted in the LinkDriveSchedule tab. It is the responsibility of the
user to insure that they match - no automatic checks are done.
The average road grade (in percent grade units) may also be specified for each link. This
input represents the overall average grade of the entire link not one specific section of it. It is
used only if a drive schedule input is not provided (i.e., it will NOT be used in this example).
However, in this example a value of zero was entered as a placeholder.
In this example, MOVES will use second-by-second driving schedules to model vehicle
operation. If drive schedules are not provided, MOVES uses the average speed and average
grade inputs plus default MOVES driving cycles to model the driving behavior. When drive
schedules are entered, different emission results may be produced even if the average speed of
the driving schedules match the average speed input entered in the Links spreadsheet tab. See
Appendix G Section 5.0 for an example.
Figure G2 shows the two driving schedules of this example project in graphical form.
Link 1 shown in blue, has driving starting at around 44 mph and decreasing to zero mph as the
vehicles enter the parking lot. Link 2 shown in green has driving starting at zero mph and
accelerating to a 44 mph cruise. The variable nature of the speed - time curves are indicative of
average operation of a number of vehicles / drivers on a road. The driving schedule data and the
chart are contained in the input workbook "ProjectExamplel_input.xls" in the worksheets
"LinkDriveSchedule and LinkDriveSchedule Example Chart."
United States Environmental Protection Agency PageG-3
-------
January 2010
MOVES2010 User Guide
Figure G2
Speed / Time Trace for Example Links
10 20 30 40
Time (seconds)
50
60
70
The distribution of the traffic by MOVES source type is an additional input. It is entered
as the SourceTypeHourFraction in the LinkSourceType worksheet, and the LinkSourceType
input tab. In this example, because only heavy-duty long-haul trucks are to be modeled, all of
the values for SourceTypeHourFraction are set to unity.
For this example, the off-network parameters are shown in Table G2. These four
parameters include a vehicle population of 200 vehicles in the parking lot on average during the
hour period. This input is an average value over the one hour time period, because some
vehicles may have been in the lot at all times while others entered or exiting during the hour
period. In this example, the start fraction is set to three percent (0.03). This is the fraction of the
average vehicle population which were started during the hour. If all of the vehicles in the lot on
average are started, then this value is unity (1.0). It may also be greater than unity if large
numbers vehicles are repeatedly started during the period.
The extended idle and parked vehicle fraction parameters were set to 0.90 and 0.09
respectively, for this example. The 90 percent input for extended idle reflects the fact that 90
percent of the total vehicle - hours (only one hour by definition) in the parking lot were spent in
extended idle mode (vehicles are parked in a lot with their engines idling at higher than curb idle
speeds). The 9 percent input for parking reflects the fact that 9 percent of the total vehicle -
hours in the parking lot were spent in park mode (vehicle is parked and the engine is off). The
sum of extended idling and parking cannot be greater than unity. Currently, the parked vehicle
input is not active in any of the calculations, but a valid entry must be provided anyway.
PageG-4
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Table G2
Summary of Off-Network Project Level Parameters
Average Vehicle Population
Start Fraction
Extended Idle Fraction
Parked Vehicle Fraction
200 vehicles in the parking lot on
average
0.03
0.90
0.09
The operating mode distribution for the parking lot link must be entered. This is a
distribution by AVERAGE vehicle 'soak' time (i.e., the time since a vehicle was last started).
For example, Table G3 below shows that 5 percent of the vehicles in the parking lot have not
been started for more than 720 minutes or 12 hours. Extended Idle operating model fraction is
always set to unity (1.00) when it is present because it is the only operating mode of its type.
This input should not be confused with the off network parameter called Extended Idle Fraction
with a value of 0.90 that is shown in Table G2.
Table G3
Operating Mode Distribution Parameters for Start and
Extended Idle Processes
OpmodelD
Code
101
102
103
104
105
106
107
108
200
Operating Mode Description
Soak Time < 6 minutes
6 minutes <= Soak Time < 30 minutes
30 minutes <= Soak Time < 60 minutes
60 minutes <= Soak Time < 90 minutes
90 minutes <= Soak Time < 120 minutes
120 minutes <= Soak Time < 360 minutes
360 minutes <= Soak Time < 720 minutes
720 minutes <= Soak Time
Extended Idle Operating Mode
Operating Mode Fraction
0.00
0.05
0.30
0.10
0.50
0.00
0.00
0.05
1.00
Table G4 shows the source type age distribution for the vehicles in the project. In this
example, there is only one source type (heavy-duty long haul trucks) present. Thus, only one age
distribution is required. Additional age distributions would be required if additional source types
were present. The age distribution runs from age zero (brand new) to 30 years. All ages greater
than 30 years are included in the age 30 group. The distribution must sum to unity within a
source type. Note that the project level model does not allow separate age distributions for
different fuel types if the same source type is selected. For example, the same age distribution
would be used for both gasoline and diesel long haul trucks if both were present in the project.
United States Environmental Protection Agency
PageG-5
-------
January 2010
MOVES2010 User Guide
Table G4
Source Type Age Distribution
Source Type
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
62
agelD
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
ageFraction
0.2
0.15
0.1
0.1
0.1
0.07
0.05
0.05
0.05
0.02
0.02
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0
0
0
0
0
0
0
0
0
0
0
PageG-6
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
2. Example Data Creation and Input
A MOVES Runspec (called ProjectExamplel.mrs) was created to model this example
MOVES Project level analysis. For this example, the user should load the Runspec - Project
Examplel.mrs.
The user should note that a Project level run MUST contain only ONE
County
Year
Month
Hour
The example Runspec was further simplified to include only one sourcetype, two
roadtypes, one weekday/weekend combination and three pollutant / process combinations. The
runspec is provided as an example and the user should use it to become more familiar with this
example.
The Project level importer is accessed by either selecting "Project Domain Manager"
from the "Preprocessing" menu item at the top of the GUI, or pressing the "Enter/Edit Data"
button on the "Geographic Bounds" panel. After one of these selections is made, the Project
level importer screen will open.
The first input step is to create the Project Level database where the imported data is
stored. This is a MySQL database and it is named "ProjectExamplel_input" in this example.
The user loads the data into the Project Level database (i.e.,ProjectExamplel_input) for
each input tab by browsing for the individual file (use the Browse button), and once found,
pressing the "Import" button to import the data into MOVES. A message diagnostic of "Import
Complete" will be issued, and the GUI tab should turn from red to green if the data import was
successful. This process is repeated for each of the tabs until no more red tabs are present.
Various diagnostic messages are provided if the import was not successful. The data should be
"Browsed" and "Imported" from the Excel workbook ProjectExamplel input.xls.
The inputs are in the spreadsheets.
1. DriveScheduleSecondLink
2. OffNetworkLink
3. ZoneMonthHour
4. IM / Reflash
5. LinkSourceTypeHour
6. SourcetypeAgeDistribution
7. Fuel Supply
8. Link
9. OpModeDistribution
United States Environmental Protection Agency PageG-7
-------
January 2010 MOVES2010 User Guide
After the data loading process is complete the user should press the Done button to save
the data in the database. This will exit the Project Level data manager. As a final step, the user
may be required to go to the Geographic Panel tab and choose the new Project Level database
("ProjectExamplel_input") from a list of databases. If the new database is not visible, the user
should press the Refresh button.
Both the Excel input file ProjectExamplel.xls and the MOVES project level input
database ProjectExamplel_input are provided in the MOVES package as an assistance to the
user. If the user "Browses" and "Imports" their data from the spreadsheet ProjectExamplel.xls,
the user's final database should be the same as ProjectExamplel_input.
In this example, all of the inputs for the Project Level were read from a single Excel
workbook. This was done to make the process easier for the first time user, and to facilitate and
simple "Browse" and "Import" data entry. However, if the user is starting from scratch with
their own project, it is recommended that they use the Create Template button or the Export
Default button for each of the Project Level input tabs. This will create a set of Excel workbook
templates or default data spreadsheets (with a set of individual worksheets - one for each input
tab). The user should populate or modify these templates or data tables with the actual data. The
spreadsheets within each template will provide necessary descriptions of the data fields and
moves codes (i.e., countylD codes, fuelformulationID codes, roadtypelD codes, hourDaylD
codes and sourcetypelD codes). The MOVES project level importer will show a list of all of the
individual Excel worksheets from an Excel workbook. The user must pick the 'active'
worksheet (usually the leftmost worksheet in the workbook or the first spreadsheet entry in the
MOVES importer) as an input
After using the Project level importer, the user should also notice that the
DriveScheduleSecondLink and the opmodeDistribution table need not exist together for all of the
roadtype links. In this example, the DriveScheduleSecondLink table contains an average speed-
time 'trace' for both roadway links. It is used by MOVES to internally create an
opmodeDistribution for each roadway link. A separate opmodeDistribution for the road links is
not required to be supplied, but could have been supplied in-lieu of the
DriveScheduleSecondLink data input. The opmodeDistribution is always required for the start
operation parameters (table 3 contains the inputs). It contains the opmodeDistribution for the
NOx emission starts. These values are used to differentiate start soak times.
Alternatively, neither a DriveScheduleSecondLink or the OpModeDistribution table need
be provided. The user may simply specify an average speed for each link in the "Links" table. If
this option is utilized, MOVES selects two default driving schedules and uses the average speed
input to interpolate between the two cycles to create a new default cycle for that average speed.
(See Appendix G Section 4 for more details).
3. MOVES Results for the Example
The results for this simple MOVES Project Level simulation are reported in the MySQL
database "ProjectLevel_Output". They are summarized below.
PageG-8 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Table GS
MOVES Project Level Example Simulation Results
LinkID
1
2
3
3
Link Description
Inbound Road
Outbound Road
Parking Lot (extended idle)
Parking Lot (start)
NOx emissions (grams)
793.31
120.97
9768.33
4.17
The emissions are reported as an 'inventory' for the project and are broken down by
linkID (roadway and off-network - the user must specify that the results to be reported by
roadway and process in the Runspec). In this example, the results are reported in units of grams
of NOx emissions. The time domain for the Project Level is always one hour. The user should
also remember that these results are average results over the one hour time domain and the
geographic link domain. One reason project level reports 'average' results is because the
model's calculation methodology assumes (for simplicity) independence of the individual links
in the project, and does not dynamically calculate traffic flows between links or residence times
in off network (the user must do this step before the data is entered into the MOVE project level
simulator.
The large difference in NOx emission inventories between two physically similar links
(link 1 and link 2) is because of the large difference in traffic volumes. The traffic volume for
link 1 is an order of magnitude greater than the traffic volume for link 2. The relatively small
amount of NOx emissions from the start process is the result of a very low start fraction input
(i.e., 3 percent). The relatively large amount of emissions from the extended idle process reflects
a fairly high fraction of extended idle operation (i.e., 90 percent). In comparison, the running
operation of the inbound road contains half as many vehicles (100 vehicles versus 200 in
extended idle), and the running operation on average lasts only about 2 minutes per vehicle
versus the entire hour for 90 percent of the vehicles.
4. MOVES Project Example #2
This example (the inputs are in Excel Spreadsheet ProjectExample2_input.xls) has
virtually all of the same inputs as Project Example #1 discussed in Sections 1 through 4. As a
result none of the data and explanations will be repeated. The only difference between the two
examples is the ACTIVE use of the Average Speed input in this example instead of the
DriveSchedule inputs. The purpose of this brief example is to show that different results for
roadway links are obtained from the two different methods of modeling vehicle operation.
In this example, the average speed input of 33.6 mph is imported and used for Link 1 and
31.6 mph is used for Link 2. These inputs are in the Links tab. The average speed / average
grade inputs become ACTIVE in MOVES when the specific drive schedule inputs shown in
Figure 1 are NOT imported / used by the Driveschedule Importer GUI. If the drive schedule
data (or operating mode distribution data for roadway links) are imported, they automatically
over-ride the average speed inputs in the Links tab.
United States Environmental Protection Agency
PageG-9
-------
January 2010
MOVES2010 User Guide
Instead of user supplied drive schedules being used to represent vehicle operation, built-
in default drive schedules are used when average speed inputs are entered. The two input types
(drive schedule and average speed) are not necessarily equivalent. The difference can be
quantified by comparing the results in Table G6 with those of Table G5.
Table G6
MOVES Project Level Example Simulation Results
LinkID
1
2
O
O
Link Description
Inbound Road
Outbound Road
Parking Lot (extended idle)
Parking Lot (start)
NOx emissions (grams)
731.77
79.45
9768.33
4.17
5. MOVES Project Example #3
This example briefly presents and discussed several real world ramp cycles developed
under contractor for EPA. These are provided because the Project Level does not contain default
data for modeling freeway ramps. Entering an average speed / grade in the Project Level Links
importer will not model a freeway ramp. The only way a user can model a freeway ramp using
the Project Level is to enter a ramp drive schedule in the DriveSchedule importer or a roadtype
operating mode distribution using the OpmodeDistribution input tab.
The attached Excel spreadsheet Ramp_Driving_Cycles.xls contain several real world
drive schedules for various ramp configurations. They are based on a 2004 Sacramento,
California driving study. These schedules do not model any actual real world project, but serve
as realistic examples of ramp operation. They also function as a starting point for the user to
develop actual cycles that precisely fit the needs of their specific project. They can be used in
MOVES Project (or modified for use) by defining a new ramp LinkID (i.e., Rampl, Ramp2, etc)
and populating the DriveSchedule importer with a speed-grade / time trace based on ramp
driving operation.
The Summary table in the Ramp_Driving_Cycles.xls spreadsheet lists the ramp
configuration type, the grade change toggle and the ramp metering designation. The table
includes only "on-ramps". No data are available for "off-ramps". Ramps may be configured in
several ways with different operating behavior occurring on each. The most prominent types are
the "Diamond" configuration or the "Loop" or "Cloverloop" configuration. The "Diamond"
configuration typically has higher speed and acceleration operation than the "Loop"
configuration. A ramp may also be "metered" by a traffic light at the end of the ramp that
controls access to the freeway. The final ramp configuration is the "Transition" ramp. It occurs
when one freeway transitions to another freeway. The individual cycles are also denoted by the
general grade change of the ramp. Three possibilities are provided for the "Diamond" and
"Loop" configurations.
PageG-10
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
Appendix H - Scenario 3: County Data Manager Example and Basic MySQL
Queries for Analyzing Output
1. Explanation of Scenario 3
The County Data Manager is expected to be used extensively by users, particularly by
nonattainment or maintenance areas when conducting SIP or conformity analyses. This tool
provides the user the ability to import and edit local data, rather than using MOVES defaults.
This appendix will also go through the MOVESOutput table in the MySQL Query Browser to
give users some basic queries that can be used for their own analyses.
In this scenario, the County Data Manager is used to construct a RunSpec using area-
specific data. The area being modeled will be a custom domain. While there are some
differences between using the custom domain option and selecting an individual county, the
basic operation of the County Data Manager is the same. Where differences exist, this scenario
will describe how a custom domain and a single county would be treated differently.
2. Constructing the RunSpec
The custom domain in this scenario will be named "Example City" and will be an ozone
nonattainment area, so the selections and use of the County Data Manager will reflect that
assumption. On the Pollutants and Processes panel, all processes for Volatile Organic Carbons
(VOCs) and Oxides of Nitrogen (NOx) are selected because these pollutants are associated with
the formation of ground-level ozone. If VOCs are selected, several other pollutants and
processes must be selected as well because they are needed when calculating VOC emissions.
Therefore, this run contains a fair number of pollutant-processes and will take a fair amount of
time to run (about 16 minutes on a computer with a dual-core processor), but the variety of the
output will be useful later when analyzing the output in the MySQL Query Browser. If the user
simply wants practice with the process of using the County Data Manager and importing files, it
is recommended that the user select only NOx processes on the Pollutants and Processes panel
as evaporative emissions of hydrocarbons take the most time in MOVES.
The RunSpec should be filled out in its entirety before the County Data Manager is used.
In this example, selections were limited to reduce the run-time of the RunSpec, but some
variation is included to emphasize how output can be post-processed in MySQL.
Open the file name "examplecity_2013 July.mrs" (located in the USER Guide Example
Files\City Example\City Example Files folder) to view the RunSpec and to create an output
database using the General output panel (e.g. examplecity_2013 July_out). Then select the
RunSpec Geographic Bounds panel and notice that Custom Domains require the user provide
additional information about the area. Users can change any of these fields (except County ID
because the input files have countyID=99001), but should be aware that doing so will result in
different emission results. Next, click the "Enter/Edit Data" button to open the County Data
Manager window.
United States Environmental Protection Agency Page H-l
-------
January 2010 MOVES2010 User Guide
3. Using the County Data Manager
With the County Data Manager open, name and create a user-input database (e.g.
examplecity_2013 _july_in).
Next, notice that the Fuel Formulation, Ramp Fraction, Zone Road Activity, and I/M
Programs tabs all start with green checks for different reasons. For Fuel Formulation, as long as
default fuel formulations are referenced in the Fuel Supply tab, then no data has to be imported;
however, if a new fuel formulation is created or if the properties of an existing fuel formulation
are changed, then the new fuel formulations should be imported. For Ramp Fraction, the default
fraction of 8% of VHT is applied if no data is imported on this tab, but users can import new
values if desired. The Zone Road Activity tab erroneously shows a green check, but data MUST
be imported for MOVES to calculate results properly; a value of 1 should be entered for the
SHOAllocFactor for each road type so that all of the VMT input by the user is assigned to the
custom domain. Finally, the I/M Programs tab starts with a green check because there are no
default programs in the custom domain that have to be accounted for. Of these 4 tabs, data will
be imported for Zone Road Activity and I/M Programs.
For all other tabs, files containing the area-specific data must be imported. The importing
process is the same for all the tabs, so it is explained generally in the next paragraph. The Excel
files containing the example area-specific data are included as part of the MOVES installation
pack and have the following naming convention:
examplecity_2013 JulyJTABNAME]
Users can open the files before importing them to view how the data is formatted and can
refer to the supporting worksheets for clarification on the numerical codes or abbreviations.
Notice that for some files, wildcards are used to greatly reduce the number of rows that have to
be entered (e.g. Average Speed Distribution - 64 with wildcards vs. 11,520 without).
Importing the files is straightforward - simply click the "Browse" button, find where the
file is saved, and select the appropriate file for the tab (i.e. if working in the "Age Distribution"
tab, select the file "examplecity_2013July_agedistribution.xls"). After the file has been
selected, a small pop-up window appears:
Page H-2 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Select the Worksheet to read
sourceTypeAgeDistribiition
AgeCategory
SourceUseType
Cancel
Select the correct worksheet (in this example, it will generally be the first worksheet listed and
will usually have a name similar to the tab name) and click "OK." For the Vehicle Type VMT
tab, there are four worksheets within the file "examplecity_2013July_vehicletypevmt.xls" that
should be imported: HPMSVTypeYear, monthVMTFraction, dayVMTFraction, and
hourVMTFraction. The names of the worksheets correspond to the names of the database tables
for which data is being provided.
Next click the "Import" button. The "Messages" box should say which table was imported and
"Import Complete." If there were problems with the import, error messages here would describe
the problem. In case of error, the user should revise the input file, save the changes, and then
click the "Clear Imported Data" button before reattempting the import.
The County Domain Manager can be used to input data for a custom domain (as shown in
this example) or a specific county. Currently, the only difference is that the custom domain
option includes a "Zone Road Activity" tab. This tab exists to allow the Source Hours Operating
(SHO) to be allocated to different zones within a custom domain; however, this capability is not
fully implemented in MOVES2010 and values of 1 should be entered for all road types within
the zone.
Once all the files have been imported, the database tables have been populated. Click
"Done" in the County Data Manager to return to the Geographic Bounds panel. Make sure the
user-input database is selected in the Domain Input Database section of the Geographic
Bounds panel. The RunSpec and county-input database have both been completed, so the
RunSpec can now be executed by selecting Execute from the Action drop-down menu.
4. Analyzing the Results in the MySQL Query Browser
First, a brief summary of the major pieces of the MySQL Query Browser.
United States Environmental Protection Agency
Page H-3
-------
January 2010
MOVES2010 User Guide
Query
f MySQL CJuery Urowscr - Conn
Ffe Ed* Vww Query Script Tor*.
1^) li^J ffl
O Re*ufti«t I
I SELECT ' FROM example" ty_7Q13_jul y_cu1 novf-jriin'
lunSpecFJeOateTinne
2003-12.1709:4205
state
Inv
15834
X ~[|~ p •;.*,->.
List of
i Databases
, , , and Tables
~
~
~
i
SjnUx
My3<51. Trarsact)ofMiljndLoc*lng...
. . ftepkation Ststwrnots
«_. SQl Syntw for P«p«d Statement
1: 1
The top left box is the Query Area, bottom left is the Data Area, and top right is the List of
Databases/Tables. The tables within a database can be revealed by clicking the black triangle
just to the left of the database name. There are queries below that have the following syntax:
SELECT * FROM 'examplecity_2013 July_outY[table]';
These queries can be auto-generated by dragging the table name from the right-hand List of
Tables and dropping it in the Query Area or Data Area. If the table name is dropped in the
Query Area, the text for the query is generated, but the query it self is not executed; so the user
must either click the Execute button (lightning bolt) or press CTRL + Enter. However, if the
table name is dropped in the Data Area, the query will be generated in the Query Area and auto-
executed with results immediately appearing in the Data Area.
Now that some of the basics have been covered, the results from the example can be
analyzed. Listed below are MySQL Queries and some discussion of the results they generate.
Users should be able to copy and paste the queries into the Query Area of MySQL as long as the
output database name is "examplecity_2013 July_out"; if the user provided a different output
database name, that name should be used wherever "examplecity_2013 July_out" appears.
1) SELECT * FROM 'examplecity_2013July_ouf / moveserrof;
Users can look at the MOVESError log to make sure the run executed normally. There should
be no results from this query.
Page H-4
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
2) SELECT * FROM 'examplecity_2013July_ouf /movesrurf;
The MOVESRun table gives some basic information about the RunSpec, the description, the
date and length of time, etc. If there are multiple runs in the database, there will be multiple
MOVESRunID entries here.
3) SELECT * FROM ' examplecity_2013 July_ouf /movesactivityoutpuf;
The MOVESActivityOutput table contains all the activity results from the RunSpec and should
have 1446 rows (there is a bar below the data area that tells you how many rows a query returns).
In the RunSpec, the distance traveled and population options were selected. Both of these values
were inputs, so let's make sure the input values were carried through to the output correctly.
Population is easier, so we'll look at that first.
4) SELECT sourcetypelD, SUM(activity) AS population
FROM " examplecity_2013 July_ouf /movesactivityoutpuf
WHERE activitytypeID=6
GROUP BY sourcetypeid
ORDER BY sourcetypeid;
You'll notice the query has gotten more complicated, but it can be easily explained. The first
line is the SELECT statement, which states the fields from the table that will be displayed. Since
population is not time dependent and we're only looking at one county, the only important field
is the sourcetypelD itself; however, a sum of the activity is required because output was
differentiated by fuel type, but that is not of interest right now. The SUM(activity) will be
renamed in the resulting table "AS population". The second line is the FROM statement, which
just identifies the database and table that should be used. The third line is the WHERE clause,
which specifies that only activitytypeID=6 should be used when querying the table (since we're
just looking at population). The fourth line is the GROUP BY clause, which is used when a sum
is calculated. Since the clause says, "GROUP BY sourcetypeid", all data of different source
types will be kept separated, but any data within the same source type will be summed (so the
different populations for each fuel type will be added together). The fifth row is the ORDER BY
clause, which simply states the order in which the resulting information will appear.
The resulting table from this query should have just 3 rows and the populations should be (after
rounding) 500,000; 300,000; and 50,000 for source types 21, 31 and 32, respectively. These
values match the populations that were imported.
5) SELECT dayid,sourcetypeid, SUM(activity)*dayID*31/7 AS PortionofMonthVMT
FROM " examplecity_2013 July_ouf /movesactivityoutpuf
WHERE sourcetypeid=21 AND activitytypeid=l
GROUP BY dayid
ORDER BY dayid;
This statement is the beginning to calculate the VMT for passenger cars (sourcetypeid=21), but
doing so is not a straight-forward process and that fact can be seen in the SUM statement above
(notice that the GROUP BY clause only has dayid because the WHERE clause identifies that
United States Environmental Protection Agency Page H-5
-------
January 2010 MOVES2010 User Guide
only 1 sourcetypeid will be queried, so grouping by sourcetypeid is not necessary, but would not
affect the query if it were included). The temporal output for the RunSpec is hour, so that means
the VMT output was originally for one hour of one of the types of days; therefore, the VMT
should be summed within the daylD to get the total for that type of day. Then, this query adds
two additional steps: 1) by multiplying by the dayid, the product is the VMT on that type of day
in a week; and 2) by multiplying by 31/7 (the number of days in July divided by the number of
days in the days in a week), which is the number of weeks in July, this second product gives the
VMT on that type of day in the entire month.
The resulting table should have just 2 rows as can be seen in the table below. An additional
column has been added using an Excel spreadsheet to sum the VMT from the two types of days.
dayid
2
5
sourcetypeid
21
21
PortionofMonthVMT
1.21E+08
3.44E+08
Month VMT
4.65E+08
The monthVMTFraction table assigned a value of 1 to July, so the VMT that was input was
essentially a monthly VMT for July and we can see that the Month VMT is equal to the value that
was input for JdPMSVTypelD of 20 (examplecity_2013July_vehicletypevmt.xls, worksheet
"JdPMSVTypeYear"). There are ways to calculate the MonthVMT entirely within MySQL, but
that involves either creating tables or using subqueries, which is beyond the scope of this
example. Therefore, once users get to this point, use of an external spreadsheet tool is
recommended, unless the user is familiar with more complex MySQL queries.
More detail can be acquired using the query above as a template (e.g., adding "roadtypelD" to
the SELECT, GROUP BY, and ORDER BY clauses to see the VMT on each road type to make
sure the road type distribution was applied correctly; calculating VMT for JdPMSVTypeID=30).
Users are encouraged to experiment with the query above to improve their MySQL skills and
better understand how to compare inputs with outputs to make sure the results are logical.
6) SELECT * FROM 'examplecity_2013July_ouf /movesoutpuf;
This table should contain 23432 rows and gives all the emissions output with a significant
amount of detail since output is differentiated by fuel type, emission process, road type, and
source type. Therefore, using MySQL to condense the results holds great potential for
simplifying the post-processing.
7) SELECT monthid, pollutantid, SUM(emissionquant) AS grams
FROM 'examplecity_2013 July_ouf /movesoutpuf
WFffiRE dayid=5 AND pollutantid IN (3,87)
GROUP BY dayid, pollutantid
ORDER BY pollutantid;
This query will greatly simplify the original output table from 23,000 rows to 2, but a major
reason for this is that not all the data is being reported.
Page H-6 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
mo nth id
7
7
pollutantid
3
87
grams
2.11E+07
1.21E+07
Some assumptions were made to reduce the reported output that may be similar to those users
will make in their analyses, such as only a single weekday is being looked at and the only
pollutants of interest are NOX (3) and VOCs (87). Notice that in the WHERE clause that a new
command was used, "pollutantid in (3,87)"; the IN command is a more concise way of saying
"pollutantid=3 AND pollutantid=87" and can be used with any field that has multiple entries.
Once again, users are encouraged to vary this query to see the results for different conditions
(e.g. choose other pollutants; see emission results from each source type or on the different road
types; etc.).
United States Environmental Protection Agency
Page H-7
-------
-------
MOVES2010 User Guide January 2010
Appendix I - Stage II Refueling Control Programs
Stage II refueling emission control programs are intended to reduce HC and associated
air toxics emissions by reducing the amount of gasoline vapor that escapes to the atmosphere
during refueling. The amount of reduction depends on whether the vehicle has an onboard
recovery system and the level of uncontrolled emissions. The uncontrolled emissions are
calculated from inputs such as fuel RVP, vehicle fuel economy, and temperature parameters.
Stage II programs are run by state, local or tribal governments and the effects of these programs
will vary depending on the number of locations and the sales volume of stations equipped with
Stage II recovery systems and their average state of repair. See the MOVES Software Design
Reference Manual for more information about how MOVES calculates emissions from refueling.
The MOVES database contains information about all of the existing Stage II programs by
county based on the parameters used for the 2005 National Emisson Inventory (NEI). For the
initial release of MOVES, the effects of Stage II programs can only be altered by users by
manually editing the tables used by MOVES to obtain the Stage II control information. Future
versions of MOVES are expected to include graphical user interface (GUI) tools to assist in
altering Stage II program effects for individual counties. Until these tools are available, this
appendix is intended to assist users in making changes to the default parameters related to Stage
II program effects.
Stage II refueling emission control programs can only affect refueling losses that occur
during refueling. Onboard Refueling Vapor Recovery (ORVR) systems on modern vehicles are
designed to minimize the refueling losses without Stage II controls. These reductions are already
accounted for by MOVES, so that the additional control of Stage II will only affect the
remaining refueling losses from these ORVR vehicles.
County Year Table
The MOVES database contains a table named County Year which contains information
about each county for every calendar year. This table contains two fields that determine the
Stage II program effects:
o refuelingVaporProgramAdjustment
o refuelingSpillProgramAdjustment
The refueling VaporProgram Adjustment field is a number between zero and one (1.0)
which indicates the fraction that is the reduction in full refueling displacement vapor losses that
result from the Stage II recovery program that county in that calendar year. The
refuelingSpillProgramAdjustment field is a number between zero and one (1.0) which indicates
the fraction that is the reduction in full refueling fuel spillage losses that result from the Stage II
recovery program that county in that calendar year. A value of zero would indicate that the
program had no effect and a value of one would indicate that all vehicle refueling emissions had
been eliminated.
United States Environmental Protection Agency Page 1-1
-------
January 2010 MOVES2010 User Guide
Updating Refueling Adjustments Using MySQL Query Browser
The simplest way to change an existing Stage II program effect is to use the MySQL
Query Browser application to open the appropriate table and manually change the existing
values, but NEVER change values in a default MOVES database provided by EPA. MOVES is
designed to easily provide replacement values for default values using MySQL tables via the
Manage Input Data Sets panel on the MOVES graphical user interface (GUI). Using the
Manage Input Data Sets panel, type the name you wish to use for the database which will hold
your Stage II estimates into the Database drop-down box. Now click on the "Create Database"
button and your will create a database to hold your information. The name will have to meet the
criteria for database names (no spaces, no special characters) and we suggest it include text to
help you identify its contents and purpose (for example, StageII_Input).
Once you have an input database, you can open the MySQL Query Browser to work with
the tables. If the Query Browser was already open, you may need to right-click in the Schemata
panel and refresh the list of database. Once you find your database, double-click on the name
and that will show you all of the tables it contains. The database will contain empty versions of
every table used by MOVES. The table that contains the Stage II program adjustments is called
County Year and contains only four fields:
countylD
yearlD
refueling VaporProgram Adjustment
refuelingSpillProgramAdjustment
Using the Query Browser Edit function (at the bottom of the result window) you can add
or alter the contents of the table. Be sure to execute the Apply Changes button to save any
alterations.
Now return to the Manage Input Data Sets panel and select your database from the pull
down menu. You can add additional description text and then click the add button. When you
include this database in your run specification, MOVES will use your values in preference to any
default values in the MOVES database.
The other empty tables may be deleted from your database. Leaving them will not harm
your run specification (since the tables are empty), but they can be confusing. To delete empty
tables, go to the Query Browser, double click on the database to show the tables and right click
on the table you wish to delete. Choose "drop table" from the menu and the table will be
removed from that database. Multiple tables can be selected by using the CTRL or Shift buttons.
Page 1-2 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Appendix J - MOVES "Decoder"
MOVES "Decoder"
Source Type
sourcetypeid
11
21
31
32
41
42
43
51
52
53
54
61
62
sourcetypename
Motorcycle
Passenger Car
Passenger Truck
Light Commercial Truck
Intercity Bus
Transit Bus
School Bus
Refuse Truck
Single Unit Short-haul Truck
Single Unit Long-haul Truck
Motor Home
Combination Short-haul Truck
Combination Long-haul Truck
Process
processid
1
2
9
10
11
12
13
15
16
17
18
19
90
processName
Running Exhaust
Start Exhaust
Brakewear
Tirewear
Evap Permeation
Evap Fuel Vapor Venting
Evap Fuel Leaks
Crankcase Running Exhaust
Crankcase Start Exhaust
Crankcase Extended Idle Exhaust
Refueling Displacement Vapor Loss
Refueling Spillage Loss
Extended Idle Exhaust
Day
davID
2
5
dayName
Weekend
Weekdays
FuelType
fuelTypelD
1
2
3
9
fuelTypeDesc
Gasoline
Diesel Fuel
Compressed Natural Gas
Electricity
Road Type
roadtypeid roaddesc
1 Off-Network
2 Rural Restricted Access
3 Rural Unrestricted Access
4 Urban Restricted Access
5 Urban Unrestricted Access
Activity
activity TvpelD
1
2
3
4
5
6
7
activityType
distance
sourcehours
extidle
sho
shp
population
starts
activity TvpeDesc
Distance traveled
Source Hours
Extended Idle Hours
Source Hours Operating
Source Hours Parked
Population
Starts
SCCV Type
SCCVtypelD
1
2
3
4
5
6
7
8
9
10
11
12
PART5SCCV
typeDesc
LDGV
LDGT1
LDGT2
HDGV
MC
LDDV
LDDT
2BHDDV
LHDDV
MHDDV
HHDDV
BUSES
MOBILES SCCVtypeDesc
1. 1DGV. "Light Duty Gasoline Vehicles (LDGV)"
Light Duty Gasoline Trucks 1 & 2
Light Duty Gasoline Trucks 3 and 4
Heavy Duty Gasoline Vehicles 2B thru 8B and Gasoline Buses
Motorcycles (MC)
Light Duty Diesel Vehicles (LDDV)
Light Duty Diesel Trucks 1 thru 4 (LDDT)
Heavy Duty Diesel Vehicles (HDDV) Class 2B
Heavy Duty Diesel Vehicles (HDDV) Class 3, 4, and
Heavy Duty Diesel Vehicles (HDDV) Class 6 and 7
Heavy Duty Diesel Vehicles (HDDV) Class 8A and 8
Heavy Duty Diesel Buses (School and Transit)
5
B
Pollutant
pollutantid pollutantname
1 Total Gaseous Hydrocarbons
2 Carbon Monoxide (CO)
3 Oxides of Nitrogen
5 Methane (CH4)
6 Nitrous Oxide (N20)
20 Benzene
21 Ethanol
22 MTBE
23 Naphthalene
24 1.3-Butadiene
25 Formaldehyde
26 Acetaldehyde
27 Acroiein
30 Ammonia (NH3)
31 Sulfur Dioxide JS02J
32 Nitrogen Oxide
33 Nitrogen Dioxide
79 Non-Methane Hydrocarbons
80 Non-Methane Organic Gases
86 Total Organic Gases
87 Volatile Organic Compounds
90 Atmospheric C02
91 Total Energy Consumption
92 Petroleum Energy Consumption
93 Fossil Fuel Energy Consumption
98 C02 Equivalent
100 Primary Exhaust PM10 -Total
101 Primary PM10 - Organic Carbon
102 Primary PM10-Elemental Carbon
105 Primary PM10 - Sulfate Particulate
106 Primary PM10 - Brakewear Particulate
107 Primary PM10 - Tirewear Particulate
110 Primary Exhaust PM2 5 - Total
111 Primary PM2 5 - Organic Carbon
112 Primary PM2 5 - Elemental Carbon
115 Primary PM2 5 - Sulfate Particulate
116 Primary PM2.5 - Brakewear Particulate
117 Primary PM2 5 - Tirewear Particulate
United States Environmental Protection Agency
PageJ-1
-------
-------
MOVES2010 User Guide January 2010
United States Environmental Protection Agency PageJ-1
-------