CATS - STAC

System Profile

System Full Name	Civil Aviation Terminology System
System Full Name (French)	Système de terminologie de l'Aviation civile
Business Administrator	Ruxandra Lungu
Business Owner	Guy Houdin
Director	Angèle Saumur
Subject Matter Expert	Mike Clark
Division
NTARS Code	CA68-CA12
Source Location
Source Code Location	http://tfsprod:8080/tfs/CivAv/CATS-STAC/_dashboards
Migration to DevOps
New Source Code Location (DevOps)	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CATS-STAC

Technology Assessment

Platform Type	Web (External)
Database Platform and Version	Oracle 18C
Development Language and Framework	ASP.NET
Operating System and Version	Windows Server 2016
Additional Dependencies
Authentication

Environment Access Information

ENV	UNC	WWWFILES	URL	DB

ENV	URL	DB
DEV		CATSD
PREACC
ACC		CATSA
PROD	http://wwwapps.tc.gc.ca/Saf-Sec-Sur/2/cats-stac/	CATSP
TRAINING

System Overview

Terminology bank for Civil Aviation.

The Civil Aviation Terminology System (CATS) is a collection of about 18,000 term records that were created by members of Aviation Terminology and Linguistic Services for use of aviation people world-wide. This application is used by the Aviation Terminology Standardization group of Transport Canada.

Banque de données terminologiques pour l'aviation civilee.

Good To Know

<--->

How-To and Fixes

<Sub-sections should describe how to address known support request, including any scripts, instructions / steps, etc… >

139279 CATS Report - All the term records - Open Government is asking for the whole dataset from CATS.

Query to return all the terms and definitions, formatted so it’s displayed/sorted properly when dataset is exported to Excel.

select title_eng, title_fr, 
replace(term_eng,Chr(13),Chr(13) || Chr(10)), 
replace(term_fr,Chr(13),Chr(13) || Chr(10)) 
from term_clobs order by UPPER(Replace(title_eng,'"','')) ;

Once data is in Excel:

Replace all occurrences of   with “ “ (one space)