An Introduction to MOVES:
County Data Manager
FHWA Resource Center
&EPA
EPA-420-B-09-021
-------
© vvEPA
Presentation Outline
Setting up the County Data Manager.
Examples of entering county specific data.
Issues and limitations.
-------
© vvEPA
County Domain
• Users must use the County scale for SIP and
Conformity analysis.
• County scale requires entering county specific
data.
• Access to default data is limited.
-------
vvEPA
Setting up a County Domain
^^^^^^^^^^^^^^
Set up a Run Specification file first.
- This enables MOVES to filter the default database for relevant
information
The RunSpec must have:
- Only a single county selected.
- Only a single calendar year selected.
Create a County Domain database to store the
information, and a separate database to store the
results for the county.
We will be using the County Data Manager to set up the county database.
-------
vvEPA
Setting up a Run Specification
MOVES cannot run without a valid Run
Specification (runspec).
A runspec indicates the location, time period,
alternate data and output preferences.
Runspecs can (should) be saved and can be re-
loaded to be run again and/or edited.
The GUI panels are used to set up your runspec.
-------
^MMjli^&^'ZJIil^^^BHRRRI
File Edit Preprocessing Action
'%, Scate
I Time Spans
it Geographic Bounds
E] *' VehiclesEqiiinnient
Ss. RaadTypa
1 Pollutants Ami Praces
:::j Manage Input Data Set
El / Strategies
E] | Output
^ Advanced Performang
Ready...
Description
PostProcessina Settings He^
Description:
L-il-H Cuunt, Inriiarn Jul, Z013J
This panel shows where you can describe your analysis.
A good description will help you keep track of your results.
-------
County Scale
" V'1 , , -IPlxj
File Edit Preprocessing Action Postprocessing Settings Help
/ Description
1 Time Spans j
1 Geographic Bounds
JTJ i vehides£ciulpntent
-™; Road Type
I Pollutants And Proced
^ Manage Input Data Sej
El / Strategies
El f Output !
fj Advanced Performanc
* . H
Ready...
Domain/Scale
..• National Use the default national database with default state and local allocation factors.
Caution: Do not use this scale setting for SB* or conformity
p. analyses. The allocation factors and other defaults applied at
/|\ the state or county level have not been verified against specific
*™ state or county data and do not meet regulatory requirements for
SfPs and conformity determinations.
•* County Select or define a single county that is the entire domain.
Note: Use this scale setting for SIP and regional conformity analysis.
Use of this scale setting requires user-supplied local data for most
activity and fleet inputs.
0 Project Use project domain inputs.
Note: Use this scale setting for project level analysis for conformity,
NEPA,or any other regulatory purpose. Use of this scale setting requires
user-supplied data at the link level for activity and fleet inputs that
describe a particular transportation project.
Calculation Type
1 •-• Inventory Mass and'or Energy within a region and time span.
.'. Emission Rates Mass and/or Energy per unit of activity.
XV Caution: Changing these selections changes the contents of other
/JA input panels. These changes may include losing previous data contents.
7
This panel is used to select the scale of the analysis.
Select County. Select Inventory. (We will discuss the Emission Rates option later.)
Selecting County will require the use of the County Data Manager.
-------
Time Span
File Edit Pre Processing Action Post Processing Settings Help
/ Description
/State
/ |
1 Geoff aphic Bounds
[Tj I VehfctesjEcjiiipment
'S- Road Type
i Pollutants And Proem;
.5; Manage Input Data Set
0 y arables
S | output
/ Advanced Performand
«, 'i I.M
Ready-
Time Aogre(jation Level
Year -;> Month Day "Hour
Years Months
Select Year: 2013 »J , Jatuiaiy :^Julif
Years: [February :". = Aagust
2013 I March --. September
, 'April 'October
May November
June L December
Select All Clear AH
Days Hours i
WeeKend Start Hour: 12:00 12:59 "
y_ Weekdays Bid Hour: 1 12:00 - 12:59 •*•
Select An |^ aearAII | i Select All ij Clear All
8
This panel is used to select the time period you wish to include in the output.
You may select only one year if you wish to use the County Data Manager.
8
-------
vvEPA
Geographic Bounds: County
Once you have selected the County scale, you may
only choose a single county from the list.
Choosing a county selects the available default
data stored for that county.
You must first select a calendar year for analysis
(previous screen).
You must create or select a database to store the
county specific data, (done later)
-------
Select a single County
File Edit Pre Processing Action Post Processing Settings Help
/ Description !
Ell i/ohu-i «: • id
r vefBcies&auipntent
S- RaadTwws
1 Pollutants And Procefl
™ Manage Input Data Set
[+) y Strategies
[+] 1 output
j! Advanced Performanc
Ready...
ReoSort: States: Counties:
DISTRICT OF COLUMBIA " INDIANA - Johnson County
[FLORIDA ' INDIANA - KttOX County
GEORGIA INDIANA - Kosciusko County
* County iHAWAH "^ INDIANA La Porte County
ilDAHO INDIANA - Lagranye County
ILLINOIS , INDIANA Lake county
Custom Domain i|ND1AHA 1 i ilNDIANA - Lawrence County
IOWA | 1 INDIANA - Madison County
JKANSAS T | 4 »
Select All \l Add
Domain Input Database
The County domain scale requires a database of detailed data.
Server:
Database: T t Entef£dit Dat
Selections: \
" ilNDIANA - Lake County
a Refresh 1 i
Geographic Bounds Requirements j
Please select a domain database.
10
This panel is used to select a county.
You may only select one county if you wish to use the County Data Manager.
10
-------
Select fuel/vehicle combinations
File Edit Pre Processing Action Post Processing Settings Help
Description
y Scale
/" Time Spans
j' Geographic Bounds
B y Vehiclesfcquipment
/
jf Road Type
j> Pollutants And Proces
jf Manage Input Data Se^
[+j ^: Strategies
S / Output
jf Advanced Performant
Open an existing RunSpec
Fuels: Source Use Types: Selections:
Compressed Natural Gas (CNG) iCombination Long-haul Truck Gasoline - Passenger Car
Diesel Fuel Combination Short-haul Truck
Electricity Intercity Bus
Ethanol (E85) Light Commercial Truck
Gasoline Motor Home
Liquid Propane Gas (LPG) Motorcycle
Passenger Car
Passenger Truck
Rgfuse Truck
School Bus
Single Unit Long-haul Truck
Single Unit Short-haul Truck
Transit Bus
SetectAII ; Select All
•
n
This panel is used to select the fuel types and source use types to be included in
the output.
11
-------
ne EdR Pre Pf acessttia Actton
/«.
/' Gesgrstilite SsHBHte
_f On dwarf VWtfcit
/
, ___..
ttj >' &dpu(
tytm M> inttslifi)) HuaSfntc
Select road types.
AwBNable Road ivi»«: Selected Road T»es:
riiirat rtesirtctect Access ftiirat RcsirictM Access
Rural sjrifesiflc-tea Access Rural Unt e^rKted Access
Urban Restricted Access Utbati Hettricled Access
&1M.-IAH AtM EteMe
12
>
This panel is used to select the road types to be included in the output.
12
-------
Select pollutant/processes.
tie NM Wwpfiar«tti**ttij fcfttw Praslfttjn
o
13
This panel is used to select the pollutants and processes to be included in the
output.
The activity (vehicle miles traveled, VMT) can also be selected here. If you do not
choose this option, there will not be VMT values in the output database.
13
-------
c
Create a new output database.
^2S3E20EHIIIHBHBI^^^^^^HSIiSI§f.."i"... ",\,n *' • , «jai>;j
FSe EiM Pre Prflee-ssBKi Action Post Pt oeesaJna s*Hmns Wt>
/ S««»
Q / mwot
/
< i >i
R,»V...
OeBtnj>atatia£e«
»«A|tul
MaM tMW: Grans »
14
This panel is used to create (or choose) an output database and the time units for
the output tables.
This information will be stored in the output database for reference.
14
-------
Choose output granularity.
/ OrtfltHMfift
" flMtftMt
15
This panel determines the detail contained in the output. The output will be by
pollutant (always), hour, county, emission process and road type.
The user could also choose model year, fuel type and source use type or SCC
(source classification code).
15
-------
vvEPA
Completed Run Specification
Save your run specification.
Use naming conventions (like .mrs for MOVES run
specification)
Although the run specification is complete, it will
not run without entering county specific
information.
Use the County Data Manager to enter data.
16
16
-------
Go to the County Data Manager
yie Edit Preprocessing] Action
Postprocessing Tools Settings Help
J DisplayCditlM Program Coverage Records
Data bnporter _______ — — '
( Project j start County Data Manager GUI states: Counties: Selections:
f
*
jf OnRoatiVetHf
/ Road Type
J' PoBuJantsAndPHK
f Manage Input Data f
\±\ ^ Strategies
Q Output
, 1
f General Outpt
1
j Output Emissj
j ' Advanced Perform^--
i 1 IH
(ALABAMA *J • INDIANA - Lake County j
ALASKA | |
[ARIZONA ' | |
• county [ARKANSAS 1
[CALIFORNIA 1
' ''''" IcOLORADO i
Custom Domain |cONNECTICUT | ! |
IDELAWARE |
[DISTRICT OF COLUMBIA » ! ' 1
Select All i
Domain Input Database
The County domain scale requires a database of detailed data.
Seiven |localh_os1 j ^^*^**^ ^^""•^
Database: ] V T N Enterj1E(Jit Data Ifefresli i
Piease select a domain database.
< i i >
Select and Import County-Level Data
17
Since we do not have a county database yet, we must create one.
Use the Enter/Edit Data button to go to the County Data Manager.
17
-------
Create an input database
;r> Road Type Distribution j i^,Sfc^»T»B»>l!t)«»llo*
RunSpec Summary Dalahasc J Age Distribulion j Average Speed Dislrihutloii J Fuel Supply J Meteorology Data
Select or create a database to hold the Imported data.
Server: llocalhost
Database: JLakeJnput
Log:
" Create Database Refresh
£| t Database successfully created.
Database
18
This is the County Data Manager. You can also get here from the pull-down Pre-
processing menu.
Enter the name you wish for your database (no spaces or special characters) and
push the Create Database button.
When you create a database, you will get this pop-up message to indicate that the
database was successfully created.
18
-------
These empty tables were created
19
This slide shows the MySQL Query Browser showing the tables contained in the
county database we just created.
19
-------
© vvEPA
County Data Manager
Export templates (or default data).
Enter/edit the data in MS Excel files.
Import the data to your input database.
20
-------
vvEPA
Export Template
Most parameters can be entered using a
spreadsheet.
The run specification will determine the scope of
the template that is presented.
Use the XLS extension to get a spreadsheet format.
Extra tabs will help you decode the categorical
values.
21
21
-------
Export Template
RunS|iec Summafv Database iy Age Distribution ' J AueraaeSneedDistrihution
Description of Imported Data:
sourceTypeAgeDistribution Data Source:
le: (please select a file)
Export Imported Data I I Clear Imparted Data
:,' MeteorologyData
Age Distribution
22
This panel shows where on the panel the button is to initiate the creation of a
template for this information (age distribution).
22
-------
j File Edit view
^, xl ^ J
Ireeit Ferroat lods Data Window Help
a 1" »i i J -i- / ' - '
UJ31'
(:eT)fpeAgep|stributipnA AgeCutegoty
Draw .
Ready
23
Notice that all of the ageFraction cells are empty. This is where the data will go.
Notice that there are tabs which explain the AgeCategory and SourceUseType
fields.
23
-------
oEPA
Export Default Data
Only some parameters have default data available.
- Average Speed Distribution
- Fuel Supply
- Meteorology Data
The run specification will determine the amount of
default data that is presented.
Use the XLS extension to get a spreadsheet.
Extra tabs will help you decode the categorical
values.
In most cases, users should not use default data.
24
24
-------
Export Default Data
Ramp Fraction [ ij Road Type Distribution i y> Source Tyjie Population ^ Vehicle Type VMT Tools
RunSpec Summary Database ,J Age Distribution ; (J Average Speed Distribution ' ,J Fuel Supply \ i«J Meteorology Data
Description of Imported Data:
roneMonthHour Data Source:
:ile: (please select a file)
Create Template...
Export Imported Data | Clear Imparted Data
25
This panel shows where on the panel the button is to export default data from the
MOVES database. Not all import panels can access default data.
25
-------
Default Meteorology
^ "*' "
'3J File Edit View Insert Format Tools Data Window Help
J^rfd-3^i*-J»'J?°Jijt--J^*/~f'' J £
-J J
A1 •» j& monthlD
/I U a;[4j]luo>
1 Im
J4J
; Draw "
Ready
D
:onelD hourlD temperature relHumsdity
180890 13 81.69999695
57
?oneMqnthHour/^Hi^fAn£[i£Xj^onMffiiEi^ 1^1
AutoShapes - \ V CH O ij -41 O itl cfi ^ ' a£ * A ' = ^ S J J I
26
Note that only the location, month and hour selected in the run specification is
shown.
Note that there are tabs that decode the hour of the day, month of the year and
zone.
26
-------
© vvEPA
Importing Data
^^^^^^B
Data can be read directly from the MS Excel
worksheet tabs.
Browse to find and select the MS Excel file.
Be sure to add a description of the data you are
about to import.
Select the appropriate tab (usually the first one).
Click on the Import button after you have selected
the spreadsheet file and tab location.
You should get an "Import Complete" message.
27
Description data will help you keep track of what you have already put into the
database you are creating.
27
-------
Import Meteorology Data
xj
Ramp Fraction | Mliml^wnjlMMIIlll i. W Source lyiie Population |_ ij Vehicle Type VMT [ ToolsJjfM, •
RunSpec Summary Database j flge Distribution J average Speed Distribution J Fuel Supply ] t3 Meteorology Data
Description of Imported Data:
jUsing the MOVES default data
roneMonthHour Data Source:
lle: (please select a tile)
Export Default Data
28
Select the ZoneMonthHour tab (with the temperature and humidity data). In the
template and export spreadsheets the first tab in the workbook usually contains the
information you will want to import.
28
-------
vvEPA
Data Successfully Imported
^^^^^^^^^^^^^B
Check to see if you get an "Import Complete"
message.
When the import is successfully completed the red
"X" will change to a green check on the County
Data Manager tab.
The description you entered will appear in the log,
which can be viewed on the database tab.
29
29
-------
Import Success
,,_! Ramp Fraction . Road Type Distribution ^ Source TWePopulation =i Vehicle Type VMT Tools MM
RunSpec Summary Database | Aye Distribution -i Averaae Speed Distrihution j Fuel Supply
Select or create a database to hold the imported data.
Server: hmlhj t i
Database: lahejnput
Create Database
Refresh
_nn i !p u I- cu *54 MPtHi-irninn i -t\-i FiltPdZoneMonthHourtabti
Using the MOVES default data.
Database
30
This panel shows where the comments we wrote on the import panel are displayed.
These comments are stored in the database.
30
-------
f V i
vvEPA
Repeat for all county-specific inputs
^^^^^^K
Age distribution.
Vehicle population by vehicle type.
Annual VMT by vehicle type.
Fuel specifications.
Hourly temperature and humidity.
Distribution of VMT by road type.
Distribution of speed by road type.
Ramp fraction (optional).
Inspection/maintenance program description.
31
Default Ramp Fraction is 8% of VMT from Road Types 2 and 4 are on Ramps.
31
-------
vvEPA
Use the Training_Lake Inputs:
Use the Training_Lake inputs for:
- Age distribution.
- Vehicle population by vehicle type.
- Annual VMT by vehicle type.
- Hourly temperature and humidity.
- Distribution of VMT by road type.
- Distribution of speed by road type.
Export/Import Defaults for Fuel Supply.
Skip the I/M Editor- This will be discussed later.
Skip the optional Ramp fraction.
32
Since we have a set of input files already populated, lets use them.
The Example City fuels will not work for Lake County, IN, without editing.
32
-------
Fully Populated County Data
Database | ,,„ i «ge Distribution ,
lelect or create a database to how the Imported data.
Seiver: llocalhost I
>ftMaWfeAVt
Average Speed Distribution Fuel Supply ; Meteorology Data
Database: lakejnput
^ Create Database
Los:
2QQ9-Q5-27 15:55:55 Fuel Supply Filled FuelSupply table
Lake County default fuel supply
2009-05-27 1 5.54:54 Average Speed Distribution Filled AvgSpeedDistribution table
Lake County average speed distribution
2009-05-27 1 5:50'38 Age Distribution Filled SourceTypeAgeDistribution table
Lake County age distribution
2009-05-27 1 5:50:22 Vehicle Type VMT Filled HPMSVTypeYear table
Lake County vehicle type VMT
2009-05-27 15:50:01 Source Type Population Filled SourceTypeYear table
Lake County source type population
2009-05-27 1 5:49:33 Road Type Distribution Filled RoadTypeDistribution table
Lake County Road Type Distribution
2009-05-27 1 5:48'49 Meteorology Data Filled ZoneMonthHour table
Using the MOVES default data
Database
33
This panel displays the times when changes were made to each table in our county
database along with any comments we have provided.
33
-------
© oEPA
Other Features
^^^H
Database
- Used to select the database to be edited.
- Displays the log of changes.
RunSpec Summary
- Contains a summary of the run specification.
- Helpful as a reference while creating inputs.
Tools
- Generate importer XML file.
- Used for batch operation.
- Can be used to automate importing your data.
34
34
-------
.1 Ramp Fraction 1 Roau Type Distribution I ' Source Type Population Vehicle Type VMT Tools Wl
Runspee Summaiy ' Database (ii Age Distribution Average Speed Distribution i Kiel Suppty Meteorology Data
Output Database Server Name: [using default]
Output Database Name: lake_mo
Time Spans:
Aggregate By: Hour
Years:
2013
Months:
July
Days:
Weekdays
Hours:
Begin Hour: 12:00- 12:59
EndHour:12:OD-12:59
Geographic Bounds:
COUNTY geography
Selection: INDIANA- Lake County
On Road Vehicle Equipment:
Gasoline- Passenger Car
RoaeJ Types.
Off-Network
Rural Restricted Access
Rural Unrestricted Access
Urban Restricted Access
Urban Unrestricted Access
Pollutants And Processes:
Running Exhaust Oxides of Nitrogen
Running Exhaust Total Gaseous Hydrocarbons
Manage Input Data Sets:
RunSpec Summary
Done
35
This panel displays the run specification information that governs the content of the
county database we have created.
35
-------
vvEPA
Back to Geographic Bounds
Click Done to close the County Data Manager.
Click Refresh to update the list of databases.
Select your database from the list.
Continue to build your run specification.
36
36
-------
Select your new database.
File Edit Preprocessing Action Postprocessing Tools Settings Help
Description
1
f* Time Spans
1
^ On Road Vet* ,
, RoadTspe
^ PoBflantsAtHlProc
^ Manage Input Data'
El , Strateaies
B / Output
GeseralOiitpt ]
. output Emtssi '
f~ fliteanced Perform^
< IH ,
Region: States: Counties: Selections:
JALABAMA *ij INDIANA Lake County
IALASKA
iARIZONA
• County 1ARKANSAS
JCALIFORNIA
1 '' ''" JCOLORADO
Custom Domain jCOHNECTICUT
DELAWARE
JDISTRICT OF COLUMBIA -J
Select All
Domain Input Database
The County domain scale requires a database of detailed data.
Server^%ca!hQsi ^""^^
Database: lakejopjit J ^ Enter/EtUt Data Refresh
Geographic Bmrnds Ret)hkenients ^^^
< ' , -, - ' 1 >
Select anil Import County-Level Data
37
This panel shows where on the panel you select the county database you wish to
use for this run.
If you do not have a county database yet, you select Enter/Edit Data to go to the
County Data Manager.
37
-------
38
-------
oEPA
Developing inputs:
Comparison to MOBILES
MOBILES: VMT fractions, road type distribution
(fraction of total VMT), ramp fraction, speed
distribution, age, fuels, met data
- Total VMT (or VMT by road type, time of day, etc) applied
outside model
- RVP, temperature & year only inputs required for model to run
MOVES: Sourcetypepopulation, total VMT by
vehicle type, road type distribution (fraction of total
VMT), ramp fraction, speed distribution, age, fuels,
met data
39
39
-------
© oEPA
Developing inputs:
Key differences from MOBILES
^^^^^^^^^^^^^^^^^H
MOVES needs the number of vehicles (population)
by vehicle type.
- Not typically available in SIPs.
- Will need guidance.
MOVES needs vehicle miles traveled by vehicle
type (not MOBILES VMT fractions).
- VMT data exists in SIPs or use HPMS data.
- Need to map local data to new MOVES vehicle categories.
- Will need guidance.
40
40
-------
vvEPA
Converters
Converters are spreadsheets that convert
MOBILES external input file data into MOVES
compatible data.
Converted inputs can be read directly by the
County Data Manager from the spreadsheets.
You do not need converters if you can enter the
data directly.
41
41
-------
G vvEPA
Available Converters
Speed
Registration
Distribution
Temperature
42
-------
© vvEPA
Age Distribution
Uses MOBILES
registration
distribution files
Converts to MOVES
Age Distribution input
file
Uses standard 10-10-5 MOBILES age distribution tables
43
-------
MOBILES input tab.
*-.*...*.-^..A
tV" • 44
Input tab
44
-------
Results for MOVES.
45
Output tab with containing data for MOVES County Data Manager AgeDistribution
input file
45
-------
© V>EPA
Speed Converters
Available for NMIM and MOBILES speed tables
- NMIM converter uses 18 speed files: 9 FW, 9 AR
- MOBILE6 converter uses 2 speed files: Urban, Rural
Converts into MOVES compatible speed input
file
46
-------
MOBILES input for urban
£ 3
47
Urban input tab
47
-------
Results for MOVES.
.'« » *,, * N^Cct ,^m*VA*W'jtw*«ft'sWf>irt»*f - *X "
Output tab for MOVES County Data Manager AverageSpeedDistribution input file.
The converter only gives age distribution for weekends (hourdaylD=2). Weekdays
can be added by copying and pasting the output distribution below the weekend
distribution and changing the hourdaylD to end in 5 instead of 2 (eg. 75 rather than
72).
48
-------
© vvEPA
Temperature Converter
Some M6 users
input MAX and MIN
daily temperature
- MOVES requires 24
values
Fills in all 24 hours
based on diurnal
temperature curve
MOBILES day
begins at 6am
MOVES day begins
at 12am
49
-------
Converts Min/Max to hourly.
/ ii * « a fi t
Cannot be used for humidity. Currently being developed
50
-------
vvEPA
Miscellaneous
Currently MOVES requires annual VMT - MOVES
disaggregates to time period (hour, day).
Watch your units (e.g., use of "tons" might result in
0 emissions for low-emission pollutants and short
time periods, due to rounding)
COM and Project Level won't work with databases
that contain data for multiple years.
EPA is developing alternative approaches and
guidance to generate data for:
- Age Distribution
- Source Type Population
51
51
------- |