Client Identification Database (CID) platform site bulk upload procedures

Transport Canada's Client Identification Database Platform, herein referred to as TC CID Platform, addresses recommendations made by the Office of the Auditor General of Canada, that Transport Canada improve its knowledge of stakeholders involved in the importing, offering for transport, handling, or transportation of dangerous goods (DG) herein referred to DG activities. In response to this recommendation, the Transportation of Dangerous Goods (TDG) Directorate is introducing a new requirement for businesses involved in DG activities to register and provide information on their DG activities. For more detailed information, please visit the Canada Gazette, Part II Volume 157, Number 22.

On this page

Getting started

While individual site registrations can be done one (1) at a time, utilizing the Site Bulk Upload Excel Workbook is a highly efficient and time-saving solution for registering or updating multiple sites simultaneously.

You have the option to name each site in the workbook, although it is not mandatory. However, each entry must include the following:

  • site location, which can be specified using one (1) of the following:
    • mailing address; applicable to postal codes that do not start with a zero (0);
    • legal land description; only available for rural and remote areas of Manitoba, Saskatchewan, Alberta, British Columbia;
    • latitude and longitude;
  • at least one (1) mode of transport;
  • at least one (1) type of activity; and
  • which classes and/or divisions apply to the site.

Download a workbook

Any site information that existed in the platform when you download the workbook will be included. Any information you upload will replace existing information on the platform. Please download a new version of your workbook when updating any of your site information.

  1. Sign into the CID Platform
  2. Select “Sites” from the left-hand menu
  3. Select “Download Bulk Site Upload Workbook” and save it on to your computer
  4. Open the workbook file

Create or update a workbook

  1. Enter a unique name for each site (optional). This name is for your reference.
  2. Enter the site's location using one (1) of these methods:
    • mailing address
      • enter the site's mailing address by completing the fields as marked;
      • in “Address Line 1” enter the street number, name, and abbreviated street type such as Dr, St, Cres;
      • for “Address Line 2” (Optional) enter any other information about the site, like a room number or specific entrance; and
      • for “Address Line 3” (Optional) enter any other relevant information, like your desk number or office cubicle.
    • legal land description
      • complete the fields as marked using the form's drop-down menus.
    • latitude and longitude
      • enter the site's latitude and longitude in decimal degrees using four (4) decimal points (e.g., 45.1234), you must include four (4) decimal points;
      • latitude must be between 40.0000 and 80.0000; and
      • longitude must be between -50.0000 and -150.0000.
  3. Enter the types of activities occurring on the site. Select "Yes" from the drop-down menu if the site performs the listed type of work:
    • importing: you import dangerous goods into Canada. This doesn't apply when goods are being transported on a vessel or aircraft not registered in Canada.
    • handling: loading, unloading, packing, or unpacking dangerous goods in a means of containment.
    • offering for transport: choosing a carrier, and/or preparing dangerous goods for transport by a carrier.
    • transporting: moving dangerous goods from one place to another.
  4. Enter the modes of transportation that are used to move dangerous goods to/from your site. If your site uses the mode listed in the column header, then choose “Yes” from the drop-down menu:
    • road: dangerous goods transported by road.
    • rail: dangerous goods transported by rail.
    • air: dangerous goods transported by air.
    • marine: dangerous goods transported by water where the means of containment is not the vessel, such as freighters, ferries.
  5. Enter the classes/divisions of dangerous goods that your site handles:
    • separate each class/division with a comma;
    • for class 1, include the compatibility group for each division; and
    • for classes 2 to 6, compatibility groups are not required.

      Need help?

      • Find a list of classes and divisions in Appendix A
      • Find a list of compatibility groups for Class 1, Explosives in Appendix B
  6. This field already displays the site status, indicating whether it's active or inactive.
  7. Any information from previous workbooks can be copied and pasted on to a new workbook. You will have to copy/paste into the section between Column A (Site Name) and Column X (Class/Division) starting with row 7 and however many rows of input you have after row 7. (Row 7 is the first row for inputting sites.).

