Saving evaluations in databases

You can use the direct output to save the following evaluations to a database (Configuring the database connection for evaluations):

Vehicle record (Saving vehicle record to a file or database)
Vehicle travel times (raw data) (Evaluating vehicle travel time measurements)
Pedestrian record (Saving pedestrian record to a file or database)
Nodes (raw data) (Evaluating nodes)
Signal changes (Evaluating signal changes)

1. Ensure that the database connection is configured (Configuring the database connection for evaluations).

2. From the Evaluation menu, choose > Configuration > Direct Output tab.

3. For the desired evaluation, select the option Write database.

4. Make the desired changes:

Element	Description
From time	Simulation second in which the evaluation is started
To time	Simulation second in which the evaluation is finished
More	Evaluation-specific parameters. These are described in the individual evaluations.

5. Confirm with OK.

6. Start the simulation (Running a simulation).

The database file is saved. A table EvalInfo is created for the evaluations in the database. The table contains the evaluations with the user-defined name of the table in the Table name column. If you wish to execute multiple simulation runs, the data from the simulation runs is saved only in a database table. In the attribute list, multiple columns with the same title name are merged to one column.

Note: If you wish to execute multiple simulation runs and to save the results in a database table, avoid switching the selection of attributes between simulation runs. Otherwise, the table with the previous data simulation runs will be deleted.

Data from the simulation run are saved after the simulation end to the directory ..\<Name of network file>.results in the default data format *.db.

Superordinate topic:

Configuring evaluations for direct output