This is the online help for the National Collision Database (NCDB) Online.
This is a quick overview of the four steps for creating a table using NCDB Online. For more detailed information, see the topics for Step 1, Step 2, Step 3, and Step 4.
If you want to change your selections or the layout of your table, you can return to any page at any time. To return to a page, click the links for Step 1, Step 2, Step 3, or Step 4 at the top of the page.
Back to top
First use the Select variables page to choose the variables for your table. Variables will appear as dimensions.
Variables are arranged into four categories, as follows:
After you have chosen the variables for your table, you can use the Select items page to select items for each variable.
Note that you can also request 'no totals' by deselecting all of the choices. 'No totals' is the best choice for variables that only have one selected item -- for example, if you are only selecting one year for the Year variable.
If you have not selected any options under Totals to calculate, it does not matter what is selected under Display of totals and items.
If you want to accept the default item selections for a variable, you do not have to open it or make any selections. These are the default item selections for all variables:
The variables Age and Collision Hour have a Ranges section as well as an Items section. You can select a range of values as well as, or instead of, individual values.
Note that if you select both ranges and totals, the totals will be calculated intelligently. That is, they will not contain double counts.
When you have finished selecting variables and items for your table, you can use the Set table layout page to define your table's layout.
Layout refers to the positioning of dimensions on the rows, the columns, and the Other dimension area of a table. You can use the Set dimension order section of this page to lay out your table.
When you have finished laying out your table, select Next step to display your table on the View table page.
The View table page displays your data in the form of a table.
The tasks you can perform on the View table page are described here:
The current pagination of the table appears just above the table. For example, it might say 'Rows 1 to 20 of 30', or 'Columns 1 to 3 of 3'.
If a table has more rows or columns than you can see on one page, you can select Page up, Page down, Page left, or Page right to see more.
Downloading a table saves it on your computer.
To download a table:
Notes provide information about objects such as tables, dimensions, or items.
Other dimensions are those that appear in the Other dimension area. Other dimensions are not on the rows or the columns, but their data affects the values in the table.
This section of the help describes other pages in the NCDB Online application, such as the download page, the online help and tutorials, and the summary pages.
The Download page appears when you have selected a file format for the table you wish to download. It informs you of the size of the downloaded file.
Note: In order to maintain acceptable performance on the site, download limits (the total number of cells that can be downloaded) have been set. If you exceed the limit a message will appear. In that case you should reduce the number of variables in your table or the number of selected items in the variables.
The Variable details page provides additional information about the selected variable. The following information may be provided:
To open the details page for a variable, select the Details icon next to the variable's name.
The Item notes page provides additional information (metadata) about a dimension item.
The Dimension notes page provides additional information (metadata) about a dimension.
The Table summary page provides additional information (metadata) about a table.
A dimension is a category of data in a table, such as Weather or Age. You create dimensions by choosing variables.
Reports have three dimension positions: Column dimensions, Row dimensions, and Other dimensions.
© Her Majesty the Queen in Right of Canada, as represented by the Minister of Transport.