-------
© oEPA
Output Presentation Outline
An exploration of output results.
Post-Processing Menu
- Summary Report.
- MySQL Scripts.
- State/County Map.
Feel free to ask questions!
-------
© oEPA
MOVES Output
All of the results of a MOVES run are stored in
MySQL database tables.
These results can be accessed by:
- Using MOVES post-processing tools.
- Using MySQL query commands.
- Using the MySQL Query Browser software.
- Using Microsoft Access with a MySQL ODBC.
Any table may be exported to other applications
(i.e., MS Excel) for further processing.
-------
© oEPA
Output Tables
MOVESOutput - Contains the emission results.
MOVESActivitvoutput - Contains the distance.
MOVESRun - Information about the run.
Emission Rate Output:
- MQVESLookupQutput
- MQVESLookupActivityQutputTemp
Diagnostic Tables:
- ActivitvTvpe, MQVESError, MOVESTablesUsed,
MQVESWorkersUsed and MQVESEventlog tables are used
for run diagnostics.
-------
Output Tables
File Edit Mew Query Script Toots Window Help
sJ
Refresh
[SELECT' FPOH \Wr'
I E (plain Compare
O ResuJUel 1
disSanceUnilc roaesL
[ai-aDH-niMr stafemeni-
Dafa Manipulation Statements
11 ,L iHit ct tements
M L Ti ar a t unai and LocNng .,,
Citati't' AJr in Oration Statements
trpli dtrn jf^t-ments
-------
MOVESOutput
Table
MOVESRunID
iterationID
yearlD
month ID
daylD
hourlD
statelD
countylD
zonelD
MnklD
pollutant! D
process! D
sourceTypelD
fuelTypelD
modelYearlD
roadTypelD
SCC
emissionQuant
emissionQuantMean
emissionQuantSigma
-------
MOVESActivityOutput
Table
MOVESRunID
iterationID
yearlD
month ID
daylD
hourlD
statelD
countylD
zonelD
MnklD
sourceTypelD
fuelTypelD
modelYearlD
roadTypelD
SCC
activityTypelD
activity
activityMean
activitySigma
-------
MOVESRun
Table
MOVESRunID
outputTimePeriod
timeUnits
distanceUnits
massUnits
energyUnits
runSpecFileName
runSpecDescription
runSpecFileDateTime
runDateTime
Scale
minutesDuration
defaultDatabaseUsed
masterVersionDate
masterComputerlD
domain
domainCountylD
domainCountyName
domain DatabaseServer
domain DatabaseName
8
-------
Post-Processing Menu
File Edit Preprocessing Action Postprocessing Settings Help
Description
Scale
Time Spans
Geographic Bounds
El I Vehicles.Equipment
Road Type
Pollutants And Processes
Manage input Data Sets
0 Strategies
[+] J Output
Advanced Performance Features
Run MySQL Script on Output Dai
Produce Summary Report
Produce State/CountyMap
Run MySQL Script on MOVES Output Database
9
-------
© oEPA
Post-Processing Menu
Use this menu once you have results.
You select an existing output database using the
runspec used to generate the results.
Options for processing output include:
- Execute existing MySQL scripts.
- Summarize results into text files.
- Graphically represent results in a county map.
10
10
-------
Post-Processing Scripts
Select Scrlptllj
Select output processing script
DecodeMOVESOutput.sql T
OK
Cancel
11
11
-------
Post-Processing Scripts
Select Script
i to)
Select output processing script
DecodeMOVESOiitput.sql T
DecocteMOVESOutput.sql
TabbedOutput.sql
•\2
-------
vvEPA
Post-Processing Scripts
The scripts are applied to the latest RunID in the
current output database selected by the runspec.
You can select previous runs from the database
using the MOVES Run Error Log window from the
pull down Action menu.
These are simply MySQL command scripts stored
in the /database/OutputProcessingScripts folder of
the MOVES application installation.
Users may write their own scripts and add them to
the folder or add scripts obtained from other users.
13
13
-------
Decode MOVES Output Script
- MOVES Post-Processing MySQL Script
- Decodes most key fields of MOVESOutput and MOVESActiuityOutput Tables
- Creating tables DecodedMOVESOutput and DecodedMOVESActMtyOutput
- that contain the additional character fields
- This version written 9)22)2005
- Assumes MOVESOBDRAFT2009 database exists and can serve as a source of the
- relevant category tables listing legal values.
- LEFT JOINS are used so that records with NULL key field values will be preserved.
- Version updated 2008-07-07 for "distance" change to more general "activity".
14
14
-------
oEPA
Post-Processing Scripts-Warning!
Read the script documentation!
- Scripts may require that you run MOVES is a particular way.
- Scripts may require specific units.
As we get more experience with using MOVES, new
scripts will likely be written.
Do you have ideas for useful scripts? Send them
to mobile@epa.gov.
15
15
-------
Produce Summary Report
Emission Prod'
•fl
Select Emission Process to Report
AH Processes
OK Cancel
16
16
-------
© vvEPA
Summary Report
You select the database you wish to summarize
using the runspec.
Select which process you wish to summarize.
17
-------
Summary Report
*: Specify Parameters for Summary Repoi
xJ
Report Title: [Summar/ Report
Specify Report for Emission Process: Total of All
Report File Name: |SummaryReport
Run Number(s) Order .'Choose Categories Data Items
Run: 1 Time: 2008-11-29 16:14:50 OrangeCounty roadTypelD Distance
modelYearlD Oxides of Nitrogen
statelD
yearlD
rnotrthID
daylD
hourlD
countylD
sourceTypelD
fuelTypelD
MOVESRunID
Move To Top of List
Display on Screen ikl Produce tabbed output
Estimate Report Width 55 Columns
OK
Cancel
18
18
-------
vvEPA
Summary Report
Name Summary Report Table and File
Choose the Run from the list available in the
database.
Choose the categories of the summary and their
order.
Choose the pollutants included in the summary.
Display on screen and/or text file output.
Estimate column width for text file.
Results will also be stored in a MySQL table in the
output database for the runspec.
19
19
-------
Summary Report: Body
^^H & Screen Reoort
i! &*
Road HodelYr
2 1969
2 1970
2 1971
2 1972
2 1973
2 1974
2 1975
2 1976
Print and Close Report
Close Report
-^.,: xi
NOx Distance
0 0
1SS2S S193
15677 5244
1S938 5331
16791 5451
33671 11202
51718 17148
54133 17788
^
T
20
20
-------
© vvEPA
Summary Report Body
Sums the pollutants you selected into the
categories you specified.
Note that the road type categories are indicated by
their numeric codes.
21
-------
Summary Report: Header
^^H 1 Screen Reoort
[Header
Run
IB**
,|. BUM*
», i
Header Item
Report Title
Report Date/Time
MOVES Output Database
Emission Process
1
1
Run Date /Time
Run Specification
1 Run Spec
1
1
1
1
1
File Date /Time
Run Spec Description
Mass Units
Energy Units
Distance Units
Time Units
Print and Close Report
Close Report
»£,,;•,')".' i •' x)
Item Value
Summary Report
2008-11-29 18:13:3
orangecounty mo
All
2008-11-29 16: 14: SO
OrangeCounty
2008-11-29 16:14:38
Chapel Hill, Orange County 1999 This is only a test.
g
J
mi
hour
22
22
-------
• IT*
© oEPA
Summary Report: Header
^^^^^^^^^^^^^^m
The header information shows you information
about the summary results including:
- The units of the values.
- The run ID and database from which the data was taken.
- The description of the run you put in the runspec.
- The date and time the report was generated.
23
23
-------
Summary Report: Decode
4|-, Screen Report
Header j Body ; Decode
Category Field
roadTypelB
roadTypelD
roadTypelD
roadTypelD
Value Description
2 Rural Restricted Access
3 Rural Unrestricted Access
4 Urban Restricted Access
5 Urban Unrestricted Access
Print and Close Report
Close Report
24
24
-------
© vvEPA
Summary Report: Decode
The decode tab will show descriptive text for most
of the numeric codes used in the body of the
report.
25
-------
Summary Report: Save
Please soecitv a directory lor the tabbed oUtD
Look In:
Local Disk (C:)
[tjSj [Ef
a ant
C3 ant 1.65
Qcvs
Cl David
Cl DELL
n Directory
C3 DRIVERS
C3 Energy Star
QEPA
C3I386
C3j2sdk1.4.2_03
C3JAVA
rl Documents and Settings [3jdk1.3.1_02
f~1 jfcunit
C3jh1.1.3
C3 junit3.7
C3junit3.8.1
C3 Lotus
Qmysql
C3NDPS
C
c
c
c
c
c
c
< [ | >
File Name:
Files of Type:
All Files
Select Directory
Cancel
26
26
-------
oEPA
Summary Report: Save
If you chose to save tabbed output, you will be
prompted for a location to place the files generated
by the Summary Report.
Three files will be written:
- SummaryReportBody.tab
- SummaryReportHeader.tab
- SummaryReportDecode.tab
These text files can be opened by any word
processor or spreadsheet application.
27
27
-------
vvEPA
Summary Report Features
You can produce multiple summary reports from
the same database by using different names.
The Summary Report can be used to aggregate the
more detailed results.
Allows the user to specify a more detailed output in
the Output Emissions Detail and produce multiple
reports with varying level of detail from the same
run.
28
28
-------
V &T
vvEPA
Generate State/County Map
^^^^^^^^^^^^^^^H
Used to create a graphical representation of the
data.
The result table selected:
- Must contain results by county (include county ID values).
- Must contain only one row for each county.
Result tables can be created using the Summary
Report.
The database containing the table is selected using
the run specification.
29
We are not demonstrating this feature.
29
-------
MOVES Map Example - Delaware
&EPA
30
30
-------
© vvEPA
Other Post-Processing
Export the data using the MySQL script.
Export the data using the MySQL Browser.
- CSV
- MS Excel
- PLIST
Use the data from MS Access using the ODBC
31
-------
vvEPA
MySQL Query Browser
File Edit Vtew Query Script Tools Window
-— X *£»/ I
•Subset , Refresh ]
©Resullset 1
| 9 avgSpeedBL.. | avgBiriSpeed | avgSpeen
1 2.5 speed <
2 5 2.5mph <
3 ID 7.5mph<
4 1 5 1 2 5mph
5 20 1 7 5mph
6 25 22.5mph
7 3D 27.5mph
S 35 32.5mph
9 40 37 5mpr
0 45 42.5mph
1 50 47.5mph
^ 3 60 57.5mph
4 65 62.5mph
5 70 67.5mph
6 75 72.5mph
1: 27 { \
Help
"""*"'
dBinDesc |
5mph
speed < 7 5mph
speed < 12.5mph
= speed 17.5mph
-speed 22.5mph
-speed 27.5rnph
= speed 32.5mph
- speed 37.5rnph
= speed 42.5mph
= speed 47.5mph
-speed 52.5mph
- speed 62.5mph
= speed S7.5mph
<= speed 72.5mph
<= speed
M Firs' M si /J ears
-101 "I
£±. ~^<
Schemata > f I
MOVESDB 2007041 2 j
ageLalegoc
qpgrr up
a'.pra.ptaf l.gasohne
a PFaqptanl ir-np^-raMii^-
a/ tpeedbin
a pf-edd tnbuh n
_ M oak i.ihJhu.ri^chot,
rlrt n^l-t_. Hon nori.1 o
Syntax F 1
Data Manipulation •*•
DELETE
DO
HANDLEP
INSERT
LOAD DATA INFILE
REPLACE
Subquen
TRUNCATE
^*^~
32
-------
vvEPA
MySQL Query Browser
Provided with the MOVES model
Windows tool for viewing databases, executing
queries, and editing tables
Resultsets can be exported as csv or Excel files
Built-in Help files
Records query history, so you can repeat queries
without retyping them
Tables can be edited directly, rather than using
MySQL commands
- Table must have a key to be edited directly
33
33
-------
vvEPA
Exploring MOVES Databases with
Query Browser
^^^^^^^^
We'll demonstrate some simple MySQL commands
in Query Browser
- Commands are shown in the slide headings and screenshots
- Note that some screenshots show older versions of MOVES
and/or output databases you won't have on your computer
To Open Query Browser (don't need to do this now):
- Start/Programs/MySQL/MySQL Query Browser
- Make sure "localhost" is specified (might not be after initial
installation) and click OK
• Click "ignore" on warning message about schema
• You can suppress this message for future use
34
34
-------
© vvEPA
MySQL Query Browser opening view
with available databases (example)
35
-------
vvEPA
Double-clicking on the MOVES
default database opens up tables
File Edit View Query Script Took Window Help
36
36
------- |