TSB Pipeline Investigation

Description

Transportation Safety Board (TSB) Pipeline Investigation
The TSB's team of experts has extensive knowledge and experience in the areas of pipeline engineering, metallurgy, welding and control systems, as well as the pipeline regulatory environment. We have access to and use highly trained specialists and state-of-the-art equipment to examine and test pipeline components involved in occurrences in order to identify and confirm safety deficiencies. TSB pipeline investigators also serve on and actively participate in various government and industry committees, activities and forums in order to monitor trends and promote the safety messages resulting from our investigations.

The TSB is an independent agency, created by an Act of Parliament (the Canadian Transportation Accident Investigation and Safety Board Act). Its mandate is to advance transportation safety in the marine, pipeline, rail and air modes of transportation by:

• conducting independent investigations, including public inquiries when necessary, into selected transportation occurrences in order to make findings as to their causes and contributing factors;

• identifying safety deficiencies, as evidenced by transportation occurrences;

• making recommendations designed to eliminate or reduce any such safety deficiencies; and

• reporting publicly on our investigations and on the findings in relation thereto.

Pipeline Incidents (Occurrence) consists of two types:

• Reportable - Class 2 or 3

• Non-reportable

Originator

1. Transportation Safety Board (TSB)

Use Cases

Source(s)

Remarks

1. Join two tables using OccNo as primary key to form a superset.

2. The data on occurrences are released on or soon after the 15th of each month, and date to the last day of the month preceding their release.

Process for EGIS integration

CSV File:

1. Download the Occurrence and Aircraft CSV file from TSB.

2. In FME, use the Feature Merger transformer to join the Occurrence and Aircraft dataset using OccNo as the primary key.

3. Insert a new attribute to hyperlink TSB Report for records with OccClassID=2 or 3.

4. A typical Report URL looks like this: https://www.tsb.gc.ca/eng/rapports-reports/pipeline/2011/p11h0011/p11h0011.html

5. Replace p11h0011 with the OccNo and 2011 with OccYear.

6. Transform the Lat/Long to point.

7. Output to KML, SHP or GDB as required.

8. Import into EGIS

Display Optimization:

1. Sampled/thinned data (generated using data sampling technique) and Class 2 & 3 incidents are displayed at small and medium scale. With scale transition, original data are displayed at large scale thus improve display performance and reduce cluttering.

TC Smart Maps:

1. Not all GIS applications can consume KML file directly due to its unique data structures such as networklinks, folders, models etc.

2. Please contact Lawrence Chong, Digital Services Directorate for TC Smart Maps KML dataset and format translation.

3. TC Smart Maps KML link: \\tc.gc.ca\tcgis\GISData\Google Mashup\TSB_Investigation\Pipeline\TSB_Investigation-Pipeline.kmz

Customization:

1. Schema transformation: As required

2. Denormalization: Not required

3. Value coding: Not required

4. Attribute renaming: As required to improve readability

5. Attribute removal: It is highly recommended as some fields are unnecessary, this will also reduce file size and improve performance

6. Geoenrichment: Feature symbolization is recommended to improve visualization. OccClassID=2 or 3 are reportable incidents. It can be symbolized differently and display at smaller scale.

7. Format translation: Not required

8. Language translation: French version available

9. Update frequency: As identified