AIR ROUTE TRAFFIC CONTROL CENTER FACILITIES AND COMMUNICATIONS DATA BASE RECORD LAYOUT (AFF-FILE) INFORMATION EFFECTIVE DATE: 4/26/1999 RECORD FORMAT: FIXED LOGICAL RECORD LENGTH: 251 FILE STRUCTURE DESCRIPTION: --------------------------- THERE ARE A VARIABLE NUMBER OF FIXED-LENGTH RECORDS FOR EACH AIR ROUTE TRAFFIC CONTROL CENTER FACILITY. THE AIR ROUTE TRAFFIC CONTROL CENTER FACILITY FILE (ARTCC) CONTAINS ALL REMOTE AIR/GROUND FACILITIES (RCAG), AIR ROUTE SURVEILLANCE RADARS (ARSR), SECONDARY RADARS (SECRA), AND CENTER RADAR APPROACH CONTROL FACILITIES (CERAP), UNDER U.S. AREA OF RESPONSIBILITY. THE FILE DOES NOT INCLUDE ANY FOREIGN FACILITIES AND/OR RADARS. THE NUMBER OF RECORDS IS DETERMINED BY: 1) THE AMOUNT OF TEXTUAL REMARKS PERTAINING TO THE AIR ROUTE TRAFFIC CONTROL CENTER 2) FREQUENCIES AND THEIR USES ASSOCIATED WITH EACH AIR ROUTE TRAFFIC CONTROL CENTER 3) THE AMOUNT OF TEXTUAL REMARKS PERTAINING TO FREQUENCIES AND THEIR USES THE RECORDS ARE IDENTIFIED BY A RECORD TYPE INDICATOR (AFF1, AFF2, AFF3, AFF4), AND THE ARTCC CENTER IDENTIFIER, LOCATION, AND FACILITY TYPE. THE FILE IS SORTED BY CENTER IDENTIFIER, LOCATION, FACILITY TYPE, RECORD TYPE, (FREQUENCY, ASSOCIATED AIRPORT IDENT) - AFF3 RECORDS ONLY EACH RECORD ENDS WITH A CARRIAGE RETURN CHARACTER AND LINE FEED CHARACTER (CR/LF). THIS LINE TERMINATOR IS NOT INCLUDED IN THE LOGICAL RECORD LENGTH. DESCRIPTION OF THE RECORD TYPES: -------------------------------- 'AFF1' RECORDS CONTAIN GENERAL DESCRIPTIVE LOCATION INFORMATION PERTAINING TO THE AIR ROUTE TRAFFIC CONTROL CENTER FACILITY. THERE IS ALWAYS ONE 'AFF1' RECORD. 'AFF2' RECORD(S) CONTAIN(S) TEXTUAL REMARKS PERTAINING TO THE AIR ROUTE TRAFFIC CONTROL CENTER FACILITY. THERE CAN BE 0 TO 50 'AFF2' RECORDS. 'AFF3' RECORD(S) CONTAIN(S) THE COMMUNICATIONS FREQUENCIES AND THEIR USES AS THEY ARE RELATED TO THE AIR ROUTE TRAFFIC CONTROL CENTER FACILITY. THERE CAN BE 0 TO 50 'AFF3' RECORDS. 'AFF4' RECORD(S) CONTAIN(S) TEXTUAL REMARKS PERTAINING TO THE COMMUNICATIONS FREQUENCIES AND THEIR USE. THERE CAN BE 0 TO 50 'AFF4' RECORDS. GENERAL INFORMATION: -------------------- 1. LEFT JUSTIFIED FIELDS HAVE TRAILING BLANKS 2. RIGHT JUSTIFIED FIELDS HAVE LEADING BLANKS 3. ELEMENT NUMBER IS FOR INTERNAL REFERENCE ONLY AND NOT IN THE RECORD. 4. THE UNIQUE RECORD IDENTIFIER IS MADE UP OF THE CENTER IDENTIFIER, LOCATION, AND FACILITY TYPE. 5. LATITUDE AND LONGITUDE INFORMATION IS REPRESENTED IN TWO WAYS: A. FORMATTED: ------------ LATITUDE DD-MM-SS.SSSH LONGITUDE DDD-MM-SS.SSSH WHERE : DD IS DEGREES MM IS MINUTES SS.SSS IS SECONDS H IS DECLINATION EXAMPLE : LAT- 39-06-51.070N LONG- 075-27-54.660W B. IN ALL SECONDS: ----------------- LATITUDE AND LONGITUDE SSSSSS.SSSH WHERE : SSSSSS.SSS IS THE DEG/MIN/SEC CONVERTED TO ALL SECONDS H IS THE DECLINATION EXAMPLE : LAT- 140811.070N LONG- 271674.660W ********************************************************************* 'AFF1' RECORD TYPE - BASE DATA ******************************************************************** J T L S L E N U Y E T O L U S P N A C E M T E G R A M B T T T E E H I N R O T N FIELD DESCRIPTION L AN 04 00001 NONE RECORD TYPE INDICATOR. AFF1 - AIR ROUTE TRAFFIC CONTROL CENTER FACILITY INFORMATION L AN 0003 00005 DLID AIR ROUTE TRAFFIC CONTROL CENTER IDENTIFIER. (EX: ZAB) ADMINISTRATIVE DATA ------------------- L AN 0040 00008 NONE AIR ROUTE TRAFFIC CONTROL CENTER NAME. (EX: ALBUQUERQUE) L AN 0030 00048 DLID SITE LOCATION. LOCATION OF THE FACILITY CONTROLLED BY THE AIR ROUTE TRAFFIC CONTROL CENTER. (EX: SANDIA MOUNTAIN) L AN 0050 00078 FF21 CROSS REFERENCE. ALTERNATE NAME FOR REMOTE COMMUNICATIONS AIR/GROUND FACILITY AND AIR ROUTE SURVEILLANCE RADAR. (EX: ALBUQUERQUE) L AN 0005 00128 DLID FACILITY TYPE. TYPE CODE DESCRIPTION --------- ----------- ARSR AIR ROUTE SURVEILLANCE RADAR ARTCC AIR ROUTE TRAFFIC CONTROL CENTER CERAP CENTER RADAR APPROACH CONTROL FACILITY RCAG REMOTE COMMUNICATIONS, AIR/GROUND SECRA SECONDARY RADAR L AN 0010 00133 NONE INFORMATION EFFECTIVE DATE (MM/DD/YYYY) THIS DATE COINCIDES WITH THE 56 DAY CHARTING AND PUBLICATION CYCLE EFFECTIVE DATE. L AN 0020 00143 FF2S SITE STATE NAME. (EX: NEW MEXICO) L AN 0002 00163 FF2 SITE STATE POST OFFICE CODE. (EX: NM) GEOGRAPHICAL DATA ----------------- L AN 0014 00165 FF4 SITE LATITUDE. (FORMATTED) L AN 0011 00179 FF4S SITE LATITUDE. (SECONDS) L AN 0014 00190 FF5 SITE LONGITUDE. (FORMATTED) L AN 0011 00204 FF5S SITE LONGITUDE. (SECONDS) L AN 0037 00215 NONE BLANK. ********************************************************************* 'AFF2' RECORD TYPE - SITE REMARKS DATA ********************************************************************* J T L S L E N U Y E T O L U S P N A C E M T E G R A M B T T T E E H I N R O T N FIELD DESCRIPTION L AN 04 00001 NONE RECORD TYPE INDICATOR. AFF2 - REMARKS RECORD. L AN 0003 00005 DLID AIR ROUTE TRAFFIC CONTROL CENTER IDENTIFIER. (EX: ZAB) L AN 0030 00008 DLID SITE LOCATION. LOCATION OF THE FACILITY CONTROLLED BY THE AIR ROUTE TRAFFIC CONTROL CENTER. (EX: SANDIA MOUNTAIN) L AN 0005 00038 DLID FACILITY TYPE. L AN 0004 00043 NONE SITE REMARKS ELEMENT NUMBER. (EX: 1) L AN 0200 00047 NONE SITE REMARKS TEXT. (EX: ARSR SHARED WITH CLEVELAND ARTCC) L AN 0005 00247 NONE BLANK. ************************************************************************ 'AFF3' RECORD TYPE - COMMUNICATIONS FREQUENCY(S) AND THEIR USES ************************************************************************ J T L S L E N U Y E T O L U S P N A C E M T E G R A M B T T T E E H I N R O T N FIELD DESCRIPTION L AN 04 00001 NONE RECORD TYPE INDICATOR. AFF3 - FREQUENCY(S) AND THEIR USES. L AN 0003 00005 DLID AIR ROUTE TRAFFIC CONTROL CENTER IDENTIFIER. (EX: ZAB) L AN 0030 00008 DLID SITE LOCATION. LOCATION OF THE FACILITY CONTROLLED BY THE AIR ROUTE TRAFFIC CONTROL CENTER. (EX: SANDIA MOUNTAIN) L AN 0005 00038 DLID FACILITY TYPE. FREQUENCY/ALTITUDE/USE DATA ---------------------------- L AN 0007 00043 NONE FREQUENCY ASSOCIATED WITH THE FACILITY. (EX: 269.4) L AN 0010 00050 FQ20 ALTITUDE. INDICATION OF WHETHER LOW, HIGH, LOW/HIGH, AND/OR ULTRA HIGH TRAFFIC IS CONTROLLED ON EACH FREQUENCY. (EX: LOW) L AN 0017 00060 FQ21T SPECIAL USAGE NAME. SPECIAL USAGE NAME FOR EACH FREQUENCY. USAGES: APPROACH CONTROL DISCRETE DO NOT PUBLISH OCEANIC IFR SERVICE PROVIDED TO LANDING FACILITY ---------------------------------------- L AN 0004 00077 E7 LOCATION IDENTIFIER ASSIGNED TO THE LANDING FACILITY (AIRPORT). (EX: E80) L AN 0020 00081 A4S ASSOCIATED STATE NAME. (EX: NEW MEXICO) L AN 0002 00101 A4 ASSOCIATED STATE POST OFFICE CODE. (EX: NM) L AN 0026 00103 A1 ASSOCIATED CITY NAME. (EX: BELEN) L AN 0042 00129 A2 OFFICIAL AIRPORT NAME. (EX: ALEXANDER MUNI) L AN 0014 00171 A19 LATITUDE OF THE AIRPORT. (FORMATTED) L AN 0011 00185 A19S LATITUDE OF THE AIRPORT. (SECONDS) L AN 0014 00196 A20 LONGITUDE OF THE AIRPORT. (FORMATTED) L AN 0011 00210 A20S LONGITUDE OF THE AIRPORT. (SECONDS) L AN 0031 00221 NONE BLANK. ********************************************************************* 'AFF4' RECORD TYPE - REMARKS DATA ******************************************************************** J T L S L E N U Y E T O L U S P N A C E M T E G R A M B T T T E E H I N R O T N FIELD DESCRIPTION L AN 04 00001 NONE RECORD TYPE INDICATOR. AFF4 - REMARKS RECORD. L AN 0003 00005 DLID AIR ROUTE TRAFFIC CONTROL CENTER IDENTIFIER. (EX: ZAB) L AN 0030 00008 DLID SITE LOCATION. LOCATION OF THE FACILITY CONTROLLED BY THE AIR ROUTE TRAFFIC CONTROL CENTER. (EX: SANDIA MOUNTAIN) L AN 0005 00038 DLID FACILITY-TYPE. L AN 0007 00043 NONE FREQUENCY ASSOCIATED WITH THE REMARK. (EX: 269.4) L AN 0002 00050 NONE FREQUENCY REMARK SEQUENCE NUMBER. (EX: 1) L AN 0200 00052 NONE FREQUENCY REMARKS TEXT. (EX: PRIMARY FOR AREA NE AND E OF HNL VORTAC OUT TO APPROXLY 90NM)