-------
August 2010
MOVES User Guide
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 15597916264946779
File Edit Pre Processing Action Pa
Execute Data Importer.,
I.M Importer
Data Importer
County Data Manager
Project Data Manager
The County Data Manager (CDM) and the Project Data 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 Data 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 Data 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 Data 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 Data
Manager were not completed; however, the results from such RunSpecs may
Page 48
United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
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 Data 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 Data Manager (leaving the I/M Importer aside, for the
moment). First, as "domain managers" the County Data Manager and Project Data 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 Data 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.
El MOVES County Data Manager
@ Source Type Population [ @ Vehicle Type VMT | Q I/M Programs | Tools
@ Fuel Supply
Q Fuel Formulation
@ Meteorology Data
Q Road Type Distribution
RunSpec Summary
Database
@ Age Distribution
U Average Speed Distribution
Select or create a database to hold the imported data.
Server: localhost
Database:
\T\\ 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 Data Manager restricts the RunSpec to a single hour, daytype, month and
county. The Data Importer can be used with any RunSpec.
United States Environmental Protection Agency
Page 49
-------
August 2010
MOVES User Guide
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, including the I/M Importer.. Specific instructions associated with using the County
Data Manager or the Project Data Manager to establish a new domain are included where
appropriate.
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.
O MOVES County Data Manager
0 Fuel Supply
Q Fuel Formulation
I Meteorology Data
RunSpec Summary
Database
9 Age Distribution
_L
O Road Type Distribution
i Average Speed Distribution
Select or create a database to hold the imported data.
Database:
Log:
localhost
•^ I Create Database
Refresh
Clear All Imported Data
Database
Done
Page 50
United States Environmental Protection Agency
-------
MOVES User Guide August 2010
By default, the host server for the receiving database is "localhost" (generally the
MYSQL data folder on 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).
XCaution! The user should never attempt to create a new input database with the same name as
the MOVES default database or of any user-supplied MOVES output databases.
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.
XCaution! When a database is created for a RunSpec at the County or Project Domain/Scale,
a "year" table is automatically created with the year selected in the RunSpec. If any
files are imported with a different year in a field, MOVES will add this year as an
additional record in the"year" table. However, even if the incorrect data is cleared
using the importer, the "year" table will not be changed, and MOVES will not
execute. Users should take care to not import different years into an input database,
but if this occurs there are currently two solutions: 1) Create and populate a new
database with corrected files; or 2) Use MySQL to view and delete the row from the
table. The MySQL queries to do this are: SELECT * FROM [database_in].year;
DELETE FROM [database_in].year WHERE yearID=[undesired_year];
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.
United States Environmental Protection Agency Page 51
-------
August 2010
MOVES User Guide
^^^^^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.
Page 52
United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
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 Data 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.
United States Environmental Protection Agency
Page 53
-------
August 2010
MOVES User Guide
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 MOVES:
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 Data
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.
Page 54
United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
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:
United States Environmental Protection Agency
Page 55
-------
August 2010
MOVES User Guide
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 MOVES.
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.
Page 56
United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
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
United States Environmental Protection Agency
Page 57
-------
August 2010
MOVES User Guide
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.
Page 58
United States Environmental Protection Agency
-------
MOVES User Guide August 2010
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.
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.
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.
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.
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
United States Environmental Protection Agency Page 59
-------
August 2010
MOVES User Guide
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
U Fuel Supply
Fuel Formulation
Meteorology Data
Ftamp Fraction
RunSpec 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 ivi itl iVMTFi action Data Source:
- fnleaae select a file\
Import
Messages:
Export Default Data
Vehicle 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.
Page 60
United States Environmental Protection Agency
-------
MOVES User Guide August 2010
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 dayVMTFraction 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.
XCaution! For all the VMTFraction tables (month, day, and hour), a "Warning" message will
appear if the fractions provided by the user sum to less than 1, and the tab header
will erroneously turn to a green check. This should be an "Error" message, and the
tab header should be red. Users must enter VMTFraction tables that sum to 1 even
if not all 12 months, 2 types of day, or all 24 hours are being modeled.
A user wishing to model a portion of a year has two options: The user may import
a true yearly VMT value (i.e. a value defining VMT for all months, days, and
hours) and give the desired allocation to the time periods being modeled and
populate the other months, day, or hours with placeholder values such that the each
of the VMTFraction tables correctly sums to 1. Or a user may import only the
amount of VMT appropriate for the time period being modeled and may assign
values that correctly allocate this VMT over the modeled time periods.
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
United States Environmental Protection Agency Page 61
-------
August 2010 MOVES User Guide
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.
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 a restricted road type (i.e. 2 or 4)
is selected in the RunSpec.
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.
The Fuel Formulation importer allows the user to change the following fuel properties.
Page 62 United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
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 MOVES, 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 MOVES the value is not required and may be left blank.
XCaution! Although fuelYearlD might seem to refer to the calendar year, the year table in the
MOVES default database maps all years 2012 through 2050 to the "fuelyear" 2012;
thus for years 2012 through 2050, the fuelyearid 2012 should be used.
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.
United States Environmental Protection Agency
Page 63
-------
August 2010 MOVES User Guide
2.3.3.4.10 I/M Importer
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).
X CAUTION! I/M emission effects are not currently available for diesel fuel or continuous I/M
inspection frequency.
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.
? 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
modifying the input so that one of the overlapping programs is "ignored" 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 "UseEVIYN" 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.
? 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.
Page 64 United States Environmental Protection Agency
-------
MOVES User Guide August 2010
^ 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.
X CAUTION! The green check for this importer is not working correctly; when modeling a
Custom Domain, user data entry is required.
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 Data 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.
United States Environmental Protection Agency Page 65
-------
August 2010
MOVES User Guide
Table 2.3.3.4.12 shows the allowable ranges for the average speed inputs in Project level
runs.. The user may enter any speed in units of miles per hour (mph) within the given range.
Average link speed inputs outside of the 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.
Page 66
United States Environmental Protection Agency
-------
MOVES User Guide August 2010
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.
United States Environmental Protection Agency Page 67
-------
August 2010
MOVES User Guide
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 MOVES 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 MOVES 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.
Page 68
United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
? 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.
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
United States Environmental Protection Agency
Page 69
-------
August 2010 MOVES User Guide
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 MOVES. 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.
XCaution! Note that the MOVES Decode script uses the "default" database supplied
with MOVES to decode the numeric values in the tables. If the default database has been
replaced, the Decode script will need to be modified with the new database name.
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 MOVES, 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.
Page 70 United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
Emission Process Selection
Select Emission Process to Report
All Processes
All Processes
Extended Idle Exhaust
Running Exhaust
County do Start Exhaust
de
Clicking "OK" allows the user to specify the content and level of report aggregation.
Specify Report for Emission Process: Total of All
Report Description: summary Report
Report Table Name: SurnmaiyReport
Run Number(s)
Categories
Data Hems
Run: 1 Time: 2010-07-23 09:30:21.0 MOVES2010aExample
/earlD
sourceTypelD
fuelTypelD
MOVESRunlD
Distance
Methane (CH4)
Nitrous Oxide (N2O)
Total Energy Consumption
Total Gaseous Hydrocarbons
Add Add All
Selection
Add | | Add All
Selection
Remove Remove All
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.
2. Specify the base portion of the table 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 the Run Number(s), Categories, and Data Items to be reported. The "Add" or
"Add AH" buttons may be used to select the Run Number(s), Categories and Data Items.
Highlighting one entry and pressing the "Add" button will move the selected item to the
United States Environmental Protection Agency
Page 71
-------
August 2010
MOVES User Guide
"Selection" box below. Pressing the "AddAll" button selects all items and moves them
to the "Selection" box below. The order in the Selection boxes for Categories and Data
Items may be changed using the up and down arrows to the right of the Selection boxes.
Similarly, the items in the Selection boxes may be removed by using the "Remove" or
the "Remove All" buttons below the Selection boxes.
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. In this example, one category, "MOVESRunID" has
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. In the following example, Run 1, Distance, Total Energy Consumption, Total Gaseous
Hydrocarbons, and Methane have been selected. These items will be reported by yearlD
and sourceTypelD and FuelTypelD.
Specify Report for Emission Process: Total of All
Report Description: summary Report
Report Table Name: tinrnrri,HryPtpu11
Data Items
Run: 1 Time: 2010-07-23 09:30:21.0 MOVES2Q10aExample
yearlD
sourceTypelD
fuelTypelD
MOVESRunID
Distance
Methane (CH4)
Nitrous Oxide (N20)
Total Energy Consumption
Total Gaseous Hydrocarbons
Run: 1 Time: 2010-07-23 09:30:21.0 MOVES2010aExample
yearlD
sourceTypelD
fuelTypelD
t
I
distance
Total Energy Consumption
Total Gaseous Hydrocarbons
L^
4
XCaution! If the output data is disaggregated by day or hour, the output database will contain
results for only two days in each month - a weekday (daylD 5) and a weekend-day
(daylD 2). In this case, Summary Reporter should not be used to display results for
a month or year, since the current code erroneously simply sums these two days
Page 72
United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
together. The user should distinguish by day ID in the report and then externally
weight the result according to the type of day to see meaningful result for a month
(e.g. 22 weekdays and 9 weekend-days in a 31-day month) or year (e.g. 261
weekdays and 104 weekend-days in a 365-day year).
In the example shown above, all report options have been selected. When "OK" is
clicked, the screen report appears:
Year So
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
1999
urce Fuel
11 1
21 2
31 1
32 1
42 1
43 1
43 2
51 1
51 2
52 1
52 2
53 1
54 1
54 2
61 1
62 2
TotalEnercfy
54774748718039040
21456520591966208
999999984306749440
999999984306749440
70961861981372416
115498297589760
1400867605446656
10265243494121472
33945864581939200
52221923236511744
339057637607866370
490930979729309700
21761766065176576
33903813767168000
TotalHC
27475869696
CH4 Distance
1708627853312 104348565504 1563380023296
1675489920
7076213760
307742310400 22
15079469056
2241801472
12172080
845515072
89545000
3564144 5260331008
54043720 22549399552
8042544 2996087040
666027 6768602
2938257 1085468032
0 82220896
4372787200 446765184 818712960
1981212928
291879712
1808979712
72477884416 9
31263641600
2632335872 J
2214443776
7798889 2667753984
11549717 94798800
6026978 2275170048
92088352 35360849920
7326088 2972167168
36419364164993024 7628773888 440970496 2611098112
8640693589245952
12232791634739200
999999984306749440
621808320
1577764 598219712
3020628992 216745984 4800S2304
44360523776
38238654464 J
Save Pr
.35804304 66530500608
nt Close
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.
United States Environmental Protection Agency
Page 73
-------
August 2010
MOVES User Guide
| Header [ Body [ Decode
sou
on
OU
OU
Oi.l
OU
OU
OU
OU
OU
OU
OU
eType
eType
eType
eType
eType
eType
eType
eType
eType
eType
eType
eType
fuel-Type
fuelType
D 11 Motorcycle
D 21 Passenger Car
D 31 Passenger Truck
D 32 Ligh
D 41 Inte
D 42 Tran
D 43 5 ho
I> 51 R fu
D 52 S ng
D 53 3 ng
D 54 H to
D 62 C mb
D 1 Gaso
D 2 Dies
Commercial Truck
city Bus
it Bus
1 Bus
e Truck
e Unit Short-haul Truck
e Unit Long-haul Truck
Home
nation Long-haul Truck
ine
1 Fuel
Save Print Close
When the user is done viewing the screen report, the user may click on "Save" to save
the report, "Print" to print the report, or "Close" to close the Summary Reporter without
printing.
XCaution! 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.
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.)
Page 74
United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
ate 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,
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.
Generate State/County Map
Colors:
Full Color
0 Show FIPS codes
0 Show legend colors
[Pj Show legend text
Number of colors:n6
Minimum Data Value: 1.0
Maximum Data Value:) 10
United States Environmental Protection Agency
Page 75
-------
August 2010
MOVES User Guide
2.3.6 Tools
Tools provides a drop-down menu with the choice Multiple RunSpec Creator.
H MOVES - C:\Epa\Moves\MOVESGHGSouiceWOVES2009Example.mis - ID 456579!
File Edit Pre Processing Action Post Processing
lools Settings Help
Multiple RimSpec Creator
This menu item contains a list of MOVES tools. Currently, 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
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.
Page 76
United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
H Multiple RunSpec Creator
Instructions
This tool creates new RunSpec files using the currently loaded information as a template, making substitutions
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 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
File:
Browse...
Create Template...
File Name Prefix
Prefix:
RunSpec Output Directory
Folder:
Browse-
Messages:
Create FlunSpecs
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:
1
2
3
4
5
6
7
A B
CountylD County Description
26161 MICHIGAN - Washtenaw County
26161 MICHIGAN - Washtenaw County
26163 MICHIGAN - Wayne County
26161 MICHIGAN - Washtenaw County
251 63 MICHIGAN - Wayne County
CD E F
G
Year Additional Text Name Primary MOVES DB Output DB Domain DB
2009 Washtenaw MOVESDB20090112 WashtenawOutput
2009 Wayne MOVESDB20090112 WayneOutput
2010 Washtenaw MOVESDB20090112 WashtenawOutput
2010 Wayne MOVESDB20090112 WayneOutput
2011 Washtenaw MOVESDB2009Q112 WashtenawOutput
2011 Wayne MOVESDB20090112 WayneOutput
H
I
Advanced Features DB User DB
United States Environmental Protection Agency
Page 77
-------
August 2010
MOVES User Guide
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
County ID
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.
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
Page 78
United States Environmental Protection Agency
-------
MOVES User Guide August 20 1 0
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_26 1 6 1 _2009_Washtena w . mrs
|i_] Test_26 i 6 1 _20 1 Q_Washtena w . mrs
k_] Test_26 1 6 1 _20 1 1 _Washtena w . mrs
fsj Test_26 1 63_2Q09_Way ne . mrs
isj Test_26 1 63_2Q 1 0_Way ne . mrs
U Test_26 1 63_2Q 1 1 _Way ne , mrs
53 Test_ExecuteRun5pecs.bat
As can be seen, the naming convention is:
__[_].mrs
_ExecuteRunSpecs.bat
7 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
rem ___________________________________________________________
echo Changing to the MOVES folder and compiling code...
C:
cd "C:\EPA\MOVES\MOVESGHGSource"
call setenv.bat
call ant compile
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
United States Environmental Protection Agency Page 79
-------
August 2010
MOVES User Guide
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\Task91 OLoopingTool\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\Task910LoopingTool\Test_26161_2011_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:\EpaWovesWOVESGHGSourcG\MOVES2009Examplfi.mrs - ID 45657980!
File Edit Pre Processing Action Post Processing Tools
Settings Help
n- Configure MOVES...
2.3.7.1 Configure MOVES
Configure MOVES
Default Input Database
Server:
localhost
Default Database: movesdb20100720
Default Output Database
Server: localhost
Shared Distributed Folder Path
C:\Epa\Moves\MOVE3GHG3ource\SharedWork |
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,
"localhost" (the MYSQL data folder on the user's own machine) 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
Page 80
United States Environmental Protection Agency
-------
MOVES User Guide
August 2010
will choose the default database distributed with MOVES. 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.
El MOVES - ID 7250826382608025992
File Edit Preprocessing Action Postprocessing lools Settings Help
MOVES User's Guide
">P About MOVES...
Description
Scale
Time Spans
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 81
-------
August 2010
MOVES User Guide
About MOVES
MOVES
This version : 2010 07 20
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 I ittp:1 www.fjiui.oi y licenses.1'
Page 82
United States Environmental Protection Agency
-------
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
sec
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
sec
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
sec
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.
Note While activity is "divided out" in the Emission Rates output, the amount of time spent
driving affects the evaporative emission rates. Therefore, it is important to input
realistic VMT, Population, Average Speed Distribution and Road Type Distribution
information.
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
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
United States Environmental Protection Agency Page A-5
-------
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 MOVES2010a 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.
"'' ODBC Data Source Administrator
? X
User DSN | System DSN | File DSN | Drivers | Tracing | Connection Pooling | About
User Data Sources:
Name
Driver
1990NQX_MOVES_Out
dBASE Files
EmRatesByAge
Excel Files
MOVESDB20Q9112
MS Access Database
MySQL ODBC 3.51 Driver
Microsoft dBase Driver (x.dbf)
MySQL ODBC 3.51 Driver
Microsoft Excel Driver (K.xls)
MySQL ODBC 3.51 Driver
MySQL ODBC 3.51 Driver
Microsoft Access Driver f.mdb)
Add...
Remove
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-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".
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.
Edit View Insert Format Records Tools Wffidow Help
A °a. j i y: ; -n u. f- <3 . ia • - _ - * a
Type a question For help .-r
Select the file data source that describes the dnver C- ^ you * to connect to.
You can uce any tile data =ouice that refer; to an ODBC dnver '/jhich is installed
In this example NMIM20070812 is chosen from the Data Source Name column. Select
OK to load the data into Access.
: File Edit View Insert Format Tools Table Window Help
ij .Jd j J giy a A J : --> •
Ji n[j>]!
*! |
1 Normal . Times New Ror
>
- A • e
File Data Source Machine Dala Source |
_
dBASE Files
Excel Files
MOVESDB 20081202
A M.id-nne P.jf.3 Source i= ^perit-r t.-, thr rnsi;hine .ind rannnl be shared
"User" data sources are :pec.ik' to a ucor or. livi iTiaclnne ":i',i.;tem" data
sources can be tried tiy all u-: ers on this machine, or by a system-wide service.
Cancel Help
^ AijtoShapes- \ \ Q Q
- A - = ^ S -> J
Windows M.., Si 2 Window,
Type a question For help » X
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.
: 4l Normal
Insert Format Tools Table Window Help
y a. i / -A j\*>~
ii 0 - j
it)) I -UBead |
Times New Roman . 12 •, B I U
Type a question fot help » X
Tables
cntycntsncdl999
cntycntsncdZOOS
coryel_05_temp
coryel_06_sum
coryel_09_temp
coryell_nat_vmt
county
county map
countymonth
Countymonthhour
rcuntymnnthhouizon:
1 OK 1
[ Cancel ]
j Select All j
[ Deselect All J
1 1 Save password
jg
Ln 1 Col 1
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.
XCaution! Edits made to the tables or data in MS Access will not affect the original MySQL
tables and cannot be used directly in MOVES.
Page B-8
United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
D Microsoft Access
: File Edit View Insert lools Window Help
^ -a -
Ullnllxl
Objects
J Tables
^J Queries
H Forms
13 Reports
Hi Pagss
^ Macros
<8 Modules
Groups
create table in Design view
Create table by using wizard
Create table by entering data
baseyearvmt
county
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
Page B-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.
i File Edft View Insert loot Whrnow Hefc
i j j "ii VI . I • -*'.- jl-l I • i-
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.
Page B-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 MjiQDBC
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 8. table
l~~ Use manager cursors |exp]
l~ Don't use setlocale
r Pad CHAR to full length
l~~ Return table names in SQL Describe Col
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)
\~ Disabb transactions
l~5irn 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 j ava interpreter.
• The MOVESCommandLine j ava 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 MOVES 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 MOVES, 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 MOVES, 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 MOVES, 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 - 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 F-l
-------
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:
- county ID
- yearlD
- refuelingVaporProgramAdjustment
- 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 F-2 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
Appendix G - 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)
Average Road Grad - In (linkl)
Average Road Grad - Out (Iink2)
Number of Vehicle in Parking Lot (link 3)
Washtenaw County, Michigan
2009
January
ll:OOPMtoll:59:59PM (hour 24)
Weekday
28. 5 F
69.5 %
Rural Unrestricted Access - can
any non freeway rural road
represent
0.997 miles
100 vehicles per hour
10 vehicles per hour
28.5 miles per hour
28.5 miles per hour
0.857 percent
-0.857 percent
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 (28.5 F), and relative humidity of (69.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. For example if
the user wishes to model total PM2.5 emissions, inputs much be entered for elemental carbon,
organic carbon, sulfate and total energy 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.
PageG-2
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
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.997 miles
in length.
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. In this case both the inbound
and outbound links had the same average speed of 28.5 mph. 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 the values of 0.857 and -0.857 percent were entered as a placeholders
(this is the actual average of each second of the drive schedule inbound and outbound).
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 or
average grade of the driving schedules match the average speed / grade input entered in the Links
spreadsheet tab.
Figure G2 shows the two driving schedules of this example project in graphical form.
Link 1 - inbound shown in blue, has vehicles entering the parking lot at 30 mph and eventually
coming to a stop. Link 2 - outbound shown in dotted pink has driving starting at zero mph and
accelerating to a 30 mph cruise. These are simple idealized cycles that are for illustration only.
Note that the two cycles overlap each other at 30 mph on the figure, and are consequently hard to
read. The driving schedule data and the chart are contained in the input workbook
"Project_Examplel_input.xls" in the worksheets "DriveScheduleSecondLink and Link Drive
Schedule Chart."
United States Environmental Protection Agency PageG-3
-------
January 2010
MOVES2010 User Guide
Figure G2
Speed / Time Trace for Example Links
35
30
25
20
CD
Q_
C/)
10
0
0 20 40 60 80
Time (seconds)
100
120
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. However, in this example, the fraction of
vehicles from 20 to 30 years old is zero. 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 Project_Examplel.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.
XCaution! In general the user should complete ALL of the runspec entries (i.e., Scale, Time,
Geographic Bounds, etc) BEFORE accessing the Project Domain Manager.
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 "Project_Examplel_input" in this example.
The user loads the data into the Project Level database (i.e.,Project_Examplel_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 Project Example 1 input.xls.
The inputs are in the spreadsheets.
1. DriveScheduleSecondLink
2. OffNetworkLink
3. ZoneMonthHour
4. IM / Reflash
5. LinkSourceTypeHour
6. SourcetypeAgeDistribution
7. Fuel
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
("Project_Examplel_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 Project_Examplel.xls and the MOVES project level input
database Project_Examplel_input are provided in the MOVES package as an assistance to the
user. If the user "Browses" and "Imports" their data from the spreadsheet
Project_Examplel.xls, the user's final database should be the same as
Project_Examplel_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.
3. Changes Between MOVES2010 and MOVES2010a
Changes were made in the Project Level Input GUI between the December, 2009 version
of MOVES and the MOVES2010a (summer 2010 release). As a result, input databases
created for the previous MOVES model cannot be used in the new version. The user will be
PageG-8 United States Environmental Protection Agency
-------
MOVES2010 User Guide
January 2010
required to re-enter their data from their Excel spreadsheets. The principal difference is the
FuelSupply and FuelFormulation tabs have been replaced with a new Fuels tab. This new tab
contains both the FuelSupply and FuelFormulation inputs in separate Browse and Template
sections. A single Import button is used for both (do not attempt to import before both have been
Browsed and Selected). Another change is that the user MUST enter fuel information for their
project. It is now a required input. It is strongly suggested that the user (1) Export the default
fuel information first into a spreadsheet, (2) make any necessary changes in the spreadsheet, and
(3) browse and import the spreadsheet into the database.
Another input change between the December, 2009 version of MOVES and the
MOVES2010a (summer 2010 release) is the addition of the average grade input in the Links
spreadsheet tab. The new version of MOVES requires the header title in the first row of the
spreadsheet, but accepts any value as a placeholder (i.e., 0 percent) if the user is also supplying a
DriveSchedule or Operating Mode Distribution input.
The output for project level has also changed. Emission rate output for starts are now in
mass per start and emission rate output for extended idle is now in mass per vehicle hour spent in
extended idle mode.
4. 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 in Table G5 by issuing the
following MySQL command in the MySQL Query browser:
SELECT movesrunid,pollutantid,processid,linkid,sum(emissionquant) as e
FROM project_examplel_output.movesoutput m
group by movesrunid,pollutantid,processid,linkid;
Table GS
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)
1266.54
57.73
48841.61
18.92
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
United States Environmental Protection Agency
PageG-9
-------
January 2010
MOVES2010 User Guide
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.
5. 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 28.5 mph is imported and used for Link 1 and
28.5 mph is used for Link 2. Likewise, the average grade inputs for Linkl and Link2 are 0.857
percent and -0.857 percent, respectively. 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.
Instead of user supplied drive schedules being used to represent vehicle operation, built-
in default drive schedules that bracket the average speed inputs (in this case 28.5 mph) are used
when average speed inputs are entered. Likewise, the average grade values of 0.857 or -0.857
percent are assumed for the entire length of the links rather than the varying road grades used in
Example 1. The results shown in Tables G5 and G5 for links 1 and 2 definitely show that the
two input types (specific drive schedule and average speed/grade) are not necessarily equivalent.
Table G6
MOVES Project Level Example Simulation Results
LinkID
1
2
O
3
Link Description
Inbound Road
Outbound Road
Parking Lot (extended idle)
Parking Lot (start)
NOx emissions (grams)
1696.47
117.47
48841.61
18.92
PageG-10
United States Environmental Protection Agency
-------
MOVES2010 User Guide January 2010
6. 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.
7. MOVES Project Example #4
This final example is not a specific MOVES example, but is instead a possible
generalized / conceptualized use case for the MOVES Project Level domain. The MOVES
Project Level domain is structured to operate, calculate and report at the LINK level.
Traditionally, the term LINK implies a section of road or a road-type. However, it can also be
thought of in the MOVES context as an individual vehicle operating on a set of roadways or an
individual vehicle making as 'trip'. In this context, the drive cycle becomes the entire speed-
time operation of an individual vehicle over a road network. Any start or extended idle operation
is represented in the off-network. Several other parameters can be made more specific by
narrowing the runspec to certain source types or fuel types, and if necessary creating additional
runspecs and Project Level inputs to include all of the desired source types or fuel types . Thus,
a Project domain could consist of thousands of individual vehicles operating over the road
network.
United States Environmental Protection Agency PageG-11
-------
-------
MOVES2010 User Guide January 2010
Appendix H - 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 c:\Program
Files\MOVES20100826\USER_Guide_Example_Files\City Example 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).
XCaution! If any changes are made to the RunSpec after the database has been created, the
database may no longer be correct for the revised RunSpec. This is because some
"core" tables are populated based on the selections in the RunSpec at the time of the
creation of the database and these core tables can only be changed directly in
MySQL (i.e., there are no tabs to edit these core tables). Users should take care in
if changing the RunSpec while using an existing database and should always
double-check the tab headers to ensure all the necessary data has been provided
after making a change to the RunSpec.
Next, notice that the Generic, Ramp Fraction, Zone Road Activity, and I/M Programs
tabs all start with green checks for different reasons. 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] .xls
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 reat
sourceTypeAgeDistribution
AgeCategory
SourceUseType
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 above menu is an example where one worksheet is selected from one Excel file,
which is typical. However, importing data for the Vehicle Type VMT tab, requires the
vehicletypevmt.xls file to be selected 4 times, once each for year, month day and hour data, and
all 4 types of data are Imported separately.
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 MOVES 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_2013July_ouf /[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_2013 July_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_2013July_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 /movesactivityoutput"
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 HPMSVTypelD of 20 (examplecity_2013July_vehicletypevmt.xls, worksheet
"FtPMSVTypeYear"). There are ways to calculate the Month VMT 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 FtPMSVTypeID=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 - MOVES DECODER
sourceusetype
sourceTypeld
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
day
davID
2
5
davName
Weekend
Weekdays
fuettype
fuelTvpelD
1
2
3
4
5
9
fuelTvpeDesc
Gasoline
Diesel Fuel
Compressed Natural Gas (CNG
Liq Petroleum Gas (LPG)
Placeholder Fuel Type
Electricity
emission process
processid
1
2
9
10
11
12
13
16
16
17
18
19
90
processName
Runninq 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
Road Type
roadTvpeld
1
2
3
4
5
roadDesc
Off-Network
Rural Restricted Access
Rural Unrestricted Access
Urban Restricted Access
Urban Unrestricted Access
activitytype
activity Type ID
1
2
3
4
5
6
7
activity Type activity Type Desc
distance Distance traveled
sourcehoLirs Source Hours
extidie Extended Idle Hours
she Source Hours Operating
slip Source Hours Parked
population Population
starts Starts
SCCV Type
SCCVtypelD
1
2
3
4
5
6
7
8
9
10
11
12
PART5SCCV
type Desc
LDGV
LDGT1
LDGT2
HDGV
MC
LDDV
LDDT
2BHDDV
LHDDV
MHDDV
HHDDV
BUSES
MOBILES SCCVtypeDesc
Light Duty Gasoline Vehicles (LDGV)
Light Duty Gasoline Trucks 1 & 2
Light Duty Gasoline Trucks 3 and 4
Heavy Duty Gasoline Vehicles 2B thru SB 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 5
Heavy Duty Diesel Vehicles (HDDV) Class 6 and 7
Heavy Duty Diesel Vehicles (HDDV) Class 8A and 8B
Heavy Duty Diesel Buses (School and Transit)
pollutant
pollutantid
1
2
3
5
6
20
21
22
23
24
25
26
27
30
31
32
33
79
80
86
87
90
91
92
93
98
99
100
101
102
105
106
107
110
111
112
115
116
117
pollutantname
Total Gaseous Hydrocarbons
Carbon Monoxide (CO)
Oxides of Nitrogen
Methane (CH4)
Nitrous Oxide (N20)
Benzene
Ethanol
MTBE
Naphthalene
1.3-Butadiene
Formaldehyde
Acetaldehyde
Acrolein
Ammonia (NH3)
Sulfur Dioxide (S02)
Nitrogen Oxide (NO)
Nitrogen Dioxide (N02)
Non-Methane Hydrocarbons
Non-Methane Organic Gases
Total Organic Gases
Volatile Organic Compounds
Atmospheric C02
Total Energy Consumption
Petroleum Energy Consumption
Fossil Fuel Energy Consumption
C02 Equivalent
Brake Specific Fuel Consumption(BSFC)
Primary Exhaust PM10 - Total
Primary PM10 - Organic Carbon
Primary PM10 - Elemental Carbon
Primary PM10 - Sulfate Particulate
Primary PM10 - Brakewear Particulate
Primary PM10 - Tirewear Particulate
Primary Exhaust PM2.5 - Total
Primary PM2 5 - Organic Carbon
Primary PM2.5 - Elemental Carbon
Primary PM2.5 - Sulfate Particulate
Primary PM2 5 - Brakewear Particulate
Primary PM2.5 - Tirewear Particuiate
United States Environmental Protection Agency
Pagel-l
-------