Home

CEMDAP User`s Manual - The University of Texas at Austin

1. From Linear terms entered Persons wi 5 7896 30000 Constant Dne Zones a Variable SES 30000 onstant One A 30005 number of school going children 30182 single school going child 30183 presence of school going children Ge 30006 multiple school going children 30007 number of non school going children 30008 single non school going child 30009 presence of non school going children 30184 multiple non school going children v Coefficient 57556 Figure 4 43 Linear Regression Model Interactive User Interface When the linear regression eguation has been completely configured the dialog box looks as shown below The arrow buttons gt and lt can be used to add remove or edit terms 48 CEMDAP v 3 1 User s Manual Adult s school Start time Variance 0 0764 Regression Function Fram Linear terms entered Households A 0 1696 somecol 0 1696 assobach Zones za 0 2757 mastphd Other L 0 1389 adchild SES 1 1e 003 income Variable 0 128 presch V A kgtog4 g5tog8 gSorhigh lowage loage1 loage2 somecol Coefficient 0 1280 Figure 4 44 Example of Fully Configured Linear Regression Model Once the configuration of the individual models is finished click OK to close the model dialog box and then click the Close button to return to the corresponding model system interface and then access the next suite of models When the entire
2. Example of Constant and Corresponding Coefficient for the Utility Example of Fully Configured Multinomial Logit Model Binary Logit Model Interactive User Interface Example of Fully Configured Binary Logit Model Example of Fully Configured Ordered Probit Model Work Start End Time Model Interactive User Interface Run command in the Simulation Men Simulation in Progress Dialog Box Simulation Completed Successfully Dialog Box CEMDAP v 3 1 User s Manual Figure B 1 Run Command in Start menu of Windows 76 Figure B EE 76 Figure B 3 Command Prompt dialog box cd 77 Figure B 4 Command Prompt dialog box cd Program files postgresql 8 2 bin 77 Figure B 5 Command Prompt dialog box psgl d database name U user name 78 Figure B 6 Command Prompt dialog box C Program Files PostgreSQL 8 2 bin TestData households dat 79 CEMDAP v 3 1 User s Manual CEMDAP v 3 1 User s Manual List of Tables Table 2 1 Dala Med casein EE ED SE EH Table 22 Models Mens EE Table 2 3 Simulation Men EE able 24 Help Eege Table 3 1 Households Table with Required Variables eee Table 3 2 Persons Table with Required Vanables een Table 3 3 Zones Table with Required Variables eee Table 3 4 Zone2Zone Table and Requ
3. optional description lt unavailable gt lt Variable ID 10017 value 0 2604 optional description unavailable gt lt Variable ID 10011 value 0 2393 optional description unavailable gt lt Variable ID 10012 value 0 8228 optional description unavailable gt lt Variable ID 6 value 0 1314 optional description unavailable gt lt Variables gt lt Intervals gt lt Interval start 0 param 2 5892 gt lt Interval start 260 5 param 1 9999 gt lt Interval start 270 5 param 1 4535 gt lt Interval start lt 280 5 param 0 9721 gt lt Interval start lt 285 5 param 0 6452 gt lt Interval start 290 5 param 0 4148 gt lt Interval start 295 5 param 0 0264 gt lt Interval start 300 5 param 0 2779 gt lt Interval start lt 310 5 param 0 5515 gt lt Interval start lt 320 5 param 0 7849 gt lt Interval start 330 5 param 1 0679 gt lt Interval start 350 5 param 1 3303 gt lt Intervals gt lt ModelConfig gt 88 CEMDAP v 3 1 User s Manual 6 Location Choice Model The first line in the Location Choice Model starts with the name of the model that is coded in the ModelConfig id part The class of the model classCLocationMM is also identified in the first line of the configuration in the optional type part The second line in the syntax indicates an opening command for the variables of the model The subsequent lines then de
4. regression equation by picking the relevant variable from the Variable list and entering its parameter in the space designated Coefficient Click the arrow button gt to add the term to the linear regression expression The From option lists the sets of variables available Households contains all the household related variables from the input 47 CEMDAP v 3 1 User s Manual household table Persons contains the person related variables from the input person table and Zones contains the zonal variables from the input zones table Other which is highlighted in the figure below is a list of other variables including the constant any interaction terms and variables that may be generated during the simulation process by models higher up in the modeling framework In the figure below we enter the constant by selecting Other in the From list and Constant One from the corresponding Variable list Enter the value of the constant in the Coefficient box and click the arrow button gt to enter the constant The reader will note that the number that appears at the beginning of variables in the Other list is the ID of the variable It is the variable ID that gets stored in the model specification file and it is the variable ID that is recognized by CEMDAP These IDs are shown only for endogenous variables Adult s school Start time Variance 0 0764 Regression Function
5. 4 Zone2Zone Table and Reguired Variables Column Variable Variable Name Comment 1 Origin Zone ORIG_ZON 2 Destination Zone DEST ZON 3 Adjacent ADJACENT 1 if origin and destination zones are adjacent 4 Distance DISTANCE Miles Table 3 5 LOSdir Table with Required Variables Column Variable Variable Name Comment 1 Start time STAT T Start time of the time period of the LOS table 2 End time END T End time of the time period of the LOS table 3 Table name TBNAME Name string of the LOS table 14 CEMDAP v 3 1 User s Manual Table 3 6 LOS Table with Required Variables Column Variable Variable Name Comment 1 Origin zone ORIG ZON Destination zone DEST ZON 3 Same zone SAME ZON 4 Adjacent ADJACENT gt Distance DISTANCE miles 6 DA IVTT DA IVIT minutes 7 DA OVTT DA OVIT minutes 8 Transit availability TR AVAIL 9 Transit IVTT TR IVTT minutes 10 Transit OVTT TR OVTT minutes 11 Transit cost TR COST Dollars 12 DA cost AU COST Dollars Appendix A shows all the tables and variables including the required variables and some additional variables used in the current implementation of CEMDAP for the DFW area The Data Inputs are required to be in the postgreSQL database format The input tables in the postgreSQL database must take titles as specified above and the variables must be of the double type The variables names are not pre specified each variable is identified by the sp
6. 5 7896 lt ModelConfig id Adult s school start time time from 3 AM optional type class CRegressMM gt lt Variance gt 0 0764 lt Variance gt lt Variables gt lt Variable ID 30000 value 5 7896 optional description temp gt lt Variable ID 10023 value 0 1696 optional description temp gt lt Variable ID 10024 value 0 1696 optional description temp gt lt Variable ID 10025 value 0 2757 optional description temp gt lt Variable ID 10040 value 0 1389 optional description temp gt lt Variable ID 10026 value 0 0011 optional description temp gt lt Variable ID 16 value 0 1280 optional description temp gt lt Variables gt lt ModelConfig gt 4 Ordered Probit Model The first line in the Ordered Probit Model starts with the name of the model that is coded in the ModelConfig id part The class of the model classCOrdProbitMM is also 86 CEMDAP v 3 1 User s Manual identified in the first line of the configuration in the optional type part The second line indicates an opening command for the variables of the model The subsequent lines then describe the various parameters associated with that model In order to describe the variables the Variable ID of each variable is first entered in the Variable ID part and then the corresponding parameter of the variable is coded in the value part It is also possible to give a description for the variable in the optional description
7. 90
8. File name DFW modeleonfiguration cmi M 5 Je Save as type CEMDAP Model Files cml v 2 My Network Figure 4 42 Save As Dialog Box from the Load Command 4 4 5 Configuring specific model types All the model components in the embedded model system fall into one of seven categories based on their econometric structures Linear Regression Hazard Duration Binary Logit Multinomial Logit Location Choice Ordered Probit or Work Start End Time please see Guo et al 2005 for a discussion on the structure of work start end time model and Pinjari et al 2006 for all the model components and their prescribed econometric structures in CEMDAP In this section we take an example of each of these model types and illustrate their methods of configuration Note Clicking OK in any dialog box only saves the information temporarily In order to save a model configuration choose the Save command in the Models Menu Linear Regression An example of a linear regression model is the Adult s School Start Time Note that the dependent variable in the regression models for duration is assumed to be the log of the duration This is done to ensure that we always predict a positive value The inputs required for this model are the variance parameter the variable parameters and variables in the linear regression equation First enter the variance in the box titled Variance in the top left corner of the dialog box Then enter the linear
9. Joint nite Models MENU EE 31 Figure 4 22 Interactive UI in the Models men 31 Figure 4 23 Main Dialog Box of the Interactive User Interface 32 Figure 4 24 Generation Allocation Model System Interactive User Interface 33 Figure 4 25 Generation amp Timing of Work and School Activities of Adults Interactive User Interface sees zan ie mechs tess EEN 34 CEMDAP v 3 1 User s Manual Figure 4 26 Generation of Children s Travel Needs and Allocation of Responsibilities to Parents Interactive User Interface Figure 4 27 Generation of Independent Activities by Adults and Children for Personal and Household Serving Needs Interactive User Interface Figure 4 28 Scheduling Model System Interactive User Interface Figure 4 29 Scheduling of Work to Home Commute for Worker Interactive User are E Figure 4 30 Scheduling of the Home to Work Commute for a Worker Interactive USE IA AA MA teg Figure 4 31 Scheduling of the Tour Containing the Drop off Activity for a Nonworker Interactive User Interface ke s kna ek ese ana Na ka ete Figure 4 32 Scheduling of the Tour Containing the Pick up Activity for a Noriworker Interactive User Interface ss cist Gidse ieke N dards a po een Figure 4 33 Scheduling of the Tour Containing the Pick up Activity for a Nonworker Interactive User Interface AAA Figure 4 34 Scheduling of the J
10. been configured refer to the figure on the next page enter the threshold parameters First in the box titled Baseline time intervals enter the number of discrete time periods N into which the duration is divided Note Please do not enter zero because there cannot be zero number of discrete time periods Then to enter the threshold parameters number of threshold parameters N 1 click Edit Additional boxes open up to enter the start times of each of the discrete periods and the corresponding parameter estimates seguentially from start time of the second discrete period to the start time of the last discrete period hence there are N 1 parameters Note The end time of any discrete duration period is the start time of the next period The start time of the first discrete period is to be specified as zero while the end time of the last discrete period which is not specified is implicitly taken as infinity Click on the arrow buttons gt and lt to scroll When the hazard model is fully configured the dialog box looks as shown below Note If the user needs to change the number of base line time intervals after clicking Edit it is advised that the model configuration be cancelled and reconfigured 50 CEMDAP v 3 1 User s Manual Children s school Start time Variance 0 21 53 Duration Function From Linear terms entered Households 0 5034 lowage S si 0 2604 kgtogd 0 2393 afriamer 0 8228 asi
11. implemented Allocation of the Joint Discretionary Activity to One of the Parents GA15 Figure 4 26 Generation of Children s Travel Needs and Allocation of Responsibilities to Parents Interactive User Interface 35 CEMDAP v 3 1 User s Manual CEMDAP Generation of Independent Activities by Adults and Children for Personal and Household Serving Needs x For each child not undertaking joint discretionary activity Decision to Undertake Independent Discretionary Activity GA16 Decision of Household to Undertake Grocery Shopping GA17 Household undertakes shopping Single person household Multiple person household For each adult Activity allocated to the single adult Decision to Undertake Shopping Given that Household Undertakes Grocery Shopping GA18 For each adult Decision to Undertake Personal Household Business Activities GA19 For each adult Decision to Undertake Social Recreational Activities GA20 For each adult Decision to Undertake Eat out Activities GA21 Figure 4 27 Generation of Independent Activities by Adults and Children for Personal and Household Serving Needs Interactive User Interface When all the components of the generation allocation model system have been configured click Close to return to the main dialog box The scheduling system user interface shown on the next page can be obtained by clicking on the Scheduling Model System button in the Overall Modelin
12. in pgAdmin III under the Table icon and filename is the complete path name of the file from which data is to be loaded 5 Step four must be repeated for each table that needs to be populated with data i e losdir losoffpk lospeakam lospeakpm persons zone2zone and zones 6 Exit out of the Command Prompt window 2 3 Create Index Once all files are loaded into the database you will need to create indices for all tables households losoffpk etc To do so you can follow two ways 79 CEMDAP v 3 1 User s Manual One of the ways of creating indices can be performed by directly using a sql statement to create the indexes for all the tables that you have To do so 1 In the pp ADMIN window Select Tools gt Query Tool from the menu 2 Paste the query statement provided below into the Query window and press F5 or select Query Execute from the menu to run the query Once you run the query a message will appear Query returned successfully with no result exit the Query window Click NO to saving the text right click on the Tables icon and then click Refresh to see the indices updated CREATE UNIQUE INDEX households_1x ON households USING btree hid CREATE UNIQUE INDEX losdir_1x ON losdir USING btree start_t end_t CREATE UNIQUE INDEX losoffpk_1x ON losoffpk USING btree orig zon dest_zon CREATE UNIOUE INDEX lospeakam 1x ON lospeakam USING btree orig zon dest zon CREA
13. may also have additional columns corresponding to additional explanatory variables used in the underlying empirical models Overall each exogenous variable must have a corresponding column in the appropriate table The structure of each of the input tables is presented below identifying only the required data items and their ordering within the tables Additional columns are simply appended to these tables Table 3 1 Households Table with Required Variables Column Variable Variable Name 1 Household ID HID 2 Number of adults N_ADULTS 3 Total number of HH vehicles N_AUTOS 4 Home TSZ location ZONE ID 5 Number of children KIDS 6 Household structure Structure 13 CEMDAP v 3 1 User s Manual Table 3 2 Persons Table with Required Variables Column Variable Variable Name 1 Household ID HID 2 Person ID PID 3 Employed EMPLOYED 4 Student STUDYING 5 Driver s license LICENSE 6 Location of work WORK ZON 7 Location of school STUD ZON 8 Female FEMALE 9 Parent PARENT Table 3 3 Zones Table with Reguired Variables Column Variable Variable Name 1 Zone ID ZID 2 Dallas CBD DALCBD 3 Fort Worth CBD FWCBD 4 Distance to the nearest shopping mall SHOPDIST gt Accessibility to retail employment REMPACC 6 Accessibility to retail and service employment RSEMPACC 7 Distance to the nearest shopping mall SHOPDIST 8 Zonal service employment SEMP 9 Zonal retail employment REMP 10 Zonal population NUMPERS Table 3
14. number 3 Work school start time 4 Work school end time 5 Number of before work tours 6 Number of work based tours 7 Number of after work tours Table 3 10 Childstu Out Format and Content Column No Description 1 Household identification number 2 Person identification number 3 School start time 4 School end time 5 Child gets dropped off at school by parent 6 Child gets picked up from school by parent Table 3 11 Nonworkers Out Format and Content Column No Description 1 Household identification number 2 Person identification number 3 Total number of tours made 17 CEMDAP v 3 1 User s Manual Table 3 12 Tours Out Format and Content Column No Description 1 Household identification number 2 Person identification number 3 Tour identification number 4 Home work stay duration before tour 5 Tour mode 6 Tour duration 7 Number of stops in tour Table 3 13 Stops Out Format and Content Column No Description 1 Household identification number 2 Person identification number 3 Tour identification number 4 Stop identification number 5 Activity type 6 Start time of travel to the stop 7 Travel time to stop 8 Stop duration 9 Stop location zone ID 10 Origin zone ID 11 Trip distance zone to zone 12 Activity type at the previous stop 18 CEMDAP v 3 1 User e Manual Chapter 4 Basic Operations 4 1 REGISTERING THE INPUT DATABASE The input database which is in the
15. or nuclear family household Adchild 42 Person is 16 years of age or older Adult 43 Hispanic Hisp 44 Other race Othrace 45 Grade 8 or lower completed adult G8orlow 64 CEMDAP v 3 1 User s Manual 46 Grade 9 to grade 12 completed adult G9tog12 47 High school completed adult Highsch 48 Total weekly work duration excluding weekend Workhrs 49 Work duration greater than 40 hours a week Wdurhigh 50 Medium work flexibility Medflex 51 Low or no work flexibility Lowflex 52 Employment type other industries Emptype6 Table A 3 Zones Table Specification for DF W Area column Variable Description variable Name 1 TSZ zone id ZONEID 2 Distance to the nearest major shopping zone SHOPDIST 3 Accessibility with cost retail employment REMPACC 4 Accessibility to retail service employment RSEMPACC 5 Accessibility to total employment TEMPACC 6 Accessibility to population POPACC 7 Dallas CBD dummy variable DALCBD 8 Fort Worth CBD dummy variable FWCBD 9 Median income of the zone 1000s of Dollars MEDINC 10 Number of households in the zone NUMHH 11 Number of persons in the zone NUMPERS 12 Basic employment in the zone BEMP 13 Retail employment in the zone REMP 14 Service employment in the zone SEMP 15 Total employment in the zone TOTEMP 16 Parking cost PARKCOST 17 County COUNTY 18 Special land use SPLLUSE 19 Internal zone dummy variable INTERNAL Note The procedure to calculate the accessibility measures
16. part Once the entire set of variables embedded in the model are defined variables part is closed The reader will note that each row under the lt Variables gt command represents a single variable The following line indicates an opening command for the threshold values of the model The values of each threshold are entered in the Threshold value part one by one Once the entire threshold values are entered the model is closed The following configuration presents the framework for one of the Ordered Probit models in CEMDAP Number of stops in a tour before work tour The first variable of the model has a variable ID of 30085 and the corresponding value of the parameter is 0 728 There are four threshold parameters in this model and their values are 3 1768 4 0896 4 7494 and 5 194 lt ModelConfig id Number of Stops in a tour before work tour optional type class COrdProbitMM gt lt Variables gt lt Variable ID 30085 value 0 728 optional description lt unavailable gt lt Variable ID 30104 value 0 402 optional description unavailable gt lt Variable ID 30092 value 0 0024 optional description unavailable gt lt Variable ID 30093 value 0 763 optional description lt unavailable gt lt Variable ID 30094 value 0 7391 optional description unavailable gt lt Variable ID 30096 value 0 5848 optional description unavailable gt lt Variable ID 30070 value 0 2946 optional descrip
17. service employment 2 total employment and 3 population e Sum over all internal zones excluding the airport zones if we don t have the internal identifier sum over all zones except the airport zones The airport zones are identified in the special land use variable There measures have to be re evaluated when the corresponding size measure changes 68 CEMDAP v 3 1 User s Manual Appendix B Input Database Preparation in PostgreSQL Format This document provides the instructions for setting up PostgreSQL and the CEMDAP dataset on your computer 1 Installing PostgreSQL 1 Go to the PostgreSQL on line download page at http www posteresgl org ftp binary and click on the latest folder of PostgreSQL Le the click on the folder that is farthest down the page that is not a beta version Note these instructions assume a version 8 2 4 is downloaded Next locate the win32 folder and click on it Next locate and download the file postgresql 8 2 4 1 zip from one of the mirror sites onto a temporary directory e g C Temp on your machine either http or ftp Note that the filename of the file changes with the version number Locate and extract the zip file Run the Windows Installer postgresql 8 2 msi the file name varies with the version number Follow the installation instructions listed on http pginstaller projects postgresgl org Tips a In the Service configuration page 1 Install as a
18. that the list of variables supported by the work start and end time model is pre determined and available only under the Other variables list The user must use only these variables in the calibration and enter the parameters appropriately 57 CEMDAP v 3 1 User s Manual Work Start End Time Function From Linear terms entered Persons 0 345 30000 Constant One Zones Other Variable 30000 Constant Dne CONST ID ST END MODEL 30264 CONST ID ST END MODEL 30265 CONST ID ST END MODEL 30266 CONST ID ST CONST ID ST END MODEL 30267 CONST ID ST END MODEL 30268 CONST ID ST CONST DST END MODEL 30269 END MODEL 30270 END MODEL ala lo Coefficient Cancel Figure 4 53 Work Start End Time Model Interactive User Interface 4 5 INITIATING A SIMULATION RUN Prior to starting a simulation ensure that the input database is registered and loaded the output files are specified and the model system is completely configured Then select the Run command in the Simulation Menu CEMDAP Data Models EME Help Input database Unspecified Input configuration file Unspecified Sampling at 100 0 Database Type PostgreSQL Figure 4 54 Run command in the Simulation Menu 58 CEMDAP v 3 1 User s Manual The progress bar is launched whenever a simulation run is initiated and serves to keep track of the progress of the simulation In particular the progress
19. 2 Giga Hertz or above processing speed The operating systems supported include Windows NT 4 Windows 2000 and Windows XP 1 2 INSTALLATION INSTRUCTIONS To install CEMDAP in your system find the Cemdap_5Threads msi or Cemdap 10Threads msi file in the installation CD and follow the steps outlined below 1 Double click Cemdap 5Threads msi or Cemdap 10Threads msi to run the CEMDAP setup wizard 2 Inthe Welcome screen click Next to continue i Cemdap Welcome to the Cemdap Setup Wizard s PX The installer will guide you through the steps required to install Cemdap on your computer WARNING This computer program is protected by copyright law and international treaties Unauthorized duplication or distribution of this program or any portion of it may result in severe civil or criminal penalties and will be prosecuted to the maximum extent possible under the law Figure 1 1 Cemdap Setup Wizard Welcome Screen Use Cemdap_5Threads msi for machines with Random Access Memory less than 1 GB and use Cemdap_10Threads msi for machines with Random Access Memory greater than 1 GB CEMDAP v 3 1 User s Manual 3 This leads to the Select Installation Folder screen Choose the destination location and folder name for the program installation for example C Program Files University of Texas Cemdap and click Next to continue i Cemdap Select Installation Folder The installer will install Cemdap to the following fo
20. 996 Age 10 Adult is a parent Parent 11 Caucasian Cauc 12 African American Afamer 13 Asian or pacific islander Asian 14 Gender of the person Male 15 Personal vehicle availability vehicles Licensed Drivers pvehavbl 16 High work flexibility Highflex 17 Pre school completed child Presch 18 Kindergarten to grade 4 completed child kgtog4 19 Grade 5 to grade 8 completed child G5tog8 20 Grade 9 or higher completed child G9orhigh 21 Age of the person lt 5 years Lowage 22 Lowage one employed adult in household loagel 23 Lowage two employed adults in household loage2 24 Some college completed adult Somecol 25 Associate or bachelors degree completed adult Assobach 26 Masters or PhD degree completed Mastphd 27 Income in 1000s of dollars Income 28 Income HH income Incomef 29 Work duration between 0 and 20 hours a week Wdurlow 30 Work duration between 20 and 40 hours a week Wdurmed 31 Employment type construction and manufacturing Emptypel 32 Employment type wholesale and transportation Emptype2 33 Employment type personal professional and financial services Emptype3 34 Employment type public and military Emptype4 35 Employment type retail and repair Emptype5 36 Female parent in a single parent or nuclear family household Mother 37 Male parent in a single parent or nuclear family household Father 38 No school completed child Nosch 39 Child not a student Cnotstu 40 Adult is unemployed Aunemp 4 Adult son or daughter in a single parent
21. AP v 3 1 User s Manual using the embedded modeling framework This method is recommended for first time model parameter input 3 The model parameters for all the model components can be coded into a text file model configuration file in a prescribed format and then loaded into the system using the Load command in the Models Menu A sample model configuration file can be found in data under the installation destination directory Appendix C describes the prescribed format of the model configuration file For beginners and or initial users it is recommended to specify the model parameters using the Graphical User Interface instead of coding them in the model configuration file 3 2 OUTPUT DATA FILES CEMDAP produces as output the complete activity travel patterns for a day for every individual in the population of interest There are seven output files corresponding to characteristics of 1 Adults 2 Children 3 Workers 4 Students 5 Non workers 6 Tours and 7 Stops Each of these files is partitioned into smaller subsets based on the number of threads The files Adults out and Children out contain the decisions to undertake activities of different types for adults and children respectively The files Workers out Nonworkers out and Childstu out contain the pattern level attributes of the workers including adult students non workers and child students patterns respectively The files Tours out and Stops out co
22. Binary Logit Model The first line in the Binary Logit Model starts with the name of the model that is coded in the ModelConfig id part The class of the model classCBLogitMM is also identified in the first line of the configuration in the optional type part The second line in the syntax indicates an opening command for the variables of the model The subsequent lines then describe the various parameters associated with that model In order to describe the variables the Variable ID of each variable is first entered in the Variable ID part and then the corresponding parameter of the variable is coded in the value part It is also possible to give a description for the variable in the optional description part Once the entire set of variables embedded in the model are defined the model is closed The reader will note that each row under the lt Variables gt command represents a single variable The following configuration presents the framework for one of the Binary Logit models in CEMDAP Children s decision to go to school The first variable for the Children s decision to go to school model is constant that has a variable ID of 30000 and the corresponding value of the parameter is 0 5765 84 CEMDAP v 3 1 User s Manual lt ModelConfig id Children s decision to go to school optional type class CBLogitMM gt lt Variables gt lt Variable ID 30000 value 0 5765 optional description unavailable gt lt Variabl
23. CEMDAP s Manual User 40 AM 9 D CEMDAP v 3 1 User s Manual Table of Contents TABLE OF CONTENTS sissisisssscssssssssesesscsasessnsdtevensssosonssasteseassovsssses Gee ji Ge Seed deeg ee RSA Ge Gee de de ode ken 1 INTRODUCTION EE EE ER OE ETE EO ua 1 CHAPTER 1 SYSTEM REQUIREMENTS AND INSTALLATION INSTRUCTIONS 3 1 1 MINIMUM SYSTEM REOUIREMENTS ee esse se see ee ee ee mmama 3 1 2 INSTALLATION INSTRUCTIONS AAA 3 1 3 TO UNINS TALL iera er se sege Re Ee Ee eg see Ge REG A Ne Gede gee Re A ra 6 CHAPTER 2 THE CEMDAP ENVIRONMENT ese sesse se se se ese sesse se se se ese sesse se se ee ese sesse se se ee ese sesse se 9 CHAPTER 3 INPUT AND OUTPUT FILES esse se se se ese sesse se se se ese sesse se se se ston ene ee se Se Se once 13 3 INPUT DATA SPECIFICATION eenen oe eke egg ee skeep ee eed resty eed eg ke E gegee date 13 Be diel Data io OE EE EE TA on Ee deka 13 3 1 2 Model Gpecthicoottons noone 15 9 2 OUTPUT DATA FILES sine ena hin A a ala a aii 16 CHAPTER 4 BASIC OPERATION G ccccscsssssssssssssssssssssssssssssssssssssessessssssssssssssssssssessessesessesesees 19 4 1 REGISTERING THE INPUT DATABASE een 19 4 2 LOADING THE INPUT DATA FILE si 5a gese ooo d ka 23 4 3 SPECIFYING THE OUTPUT FILES s iii bs hara i boho 24 4 4 CONFIGURING THE MODEL SYSTEM eee nn 25 4 4 1 Accessing model module dialog boxes through the Models Menu 25 4 4 2 Accessing model module dialog boxes through the Interactive User I
24. EMDAP 10Threads in the Start menu under All Programs and double click on cemdap exe This opens up the following main window of CEMDAP Menus CEMDAP e Data Mei Simulation Help Deuibesr Input database Unspecified Input configuration file Unspecified Sampling at 100 0 Database Type PostgreSQL CEMDAP Figure 2 1 CEMDAP Main Window and Menus Main Window The above main CEMDAP window remains open as long as the software is being used and it hosts the important menu items and other dialog boxes The primary functionality of CEMDAP lies within the menu commands The commands below available from the menu bar and their functions are tabulated below CEMDAP v 3 1 User s Manual Table 2 1 Data Menu Choose JO fra Load the input data The input data must be registered prior to P loading it refer to Chapter 3 for details BE Specify the names and locations for the output files The output P file formats are described in detail in Chapter 3 Exit Ouit from the CEMDAP environment Table 2 2 Models Menu Choose bas Load the model configurations from file refer to Chapter 4 on Load 3 Basic Operations for instructions on configuring models Gees Save the model configurations to file refer to Chapter 4 on Basic Operations for instructions on configuring models Generation Allocation Scheduling Children To access the model configuration dialog boxes fo
25. Es Simulation Help M Load Save Generation Allocation Inpt Scheduling Children San Scheduling Worker Dat Scheduling Non Worker Scheduling Joint Children s Activities Independent Activities v xv v wha Children s Decision to go to School Children s School Start Time Children s School End Time Adult s Decision to go to Work Adult s Work Start and End Times Interactive UI Decision to take Work related Activities Adult s Decision to go to School Adult s School Start Time Adult s School End Time Figure 4 11 List of Work and School Activities Models within Generation Allocation in the Models menu CEMDAP Data Bag Simulation Help Generation Allocation Work and School Activities DI Load Save Scheduling Children al San Scheduling Worker Dat Scheduling Non Worker gt Scheduling Joint Children s Activities Independent Activities gt Interactive UI Figure 4 12 List of Children s Activities Models within Generation Allocation in the Models menu 26 Children s Mode to School Children s Mode from School Allocation of Drop off Episode to Parent Allocation of Pick up Episode to Parent Allocation of Joint Disc Episode to Parent Children s Decision to take Disc Activity with Parent CEMDAP v 3 1 User s Manual CEMDAP Data BOIS Simulation Help E Lo
26. Files User MS Access Database User PostgreSQL System TestData PostgreSQL System Test Data TripsDSN User Xtreme Sample Database 2 System A Machine Data Source is specific to this machine and cannot be shared User data sources are specific to a user on this machine System data sources can be used by all users on this machine or by a system wide service Figure 4 7 Final Select Data Source Screen 4 2 LOADING THE INPUT DATA FILE Any PostgreSQL database that satisfies the prescribed format refer to Chapter 3 and that has been registered as explained above can be loaded in CEMDAP as input The following procedure should be followed to load the input data Note If the database has just been registered this step i e loading the input data file step must be skipped These steps are essential for loading an already registered database 1 Click on the Input command in the Data Menu of CEMDAP 23 CEMDAP v 3 1 User s Manual Models Simulation Help m ie Output se Unspecified ration file Unspecified Sampling at 100 0 Database Type PostgreSQL Exit Figure 4 8 Input command in the Data menu 2 2 In the Select Data Source dialog that opens up select the Machine Data Source tab first figure on this page and choose the registered data source to be loaded for example PostgreSQL30 3 Click OK and the input data is loaded 4 3 SPECIFYING THE OUTPUT FILES Duri
27. TE UNIOUE INDEX lospeakpm 1x ON lospeakpm USING btree orig zon dest zon CREATE UNIQUE INDEX persons 1x ON persons USING btree pid hid CREATE UNIQUE INDEX zone2zone 1x ON zone2zone USING btree orig zon dest zon 80 CEMDAP v 3 1 User s Manual CREATE UNIQUE INDEX zones_1x ON zones USING btree zid The second way of creating indexes is as follows 1 Go back to the Database Explorer in pgAdmin III 2 Go to Schemas gt Public gt Tables 3 For each table listed under Tables a Right click on Indexes 0 b Select New Index to open the New Index dialog box c On the Properties tab page enter the name of the index as name of the file 1x for example enter households 1x for the households table Check Unique d Next go to the Columns page and add the column name s as shown in the table below Table B 1 Column names of Postgres Tables Table Name Column s used for indexing households hid Losdir start t end t Losoffpk orig zon dest zon Lospeakam orig zon dest zon Lospeakpm orig zon dest zon Persons hid pid zone2zone orig zon dest zon Zones zid If an index is set up correctly you will see that Index 0 has become Index 1 81 CEMDAP v 3 1 User s Manual 82 CEMDAP v 3 1 User s Manual Appendix C Structure of the Model Specification File All the components of the
28. User s Manual CEMDAP Scheduling of the Tour Containing the Drop off Activity for a Nonworker If nonworker undertakes independent non work activities Number of Additional Stops in the Tour NWSCH6 If there are one or more stops in the tour for each stop i Activity Type For the th Stop NWSCH8 Activity Duration for the ith Stop NWSCH9 Travel Time to the i th Stop NWSCH10 Location of the i th Stop NWSCH11 Figure 4 31 Scheduling of the Tour Containing the Drop off Activity for a Nonworker Interactive User Interface 40 CEMDAP v 3 1 User s Manual CEMDAP Scheduling of the Tour Containing the Pick up Activity for a Nonworker If nonworker undertakes independent non work activities Number of Additional Stops in the Tour NWSCH a If there are one or more stops in the tour For each stop i Activity Type For the i th Stop NWSCH8a Activity Duration For the th Stop NWSCH9a Travel Time to the ith Stop NWSCH10a Location of the ith Stop NWSCH1 la Figure 4 32 Scheduling of the Tour Containing the Pick up Activity for a Nonworker Interactive User Interface CEMDAP Scheduling of the Home School Home Commutes for all Children not Escorted to School OR Escor School to Home Commute Duration CSCH1 Home to School Commute Duration CSCH2 Figure 4 33 Scheduling of the Tour Containing the Pick up Activity for a Nonworker Interactive User Interf
29. ace 41 CEMDAP v 3 1 User s Manual CEMDAP Scheduling of the Joint Discretionary Tour Undertaken by a Worker with Children Departure Time For the Tour INTSCH1 Activity Duration at Stop INTSCH2 Travel Time to Stop INTSCH3 Location of Stop JMTSCH4 Figure 4 34 Scheduling of the Joint Discretionary Tour Undertaken by a Worker with Children Interactive User Interface Activity Duration at Stop JNTSCH2a Travel Time to Stop INTSCH3a Location of Stop INTSCH4a Figure 4 35 Scheduling of the Joint Discretionary Tour Undertaken by a Nonworker with Children Interactive User Interface 42 CEMDAP v 3 1 User s Manual CEMDAP Scheduling the Independent Home based amp Work based Tours for Workers who als X gt 1 after work tours Number of After Work Tours WSCH4 0 after work tours Schedule the Afte gt 1 work based tours Number of Work based Tours WSCHS SEELEN TR ra 0 work based tours Schedule the Work based Tours gt 1 before work tours Number of Before Work Tours WSCH6 Schedule the Before Work Tours Figure 4 36 Scheduling of the Independent Home based amp Work based Tours for Workers Interactive User Interface CEMDAP Scheduling Independent Tours for Nonworkers Nonworker undertakes either pick up activity or joint discretionary activity with children Nonworker does not undertake either pick up activity or joint discretionary activity with
30. ad Generation Allocation Work and School Activities gt Inpt Scheduling Children gt Children s Activities San Scheduling Worker a Children s Decision to take Independent Disc Activity HH Shopping Activity Generation Shopping Activity Allocation Personal Activity Generation Social Activity Generation Eating Activity Generation Service Activity Generation Dat Scheduling Non Worker Scheduling Joint Interactive UI Figure 4 13 List of Independent Activities Models within Generation Allocation in the Models menu CEMDAP Data Bima 50 Simulation Help Load Save Generation Allocation Scheduling Children School to Home Commute Time San Scheduling Worker gt Home to School Commute Time b 5 Dat Scheduling Non Worker Scheduling Joint Mode For Discretionary Tour Departure Time From Home For Discretionary Tour Activity Duration at Discretionary Stop Travel Time to Discretionary Stop Location Choice For Discretionary Stop Interactive UI Figure 4 14 List of Scheduling Children Models within the Models menu 27 CEMDAP v 3 1 User s Manual CEMDAP Load Save Generation Allocation gt Scheduling Children Scheduling Worker Commute Mode WS5CH1 Scheduling Non Worker Work to Home Commute Number of Stops WSCHZ Scheduling Join
31. ailable gt lt Variable ID 30172 value 0 2544 optional description unavailable gt lt Variable ID 30173 value 0 2024 optional description unavailable gt lt Variable ID 30174 value 0 1577 optional description unavailable gt lt Variable ID 30175 value 0 2264 optional description unavailable gt lt Variable ID lt 30176 value 0 2287 optional description unavailable gt lt Variables gt lt ModelConfig gt 7 Work Start and End Time Model The first line in the Work Start and End Time Model starts with the name of the model that is coded in the ModelConfig id part The class of the model class CStartAndEndTimeMM is also identified in the first line of the configuration in the optional type part The second line in the syntax indicates an opening command for the variables of the model The subsequent lines then describe the various parameters associated with that model In order to describe the variables the Variable ID of each variable is first entered in the Variable ID part and then the corresponding parameter of the variable is coded in the value part It is also possible to give a description for the variable in the optional description part Once the entire set of variables embedded in the 89 CEMDAP v 3 1 User s Manual model are defined the model is closed The reader will note that each row under the lt Variables gt command represents a single variable The following configuratio
32. ains how the complete model configuration entered using the dialog boxes can be saved in a file Section 4 4 4 explains how to load a model configuration file into CEMDAP All the model components fall into one of seven categories Linear Regression Hazard Duration Multinomial Logit Binary Logit Location Choice Ordered Probit or Work Start End Time Section 4 4 5 takes an example of each of these types to explain how they must be configured Note For Testing purposes the reader is recommended to skip to Section 4 4 4 to load the ready made model configuration file provided in the CEMDAP CD labeled as CEMDAP DFW Model Specification file cml 4 4 1 Accessing model module dialog boxes through the Models Menu The model configuration dialog boxes for each of the model components can be accessed through the Models Menu Each entry in the Models Menu allows access to a specific suite of model components Clicking on any of the models in each suite opens up the corresponding dialog box to configure the model see the following figures For example the figure below shows that the models such as Children s decision to go to school can all be accessed by clicking on Work and School Activities under 25 CEMDAP v 3 1 User s Manual Generation Allocation The subsequent figures in the following pages show how each of the remaining CEMDAP model components can be directly accessed from the menu items CEMDAP Data BO
33. ame zon float8 adjacent float8 distance float8 da ivtt float8 da ovtt float8 tr avail float8 tr ivtt floats tr ovtt float8 tr cost float8 au cost float8 WITH OIDS ALTER TABLE lospeakpm OWNER TO postgres Table zone2zone DROP TABLE zone2zone CREATE TABLE zone2zone orig zon floats dest zon float8 adjacent float8 distance float8 WITH OIDS ALTER TABLE zone2zone OWNER TO postgres 74 CEMDAP v 3 1 User s Manual Table zones DROP TABLE zones CREATE TABLE zones zid floats shopdist floats rempacc float8 rsempace float tempacc float popacc floats dalcbd float8 fwcbd floats medinc float8 numbh floats numpers floats bemp floats remp float semp float8 totemp float parkcost float county floats splluse floats internal float8 WITH OIDS ALTER TABLE zones OWNER TO postgres 75 CEMDAP v 3 1 User s Manual 2 2 Load Tables The process of loading data files into the tables is done in DOS environment under command prompt To do so 1 Open the Command Prompt window To do this a Click on Start Run in windows w Microsoft Office Word 2003 Control Panel Set Program Access and Microsoft Office Excel 2003 Defaults R Du Printers and Faxes Adobe Reader 8 EA EF N EN V Help and Support p Notepad 5 po Search w gauss exe GE Run v Paint Microsoft Office PowerPoint 2003 WinRAR All Programs gt Ope
34. an Variable 0 1314 stud_zon hid pid employed studying license work_zon stud_zon female age Coefficient Baseline time intervals 5 Base Line Hazard Time Marker 1 2 3 4 Time 0 2ea5 m 280 5 Parameter 25892 1 9999 1 ug Figure 4 46 Example of Fully Configured Hazard Duration Model Multinomial Logit An example of a multinomial logit model is the Commute Mode Choice Model within the Worker s Activity Travel Scheduling model system The discrete choices for this model are drive alone share auto ride as a passenger share auto ride as a driver transit and walk bike The model configuration dialog box for this looks as follows al CEMDAP v 3 1 User s Manual WH commute mode Utility Function Alternative Drive Alone Linear terms entered Persons Zones Other Variable hid pid employed studying license work_zon stud_zon female age Coefficient i Clear function Cancel Figure 4 47 Multinomial Logit Model Interactive User Interface To configure the multinomial logit model the utility functions of each of the alternatives must be specified Select the alternatives one at a time from the drop down menu titled Alternative to configure the corresponding utility function In the example shown above we have selected the Drive alone alternative To configure the utility function for the drive alone alternative select the releva
35. ared for the Texas Department of Transportation October 2005 A Pinjari N Eluru R Copperman I N Sener J Y Guo S Srinivasan and C R Bhat Activity Based Travel Demand Analysis for Metropolitan Areas in Texas CEMDAP Models Framework Software Architecture and Application Results Report 4080 8 prepared for the Texas Department of Transportation October 2006 61 CEMDAP v 3 1 User s Manual 62 CEMDAP v 3 1 User s Manual The input data requirements for running a simulation of the Dallas Fort Worth D FW metropolitan area are dependent on the model configurations estimated for D FW This input data therefore includes not only the required variables specified in Chapter 3 but also additional variables that are specific to the estimated D FW models The folder test_data included in the data directory under the installation destination directory contains the data required for a small sample of the D FW population for test purposes Appendix A D FW Input Data The following tables contain the specifications for the input datasets Table A 1 Households Table Specification for D FW Area Column Variable Description variable Name 1 Household ID HHID 2 Number of adults age gt 18 NADULT 3 Total number of HH vehicles including motorcycles and RVs NVEH 4 Home TSZ location HOMETSZ 5 Number of children NCHILD 6 Household structure HHSTRUCT 7 Number of unemployed adults NAUNEMP 8 Household income i
36. bar displays the number of households processed time elapsed estimated simulation time left number of threads running and the number of threads completed Simulation inprogress Number of Mousehokis Processed Simulation time secs Estimated time left secs Num of Threads Running Num of Threads Completed COT Figure 4 55 Simulation in Progress Dialog Box The title of the progress bar reads Simulation in Progress when the simulation is in progress and reads Simulation Completed Successfully when it is completed Simulation Completed Successfully Number of Househokis Processed Simulation time secs Estimated time left secs Num of Threads Running Num of Threads Completed PTE ET TTT Cx Figure 4 56 Simulation Completed Successfully Dialog Box Click OK and close the progress bar and ensure that the output files have been created The output files can then be imported into any spreadsheet and the simulated activity travel patterns of the population can be analyzed 59 CEMDAP v 3 1 User s Manual 60 CEMDAP v 3 1 User s Manual REFERENCES Guo J Y S Srinivasan N Eluru A Pinjari R Copperman and C R Bhat Activity Based Travel Demand Analysis for Metropolitan Areas in Texas CEMSELTS Model Estimations and Prediction Procedures 4874 Zone System CEMDAP Model Estimations and Procedures and the SPG Software Details Report 4080 7 prep
37. ble IDs and explanations used in the models can be found in the corresponding models in the GUI To close the model each opening statement should be closed The reader will note that each statement should start with an opening command and end with a closing command That is the name and the class of the models are captured between the opening lt ModelConfig gt command and the closing lt ModelConfig gt command All the variables in the model are captured between the opening lt Variables gt command and the closing lt Variables gt command If variance should be given in the model the value of variance is captured between the opening lt Variance gt command and the closing lt Variance gt command Similarly the alternatives in the Multinomial Logit model are captured between the opening lt Alternatives gt command and closing lt Alternatives gt command The threshold values in the Ordered Probit model are captured between the opening lt Thresholds gt command and closing lt Thresholds gt command The interval parameters for the Hazard Duration model are captured between the opening lt Intervals gt command and closing lt Intervals gt command The following template represents the main structure of the specification file however the reader will note that this template can be modified according to the different specifications of each model embedded in the software Th
38. children Jecislon to erta x 4 Tou T Jont Number of tours NWSCH1 Figure 4 37 Scheduling Independent Tours for Nonworkers Interactive User Interface 43 CEMDAP v 3 1 User s Manual CEMDAP Scheduling the Independent Discretionary Tour Undertaken by a Child Tour Mode CSCH3 Departure Time For the Tour C5CH4 Activity Duration at Stop CSCHS Travel Time to Stop CSCH6 Location of Stop CSCH7 Close Figure 4 38 Scheduling the Independent Discretionary Tour Undertaken by a Child Interactive User Interface When the entire scheduling model system for workers has been configured return to the main dialog box by clicking Close till the main dialog box appears 4 4 3 Saving model configuration file The model configurations entered using the dialog boxes can be saved into a model configuration file for future use This is achieved by clicking on the Save command in the Models Menu 44 CEMDAP v 3 1 User s Manual CEMDAP fel Simulation Help Generation Allocation Scheduling Children Scheduling Worker Scheduling Non Worker Scheduling Joint Interactive UI Figure 4 39 Save command in the Models Menu The Save command opens the Save As dialog box Choose the desired location and type in the desired model configuration filename in this dialog box and click Save to finish Save As Save in G Data My Recent Documents File name DFW_mode
39. completely configured dialog box looks as shown below Note Clicking on the Clear Function button clears all the coefficients and variables so that the utility function and can be reconfigured 54 CEMDAP v 3 1 User s Manual Decision to go to Work Base alternative NO Utility Function Altemative YES Linear terms entered 11 3021 30000 Constant One Persons 3 1 49e 002 age Zones 2 61e 002 female Other 0 4665 assobach Variable hid n adults n autos zone id kids structure naunemp hhincome zeroch Coefficient Clear function CS Figure 4 50 Binary Logit Model Interactive User Interface Location Choice An example of a location choice model is the Work Home Stop Location Model Since there is only one utility function to be configured configuration of the location choice model is similar to that of a linear regression model First enter the variance determined for the travel time model corresponding to the tour under consideration in the space designated Variance in this case enter the variance obtained for the travel time model for stops in the Work Home commute Then configure the utility function in the same way that the linear regression equation is configured That is select the relevant input table from the From list and pick the variables from the Variables box Specify the coefficient for each variable and use the arrow button gt to add the term The com
40. domain while also accommodating interactions among household members Given various land use socio demographic activity system and transportation level of service attributes as input the system provides as output the complete daily activity travel patterns for each individual in a population CEMDAP has been developed using an Object Oriented Design It was implemented in Visual C using the Visual Studio NET development platform The software provides a user friendly Windows environment to configure or modify the components of the modeling system save or load model configurations load the input data and run the simulation For an overview of the modeling system embedded in CEMDAP the reader is referred to the Guo et al 2005 and Pinjari et al 2006 The rest of this manual is organized as follows Chapter 1 describes the system requirements and installation instructions for the software Chapter 2 provides an overview of the CEMDAP environment including a description of the menus and commands available Chapter 3 describes the prescribed input and output file specifications and formats Chapter 4 guides the user through the basic operations such as loading inputs and configuring model components CEMDAP v 3 1 User s Manual CEMDAP v 3 1 User s Manual Chapter 1 Installation Instructions 1 1 MINIMUM SYSTEM REQUIREMENTS CEMDAP requires a Pentium IV class processor with 1 Giga byte or above of Random Access Memory RAM and
41. e ID 10016 value 0 9046 optional description unavailable gt lt Variable ID 10017 value 1 9349 optional description unavailable gt lt Variable ID 10018 value 1 8628 optional description unavailable gt lt Variable ID 10019 value 1 6204 optional description unavailable gt lt Variable ID 7 value 0 0056 optional description unavailable gt lt Variables gt lt ModelConfig gt 2 Multinomial Logit Model The first line in the Multionomial Logit Model starts with the name of the model that is coded in the ModelConfig id part The class of the model class CMNLogitMM is also identified in the first line of the configuration in the optional type part The second line in the syntax is the ID of the base alternative which should be always zero The subsequent lines then describe the various parameters associated with Multinomial Logit model for each alternative In order to describe the variables in each alternative define the ID of the alternative in the Alternative ID part Then the variables are described in the Variables part under the corresponding alternative The Variable ID of each variable is first entered in the Variable ID part and then the corresponding parameter of the variable is coded in the value part It is also possible to give a description for the variable in the optional description part Once the entire set of variables for each alternative in the model are defined the model is closed T
42. e number of variables can be different for each model or some of the models can have different configurations 83 CEMDAP v 3 1 User s Manual lt Configuration gt lt ModelConfig id enter name of the model optional type enter type of the model gt lt Variables gt lt Variable ID enter the variable ID value enter the value of the corresponding variable optional description enter the description of the variable gt lt Variables gt lt ModelConfig gt lt ModelConfig id enter name of the model optional type enter type of the model gt lt Variance gt enter the value of the variance of the model lt Variance gt lt Variables gt lt Variable ID enter the variable ID value enter the value of the corresponding variable optional description enter the description of the variable gt lt Variable ID enter the variable ID value enter the value of the corresponding variable optional description enter the description of the variable gt lt Variables gt lt ModelConfig gt lt Configuration gt In CEMDAP there exist seven different choice models 1 Binary Logit 2 Multinomial Logit 3 Linear Regression 4 Ordered Probit 5 Hazard Duration 6 Location Choice and 7 Work Start and End Time The format of the entry in the model specification file for each of the seven models is slightly different Below the specification file format for each of the seven models is given in detail 1
43. e tbname Table A 7 LOSdir Table Currently Present in CEMDAP Row start_t End t tbname 1 0 210 Losoffpk 2 360 780 Losoffpk 3 930 1440 Losoffpk 4 210 360 lospeakam 5 780 930 lospeakpm CEMDAP v 3 1 User s Manual Accessibility Measure Calculations Accessibility to Retail Employment Have to be re evaluated when 1 retail employment changes and or 2 impedance measures change Accessibility to retail employment measure for a time period t 1 A retail_emp ali Acc 7 N Impedence Impedence IVTT 0 Cost y 0 2868 5 0 0992 B 3 0779 t index for time period i index for origin zone j index for destination zone IVTT in minutes Cost in cents N is the number of zones The overall daily accessibility to retail employment measure is then computed as 1 X Dur Acc 1440 gt s Dur lt Duration of time period t in minutes Acc 1 Use the following three TOD time of day periods AM peak off peak PM peak IF TOD lt 209 TOD gt 360 amp TOD lt 719 TOD gt 930 IVTT off peak IF TOD gt 210 amp TOD lt 359 IVTT AM peak IF TOD gt 720 amp TOD lt 929 IVTT PM peak TOD in minutes from 3 AM Other accessibility measures e General formula 1 N SUM size impedance 67 CEMDAP v 3 1 User s Manual e Impedance peak auto IVTT e Create 3 different accessibility measures using the following as the size measures 1 retail
44. ecific table table number it belongs to and the position column number of the variable in the table Appendix B presents the procedure to prepare the input database corresponding to the DFW implementation in the postgreSQL format 3 1 2 Model Specifications The model system embedded in CEMDAP is described in greater detail in Guo et al 2005 and Pinjari et al 2006 The reader is referred to Pinjari et al 2006 for a list of all the model components The variables and parameters of each of the model components that constitute this model system must be specified the first time CEMDAP is used Thereafter the model configurations can be saved into a file using the Save command in the Models Menu and reloaded as desired using the Load command in the Models Menu The first time specification of the model configurations can be achieved in one of the following four ways refer to Section 4 4 for further details 1 Access each of the model configuration dialog boxes through the commands in the Models Menu In particular access the dialog boxes under the Generation Allocation Scheduling Children Scheduling Worker Scheduling Non Worker and Scheduling Joint entries in the Models Menu This method is recommended for changing the parameters of a few models 2 Access the model configuration dialog boxes through the Interactive UI which is also in the Models Menu The interactive user interface ties all the dialog boxes together 15 CEMD
45. ecision to Undertake acision to ga to School GA7 School End Time GAY Figure 4 25 Generation k Timing of Work and School Aetivities of Adults Interactive User Interface 34 CEMDAP v 3 1 User s Manual CEMDAP Genration of Children s Travel Needs and Allocation of Responsibilities to Parents For each child going to school Other household Single parent or Nuclear types Family household Interactions not explicitly Determine total number of implemented and no joint pick up drop off episodes to discretionary activities for be undertaken to escort all children children to from school Multiple pick up and or drop off episodes needed Only one pick up and or drop off episode needed Nuclear Family Single parent household household Interactions not explicitly implemented caponar pops ort oe en DELE Os Pick ip and or drop off episode allocated to the single parent ocation of the Pick up Episode if any to One of the Parents G413 Adjust work start and end times if the episode is allocated to a worker For each child in single parent or nuclear Family households in which at least one parent does not undertake pick up drop off episodes Decision to Undertake Joint Discretionary Activity with a Parent GA14 Single joint discretionary episode to be undertaken and both parents without pick up drop off episodes In the case of multiple joint discretionary episodes the interaction is not explicitly
46. ee Ge SA See ee 22 Figure 4 6 PostgreSQL ANSI ODBC Dialog Box eee 22 Figure 4 7 Final Select Data Source Screen ie sedes go RARR seg RA de se deeg se Ne dee 23 Figure 4 8 Input command in the Data menu OO 24 Figure 4 9 Output command in the Data menu 24 Figure 4 10 Save Simulation Results AS dialog BOX 2 sesse see se ee ee Re GRA GR ee ee 25 Figure 4 11 List of Work and School Activities Models within Generation Allocation in the Models MEDU cas oi RE aa 26 Figure 4 12 List of Children s Activities Models within Generation Allocation in the Models EE 26 Figure 4 13 List of Independent Activities Models within Generation Allocation in the Models EE Z Figure 4 14 List of Scheduling Children Models within the Models menu 27 Figure 4 15 List of Scheduling Worker Models within the Models menu 28 Figure 4 16 List of Number of Tours Models within Scheduling Worker in the Mechelen Ee 28 Figure 4 17 List of Activity Type at Stop Models within Scheduling Worker in the Models EE 29 Figure 4 18 List of Scheduling Non Worker Models within the Models menu 29 Figure 4 19 List of Tour Mode Models within Scheduling Non Worker in the Mio dels tent tesna EE ideas ee ite candied CNR eet ease eee 30 Figure 4 20 List of Activity Type at Stop Models within Scheduling Non Worker ithe Models E 30 Figure 4 21 List of Departure Time from Home Models within Scheduling
47. elect Data Source Screen 3 In the Create New Data Source dialog that opens up select the System Data Source button and click on the Next button Create New Data Source x Select a type of data source User Data Source Applies to this machine only System Data Source Applies to this machine only Selecting System Data Source creates a data source which is specific to this machine and usable by any user who logs onto this machine Figure 4 3 Create New Data Source Dialog Box 20 CEMDAP v 3 1 User s Manual 4 Scroll down and select the PostgreSQL ANSI driver from the list of drivers and click Next as displayed below Create New Data Source Select a driver for which you want to set up a data source 3 Name Microsoft Paradox Driver db Microsoft Paradox Treiber db Microsoft Text Driver txt csv Microsoft Test Treiber txt csv Microsoft Visual FoxPro Driver Microsoft Visual FoxPro T reiber PostgreSQL ANSI PostgreSQL Unicode SQL Server S na Mm m S oe la la IE meel Figure 4 4 Select driver Screen within Create New Data Source Dialog Box 5 Once you click Next the following box will appear Then click Finish to open up the PostgreSQL ANSI ODBC dialog box 21 CEMDAP v 3 1 User s Manual Create New Data Source When vou click Finish you will create the data source which you have just configured The driver may prompt yo
48. er in the Models menu 30 CEMDAP v 3 1 User s Manual CEMDAP KEE Simulation Help Load Save Generation Allocation k Scheduling Children gt Scheduling Worker gt b gt Scheduling Non Worker Scheduling Joint Departure time From home I5CH1 Activity duration at stop ISCH2 Travel time to stop ISCH3 Location of stop J5CH4 Interactive UI Figure 4 21 List of Departure Time from Home Models within Scheduling Joint in the Models menu 4 4 2 Accessing model module dialog boxes through the Interactive User Interface Simulation Help Load Save Generation Allocation Scheduling Children Scheduling Worker Scheduling Non Worker Scheduling Joint Interactive UI Figure 4 22 Interactive UI in the Models menu 31 CEMDAP v 3 1 User s Manual The Interactive UI command in the Models Menu opens up the interactive user interface that ties together the model configuration dialog boxes for all the model components that constitute the embedded model system This interactive UI is also reflective of the underlying modeling framework embedded within CEMDAP Specifically the analyst can understand the process used by CEMDAP to generate the activity travel patterns by following flow represented by the Interactive UI windows The main dialog box of the interactive user interface looks as shown below CEMDAP Overall Modeling F
49. essfully with no result 3 Exit out of the Query window Click NO to save changes The query creates empty tables as can be seen under Tables with the appropriate column properties These columns are empty and so our next step is to populate the columns 70 CEMDAP v 3 1 User s Manual Query Statement for Table Creation CREATE TABLE households hid floats n_adults float8 n_autos float8 zone id floats kids float8 structure float DEFAULT 0 naunemp float8 hhincome float8 zeroch float8 npers float8 multadu float8 vehbylic float8 sperson float8 sparent floats couple float8 nuclear float8 ohhtype float8 numlic float8 onech float8 twoch float8 naemp float8 zeroemp float8 oneemp float8 twoemp float8 nastu float8 nenotstu float8 nostu float8 ownhome float8 sfdunit float8 sfaunit float8 aptunit float8 othunit float8 WITH OIDS ALTER TABLE households OWNER TO postgres CREATE TABLE persons hid floats pid float8 employed float8 71 CEMDAP v 3 1 User s Manual studying float license floats work_zon float8 stud zon float female float8 age float8 parent float8 DEFAULT 0 caucasia floats afriamer float8 asian float8 male float8 pvehavbl floats highflex float8 Dresch float8 kgtog4 floats g5tog8 floats g9orhigh float8 lowage float loagel float8 loage2 float8 somecol float8 assobach float8 mastphd float8 income float8 inc
50. g Framework box The Scheduling Model System box has buttons for Work to Home Commute Home to Work Commute Non Worker Tour Containing the Drop off at School Activity Non Worker Tour Containing the Pick up at School Activity School Home and Home School Commutes Worker s Joint Discretionary Tour with Children Non Worker s Joint Discretionary Tour with Children Independent Home based and Work based Tours for workers Independent Home based Tours for non workers and Independent Home based Tours Undertaken by Children 36 CEMDAP v 3 1 User s Manual CEDMDAP Scheduling Model System For each worker in the household Home to Wark Commute Nonworker Tour Containing the Drop off at School Activity Nonworker Tour Containing the Pick up at School Activity For each child not escorted by parents School Home and Home School Commutes Nonworker s Joint Discretionary Tour with Children For each worker undertaking independent non work activities Independent Home based and Work based Tours For each non worker undertaking independent non work activities Independent Home based Tours For each child undertaking independent discretionary activities Independent Home based Tours Undertaken by Children Figure 4 28 Scheduling Model System Interactive User Interface Clicking on each of the buttons opens up the corresponding suite of individual model components shown on the following pages After c
51. he reader will note that each row under the lt Variables gt command represents a single variable for the corresponding alternative The following configuration presents the framework for one of the Multinomial Logit models in CEMDAP Allocation of drop off episode to parent The model has 3 alternatives Alternative 0 base Alternative 1 and Alternative 2 The first variable in Alternative 1 is constant that has a variable ID of 30000 and the corresponding value of the parameter is 0 5807 lt ModelConfig id Allocation of drop off episode to parent optional type class CMNLogitMM gt lt Alternatives baseID 0 gt lt Alternative ID 0 gt lt Variables gt lt Alternative gt lt Alternative ID 1 gt lt Variables gt lt Variable ID 30000 value 0 5807 optional description unavailable gt lt Variable ID 30013 value 0 0041 optional description unavailable gt lt Variable ID 30015 value 0 0047 optional description unavailable gt lt Variable ID 10032 value 0 9955 optional description unavailable gt lt Variables gt 85 CEMDAP v 3 1 User s Manual lt Alternative gt lt Alternative ID 2 gt lt Variables gt lt Variable ID 30013 value 0 0041 optional description unavailable gt lt Variable ID 30015 value 0 0047 optional description unavailable gt lt Variable ID 10032 value 0 9955 optional description unavailable gt lt Nariables gt lt Alterna
52. ibing the CEMDAP inputs input file description and outputs output file description Prior to running CEMDAP it is necessary to install PostgreSQL The corresponding installation instructions are provided in Appendix B on page 60 1 3 TO UNINSTALL To uninstall CEMDAP use the Cemdap_5Threads msi or Cemdap_10Threads msi file in the installation CD and follow the instructions given below 1 Double click Cemdap 5Threads msi or Cemdap 10Threads msi to run the CEMDAP setup wizard 2 In the Welcome screen select the Remove Cemdap radial button and click Finish CEMDAP v 3 1 User s Manual je Cemdap Welcome to the Cemdap Setup Wizard Select whether you wantto repair or remove Cemdap O Repair Cemdap Remove Cemdap Figure 1 5 Cemdap Setup Wizard Welcome Screen once CEMDAP is Installed 3 Click Close to exit i Cemdap Installation Complete Cemdap has been sucessfully removed Click Close to exit Figure 1 6 Installation is Complete Screen once CEMDAP is removed CEMDAP v 3 1 User s Manual CEMDAP v 3 1 User s Manual Chapter 2 The CEMDAP Environment CEMDAP offers a user friendly environment to simulate the activity travel patterns of a population by using standard Windows user interface features In this chapter we present the basic features of the CEMDAP environment To start CEMDAP double click the shortcut to CEMDAP SThreads or CEMDAP 10Threads on your desktop or find CEMDAP SThreads or C
53. ired Variables EE Table 3 5 LOSdir Table with Required Variables eee Table 3 6 LOS Table with Required Variables ss sis dees Ee ee ER NA de SR ee Table 3 7 Adults Out Format and Content Table 3 8 Children Out Format and Content Table 3 9 Workers Out Format and Content Table 3 10 Childstu Out Format and Content Table 3 11 Nonworkers Out Format and Content Table 3 12 Tours Out Format and Content Table 3 13 Stops Out Format and Content ccccccssccsescoscseserssssessncssscseacessacensnsecnes Table A 1 Households Table Specification for D FW Aren Table A 2 Persons Table Specification for D FW Aren Table A 3 Zones Table Specification for DF W Aren Table A A Zone2Zone Table Specification for DF W Aren Table A 5 LOS Tables AMPeak PMPeak and OFFPeak Specifications for DF Table A 7 LOSdir Table Currently Present in CEMDAR nn Table B 1 Column names of Postgres Tables eee CEMDAP v 3 1 User s Manual CEMDAP v 3 1 User s Manual Introduction The Comprehensive Econometric Micro simulator for Daily Activity Travel Patterns CEMDAP is a software implementation of a system of econometric models that represent the decision making behavior of individuals It is one of the first systems to comprehensively simulate the activity travel patterns of all household members 1 e both adults and children further distinguished based on employment student status in a continuous time
54. is provided at the end of this appendix Table A 4 Zone2Zone Table Specification for DF W Area Column Variable Description yeu Name 1 TSZ zone id origin Origin zone 2 TSZ zone id destination Dest_zone 3 Dummy variable indicating origin and destination are adjacent zones Adjacent 4 Distance between zones Distance 65 CEMDAP v 3 1 User s Manual Table A 5 LOS Tables AMPeak PMPeak and OFFPeak Specifications for DF W Area Solun Variable Description Na Name 1 TSZ zone id origin Origin 2 TSZ zone id destination Dest 3 Dummy variable indicating origin and destination are the same zone samezone 4 Dummy variable indicating origin and destination are adjacent zones Adjacent 5 Distance between zones Distance 6 Auto In vehicle travel time between origin and Destination zones autoIVTT 7 Auto Out of vehicle travel time between origin and Destination zones autoOVTT 8 Dummy variable indicating if transit is available between zones Travail 9 Transit In vehicle travel time between origin and Destination zones TrIVTT 10 Transit Out of vehicle travel time between origin and Destination zones TrOVTT 11 Transit cost Trcost 12 Auto cost COST Table A 6 LOSDir Tables A MPeak PMPeak and OFFPeak Specifications for DF W Area Column stoja Variable 4 Variable Description Nami 1 Start Time of the time period start t 2 End Time of the time period End t 3 Name of the LOS tabl
55. lconfiguratior Si Save as type CEMDAP Model Files cml v My Network Figure 4 40 Save As Dialog Box from the Save Command 45 CEMDAP v 3 1 User s Manual 4 4 4 Loading model configuration file In the current section instructions to load the prepared model configuration file are provided The model configuration file provided in the installation CD for testing purposes or saved using the Save command in the Models Menu or created manually by entering the model configurations into a text file can be loaded into CEMDAP using the Load command in the Models Menu CEMDAP s EM Simulation Help Save Inpt Generation Allocation gt Inpt Scheduling Children gt becified San Scheduling Worker Dat Scheduling Non Worker gt Scheduling Joint Interactive LJI Figure 4 41 Load Command in the Models Menu The Zoad command opens the Save As dialog box note that the model configuration file must have already been saved as indicated in the previous section Navigate to the location of the model configuration file and select the file Click Save to finish loading the configuration file Note For Testing the CEMDAP software the reader is recommended to skip to Section 4 5 46 CEMDAP v 3 1 User s Manual Save As PIX Save in O Data v OR EE 4 IDFW modelconfigur ation cml d 4 My Recent Documents c O a o i j A To Cc T
56. lder To install in this folder click Next To install to a different folder enter it below or click Browse Folder C Program Files University of Texas Cemdap Install Cemdap for yourself or for anyone who uses this computer O Everyone Just me Figure 1 2 Select Installation Folder Screen 4 Click Next in the Confirm Installation screen CEMDAP v 3 1 User s Manual ig Cemdap Confirm Installation The installer is ready to install Cemdap on your computer Click Next to start the installation Figure 1 3 Confirm Installation Screen 5 Installation will complete in a few seconds 6 Click Close to exit the wizard CEMDAP v 3 1 User s Manual is Cemdap T kj x Installation Complete ge NA Cemdap has been sucessfully installed Click Close to exit Close Figure 1 4 Installation Complete Screen At the end of the installation process CEMDAP will be added to the Program menu and a shortcut to the program will be created on the Desktop Double click the desktop shortcut to open the CEMDAP SThreads CEMDAP 10Threads folder In this folder double click on cemdap exe to start CEMDAP The installation CD contains sample input data files in the TestData folder and the model specification or the configuration file for the Dallas Fort Worth area implementation further instructions to run CEMDAP are provided in Chapter 4 The installation CD also contains an EXCEL files descr
57. model system has been configured return to the main dialog box by clicking Close till the main dialog box appears This process is similar for all the individual models embedded in the model system Hazard Duration An example of a hazard duration model is the Children s School Start Time model within the generation allocation model system The model type supported is a hazard based duration model with a non parametric baseline and gamma heterogeneity The inputs required for this model can be configured in three steps Step One enter the parameter estimated for the gamma heterogeneity term in the box titled Variance in the top left corner of the dialog box Step Two configure the parameters on the covariates This procedure is identical to entering the linear regression parameters Select the relevant input table from the From list and pick the variables from the Variable list Specify the coefficient for each variable and use the arrow button gt to add the terms 49 CEMDAP v 3 1 User s Manual Children s school Start time Variance 0 2153 Duration Function From Linear terms entered Households 0 5034 lowage Persons Zones Other Variable male pvehavbl highflex presch katog4 g5tog8 ee laagel v Coefficient 0 5034 Baseline time intervals 5 x Figure 4 45 Hazard Duration Model Interactive User Interface Step Three after all the covariates have
58. model system embedded in CEMDAP must be configured into a model configuration file also referred to as a model specification file and input to the system before starting a simulation run The preparation of model configuration file involves providing the relevant variables and their parameters in a specific format as explained below Alternatively a complete model specification file which can be used for testing purposes is provided in the installation CD The specification file contains a complete description of each of the models included in the CEMDAP modeling framework The specification file starts with an opening lt Configuration gt command and ends with a closing lt Configuration gt command Then the individual models that are embedded in CEMDAP are coded according to their specifications The first line of each model starts with the name of the model Then the class of the model that identifies the modeling template from which the particular choice model is derived classCBLogitMM for Binary Logit class CMNLogitMM for Multinomial Logit classCRegressMM for Linear Regression classCOrdProbitMM for Ordered Probit classCHazardMM for Hazard Duration classCBLogitMM for Location Choice and Work Start End Time for Work Start and End Time Model is recorded The subsequent lines then describe the IDs of each variable in the models and the parameter values specified to those variables a complete list of endogenous variables varia
59. n presents the framework for the Work Start and End Time model in CEMDAP The first variable of the model has a variable ID of 30264 and the corresponding value of the parameter is 8751 lt ModelConfig id lt Work Start End Time optional type class CStartAndEndTimeMM gt lt Variables gt lt Variable ID 30264 value 1 8751 optional description unavailable gt lt Variable ID 30265 value 2 3648 optional description unavailable gt lt Variable ID 30266 value 1 0647 optional description lt unavailable gt lt Variable ID 30267 value 7 9309 optional description unavailable gt lt Variable ID 30268 value 4 499 optional description lt unavailable gt lt Variable ID 30269 value 1 4412 optional description unavailable gt lt Variable ID 30270 value 6 9739 optional description unavailable gt lt Variable ID 30271 value 3 6043 optional description unavailable gt lt Variable ID 30272 value 0 7273 optional description unavailable gt lt Variable ID 30273 value 4 3365 optional description unavailable gt lt Variable ID 30274 value 0 7668 optional description unavailable gt lt Variable ID 30275 value 0 1056 optional description unavailable gt lt Variable ID 30015 value 82 4853 optional description unavailable gt lt Variable ID 30018 value 0 0295 optional description unavailable gt lt Variables gt lt ModelConfig gt
60. n 1000s of dollars HHINCOME 9 Household with no children ZEROCH 10 Number of persons in household NPERS 11 Multiple number of adults 1 if nadult gt 1 0 otherwise MULTADU 12 Vehicles per licensed driver VEHBYLIC 13 Single person household SPERSON 14 Single parent household SPARENT 15 Male female couple household no children COUPLE 16 Male female couple household with children NUCLEAR 17 Other household type OHHTYPE 18 Number of licensed drivers NUMLIC 19 Household with one child ONECH 20 Household with two or more children TWOCH 21 Number of employed adults NAEMP 22 Household with no employed adult ZEROEMP 23 Household with one employed adult ONEEMP 24 Household with two or more employed adults TWOEMP 25 Number of adult age gt 18 students NASTU 26 Number of children age lt 18 who are not students NCNOTSTU 27 Number of children who are students NCSTU 28 Own residential unit OWNHOME 29 Single family detached housing unit SFDUNIT 30 Single family attached housing unit SFAUNIT 31 Apartment type housing unit APTUNIT 32 Other type of housing unit OTHUNIT 63 CEMDAP v 3 1 User s Manual Table A 2 Persons Table Specification for D FW Area column Variable Description Vanabic Name 1 Household ID HHID 2 Person ID PerID 3 Adult is employed Aemp 4 Adult or child is a student Stu 5 Is the person licensed to drive License 6 Work TSZ WorkTSZ 7 School TSZ SchTSZ 8 Person is female Female 9 Age of the person in 1
61. ndependent tour before pick up or joint discretionary NWSCH2 Decision to undertake an independent tour after pick up or joint discretionary NWSCH3 Scheduling Joint Interactive UI Tour mode CH4 Number of stops in a tour NWSCH5 Number of stops Following a pick up drop off stop in a tour NWSCH6 Home stay duration before the tour NWSCH7 Tour Tour2 ss si Activity type at stop NWSCH8 Activity duration at stop NWSCH9 Travel time to stop NWSCH10 Stop location NWSCH11 v v v v Figure 4 19 List of Tour Mode Models within Scheduling Non Worker in the Models menu CEMDAP Data UMES Simulation Help 3 Load Save Inpt Generation Allocation ecified Inpt Scheduling Children Number of independent tours NWSCH1 Decision to undertake an independent tour before pick up or joint discretionary NWSCH2 Decision to undertake an independent tour after pick up or joint discretionary NWSCH3 Scheduling Non Worker San Scheduling Worker D gt Scheduling Joint Interactive UI Tour mode NWSCH4 Number of stops in a tour NWSCH5 Number of stops Following a pick up drop off stop in a tour NWSCH6 Home stay duration before the tour NWSCH7 vy v v Activity duration at stop NWSCH9 Travel time to stop NWSCH10 Stop location NWSCH11 Figure 4 20 List of Activity Type at Stop Models within Scheduling Non Work
62. ng a simulation run CEMDAP creates seven output files refer to Chapter 3 for file formats The following steps are used to specify the location of these seven files 1 Click on the Output command in the Data menu of CEMDAP Models Simulation Help se Unspecified ration file Unspecified Sampling at 100 0 Input Output Figure 4 9 Output command in the Data menu 2 In the Save Simulation Results As dialog box that opens click on Browse to select the folder location for all the output files 24 CEMDAP v 3 1 User s Manual Save Simulation Results As Output Path Browse Figure 4 10 Save Simulation Results As dialog box 3 Select the location or enter the path name for all the output files and then click OK 4 4 CONFIGURING THE MODEL SYSTEM All the components of the model system embedded in CEMDAP must be configured into a model configuration file also referred to as a model specification file and input to the system before starting a simulation run Model configuration involves selecting the relevant variables and inputting their parameters The model system can be completely configured either by accessing all the corresponding dialog boxes to specify the models or by manually preparing a model configuration file as described in Appendix C Sections 4 4 1 and 4 4 2 describe two methods of accessing all the model dialog boxes to configure the entire model system Section 4 4 3 expl
63. ns 4 program ga Log off c gemeet Figure B 1 Run Command in Start menu of Windows b Type cmd and click OK Type the name of a program Folder document or Internet resource and Windows will open it for you cmdl Cancel Browse Figure B 2 Run dialog Box 76 CEMDAP v 3 1 User s Manual 2 At the command prompt go to the bin subdirectory under the Postgresql program directory To do this please follow the steps below a At the command prompt type cd and press Enter E Microsoft Windows AP Version 5 1 2600 C Copyright 1985 2001 Microsoft Corp C Documents and Settings Sahil gt cd N Figure B 3 Command Prompt dialog box cd b Type cd Program files posteresgl 8 2 bin and press Enter Please note that the version number 8 2 depends on the PostgreSQL version Microsoft Windows AP Version 5 1 2644 O Copyright 1985 2481 Microsoft Corp C Documents and Settings ahildcd gt Ned Program files postgresq 8 2 bin Figure B 4 Command Prompt dialog box cd Program files postgresgl 8 2 bin 77 CEMDAP v 3 1 User s Manual 3 Type in the following command and press Enter psgl d database name U user name where database name is the name of the data base for which you are populating data and user name is the user name you set up for accessing the database For example if the database name is CEMDAP Test Data and user name is
64. nt variables one at a time and enter the coefficient in the designated space Then click the arrow button gt to add the term to the utility function for that alternative This step is similar to configuring the linear regression expression In the example shown below we have selected the constant and entered the corresponding coefficient for the utility function of the drive alone alternative 52 CEMDAP v 3 1 User s Manual WH commute mode Utility Function Alternative From Linear terms entered Persons oi 1 3069 30000 constant one Zones Other a Variable 30000 constantlone 30017 expected no stop work to home auto comul 30018 expected no stop home to work auto comul 30019 expected no stop total auto commute time 30191 distance between home to work zone 30204 work home travel time for drive with passen 30205 home work travel time for drive with passen 30206 work home Home work travel time for driv e 1 3069 Clear function Figure 4 48 Example of Constant and Corresponding Coefficient for the Utility Function of one of the Multinomial Logit Model Alternatives When the utility function for the alternative has been fully configured the dialog box looks as shown on the next page The utility functions for all other alternatives can be similarly configured The utility of a base alternative with zero utility can be specified by providing a value of zero for the constan
65. ntain the tour level and stop level attributes respectively for all the individuals that undertake travel These output files can easily be imported into any spreadsheet of your choice The formats and content of these output files are given below Detailed description of the output variables can be found in an EXCEL file output file specification in the data under the installation destination directory Table 3 7 Adults Out Format and Content Column No Description Household identification number Person identification number Adult goes to work on the day Adult undertakes work related activity Adult drops off children at school Adult picks up children from school Adult undertakes joint discretionary activities with children Adult undertakes shopping activity Adult undertakes HH personal business activity Adult undertakes social recreational activity Adult undertakes eat out activity Adult undertakes other serve passenger activity ODO vm Ahh E r 16 CEMDAP v 3 1 User s Manual Table 3 8 Children Out Format and Content Column No Description 1 Household identification number 2 Person identification number 3 Child goes to school on the day 4 Child undertakes joint discretionary activities with parent 5 Child undertakes independent discretionary activities Table 3 9 Workers Out Format and Content Column No Description 1 Household identification number 2 Person identification
66. nterface 31 4 4 3 Saving model configuration file 44 4 4 4 Loading Model configuration file 46 4 4 5 Configuring specific model types 47 4 5 INITIATING A SIMULATION RUN ie ie aaa 58 REFERENCES RE EE OE ER EER EE EE EE sie ae 61 APPENDIX A D FW INPUT DATA ees ese sesse se se se ese sesse Be Se GR Ee EE Bee EE BE Be GR Ee EE Be Be GR Ee ee Be Se GR ee ee se no 63 APPENDIX B INPUT DATABASE PREPARATION IN POSTGRESQL FORMAT 69 APPENDIX C STRUCTURE OF THE MODEL SPECIFICATION FILE sesse esse esse esse esse esse esse see 83 CEMDAP v 3 1 User s Manual CEMDAP v 3 1 User s Manual List of Figures Figure 1 1 Cemdap Setup Wizard Welcome Screen 3 Figure 1 2 Select Installation Folder beraming ee of 4 Figure 1 3 Confirm Installation SEGE A ai RE EE tase laa naan 5 Figure 1 4 Installation Complete Sere ti Sdt 6 Figure 1 5 Cemdap Setup Wizard Welcome Screen once CEMDAP is Installed 7 Figure 1 6 Installation is Complete Screen once CEMDAP is removed 7 Figure 2 1 CEMDAP Main Window and Menus eee eee Ge ee eee 9 Figure 4 1 Input command in the Data Menu EE 19 Figure 4 2 Machine Data Source Tab within the Select Data Source Screen 20 Figure 4 3 Create New Data Source Dialog Dos 20 Figure 4 4 Select driver Screen within Create New Data Source Dialog Box 21 Figure 4 5 Create New Data Source Finish Screen sesse sees sees se ee
67. oint Discretionary Tour Undertaken by a Worker with Children Interactive User Interface sis iso es dasad se ia Figure 4 35 Scheduling of the Joint Discretionary Tour Undertaken by a Nonworker with Children Interactive User Interface Figure 4 36 Scheduling of the Independent Home based amp Work based Tours for Workers Interactive User Interface geesde Figure 4 37 Scheduling Independent Tours for Nonworkers Interactive User nterface linii AE EE EE ra l Figure 4 38 Scheduling the Independent Discretionary Tour Undertaken by a Child Interactive User Interface sanje anka S seas d Re Figure 4 39 Save command in the Models Men Figure 4 40 Save As Dialog Box from the Save Command Figure 4 41 Load Command in the Models Men Figure 4 42 Save As Dialog Box from the Load Command Figure 4 43 Figure 4 44 Figure 4 45 Figure 4 46 Figure 4 47 Figure 4 48 Function of one of the Multinomial Logit Model Alternatives Figure 4 49 Figure 4 50 Figure 4 51 Figure 4 52 Figure 4 53 Figure 4 54 Figure 4 55 Figure 4 56 Linear Regression Model Interactive User Interface Example of Fully Configured Linear Regression Model Hazard Duration Model Interactive User Interface Example of Fully Configured Hazard Duration Model Multinomial Logit Model Interactive User Interface
68. omef float8 wdurlow float8 wdurmed float8 emptypel float8 emptype2 float8 emptype3 float8 emptype4 float8 emptype float8 mother float8 father float8 nosch float8 cnotstu float8 aunemp float8 adchild float8 adult float8 hisp float othrace floats g8orlow floats g9tog12 floats highsch float8 workhrs floats wdurhigh float8 72 CEMDAP v 3 1 User s Manual medflex floats lowflex float8 emptype6 float8 WITH OIDS ALTER TABLE persons OWNER TO postgres CREATE TABLE losdir start_t float8 end t float tbname varchar 50 WITH OIDS ALTER TABLE losdir OWNER TO postgres Table losoffpk DROP TABLE losoffpk CREATE TABLE losoffpk orig zon floats dest zon float8 same zon float8 adjacent float8 distance float8 da 1vtt float8 da ovtt float8 tr avail float8 tr ivtt floats tr ovtt float8 tr cost float8 au cost float8 WITH OIDS Table lospeakam DROP TABLE lospeakam CREATE TABLE lospeakam orig zon floats dest zon float8 same zon float8 adjacent float8 distance float8 73 CEMDAP v 3 1 User s Manual da ivtt float8 da ovtt float8 tr avail float8 tr ivtt floats tr ovtt float8 tr cost float8 au cost float8 WITH OIDS ALTER TABLE lospeakam OWNER TO postgres ALTER TABLE losoffpk OWNER TO postgres Table lospeakpm DROP TABLE lospeakpm CREATE TABLE lospeakpm orig zon floats dest zon float8 s
69. onfiguring the individual models of each suite click the Close button to return to the Scheduling Model System interface in order to access the next suite of models 37 CEMDAP v 3 1 User s Manual CEMDAP Scheduling of Work to Home Commute for Worker If worker does not escort children to from home Commute Mode WSCH1 If there are no pick up activities If worker undertakes independent non work activities OR commute mode is other than transit and walk bike Number of Stops in the Work to Home Commute WSCH2 If there are one or more stops in the commute for each stop i Activity Type For the Eh Stop WSCH10 Activity Duration For the Tth Stop WSCH11 Travel Time to the th Stop WSCH12 Location of the i th Stop WSCH13 Figure 4 29 Scheduling of Work to Home Commute for Worker Interactive User Interface 38 CEMDAP v 3 1 User s Manual CEMDAP Scheduling of the Home to Work Commute for a Worker E If there are no drop off activities If worker undertakes independent non work activities OR commute mode is other than transit and walk bike Number If there are one or more stops in the commute for each stop i Activity Type For the ith Stop WSCH10a Activity Duration For the i th Stop WSCHi1a avel Time to the i th Stop WSCH12a Location of the Tth Stop WSCH13a Figure 4 30 Scheduling of the Home to Work Commute for a Worker Interactive User Interface 39 CEMDAP v 3 1
70. or the variables of the model The subsequent lines then describe the various parameters associated with that model In order to describe the variables the Variable ID of each variable is first entered in the Variable ID part and then the corresponding parameter of the variable is coded in the value part It is also possible to give a description for the variable in the optional description part Once the entire set of variables embedded in the model are defined variables section is closed The reader will note that each row under the lt Variables gt command represents a single variable The following line indicates an opening command for the intervals that are specified in the model The interval start time and corresponding parameter is entered for each of the interval in the model Once all the interval characteristics are defined the model is closed The following configuration presents the framework for one of the Hazard Duration models in CEMDAP Children s school start time time from 3 AM The variance of the model has a value of 0 0310 The first variable of the model has a variable ID of 70020 and the corresponding value of the parameter is 0 5034 The first interval time for the model is 0 and the corresponding parameter is 2 5892 lt ModelConfig id Children s school start time time from 3 AM optional type class CHazardMM gt lt Variance gt 0 0310 lt Variance gt lt Variables gt lt Variable ID 10020 value 0 5034
71. ours WSCH 4 5 6 Tour Mode WSCH7 Number of Stops in Tour WSCH8 Home Stay Work Stay Duration before Tour WSCH9 ty Type at Stop WSCH10 Activity Duration at Stop WSCH11 Travel Time to Stop WSCH12 Stop Location WSCH13 Figure 4 17 List of Activity Type at Stop Models within Scheduling Worker in the Models menu CEMDAP oss GC Simulation Help Generation Allocation Scheduling Children Scheduling Worker Scheduling Non Worker Scheduling Joint Interactive UI ecified Number of independent tours NWSCH1 Decision to undertake an independent tour before pick up or joint discretionary NWSCH2 Decision to undertake an independent tour after pick up or joint discretionary NWSCH3 Tour mode NWSCH4 Number of stops in a tour NWSCHS Number of stops Following a pick up drop off stop in a tour NWSCH6 Home stay duration before the tour NWSCH7 vv v v Activity type at stop NWSCH8 Activity duration at stop NWSCH9 Travel time to stop NWSCH10 Stop location NWSCH11 vv v v Figure 4 18 List of Scheduling Non Worker Models within the Models menu 29 CEMDAP v 3 1 User s Manual CEMDAP Data Miha Simulation Help N Load Save Generation Allocation Inpt Scheduling Children gt gt Jecified San Scheduling Worker D Scheduling Non Worker Number of independent tours NWSCH1 Decision to undertake an i
72. ouseholds dat For testing CEMDAP please copy the TestData folder from the installation CD and place it in the C Program Files PostgreSQL 8 2 bin Tip C Program Files PostgreSQL 8 2 bin TestData households dat shows the location where the data is loaded In the example above your data is located in the TestData folder under C Program Files PostgreSQL 8 2 bin It is best to write out the command line instead of copying and pasting e CAWINDOWSisystem32icmd exe psgl d CEMDAP_Test_Data U postgres Microsoft Windows XP Version 5 1 2688 lt C Copyright 1985 2881 Microsoft Corp C Documents and Settings Sahil ed X G N gt cd Program files postgresq1 8 i bin C Program Files PostgreSQL 8 1 bin gt psql d CEMDAP Test Data U postgres Welcome to psql 8 1 3 the PostgreSQL interactive terminal Type copyright for distribution terms Nh for help with SOL commands N for help with psql commands g or terminate with semicolon to execute query Na to quit Warning Console code page 437 differs from Windows code page 1252 8 bit characters may not work correctly See psql reference page Notes for Windows users for details CEMDAP_Test_Data copy households from C Program Files PostgreSQL 8 1 bi n TestData househo lds dat Figure B 6 Command Prompt dialog box C Program Files PostgreSQL 8 2 bin TestData households dat Tip Note that name of the table corresponds to an empty table created
73. pletely configured dialog box looks as shown below 55 CEMDAP v 3 1 User s Manual WH Commute Stop Location Auto mode Variance 0 6031 Utility Function From Persons AI Zones Other 3 Variable 30170 origin and candidate destination zones are A 30169 candidate destination zone adjacent to the gt 30234 destination is Dallas CBD 30235 destination is Fw CBD auto travel cost at start of the trip to the stop Linear terms entered 0 2495 30165 auto travel time at start u 0 6848 30166 IVTT mode walk 0 1684 30167 Distance to the ultimate 0 163 30168 Distance to ultimate dech 0 4021 30169 candidate destination zo 1 2076 30170 origin and candidate des 0 2544 30172 LN zonal retail service 0 2024 30173 LN zonal retail service 0 1577 30174 LN zonal retail service 0 2264 30175 LN zonal retail service 0 2287 30176 LN zonal retail service 30165 auto travel time at start of the trip to the stor 30236 IVTT work related 30237 IVTT shopping 30178 IYTT Household Personal bunisess activity v Coefficient Figure 4 51 Example of Fully Configured Binary Logit Model Note that the list of variables supported by the location choice model is pre determined and available only under the Other variables list The list of variables includes the inter zonal LOS characteristics and interactions between household or person characteristics and destination zone or inte
74. postgreSQL database format must be registered before it can be loaded in CEMDAP The database registration should be done each time a new database is used PostgreSQL should be installed in the computer prior to running CEMDAP Further data needs to be populated into the PostgreSQL database the reader is referred to Appendix B for installation and database loading instructions After installation of PostgreSQL and populating the database follow the instructions below to register an input file 1 Click on the Input command in the Data Menu of CEMDAP CEMDAP BAER Models Simulation Help S Output Evi ise Unspecified mpraeoconrgdration file Unspecified Sampling at 100 0 Database Type PostgreSQL Figure 4 1 Input command in the Data Menu 2 In the Select Data Source dialog that opens up select the Machine Data Source tab and click on the New button 19 CEMDAP v 3 1 User s Manual Select Data Source File Data Source Machine Data Source Data Source Name Type Description dBASE Files User Excel Files User MS Access Database User TripsDSN User Xtreme Sample Database 2 System 4 Machine Data Source is specific to this machine and cannot be shared User data sources are specific to a user on this machine System data sources can be used by all users on this machine or by a system wide service Figure 4 2 Machine Data Source Tab within the S
75. postgres the command should be psgl d CEMDAP Test Data U postgres ca CAWINDOWSisystem32icmd exe psql d CEMDAP Test Data U postgres Microsoft Windows AP Version 5 1 2600 CC Copyright 1985 2001 Microsoft Corp C Documents and Settings Sahil gt cd C N gt cd Program files postgresq1 8 1 bin C Program Files PostgreSQL 8 1 bin gt psql d CEMDAP Test Data U postgres Welcome to psql 8 1 3 the PostgreSQL interactive terminal Type copyright for distribution terms h for help with SOL commands for help with psql commands g or terminate with semicolon to execute query q to quit Warning Console code page 437 differs from Windows code page 1252 8 bit characters may not work correctly See psgl reference page Notes for Windows users for details CEMDAP_Test_Data m Figure B 5 Command Prompt dialog box psql d database name U user name This command will direct you to the corresponding database with the database name as defined above the prompt is updated as the database name in the case of our example it becomes CEMDAP Test Data 4 Once at the new prompt type in the following command and press Enter copy name of the table from filename For example if the name of the table is households and the filename is households dat the command should be as in the following 78 CEMDAP v 3 1 User s Manual copy households from C Program Files PostgreSQL 8 2 bin TestData h
76. r the suite of generation allocation model components refer to Chapter 4 To access the model configuration dialog boxes for the suite of Children Scheduling model components refer to Chapter 4 Scheduling Worker To access the model configuration dialog boxes for the suite of Worker Scheduling model components refer to Chapter 4 Scheduling Non Worker To access the model configuration dialog boxes for the suite of Non Worker Scheduling model components refer to Chapter 4 Scheduling Joint To access the model configuration dialog boxes for the suite of Joint Activity Scheduling model components refer to Chapter 4 Interactive UI To open the interactive user interface that ties all model configuration dialog boxes together using the modeling system framework refer to Chapter 4 10 CEMDAP v 3 1 User s Manual Table 2 3 Simulation Menu Choose To Initiate a simulation run Note that the input data must be Run loaded and the complete model system configured prior to using the Run command Table 2 4 Help Menu Choose To Display the CEMDAP dialog box that shows copyright and About me version information 11 CEMDAP v 3 1 User s Manual 12 CEMDAP v 3 1 User s Manual Chapter 3 Input and Output Files 3 1 INPUT DATA SPECIFICATION The inputs required by CEMDAP can be broadly classified into two categories a da
77. r zonal LOS characteristics The user must use only these variables in the calibration and enter the parameters appropriately Ordered Probit An example of an ordered probit model is the Work Home Commute Number of Stops Model The inputs required for this model are the propensity function and threshold parameters Configuring the propensity function is identical to configuring the linear regression equation That is select the relevant variables from each list Households Persons Zones and Other Enter the coefficient corresponding to the variable and click on the arrow button gt to add the term The maximum number of alternatives to be input for any model is pre determined and based on the representation frameworks supported for workers and non workers However CEMDAP supports any number of alternatives less than the maximum number For example the software supports a maximum of four tours for non workers in the D FW model system However if the maximum number of tours in a particular context is only 3 the number of threshold parameters for the ordered probit model for tours for non workers is 2 This number appears in the Threshold Values box in the bottom left corner of the dialog box In the Work Home Commute Number of Stops Model the software supports three stop options 56 CEMDAP v 3 1 User s Manual 0 1 and 2 stops and hence the number of threshold parameter is 2 Click on Edit to specify the threshold paramete
78. ramework Generation Allocation Model System Scheduling Model System Figure 4 23 Main Dialog Box of the Interactive User Interface The Generation Allocation Model System button opens up a dialog box within the generation allocation modeling framework as shown below with buttons for 1 Generation and Timing of Work and School Activities of Adults and Children 2 Generation of Children s Travel Needs and Allocation of Responsibilities to Parents and 3 Generation of Independent Activities by Adults and Children for Personal and Household Serving Needs 32 CEMDAP v 3 1 User s Manual CEMDAP Generation Allocation Model System Generation and Timing of Work and School es of Adults and Children Generation of Children s Travel Needs and Allocation of Responsibilities to Parents Generation of Independent Activities by Adults and Children for Personal and Household Serving Needs Figure 4 24 Generation Allocation Model System Interactive User Interface Clicking on each of the buttons opens up the corresponding suite of individual model components shown in the following pages 33 CEMDAP v 3 1 User s Manual CEMDAP Generation amp Timing of Work and School Activities of Adults and Children X For each child who is a student ion to go to School GAL School Start Time GAZ School End Time GA3 For each employed adult Decision to go to Work GA4 Work Start and End Time GAS D
79. rs The completely configured dialog box looks as shown on the next page Note If the user needs to change the number of base line time intervals after clicking Edit it is advised that the model configuration be cancelled and reconfigured WH Number of Stops Utility Function From Linear terms entered Households 0 2064 female Persons 3 0 4111 studying Zones 0 1876 wdurhigh Other 1 8e 003 income Ster 0 1302 30005 number of school going SS 0 5915 30029 adult undertakes work re hid 0 7581 30041 adult undertakes shoppi n adults 0 5915 30043 adult undertakes housek n autos z 0 3601 30044 adult undertakes social zone_id 0 7798 30046 adult undertakes other s kids 0 3326 30048 adult undertakes shopp structure 0 4099 30052 adult undertakes housek naunemp 1 8e 003 30014 work end time hhincome 0 4334 30063 commute mode is driver zeroch Coefficient Threshold Values 2 L Threshold 1 2 Value 0 8019 0293 Figure 4 52 Example of Fully Configured Ordered Probit Model Work Start and End Time Model The work start and end time model has a different model structure and configuration than all other model structures discussed above see Guo et al 2005 for the details on its model structure The inputs required for this model parameters and variables are entered just like the parameters and variables of the linear regression model Note
80. scribe the various parameters associated with that model In order to describe the variables the Variable ID of each variable is first entered in the Variable ID part and then the corresponding parameter of the variable is coded in the value part It is also possible to give a description for the variable in the optional description part Once the entire variables embedded in the model are defined the model is closed The reader will note that each row under the lt Variables gt command represents a single variable The following configuration presents the framework for one of the Location Choice models in CEMDAP Location choice stops in a workers tour commute The first variable of the model has a variable ID of 30 65 and the corresponding value of the parameter is 0 2495 lt ModelConfig id location choice stops in a workers tour commute optional type classCLocationMM gt lt Variables gt lt Variable ID 30165 value 0 2495 optional description unavailable gt lt Variable ID 30166 value 0 6848 optional description unavailable gt lt Variable ID 30167 value 0 1684 optional description unavailable gt lt Variable ID 30168 value 0 163 optional description lt unavailable gt lt Variable ID 30169 value 0 4021 optional description unavailable gt lt Variable ID 30170 value 1 2076 optional description unavailable gt lt Variable ID 30171 value 1 259 optional description unav
81. service 2 Allow PostgreSOL to auto generate the password Hit NEXT by leaving the Account password and Verify password section blank the password is not reguired for running PostgreSOL b In the Initialize database cluster page 1 Leave the Initialize database cluster check box checked 2 Choose the Superuser name We recommend using postgres as the user name 3 Enter the password we recommend using postgres as the password 4 Please make sure you specify and write down your account name say postgres this will be used as the User name and the password This information will be required for accessing your database later c Inthe Enable procedural languages page 1 Please accept the default settings and Hit Next d Inthe Enable contrib modules 69 CEMDAP v 3 1 User s Manual 1 Please accept the default settings and Hit Next e Inthe PostGIS page 1 Please accept the default settings and Hit Next 2 Setting up the CEMDAP database Once PostgreSQL is properly installed on your machine follow Start Programs PostgreSQL pgAdmin III to run PostgreSQL This opens up a database maintenance window You should be able to see in the database explorer left hand side panel the name of the database server e g PostgreSQL Database Server 8 2 that you created To access the database double click on the database server name This will prompt a dialog box for the password Enter the user password you set up during the ins
82. t Home to Work Commute Number of Stops WSCH3 Interactive UI Number of Tours WSCH 4 5 6 Tour Mode WSCH7 Number of Stops in Tour WSCH8 Home Stay Work Stay Duration before Tour WSCH9 TT ee Activity Type at Stop WSCH10 Activity Duration at Stop WSCH11 Trawel Time to Stop WSCH12 Stop Location WSCH13 MOON MRENE Figure 4 15 List of Scheduling Worker Models within the Models menu CEMDAP Data BAG Simulation Help Generation Allocation Scheduling Children Scheduling Worker ecified Commute Mode WSCH1 Work to Home Commute Number of Stops WSCH2 Home to Work Commute Number of Stops WSCH3 Dat Scheduling Non Worker Scheduling Joint Interactive UI Number of Tours WSCH 4 5 6 Tour Mode WSCH7 Number of Stops in Tour WSCH8 Home Stay Work Stay Duration before Tour WSCH9 Activity Type at Stop WSCH10 Activity Duration at Stop WSCH11 Travel Time to Stop WSCH12 Stop Location WSCH13 Figure 4 16 List of Number of Tours Models within Scheduling Worker in the Models menu 28 CEMDAP v 3 1 User s Manual CEMDAP Generation Allocation Scheduling Children Scheduling Non Worker Scheduling Joint ecified Commute Mode WSCH1 Work to Home Commute Number of Stops WSCH2 Home to Work Commute Number of Stops WSCH3 Interactive UI Number of T
83. t of that alternative After the utility functions for all alternatives are configured click on OK to complete the model configuration specification The reader should note that clicking on the Clear Function button clears all the coefficients and variables so that the utility function can be reconfigured 53 CEMDAP v 3 1 User s Manual WH commute mode Utility Function Alternative Drive Alone From Linear terms entered Pesons MB 1 3069 30000 Constant One Zones 1 15e 002 30017 expected no stop we Other Variable hid pid employed studying license work_zon stud_zon female age EE 0 0115 Clear function Figure 4 49 Example of Fully Configured Multinomial Logit Model Binary Logit The binary logit model is a special case of the multinomial logit model with only two alternatives It follows the same method of configuration as the multinomial logit The binary logit model however is simpler since it has only one utility function corresponding to the Yes alternative to be configured The No alternative is always taken as the base with zero utility For example consider the Decision to go to Work Model within the generation allocation model system The alternatives are either that the person decides to go to work on the given day or not Hence there is only a single utility function to be configured with the other alternative No serving as the base The
84. ta inputs which include the population characteristics zonal descriptives and level of service data of the transportation network and b model parameters for all the components of the embedded model system 3 1 1 Data Inputs The data inputs to CEMDAP are provided in the form of tables There are six main types of tables The Household table contains the household level characteristics such as residential location and number of vehicles of the population and the Persons table contains the person level characteristics such as employment status and work location The Zones table comprises data on the characteristics of each of the traffic analysis zones such as population and employment The Zone2Zone table includes data such as distance between each of the zonal pairs CEMDAP allows the analyst to specify the inter zonal level of service measures for any number of time periods The Losdir table identifies the names of the LOS tables included and the time of day period corresponding to each of these tables Finally there are as many LOS tables with names as specified in the Losdir table each containing several inter zonal LOS measures such as travel times and costs for different modes Each table comprises several required data items or columns These data include record identifiers such as household ID and person ID and other basic information required by the CEMDAP modeling system In addition the Households and Persons tables
85. tallation process Tip have the password stored to avoid having to type it in every time you want to access the database After you enter the password the Databases icon will be visible under the database server name To create a new database right click on the Databases icon and choose New Database This will prompt a new dialog box In this dialog box enter the name of the database and note down the given name Note The name can be whatever the user desires Ex CEMDAP Test Data Select Encoding as SOL ASCII and leave the other fields empty The procedure of loading data into this empty database is described in the subsequent sections 2 1 Create Tables To access the empty database click on the symbol to the left of the database name Note you may have to double click on the database name the first time you access the database Press OK if a new window pops up Then you should be able to see items such as Casts Languages Schemas and Replication listed under the database name in the Explorer Expand Schemas and expand Public You will see that the database currently contains no tables as indicated by Tables 0 Therefore the next step is to create the skeleton of CEMDAP input tables To do so 1 Select Tools gt Query Tool from the menu 2 Paste the query statement provided below into the Query window and press F5 or select Query Execute from the menu to run the query A message will appear Query returned succ
86. tion unavailable gt lt Variable ID 30072 value 0 3462 optional description unavailable gt lt Variable ID 30029 value 0 8791 optional description unavailable gt lt Variable ID 30041 value 0 6869 optional description unavailable gt lt Variable ID 30043 value 1 0051 optional description unavailable gt lt Variable ID 30044 value 0 6032 optional description unavailable gt lt Variable ID 30045 value 0 5741 optional description unavailable gt lt Variable ID 30046 value 0 8444 optional description unavailable gt lt Variable ID 10002 value 0 2135 optional description unavailable gt lt Variable ID 12 value 0 2483 optional description unavailable gt lt Variable ID 30022 value 0 1465 optional description unavailable gt lt Variables gt lt Thresholds gt lt Threshold value 3 1768 gt lt Threshold value 4 0896 gt lt Threshold value 4 7494 gt lt Threshold value 5 194 gt lt Thresholds gt lt ModelConfig gt 87 CEMDAP v 3 1 User s Manual 5 Hazard Duration Model The first line in the Hazard Duration Model starts with the name of the model that is coded in the ModelConfig id part The class of the model classCHazardMM is also identified in the first line of the configuration in the optional type part The second line in the syntax specifies the variance value of the model The third line indicates an opening command f
87. tive gt lt Alternatives gt lt ModelConfig gt 3 Linear Regression Model The first line in the Linear Regression Model starts with the name of the model that is coded in the ModelConfig id part The class of the model classCRegressMM is also identified in the first line of the configuration in the optional type part The second line in the syntax specifies the variance value of the model if the value of the variance is zero then the user should enter a very small value for variance such as 0 00001 The third line indicates an opening command for the variables of the model The subsequent lines then describe the various parameters associated with that model In order to describe the variables the Variable ID of each variable is first entered in the Variable ID part and then the corresponding parameter of the variable is coded in the value part It is also possible to give a description for the variable in the optional description part Once the entire set of variables embedded in the model are defined the model is closed The reader will note that each row under the lt Variables gt command represents a single variable The following configuration presents the framework for one of the Linear Regression models in CEMDAP Adult s school start time time from 3 AM The variance of the model has a value of 0 0764 The first variable of the model is constant that has a variable ID of 30000 and the corresponding value of the parameter is
88. u for more information System Data Source Driver PostgreSQL ANSI Figure 4 5 Create New Data Source Finish Screen 6 In the PostgreSOL ANSI ODBC dialog box shown below enter the name of the Data Source Note The Data Source can be given any name therefore you can leave the default name name of the Database ex CEMDAP Test Data Note this name should be the same as the database name that was created in data loading process described in Appendix B localhost as the name of the server the appropriate username and password of the postgreSQL data base installed in the machine see Appendix B 5432 as the Port prefer as the SSL Mode and provide a description ex Test Data of the database After entering all the above mentioned items click Save PostgreSQL ANSI ODBC Driver psglODBC Setup X Data Source PostgreSQL30 Description Test Data SSL Mode Prefer v Database CEMDAP Test Data D Server localhost Port 5432 ij User Name postgres Password mmm Options Figure 4 6 PostgreSQL ANSI ODBC Dialog Box 22 CEMDAP v 3 1 User s Manual 7 Finalize the database registration process by clicking OK to close the dialog boxes CEMDAP is now set up to access the database file you registered Select Data Source Machine Data Source File Data Source Data Source Name Type Description dBASE Files User System Test Data Excel

CEMDAP User`s Manual - The University of Texas at Austin

Contents

Download Pdf Manuals

Related Search

Related Contents