Skip to contentUnited States Department of Transportation - Federal Highway Administration FHWA Home
Research Home
Report
This report is an archived publication and may contain dated technical, contact, and link information
Publication Number: FHWA-HRT-06-089
Date: July 2006

PBCAT-Pedestrian and Bicycle Crash Analysis Tool

Version 2.0

PDF Version (14.7 MB)

PDF files can be viewed with the Acrobat® Reader®

 

CHAPTER 8. DATABASE OPTIONS

PBCAT allows the user to export a database for use in other applications or import a database that was created in Version 1.0 of the software. These options are accessed from the Database menu. (See figure 89.)

 

The Database menu includes options for importing and exporting data

Figure 89. Image. Import and export data.

 

IMPORT A DATABASE

The import function is designed to import a database that was created in Version 1.0 of the PBCAT software. Selecting Import from the Database menu produces the window shown in figure 90. The steps for importing are as follows:

 

The import function is designed for importing a PBCAT Version 1.0 database

Figure 90. Image. Import a PBCAT Version 1.0 database.

 

Step 1: Select the source database.Click the Browse button to open a window to search for and select the Version 1.0 database. (See figure 91.) Click Open, and the path and file name will be entered on the Import Database window.

Step 2: Select the destination database. Click the Browse button to open a window and enter a name for the converted file within the desired folder. Click Save, and the path andfile name will be entered on the Import Database window.

 

A click on the Browse button opens a window for the user to select the database to be imported

Figure 91. Image. Select the database to be imported.

 

Step 3: Import the database. Click Import to begin the conversion process. A status bar at the bottom of the window shows the progress of the conversion. When done, a message will appear to indicate that the process was completed successfully.

Step 4: Add the database. Once the database has been converted, it must be added to the list of Available Databases within Preferences before it can be accessed within the application. Refer to the instructions in chapter 4 for more details.

Special Note: Data from other types of crash databases may also be imported into PBCAT. However, such an operation requires a basic understanding of database concepts and structures. The file layout for the PBCAT.MDB database is provided in appendix D forthose users who are interested in this type of import operation.

 

EXPORT A DATABASE

The export feature is designed to assist users in a two ways. First, it allows those users requiring more extensive analysis and reporting options to export the data into Excel or a statistical analysis program. Second, it allows the export of specific variables that can be appended to a larger database. An example of the latter may be the export of the crash report number and the crash type variables, which may then be merged with a State or municipal crash database thatalready contains all other relevant variables.

Selecting Export from the Database menu produces a Database Export window, as shown in figure 92, which allows the user to customize the information to be exported. The steps for exporting are as follows:

 

The Export window allows the user to select the database and fields to be exported, and to choose the format options

Figure 92. Image. Select database and fields to be exported and choose format.

 

Step 1: Select the database and data type. Choose the database and data type to be exported. The data type will either be pedestrian or bicyclist.

Step 2: Select the form. Choose the form from the list of available forms in the dropdown list.The fields used in the selected form will be used to populate the list of fields available for export.

Step 3: Select the fields to be exported. Place a check next to all fields that are to be exported. All fields are initially selected. Fields can be deselected by clicking on the box and removing the check. The user can also Select All and Select None using the buttons on the right side of the window.

Step 4: Choose header option. Check the box next to Export Column Header if the database should be exported with column headers, which are the database field names.

Step 5: Select the file format. The user defines the type of file to be created upon export by selecting either Excel or a delimited text file with fields separated by either a comma, semicolon, ~, or TAB). The user can also select the Quoted option, which will result in quotes being placed around each variable. This option may be required if there are fields being exported in adelimited format that contain the chosen separator.

Step 6: Preview the file. Prior to exporting the file, the user may view the database to be created by clicking on Preview.

Step 7: Export the file. Click on Export to complete the export process. If Excel is chosen as the file format, the data will be exported into an Excel workbook, which can then be saved. If a delimited format is chosen, a window will open requesting the file name to be entered and saved.

 

FHWA-HRT-06-089

Previous | Table of Contents | Next

ResearchFHWA
FHWA
United States Department of Transportation - Federal Highway Administration