2018.01.10 by Ed Trager
Last updated: 2018.06.15 by Ed Trager
The VIPA data are currently divided into three parts:
The CASES table provides data on individual pedestrian and bicyclist cases. The table contains data on the type of accident, the accident conditions, the pedestrian or bicyclist who was involved, the year, make and model of the involved vehicle, and so on.
The CASES table itself contains groups of columns within sets of sections. The sections are, reading the columns from left to right, as follows:
Occasionally one person may have been struck by more than one vehicle. Also occasionally several people may be struck by a single vehicle. These cases are considered as single incidents in which there were multiple impacts or multiple people involved. Hence, you may see rows in the table where the same v_incident_id occurs several times.
The INJURIES table list the injuries sustained by injured individuals. There may be multiple injuries for each individual in this table. The v_person_id in this table refers back to the v_person_id in the CASES table (many-to-one relationship).
The IMPACTS data table lists x,y, and z contact locations and wrap distances. The v_iop_id —the impact on person (iop) identifier— in this table links back to the v_iop_id in the CASES table (many-to-one relationship). There are multiple contacts for each individual in this table.
To clarify the distinction made here between impact and contacts, consider the following example: Suppose that a person is struck first by one vehicle, and then by a second vehicle. In this case, the person would appear in two rows of the CASES table, but each row would contain a unique impact on person v_iop_id identifier. Then, for each of those v_iop_ids in the CASES table, you would find several corresponding rows in the IMPACTS table showing each of the various impact points on the vehicle, such as front bumper, hood, side mirror, windshield, etc.. These are what we call contacts, and for each contact you will find relevant data such as the type of impact (i.e., trace vs. deformation, etc.) and x ,y, and z coordinates, inter alia.
The web application provides three (3) views onto the data.
The grid windows labeled CASES, INJURIES, and IMPACTS represent the three primary views of the data as described above. The title bars of these primary grid windows are shown in blue.
For more sophisticated views, download the data so that you can perform your own custom joins across the three tables that we have provided. The primary keys are as follows:
In the CASES view, all cases which have accompanying PDF documents are marked with green check marks in the icam_sf_no column. Simply click anywhere within a checked row to open the associated PDF. PDFs will open in a separate browser window.
Cases with associated PDF documents are marked with green check marks.
Click anywhere within a checked row to open the PDF.
The data are conveniently displayed in flexible grid windows. This section describes how to use these grid windows effectively and efficiently.
The grid windows function more or less as window panes in operating systems such as Windows or MacOS operate. However these windows are part of the web application and do have some unique aspects. Basic usage is as follows:
Iconified windows appear on a shelf at the bottom of the application window
A rolled up window
The data grids provide many convenient features for viewing the data. Scrolling across the data is summarized below:
The data grids also provide convenient ways to manipulate the columns. Usage is summarized below:
Click and drag a column header onto the target to freeze a column
Frozen columns appear on the left and have a distinct background color
Right click on a column label to display the column context menu
Clicking on "unique" provides a listing of unique column
values with frequency and percentage of occurrence
You may filter the data displayed in the grid by specifying search criteria. To begin, first click on the magnifying glass search icon.
To filter data, first click on the magnifying glass search icon
This will bring up an advanced search window. Choose the columns and search criteria that you want to filter on. To filter on multiple columns, just press the (+) plus button and be sure to select a conjunction, either AND or OR. Note that you may need to wrap OR statements in opening and closing parentheses, ( and ), especially if you also include AND statements. To use parentheses, simply click on the ( or ) to toggle them as active. Be sure that you have matched pairs of opening and closing parentheses. Then just click on the Search button. To clear all filters, just press Clear Filters and the grid will return to displaying the complete data set.
Choose terms and criteria to filter on in the Search dialog box, then click on the Search button.
The grid will now load the subset of data that match your search criteria. At the bottom of the grid, the status bar will indicate the total number of rows that match your search criteria. The grid will now display a green funnel in the upper right hand corner to indicate that an active filter is present on the view. To modify or eliminate the filter, simply click on the magnifying glass icon again.
A filtered data set. In this view, data have been restricted to observations of
Iris versicolor with petal lengths greater than 4.0 cm. The green funnel icon in the upper right
corner reminds us that this is a filtered view of the data.
To download data, simply click on the download tray icon which appears just to the right of the magnifying glass search icon in the upper right corner of the grid.
To download data, click on the download tray icon
just to the right of the magnifying glass search icon
If any filters are active, then only the filtered subset of data will be present in the downloaded file.
The downloaded file can be easily opened in Microsoft Excel, LibreOffice, Pages, or a similar spreadsheet program.