Upload a workbook

  1. Save the completed workbook to your local folder
  2. On the CID portal, select Choose File and select the workbook you saved on your local folder
  3. Select Start Upload
  4. You will receive an email confirmation once the workbook upload is completed
    • If the upload fails, you will receive an email that will outline the errors that need to be corrected
  5. Select Next when your workbook is uploaded

Appendix A: Classes and divisions

Class/Division

Description

Class 1.1

Substances and articles which have a mass explosion hazard

Class 1.2

Substances and articles which have a projection hazard but not a mass explosion hazard

Class 1.3

Substances and articles which have a fire hazard and either a minor blast hazard or a minor projection hazard or both, but not a mass explosion hazard

Class 1.4

Substances and articles which present no significant hazard

Class 1.5

Very insensitive substances which have a mass explosion hazard

Class 1.6

Extremely insensitive articles which do not have a mass explosion Hazard

Class 2.1

Flammable gases

Class 2.2

Non-flammable, non-toxic gases

Class 2.3

Toxic gases

Class 3

Flammable liquids

Class 4.1

Flammable solids, self-reactive substances and solid desensitized explosives

Class 4.2

Substances liable to spontaneous combustion

Class 4.3

Substances which in contact with water emit flammable gases

Class 5.1

Oxidizing substances

Class 5.2

Organic peroxides

Class 6.1

Toxic substances

Class 6.2

Infectious substances

Class 7

Radioactive material

Class 8

Corrosive substances

Class 9

Miscellaneous dangerous substances and articles

Appendix B: Compatibility groups for Class 1, Explosives

When choosing Classes under Class 1, you must enter the class, division, and compatibility group.

Compatibility Group

Description

Possible Class

A

Primary explosive substance

1.1

B

Article containing a primary explosive substance and not containing two or more effective protective features. Some articles (such as detonators for blasting, detonator assemblies for blasting and primers, cap-type) are included in the compatibility group set out in column 2 even though they do not contain primary explosives

1.1
1.2
1.4

C

Propellant explosive substance or other deflagrating explosive substance or article containing such an explosive substance

1.1
1.2
1.3
1.4

D

Secondary detonating explosive substance or black powder or article containing a secondary detonating explosive substance, in each case without means of initiation and without a propelling charge or article containing a primary explosive substance and containing two or more effective protective features

1.1
1.2
1.4
1.5

E

Article containing a secondary detonating explosive substance, without means of initiation, with a propelling charge (other than one containing a flammable liquid, flammable gel, or hypergolic liquids)

1.1
1.2
1.4

F

Article containing a secondary detonating explosive substance with its own means of initiation, with a propelling charge (other than one containing a flammable liquid, flammable gel, or hypergolic liquids) or without a propelling charge

1.1
1.2
1.3
1.4

G

Pyrotechnic substance, an article containing a pyrotechnic substance or an article containing an explosive substance and an illuminating, incendiary, tear- or smoke-producing substance (other than a water-activated article or one containing white phosphorus, phosphides, a pyrophoric substance, a flammable liquid, flammable gel, or hypergolic liquids)

1.1
1.2
1.3
1.4

H

Article containing an explosive substance and white phosphorus

1.2
1.3

J

Article containing an explosive substance and a flammable liquid or flammable gel

1.1
1.2
1.3

K

Article containing an explosive substance and a toxic substance

1.2
1.3

L

Explosive substance or article containing an explosive substance and presenting a special risk (e.g., that is due to water activation or to the presence of hypergolic liquids, phosphides, or a pyrophoric substance) that needs isolation of each type

1.1
1.2
1.3

N

Articles containing only extremely insensitive detonating substances

1.6

S

Substance or article packed or designed so that any hazardous effects arising from accidental functioning are confined within the means of containment unless the means of containment has been degraded by fire, in which case all blast or projection effects are limited to the extent that they do not significantly hinder or prevent firefighting or other emergency response efforts in the immediate vicinity of the means of containment

1.4