MILITARY TRAINING ROUTE DATA BASE RECORD LAYOUT (MTR-FILE) INFORMATION EFFECTIVE DATE: 07/19/2018 RECORD FORMAT: FIXED LOGICAL RECORD LENGTH: 519 FILE STRUCTURE DESCRIPTION: --------------------------- THERE ARE A VARIABLE NUMBER OF FIXED-LENGTH RECORDS FOR EACH MILITARY TRAINING ROUTE (MTR). THE NUMBER OF RECORDS IS DETERMINED BY THE AMOUNT OF TEXTUAL INFORMATION USED TO DESCRIBE THE ROUTE AND THE NUMBER OF POINTS (OR SEGMENTS) ALONG THE ROUTE. EACH OF THE SIX RECORD TYPES WILL BE IDENTIFIABLE BY A RECORD TYPE INDICATOR (MTR1, MTR2,...,MTR6) AND THE ROUTE TYPE AND IDENTIFIER. THE RECORDS ARE IN SEQUENCE, I.E., ALL TEXT RECORDS FOLLOW THEIR READABLE ORDER AND ALL SEGMENT RECORDS ARE IN ORDER ALONG THE COURSE OF THE ROUTE. THE FILE IS SORTED BY ROUTE IDENTIFIER, RECORD TYPE, AND RECORD SEQUENCE NUMBER (INSURES THAT MULTIPLE RECORDS OF A SPECIFIC TYPE ARE IN TEXT/POINT ORDER). 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: -------------------------------- 'MTR1' RECORD TYPE CONTAINS THE BASE MILITARY TRAINING ROUTE DATA. THERE IS ONE MTR1 RECORD FOR EACH ROUTE. 'MTR2' RECORD TYPE CONTAINS TEXTUAL INFORMATION REGARDING ANY SPECIAL OPERATING PROCEDURES. EACH MTR2 RECORD CONTAINS ONE LINE OF TEXT. THERE CAN BE ZERO OR MORE MTR2 RECORDS, DEPENDING ON THE LENGTH OF THE PROCEDURE. 'MTR3' RECORD TYPE CONTAINS TEXTUAL INFORMATION DESCRIBING THE ROUTE WIDTH DIMENSIONS FOR THE ENTIRE ROUTE OR FOR ROUTE SEGMENTS. EACH MTR3 RECORD CONTAINS ONE LINE OF TEXT. THERE CAN BE 0 OR MORE MTR3 RECORDS. 'MTR4' RECORD TYPE CONTAINS TEXTUAL INFORMATION REGARDING TERRAIN FOLLOWING OPERATIONS ALONG THE ROUTE. EACH MTR4 RECORD CONTAINS ONE LINE OF TEXT. THERE CAN BE ZERO OR MORE MTR4 RECORDS. 'MTR5' RECORD TYPE DESCRIBES EACH POINT. IT INCLUDES THE EXACT LATITUDE/LONGITUDE LOCATION OF THE POINT, ITS LOCATION RELATIVE TO A NAVAID, AND TEXTUAL INFORMATION DESCRIBING ALTITUDE, TURNING, AND OTHER SUCH INSTRUCTIONS BOTH LEADING UP TO THE POINT AND AFTER PASSING THE POINT. 'MTR6' RECORD TYPE CONTAINS AGENCY INFORMATION. EACH MTR6 RECORD CONTAINS ONE LINE OF TEXT. THERE CAN BE ZERO OR MORE MTR6 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 RECORD 4. THE MTR ROUTE ID IS MADE UP OF THE ROUTE TYPE AND ROUTE IDENTIFIER. IT IS REPEATED ON EACH RECORD USED TO DESCRIBE THAT ROUTE. 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 ********************************************************************* 'MTR1' RECORD TYPE - BASE ROUTE DATA ******************************************************************** L AN 04 00001 N/A RECORD TYPE INDICATOR. MTR1: BASE ROUTE DATA L AN 0003 00005 DLID ROUTE TYPE. IR: IFR VR: VFR R N 0005 00008 DLID ROUTE IDENTIFIER. L AN 0008 00013 N/A PUBLICATION EFFECTIVE DATE YYYYMMDD L AN 0003 00021 MTR20 FAA REGION CODE L AN 0080 00024 MTR91 ARTCC IDENT. 20 OCCURENCES OF 4 CHARACTER IDENT. L AN 0160 00104 MTR29 ALL FLIGHT SERVICE STATION (FSS) IDENTS WITHIN 150 NAUTICAL MILES OF THE ROUTE. 40 OCCURENCES OF 4 CHARACTER IDENT. L AN 0175 00264 MTR21 TIMES OF USE TEXT INFORMATION. L AN 0076 00439 N/A BLANKS R N 0005 00515 N/A SORT SEQUENCE NUMBER FOR RECORD ******************************************************************** 'MTR2' RECORD TYPE - STANDARD OPERATING PROCEDURES TEXT ******************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. MTR2: SPEC. OPER. PROC. TEXT L AN 0003 00005 DLID ROUTE TYPE. IR: IFR VR: VFR R N 0005 00008 DLID ROUTE IDENTIFIER. L AN 0100 00013 MTR28 STANDARD OPERATING PROCEDURE TEXT L AN 0402 00113 N/A BLANKS R N 0005 00515 N/A SORT SEQUENCE NUMBER FOR RECORD ******************************************************************** 'MTR3' RECORD TYPE - ROUTE WIDTH DESCRIPTION TEXT ******************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. MTR3: ROUTE WIDTH TEXT L AN 0003 00005 DLID ROUTE TYPE. IR: IFR VR: VFR R N 0005 00008 DLID ROUTE IDENTIFIER. L AN 0100 00013 MTR45 ROUTE WIDTH DESCRIPTION TEXT L AN 0402 00113 N/A BLANKS R N 0005 00515 N/A RECORD SORT SEQUENCE NUMBER ******************************************************************** 'MTR4' RECORD TYPE - TERRAIN FOLLOWING OPERATIONS TEXT ******************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. MTR4: TERRAIN FOLLOWING OPER. TEXT L AN 0003 00005 DLID ROUTE TYPE. IR: IFR VR: VFR R N 0005 00008 DLID ROUTE IDENTIFIER. L AN 0100 00013 MTR46 TERRAIN FOLLOWING OPERATIONS TEXT L AN 0402 00113 N/A BLANKS R N 0005 00515 N/A RECORD SORT SEQUENCE NUMBER ******************************************************************** 'MTR5' RECORD TYPE - ROUTE POINT DATA ******************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. MTR5: ROUTE POINT DATA L AN 0003 00005 DLID ROUTE TYPE. IR: IFR VR: VFR R N 0005 00008 DLID ROUTE IDENTIFIER. L AN 0005 00013 N/A ROUTE POINT ID. A,B,C, ETC. NOTE: THE 'READABLE' ORDER FOR FIELD MTT24 REQUIRES LOOKING AT THE POSSIBLE FOUR LINES OF SEGMENT/ALTITUDE DESCRIPTION TEXT PRECEDING THE POINT, THEN THE POINT INFORMATION ITSELF (POINT ID, NAVAID DATA, LAT/LONG), THEN ANY TEXT IN THE FOUR OCCURENCES OF DESCRIPTION LEAVING THE POINT. L AN 0228 00018 MTT24 SEGMENT DESCRIPTION TEXT LEADING UP TO THE POINT MAXIMUM OF 4 OCCURENCES OF 57 CHARACTERS EACH L AN 0228 00246 MTT24 SEGMENT DESCRIPTION TEXT LEAVING THE POINT MAXIMUM OF 4 OCCURENCES OF 57 CHARACTERS EACH L AN 0004 00474 MTT25 IDENT OF RELATED NAVAID L AN 0005 00478 MTT26 BEARING OF NAVAID FROM POINT L AN 0004 00483 MTT27 DISTANCE OF NAVAID FROM POINT R AN 0014 00487 MTT4 LATITUDE LOCATION OF POINT R AN 0014 00501 MTT5 LONGITUDE LOCATION OF POINT R N 0005 00515 MTT21 RECORD SORT SEQUENCE NUMBER (SEGMENT SEQUENCE NUMBER FOR THIS POINT ALONG ROUTE) ******************************************************************** 'MTR6' RECORD TYPE - AGENCY DATA ******************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. MTR6: BASE ROUTE DATA L AN 0003 00005 DLID ROUTE TYPE. IR: IFR VR: VFR R N 0005 00008 DLID ROUTE IDENTIFIER L AN 0002 00013 MTR30 AGENCY TYPE CODE O: ORIGINATING S1: SCHEDULING-1 S2: SCHEDULING-2 S3: SCHEDULING-3 S4: SCHEDULING-4 L AN 0061 00015 MTR30 AGENCY ORGANIZATION NAME L AN 0030 00076 MTR31 AGENCY STATION L AN 0035 00106 MTR36 AGENCY ADDRESS L AN 0030 00141 MTR36 AGENCY CITY L AN 0002 00171 MTR32 AGENCY STATE (ALPHA POST OFFICE CODE) L AN 0010 00173 MTR33 AGENCY ZIP CODE L AN 0040 00183 MTR34 AGENCY COMMERCIAL PHONE NUMBER L AN 0040 00223 N/A AGENCY DSN PHONE NUMBER L AN 0175 00263 N/A AGENCY HOURS L AN 0077 00438 N/A BLANKS R N 0005 00515 N/A RECORD SORT SEQUENCE NUMBER