Sequence of Events

Introduction

The file was provided to Loyd by the NTSB.

Data Source Characteristics

  • Data file: CICTT_SOE_MAP.csv

  • Format: csv

  • Size: < 1 MB

  • Update frequency: very unlikely (data file came directly from the NTSB)

Data Target Characteristics

  • Database management system: PostgreSQL

  • Database name: io_avstats_db

  • Database table: io_sequence_of_events

Data Processing

  • Repository: io-avstats

  • Script: run_io_avstats_dev

  • Task: l_s_e (Load sequence of events data into PostgreSQL)

Processing Steps:

  1. Make the csv file with the name CICTT_SOE_MAP.csv available in the file directory data/Sequence_of_Events.

  2. Manually create an MS Excel file from the pdf document with the columns CICTT Code, Identifier and Definition.

  3. Load the MS Excel file with the task l_s_e into the PostgreSQL database.

For detailed processing steps, refer to the external repository: io-avstats

Configuration Parameter:

download_file_sequence_of_events = "data/Sequence_of_Events/CICTT_SOE_MAP.csv"
download_file_sequence_of_events_remarks = "File from NTSB via Loyd"

Contact Information

  • not available