-------
V ic,"
© oEPA
Why Learn About MySQL?
Custom inputs
- MOVES has importers for most common types of inputs, but
some MySQL expertise would be helpful for using specialized
inputs
Working with output
- While MOVES can produce summary reports from the GUI,
MySQL can be used to produce customized output
-------
© vvEPA
MySQL
Relational Database Management System
(RDBMS)
What is a "relational database"?
-------
vvEPA
Relational Databases 101
A relational database provides a way of storing,
querying, and manipulating large amounts of data
A database contains multiple tables, in which data
are stored. Each table contains records (rows) and
fields (columns)
These tables relate to each other based on values
in a particular column
-------
© oEPA
Relational Databases 101
Example: Excel spreadsheet
- Each spreadsheet is like a database
- Each "worksheet" within the spreadsheet is like a table
- However, the rules for database tables are more rigorous
-------
vvEPA
Relational Database Rules
Each table is a set of columns and rows that
describe multiple instances of something
Each field (column) must contain a unique type of
data in a specific format
Each row represents one unique record (tables
cannot contain duplicate records)
-------
oEPA
Relational Database Rules
^^^^^^^^^^^^^^_
Each table must contain at least one field with
completely unique values to identify a record (row),
and so that this record can be related to data in
other tables (a key)
- Keys are usually numeric for flexibility and speed.
NULL values are allowed when data are not known
or not relevant. Zeros are not the same as NULL.
- Keys cannot be NULL
7
-------
MOVES Databases
The MOVES default database has over 100 different
tables that store
- Lookup/reference information
- Conversion/adjustment factors
- Emissions data
- Activity data
MOVES also uses databases to store user inputs,
intermediate results and final output
8
-------
© vvEPA
Entity-Relationship Diagrams
The symbols on the connecting lines indicate the type of relationship. The
top fields (above the line) in the boxes are the key fields used in joining
tables.
-------
© oEPA
Types of Relationships
One to one
- Example: for each month there is only one month code, and
for each month code there is only one month
One to many
- Example: one model year car can be sold in any of 12
months, but during any given month only one model year car is
being sold
Many to many
- Example: any vehicle type can be of any age (any of the 30
age bins)
10
10
-------
© oEPA
Structured Query Language
(SQL)
^^m
SQL is the language used to work with modern
relational databases
- It provides the programming syntax (language) to
communicate with (query) the database and its tables
Like English, an SQL statement is made up of
subjects, verbs, and predicates
- "SELECT * FROM state WHERE stateid = 32" means "Show
me all the data from the "state" table where the state code in
the table is 32."
11
11
-------
Q vvEPA
MOVES and MySQL
Draft MOVES2009 uses only MySQL version 5.0.27
- Newer or older versions will not work.
Support for MySQL is available in the help files, the
reference manual (C:\MySQL\docs\manual.chm),
and the MySQL web site (http://www.mvsql.com)
Entity/relationship diagrams for the MOVES default
database are located at C:\MySQL\data\(MOVES
default database folder)\readme
12
12
-------
IT*
© oEPA
MOVES and MySQL
Do you need expertise in relational databases and
MYSQL?
- Not needed for simple runs
- Some basic knowledge gives users flexibility to customize
outputs and view input databases
- In-house expert would be helpful for more advanced analysis
MySQL training is available from various
commercial vendors.
13
13
-------
vvEPA
MySQL Query Browser
Provided with the MOVES installation package.
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
14
14
-------
MySQL Query Browser
File Edit View Query Script Tools Window Help
SELECT ' FROH i i [ -- II in
U3 bacl Refresh
O Resultset 1
| ? a^gapeedBL j avgBinSpeed j avg^peedPinDe-c |
1 2 5 speed < 2 5mph
3 10 5mph < speed < 2.5mph
4 15. 5mph - speed 1 7. 5mph
5 20 .Srnph -speed 22.5rnph
6 25 .5mph = speed 27.5mph
7 30 .5mph = speed 32 5mph
8 35 .5mph = speed 37.5mph
9 40 5mph = speed 42.5mph
0 45 .5mph = speed 47.5mph
1 50 .5mph -speed 52.5mph
2 55 ,5mph -speed 57 5mph
^ 3 60 .5mph -speed GZSmph
4 65 .Sfflph = speed 67.5mph
5 70 .Srnph = speed < 72.5mph
B 75 .5mph = speed
Ere ute -r
Schemata ! >
MQVESDB20G70412 _j
aqp al^gory
•-ar j ip
-^^la etankfempetatuEe
a q ppedbin
L Id Takinitialhourlraclion
Data Manipulation j±
DELETE
HANDLER
INSERT
L we CATAINFILE
REPLACE
ELE T _
Ub er
I IPC wTE JH
ll 27
^
15
The Browser can be used to display the contents of the tables in a
spreadsheet-like form.
15
-------
t V k
© oEPA
Exploring MOVES Databases with
Query Browser
^^^^^^^^m
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:
- 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.
16
16
-------
M:
w
/SQL Query Browser opening view
nth available databases (example)
File Edit View Query 5cript Tools Window Help
O Resullsel 1 .
^
i
r^ J x
hdc P PQ it 1
nk r t i _ 1 r
i i t L
fohnbyunoia
MDVESDB20D70412
movesworker
mysqi
/a \ jpe anplp
a 1 if anpltrnuF ft ,
Synlax ^^
S^£h fl r ci 1 tinn ^^^
, Transactional and Locking
)
17
17
-------
Double-clicking on the MOVES
default database opens up tables
File Edit View Query Script Tools Window
id I tiluJhi. ir(drtt«_r
:ofd5oaktank!emperalu!e
18
18
-------
DESCRIBE state;
(or, show columns from state;)
File Edit View Query Script Tools Window Heip
r.,< [ ibc t -it-
O Resuilsel 1
j Field Type Null
^ stateiD smaJJinr[6} NO
steleNeime chai(25) YES
staleAbbr chai(2) YES
"1 t H
JOlxj
Schemata
sourceu^e^pe
starlSempadjuslrnenl
C 1- fla puWnr
11 L iHiCy
Trar art inal and Locking
Describe command is used to show you the structure of a table.
You can also right click and edit a table, which will display it's structure as
well.
19
-------
Highlighting Table + F2
will also show the table structure.
mr^maeuHimm
Table Name; Javgspeedbin
:: |MOVESDBDRAFT20Cj^J
Columns and Indices I Table Options 1 Advanced Options |
Column Name
^
w
-^
avgSpeedBinID
avgBinSpeed
avgSpeedBinD..
opModelDTirew...
Datatype j
j.. , SMALLINT(6j
0 FLOAT
^ CHAR (50}
x,, SMALLINT(6]
^ SMALLINT(6J
1SZL j S^ro | Flags
^ \ UNSIGNED
1 UNSIGNED
j BINARY ;
; | UNSIGNED
; 1 UNSIGNED
\ Default Value I Comment (
I ZEROFILL 0
| ZEROFILL " ^
ASCII ; i UNIC
; | ZEROFILL f
; 1 ZEROFILL — '
Indices | Foreign Keys ] Column Details
" tt
33 PRIMARY '' ""-" "'gi
Index Type
_J
BTREE j^j
ndex Columns Is "-• >••- Dr'=«-3'n'r = r.'.i-.i
avgSpeedBinID »•
20
The F2 function key will show the structure of the table.
You can also right click and edit a table, which will display it's structure as
well.
20
-------
vvEPA
Commonly Used
Field Types in MOVES Databases
^^^^^^
INT (± 8388608)
SMALLINT (± 32767)
FLOAT(M,D), (default is (10,2))
VARCHAR (variable length string between 1 &
255 characters)
CHAR (fixed length string between 1 & 255
characters)
21
21
-------
vvEPA
"SELECT" statements in Query
Browser
Double-clicking on table names generates a
"SELECT *" (Select All) statement
Can also drag and drop from the table listing into
the results window
You can include conditions in Select statements
to filter data or locate individual data elements
22
22
-------
SELECT * FROM state;
File Edit View Query a
<*b«i tatah
O Resultset 1
cript Tools Window Help
SELECT l FPOH irtate: d'-
9 slalelD ] slaleName ] slaleAbbf
JEJOJ2S!
^,.
Schemata i
} 1 ALABAMA AL j£
_. ALA
4 AR!2
KA AK
ONA AZ
5 ARKANSAS AR
6 CAL FORNIA CA
8 COL
3RADO CO
9 CONNECTICUT CT
0 DEU
1 DIST
WARE DE
RICT OF COLUMBIA DC
2 FLORIDA FL ""*
3 GEQ
RGIA GA
5 HAWAII HI
6 !DAh
0 ID
7 ILLINOIS IL
8 IND
9 iOW
ANA IN
* IA
_____ rr_r_^ _j
L souiceuse ype
: slarts
— satsperwe ice
— "tal "
nil (F.-MI ornair-
tankiPmpp li ;f mup
— 1 uttpmci- liifpu-p
— tan! por tti rrft- j
temperatur i ju fnipnl
';ei hlrla J!j
Syntax > I
20 KANSAS KS
21 KEN
22 LOU
TUCKY KY
SIANA LA
23 MAINE ME
24 MARYLAND MD
25 MASSACHUSETTS MA Ti
' 53 rows fached in 0,CQ84s (0.000
l! 1 [
ss) X e*<
|
M Last f> Sear-h
Data Manic 1 htr
Tt r Ltirnal and Locking
23
23
-------
SELECT stateName FROM state;
ISStmiSSSSam
File Edit View Query Script Tools Window Help
me FROM stnt^
Schema! a j
ALABAMA
ALASKA
ARIZONA
ARKANSAS
CALIFORNIA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
FLORIDA
GEORGIA
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LOUISIANA
MAINE
MARYLAND
MASSACHUSETTS
__j
e a\ Icl
i L i itility
honal and Lacking
etched in Q,
5s (Q.QQCCs)
24
-------
SELECT * FROM state where stateAbbr = "KS";
File Edit View Query Script Tools Window Help
KELECT I FBOH rt at e ..her
>3o ba'k PsFwsh
O Resullset 1
ftsparvel-MCle
:adiN tn.w
J
25
25
-------
SELECT COUNT(stateAbbr) FROM state;
File Edit View Query Script Tools Window Help
mpe,,,™,.
•gpng.nco.lf. J
26
26
-------
© oEPA
Working with MOVES output
MySQL commands can be used to sort or sum
MOVES output by year, month, pollutant, road type,
etc.
- Can filter results in MySQL and export to Excel
The Output Emissions Detail options can also be
used to perform some output aggregation, but
once applied, the underlying detail is not saved
- MySQL or Excel can be used to aggregate the output after the
MOVES run, so that the detail in the native MOVES output is
still available if it's needed in the future
- In some cases, you need aggregation factors (e.g., travel time
fractions)—total emissions of a given pollutant are additive, but
emissions rates need to be weighted
27
27
-------
© vvEPA
Working with output: examples
1) Summing emissions output across roadtypes
2) Filtering MOVES lookup output for desired
emissions rates
28
-------
Specifying Detail in Output
Emissions Detail screen
Mft MM wn>MiA€fl«unu ACIMII Vita Prnc*KK«ig IIM1U Sftttmg* Help
/*•
B /«w*
l*i» Hour T ..::-•!•. - i
HHri lypa
. K Cmlaslo*! Process
.; Efllmatt Unccnaimy
29
There is only 1 emission process in Indiana.mrs (running), but emission process is
selected so that it is identified in the output database rather than being NULL.
29
-------
MOVES output tables
30
30
-------
Emissions output table, filtered for
pollutant, roadtype, emissions
v
0 n.xn« I rt»«u
1 ;«J SELECT pollutantid, ;',;•••••*
; ™ roadtypeid, ! . ," '
; ™" emissionquant «.--
; ; FROM movesoutput; '>-,.**-
31
31
-------
Summing emissions across
road types
M ^ «"• j j» ^'Cra v* """ 4? .~.
O R™*irt ?
r . Firtr i in «i j It trm * t 3. M h
» 1 WS»i1K77
S *«W«4^?*
SELECT pollutantid,
sum(emissionquant) FROM
movesoutput group by
pollutantid;
'ichmnl >
«..*-.-
32
32
-------
MOVES summary report for the
same run:
Header
Run
1
HOx
181246
TotalHC
44038
Print and Close Report
Close Report
33
33
-------
vvEPA
Other example scripts for summing
output
SELECT MOVESRunID, count(*), sum(distance)
FROM MOVESActivityOutput GROUP BY
MOVESRunID;
- (count(*) returns the total number of records summed)
SELECT MOVESRunID, pollutantID, processID,
count(*), sum(emissionQuant) FROM MOVESOutput
GROUP BY MOVESRunID, pollutantID, processID;
34
34
-------
Working with MOVES Lookup
Output Tables
35
Participants do not have the database used in the following slides.
35
-------
SELECT
* FROM moveslookupoutput;
(returns 128 rows
Flic Edit View Quer> S
G Resultset 1
MQVESRurilD
».
I
'LZV,,, ,„„,«„(„,,
,1. y
i_ript Tools Window MySQL Enterprise Help
sELEfT * FROM in •- 1 1 Li| >it| it
iteratJorJD veal D monlhl D
20111
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
2010
in this example)
daj*iD
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
HU,,
-, '^
f
" - co2te£trurtoutput A
a > J p<-
r \
yntaji
Crf Dpfinh n tafernent
n\ LTrar-drf in 1 an L l-ir
Rppkahor '-fal-fnenf^
36
36
-------
SELECT * FROM moveslookupoutput
where roadtypelD = 2;
(returns 32 rows)
O Resultst
pdlutantID
saris
sas
ssss
co2t es truno utput
000474 *F
, R e
n jr ^q&^
366.01 2
0.0050674^
i-afr ents
sactionat and Locking .,,
dministratton Statements
Statements
Prepared Statement:
37
37
-------
SELECT * FROM moveslookupoutput
where roadtypeid=2 and pollutantid=90;
(Returns 16 rows)
L Enterprise Help
for Prepared 5tat
38
38
-------
SELECT * FROM moveslookupoutput
where roadtypelD = 2 and pollutantID = 90
group by avgspeedbinID;
(now ordered by speed bin)
Tools Window MySQL Enterprise Help
9° SM*
90 SfflS
, Co21..1,umulput
J&H ~H?
-.82 bl
Cdt a Manipulation sUtem^r!-
F h SQL Utility Statements
tVi ^L T^ nsactionat and Locking ..
Database Administratton Statement
Replication Statefnent5
SQL _,. nt3> for Prepared Stat
nt5
39
39
-------
SELECT pollutantID, avgspeedbinID,
emissionrate FROM moveslookupoutput
where roadtypelD = 2 and pollutantID = 90
group by avgspeedbinID;
40
40
-------
© vvEPA
Other handy things Query Browser
can do
Export result tables.
Import data.
Edit data.
History function.
41
-------
vvEPA
Export tables using the Browser
One useful way to build input databases is to first
copy the relevant information from the MOVES
default database
Use SELECT and WHERE statements as necessary
to filter the information and get the values that you
want
In Query Browser file menu, select "Export
Resultset"—can save as .csv, .xls, or other file
formats
Then you can work with these values in Excel or
other programs
42
42
-------
Export resultsets from Browser
New Resultset Tab
New Script Tab
Open Query ...
Open Script ...
ben zeneef I e stout
co2 testru nout put
activity type
mo 'esach-'ityoutput
mave'eventlog
niaveslookupouiput
ta Definition Statement^
ta Manipulation Statements
•5QL Utility Statements
SQL TrarisacSional and Locking
tabase Administration Statements,
plication 5tatements
iQL Syntax hor Prepared Sbatemenb
43
-------
Tip: Copy query statements into exported
spreadsheets for future reference
pllJm^^^^^^^W
TBffffmSBWJg^nM^K^^^ ;..(,; ^
_ |n| x|
i-ij] File Edit View Insert Format loois Data Window Help Adobe PDF _ ff x
j ^ d _i _
_j
•5. •».»>«!
A20
1 A
-U
i j a t" a ,-, -j A - / > -
^ . xl aM .
^f
f, ^^^
B 'jf C I
; £ - H U tt@] |: >-§
1
) E. 1 F | e TJ
2 SELECT* FROM sourceusetype;
3
4 sourceTypelD
5 21
6 31
7^ 32
""8 51
"in 52
10 53
11'| 54
12 43
"13" 42
"14" 41
15 I 61
2jg| 62
17 i 11
jS___^Tabtei
HPMSVtypelD sourceTypeName rollingTerrr rotatingTer dragTermC sourceMa:
20 Passenger Car 0156461 0.002002 0000493 1.4788
30 Passenger Truck 0.22112 0.002838 0.000698 1.86686
30 Light Commercial Truck 0 235003 0.003039 0 000748 2.05979
50 Refuse Truck 1.4
1705 0 0.003572 20.6845
SO Single Unit Short-haul Truck 0.561933 0 0.001603 7.64159
50 Single Unit Long-haul Truck 0498699 0 0001474 6.25047
50 Motor Home 0 61
7371 0 0.002105 6.73483
40 School Bus 0746718 0 0002176 9.06989
40 Transit Bus 1
0944 0 0.003587 16556
40 Intercity Bus 129515 0 0003715 19.5937
60 Combination Short-haul Truck 1.9
6354 0 0 004031 29.3275
60 Combination Long-haul Truck 2.08126 0 0.004188 31 .4038-^
10 Motorcycle 0.0251 0 0.000315 0.285
' j 1 j
-r\
I ±ir
: Draw - „£ AutoShapes - \ V Q O -±J _J3J -41 O jfi s_i ^ ' ^ " ^ ' ^ ^ « '^ Jl 1
Ready
^
44
44
-------
© oEPA
Load data infile
^^^^^^^^m
This statement can be used to import information
from .csv or .txt (not .xls) files into MySQL tables
Example script to update age values:
- load data infile 'c:/MOVES/Change/NewAgeDist.csv'
- Replace into table SourceTypeAgeDistribution
- fields terminated by ','
- ignore 1 lines
- (sourceTypeld,yearld,ageld,ageFraction);
45
45
-------
© oEPA
Editing data from within Query
Browser
Cell values in tables with primary keys can also be
edited from within Query Browser itself, rather than
importing alternative data:
- Highlight a cell
- Click "Edit" button
- Make any necessary changes
- Click "Apply Changes"
- Click "Edit" button again to close
46
46
-------
© oEPA
Editing data from within Query
Browser
MOVES output tables cannot be readily edited this
way, since they do not have primary keys.
Don't edit the default database!!!
- Check the title bar at the top of the Query Browser window to
make sure that the database you want to edit is active
47
47
-------
Editing data from within Query
Browser
File Edit View Query Script Toois Window MySQL Enterprise Help
Refresh E erute^ ' t
O Resultset 1 Schemata
jonelD roadTypel D S H OAllocFactra -i
* 8053° 2 — hprnt^peywi
80590 3 O.D97S94S — njvrt'.ps.
S0530 4 0.3S871 - roadtypedislribu!i0n
80590 5 0.341B81 ~ -nurretypeagedisltibulton
Data Definitinn f tatf-rnentj
Data Manipulatidn StsEements
XMyji jL Utility Statements
MySQL Transactianal and Lacking . . ,
Peplii atinn Statements
48
48
-------
© oEPA
Copy default information into new
database
You can also copy information from the default database
directly into another database without first exporting and
then importing
This is useful when you want to edit data within Query
Browser, and don't have many values to change
Example: insert into myrun.fuelformulation SELECT * FROM
MOVESDBDRAFT2009.fuelformulation where
fuelformulationid = 1061;
In this example, "myrun" is the user input database and
"MOVESDBDRAFT2009" is the default database (syntax is
"databasename.tablename")
49
49
-------
vvEPA
Using Query Browser's "history"
function
Query Browser has a history function, so that
previous statements can be selected and applied,
rather than retyping them
• Can also pull up a previous query statement and
then modify it to select the desired data
50
50
-------
Query Browser history function
File Edit View Query Script Tools Window Help
Data Manipulation
Data Definition
MySQL Utility
51
51
-------
vvEPA
Generating local input databases for
MOVES when GUI options don't exist
^^^^^^^^^^^^^^^^^^m
MOVES has several GUI options for importing
common types of local inputs (County Data
Manager, I/M Coverage Editor, etc.)
- These are covered in other parts of the course
In some cases, non-default local data would need
to be supplied through additional input databases
(as opposed to being entered through the GUI)
Since the tables in these databases must adhere to
the MOVES default names and formats, it is safer
(and easier) to base input databases on existing
tables, rather than creating them from scratch.
52
52
-------
vvEPA
One way: Copying default tables
^^^^^^^^^^^^^m
Create a new database in MySQL
In Explorer, locate the files associated with each
necessary table in the MOVES default database,
and COPY (don't MOVE) them into the new
database folder
Each table has three associated files (*.frm, *.MYD,
and *.MYI), all of which must be copied
These can then be edited using MySQL commands
53
53
-------
^^^^^^^^^^^^^^j^^BT:!.'1 :- •••'.• '''-::''-
F le Edit View Favorites Tools Help
i_3 Back *' - , ' - y \ s Search Foldets
JDi x|
J »
^/ JfefJ HTI^
Address j^O\Ny5QL\data\MOyESDB2QQ70412 _l] *3 Go
_>readrne j±3] coldsoakinitialhourfr action frrn 3f| dayofanvweek.MYD 2j] emissionrate.M'1
$ agecategory.ftm ^23] coldsoahnitialhourl'raction.Mv'D &Q dayofany^'eet .MYI J3] emissionrate.M11
'3] agecategory.MYD ^ coldsoakinitialhourfraction.MYI ^] dayvmtfraction.frm 3] emissionrateby;
Sjj agecategory.MYI |5j] cofdsoaktanktemperature.frm ,SJ] day vmtf faction. MYD _Sj| emissionrateby;
,^j agegroup,frm j^ coldsoaktanktemperature.MYD !±| dayvmtfraction.MYI ^| ernissionrateby^
^] agegroup.MYD [H coldsoaktanktemperature.MYI ^j db.op!: J3J engmesize.frm
^j agegroup . MYI jg county . f rm
J3] averagetankgasoline . f rm s^| county . MYD
,Sfj averagetankgasoline, MYD |±| county, MYI
_3] averagetankgasoline. MYI j^| countyyear.frm
_^j averagetanktemperature.Prm j^] countyyear.MYD
j3j averagetanktemperature.MYD |^| countyyear.MYI
^ averagetanktemperature.MYI l^j cumtvvcoeffs.frrn
^ avgspeedbin.frm § cumtvvcoeffs.MYD
_3j avgspeedbin.MYD g cumtvvcoeffs.MYI
^j avgspeedbin.MVI Q datasource.frm
j3j avgspeeddistribution.frm j^] datasource.MYD
^ avgspeeddistribution.MYD @] datasource.MYI
^j avgspeeddistribution.MYI j^j dayofanyweek.frm
< i
^ driveschedule.frm ^) engmesize.MYD
3 driveschedule.MYD ^| engmesize.MYI
)H driveschedule.MYI S| engmetech.frm
^] drivescheduleassoc.frm ^j engmetech.MYC
8 drivescheduleassoc.MYD 3j| engmetech.MYI
^j drivescheduleassoc.MYI ,S^| e^ tendedidleho
3] driveschedulesecond.frm ^j e; tendedidleho
^ driveschedulesecond.MYD ^j e •'tendedidleho
§ driveschedulesecond.MYI 3] fueladjusfcment.
^] emissionprocess.frm ^j fueladjustment.
JSJ] emissionprocess.MYD ^j tueladiusl:ment.
|SJ emissionprocess.MYI S| fuelengfraction
|^ emissionrate.frm §3] fuelengfraction
±J
54
Note that all tables have three parts (frm, myd and myi). All three parts must
be copied.
Use the "flush tables;" command to unlock tables that were in use.
54
-------
vvEPA
Creating a Template Database in
MOVES
A blank database can be created in MOVES from
the Manage Input Data Sets screen—this database
contains all the tables that the default database
does, with the same format, but no data
This database can then be populated with
necessary data
55
55
-------
Creating input databases
File Edit Pre Processing Action Post Processing Settings Help
jf Description
/ Sc*
ji- Geographic Bounds
rf"' Time Spans
El y VehictesJEquipment
^ On Road Vehicle Equipmer
/ RoactType
js1'' PoHutarrts And Processes
./
E\ / Stratespes
> Alternative Vehicle Fuels S
a / cwtpot
- General Output
^ i ~n
Execute active Runspec
-i
Server: \ ' Selections:
Database: jiwashoeexamplej •*• j
Description:
i Add 1
| Create Database... j
56
56
-------
© oEPA
Never, Ever, EVER Modify the
MOVES Default Database!!!
To be safe, ALWAYS create a new database in
MOVES, or copy tables from the MOVES default
database into a new database, and THEN work on
the tables
- MOVES will not alert you if you accidentally modify the default
database
- Any changes you make will be applied to all future MOVES
runs using this database
- If you modify the default database, it will also make it
extremely difficult to troubleshoot puzzling model results
Make a backup copy of the MOVES default
database, just in case ...
57
57
------- |