TSB Investigation Marine

Owned by Diego Cesa de Meira (Unlicensed)
Sept 11, 2019
2 min read

Description

Transportation Safety Board (TSB) Marine Investigation
Canada has the longest coastline of any country in the world; total marine freight traffic is nearly 450 million tonnes. In this environment, transportation safety is crucial

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.

Marine Incidents (Occurrence) consists of two types:

  • Reportable - Class 2 or 3

  • Non-reportable

Originator

  1. Transportation Safety Board (TSB)

Use Cases

  1.  

Source(s)

Description

Source

Format

Date

Update Frequency

Metadata

Cost

Link

Remarks

Description

Source

Format

Date

Update Frequency

Metadata

Cost

Link

Remarks

Marine Incidents

TSB

CSV

Current

Monthly

Data Dictionary
Data Dictionary

Free

Occurrence Data
Marine Vessel Data

Updated on 15th of the month

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 Transformation:

  1. In FME, use the Feature Merger transformer to join the Occurrence and Marine Vessel dataset using OccNo as the primary key.

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

  3. A typical Report URL looks like this: http://www.bst-tsb.gc.ca/eng/rapports-reports/marine/2017/m17a0004/m17a0004.asp

  4. Replace m17a0004 with the OccNo and 2017 with OccYear.

  5. Transform the Lat/Long to point.

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

  7. 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\Marine\TSB_Investigation-Marine.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