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 ------- |