AM Engineering Data Base Page 1 21 April 1997 FEDERAL COMMUNICATIONS COMMISSION Mass Media Bureau Audio Services Division AM Engineering Data Base Release Tape (AMDATA.DAT) The AM Engineering Data Base is an unofficial secondary source. It is designed solely for use by FCC Engineers as an aid for processing applications, petitions for rulemaking, and notifications. The various data elements are the minimum deemed necessary for the stated purpose. Its usefulness to any other group or for any other purpose is coincidental. See Section 0.434 of the FCC Rules for a further warning and disclaimer. This description applies to the format in which the FCC's AM Engineering Data Base is stored on magnetic tape when it is made available outside of the FCC. In the FCC's VAX computer, the AM Engineering Data Base is stored as an indexed file. However, it is necessary to unload it into a sequential file to copy it on tape. This description applies to the tape format of file AMDATA.DAT. The tape is recorded pursuant to ANSI X3.27-1978 (FIPS Pub 79) using variable length records in 2048-byte blocks. Although the second file on this tape contains fixed-length records, the file is written on the tape as though it contained variable-length records. The first file contains records that are truly variable length. The volume identifier in the Volume-Header Label is "FCCAM". As this is being written, the characters are from the ASCII character set. However, it is possible that, in the future, there may be characters from the Latin Alpha 1 character set from ISO Standard 8859; these include accented characters, etc., and are an expansion to the ASCII character set. The tape contains two files. The files are: 1. The tape description. This document is included on the tape so that users who receive the tapes on a periodic basis can compare the first file on each tape with the first file on the previous tape. If there are no changes, then the format and descriptions have not changed. However, if there are differences, it is necessary to review the first file on the new tape to determine what changes in format and/or descriptions have been made. The first file will also contain announcements about possible future changes. 2. The AM Engineering Data Base (file AMDATA.DAT). This contains the engineering data for all existing and proposed stations, both foreign and domestic, in Region 2 (the Western Hemisphere). Pertinent engineering parameters, such as power, frequency, class, AM Engineering Data Base Page 2 21 April 1997 and coordinates, are included, as well as identifying information such as call sign, city, state, and country. Parameters for individual towers and for augmentations are included when appropriate. The data base is stored as an indexed file on disk. Each indexed record is 600 characters in length. The first record in the file is a header record. The final record in the file is a trailer record. The other records contain information about AM stations. A logical record for a station may contain one or more 600-character records. The first 600-character record contains the basic information, such as call, city, state, frequency, etc., plus the information for towers 1, 2, and 3, and for the first augmentation. The second 600-character record contains the information for towers 4 through 10. The third 600-character record contains the information for towers 11 through 17. The fourth 600-character record contains the information for augmentations 2 through 28. The 600-character record exists only if needed. For instance, a two-tower operation with 2 augmentations will have only records 1 and 4. In the description below, the record number is referred to as the "Item Number". Thus, a logical record can contain 600, 1200, 1800, or 2400 characters, depending on the number of towers and augmentations. When the file is written to tape, each 600-character record is written separately. Thus, the file on tape will contain only 600-character records; it will not contain variable length records. However, as noted above, they are stored on the tape as though they were variable length. Each different operation of the station is in a separate logical record. Thus, there will be separate day and night logical records, if the day and night parameters are different. If the day and night parameters are the same, there will be only one logical record, an unlimited time record. There are also different logical records for different statuses, such as applications, construction permits, and licenses. This description covers Format Versions 100 and 101. All of the information is stored in character format; floating point numbers and integers are not used. Accordingly, the numbering for the beginning of the field and the length of the field is in characters. Numeric fields are right justified, and will have leading spaces rather than leading zeros to fill the field. If you obtained the tape from NTIS, and the tape is bad, contact NTIS. If you are having trouble with the tape structure, refer to ANSI standard _____ _______ X3.27-1978, particularly Section 6.2 entitled Block Formats. Because the AM Engineering Data Base Page 3 21 April 1997 records are treated as variable length in both files on the tape, Section _______________ _______ ___ 6.2.3, entitled Variable-Length Records (D), is especially pertinent. Please report any errors, omissions, etc., in the data to: Computer Support Staff Room 350 Federal Communications Commission 1919 M St., NW Washington, DC 20554 (202) 418-2789 _______ _____ Release Notes The coordinate reference system for the latitudes and longitudes given in this data base is the North American Datum of 1927 (NAD 27). The FCC is reviewing the steps required to convert to the North American Datum of 1983 (NAD 83). The Commission will issue further guidance on the conversion to NAD 83 as more information becomes available. _______ ______ _______ Planned Future Changes ATTENTION ATTENTION ATTENTION The FCC has redesigned and restructured the AM Engineering Data Base. It has been converted to a relational data base. This change will take place on or about May 1, 1997. The existing structure and format (file AMDATA.DAT) will be retained for about six months to allow users to convert to the new structure. (For a good description of relational data bases, __ ____________ __ ________ _______ see An Introduction to Database Systems, Volume I, Fourth Edition, by C. J. Date, Addison-Wesley Publishing Co., 1986.) The data base will have several relations (tables or files) defined as follows: o The primary AM Engineering Data Base, containing things such as power, frequency, class, coordinates, hours of operation, call sign, city, state, etc. o The AM Towers, with a separate record for the data (field ratio, phasing, etc.) for each tower. o The AM Augmentations, with a separate record for the data (span, central azimuth, etc.) for each augmentation. o The AM Comments, providing for zero or more comments per record in the primary AM Engineering Data Base. The new structure description has been appended to the end of this description. AM Engineering Data Base Page 4 21 April 1997 FCC Primary AM Engineering Data Base (AMDATA.DAT) General Comments Following is a brief description of the data elements in the AM Engineering Data Base. The description includes the name of the data element, its starting position in the record, its length, and a definition of the element itself. THE HEADER RECORD The header record contains a field to identify it as the header, the volume number, the date of last update of the entire data base, and the Format Version of the data base. (There is also other information in the header record, but that is meaningful only to FCC programs.) Following is a description of the data elements in the header record: Data Element Begins Length Description Header Indicator 1 12 This indicates that this is in fact the header record. Although the header record is the first one in the data base, this is also an indicator. It has the following value: 000000000000 Unused 13 6 This is extra space for future use. Volume Number 19 5 The volume number of the data base. This is incremented by one each time that the data base is updated. This is right justified. Next CL Number 24 5 The next available change list number. Last Update Date 29 6 This is the date of last update of the entire data base. It is in the format of YYMMDD. Distinguish this from the date of last update field in each record. The date of last update field in each record refers to the date of last update of that record, while this date of last update refers to the date of last update of anything in the data base. Format Version 35 6 The Version of the Format for the AM Engineering Data Base. Each time that the record layout of the data base changes, the Format Version will be incremented by one. The description of the record layout will specify which Format Versions it covers. AM Engineering Data Base Page 5 21 April 1997 People writing programs that read the data base can examine the Format Version, and have their programs act differently for different versions, if desired. Unused 41 560 This is extra space for future use. AM Engineering Data Base Page 6 21 April 1997 THE TRAILER RECORD The trailer record contains a field to identify it as the trailer. Following is a description of the data element in the trailer record: Data Element Begins Length Description Trailer Indicator 1 12 This indicates that this is in fact the trailer record. Although the trailer record is the last one in the data base, this is also an indicator. It has the following value: 999999999999 Unused 13 588 This is extra space for future use. AM Engineering Data Base Page 7 21 April 1997 THE INDEXED KEY Following is a description of the indexed key. The indexed key is the first 12 characters of each 600-character record. Data Element Begins Length Description Frequency 1 4 The AM frequency, ranging from 540 through 1700. If the frequency is below 1000, a leading zero is included. In Region 2, the frequencies are in 10 kHz increments. In Regions 1 and 3, the frequencies are in 9 kHz increments. Control number 5 6 The control number uniquely identifies each record. If the data base is sorted by control number, then a listing that is, more or less, in order by state and city results. The records are ordered first by country. Following is the present range of control numbers for the countries: 000,000 to 099,999 Not used 100,000 to 699,999 United States 700,000 to 799,999 Canada 800,000 to 899,999 Mexico 900,000 to 909,999 Bahamas 910,000 to 919,999 Cuba 920,000 to 928,999 Dominican Republic 929,000 to 929,999 Greenland 930,000 to 939,999 Haiti 940,000 to 999,998 Other Countries in Region 2 in no particular order Users should not rely on the ranges of control numbers because they will change as we load more data concerning other countries in the Western Hemisphere. Within each country, the records are ordered by state according to the actual spelling of the state, not necessarily the two-character abbreviation. Within each state, the records are ordered by city. And within each city, the records are ordered by frequency. The values of the control numbers, although not the sequence of the control numbers, are subject to change; therefore, only the sequence, not the values, should be relied AM Engineering Data Base Page 8 21 April 1997 upon. Item Number 11 2 Tells the structure of the record. The structure of the record varies with the Item Number. Item 1 contains basic information such as call, city, state, frequency, plus towers 1 through 3, and the first augmentation. Item 2 contains the information for towers 4 through 10. Item 3 contains the information for towers 11 through 17. Item 4 contains the information for augmentations 2 through 28. The remainder of this description will depend on the item number. AM Engineering Data Base Page 9 21 April 1997 Item 1 Following is the description of the format for Item 1: Data Element Begins Length Description Frequency 1 4 See above. Control Number 5 6 See above. Item Number 11 2 See above. Since this is item 1, this will have a value of "01". ID Number 13 6 A six-character password for each record. These are subject to change and should not be relied upon. Country 19 2 A two-character field indicating which country the station is located in. Following is a list of 2-character country abbreviations that are used. These correspond to those used in Federal Information Processing Standards (FIPS) Publication 10-3, February 9, 1984. However, the following list is an abbreviated version of FIPS Pub 10-3, covering only the abbreviations which we use. AC Antigua and Barbuda AR Argentina AV Anguilla BB Barbados BD Bermuda BF The Bahamas BH Belize BL Boliva BR Brazil CA Canada CI Chile CJ Cayman Islands CO Colombia CS Costa Rica CU Cuba DO Dominica DR Dominican Republic EC Ecuador ES El Salvador FA Falkland Islands (Islas Malvinas) FG French Guiana GJ Grenada AM Engineering Data Base Page 10 21 April 1997 GL Greenland GP Guadeloupe GT Guatemala GY Guyana HA Haiti HO Honduras JM Jamaica MB Martinique MH Montserrat MX Mexico NA Netherlands Antilles NS Suriname NU Nicaragua PA Paraguay PE Peru PM Panama SB St. Pierre and Miquelon SC St. Christopher and Nevis ST St. Lucia TD Trinidad and Tobago TK Turks and Caicos Islands US United States UY Uruguay VC St. Vincent and the Grenadines VE Venezuela VI British Virgin Islands Cutoff Date 21 6 Normally, the Cutoff Date for an application. For a Domestic Status of "A", this is the Cutoff Date. For a Domestic Status of "C", this is the date the Construction Permit Expires. This is in YYMMDD format. File No. Prefix 27 4 The prefix to the file number, right justified. The dash between the prefix and the ARN is not included in the data base. App Ref No (ARN) 31 8 The application reference number, or the numeric portion of the file number. This is left justified. Domestic Status 39 1 The status of the record, according to current standing in FCC from viewpoint of FCC authorizations. Possible values are: A Application C Construction Permit D Deleted domestically, but not internationally. L License AM Engineering Data Base Page 11 21 April 1997 M A petition to move to the expanded band with no stereo preference. P Planned; an unapplied-for planned station which is internationally recognized. S A petition to move to the expanded band with a stereo preference. T Test spaces No domestic status. (For example, a Canadian station.) Hours of Oper. 40 1 The operating hours during which the parameters in this record are used. Since the data base is an engineering data base, the hours of operation are used to tell which records are used in which studies. Thus, for example, a DA1 limited time station will have hours of operation of "U" because it is used in both daytime and nighttime studies; it does not mean that the station operates unlimited time. Distinguish this from the complete schedule. Possible values are: U Unlimited. I.e., both day and night, or portions thereof. N Nighttime. D Daytime. C Critical Hours. R Canadian Restricted. P Pre-sunrise. Critical Hours is that time from Sunrise to two hours after Sunrise, and from two hours before Sunset until Sunset, local time. During that time, certain stations may be operating with reduced facilities as a result of Section 73.187 of the Commission's Rules. Canadian Restricted hours are similar to Critical Hours, except that the restriction results from the January 17, 1984, U.S.-Canadian AM Agreement. See Appendix 8 to Annex 2. Canadian Restricted Hours are called "Critical Hours" in the U.S.-Canadian Agreement, but in the data base, we call them "Canadian Restricted Hours" to distinguish them from the domestically defined critical hours in Section 73.187. Canadian Restricted Hours is that from Sunrise to one and one-half hours after Sunrise, and from one AM Engineering Data Base Page 12 21 April 1997 and one-half hours before Sunset until Sunset, local time. U.S. stations operate with restricted hours because of Canadian stations, and vice-versa. Region 2 Class 41 1 The Class (A, B, or C) of the station, as notified to the International Frequency Registration Board (IFRB) pursuant to the Region 2 MF Broadcasting Agreement. Domestic Pattern 42 1 The type of directional antenna pattern, as authorized domestically. Possible values are: T Theoretical S Standard A Augmented Domestic Class 43 2 The Class of the station, according to the FCC Rules and/or NARBA and the Mexican Agreement. The first character is numeric, in the range from 0 through 4, inclusive. The second character is alphabetic, in the range from A through E, inclusive, or spaces. Although the classes in the FCC Rules and international agreements contain Roman numerals and dashs, the classes here are represented with Arabic numbers and no dashs. Thus, a Class II-A station is carried in the data base as 2A. After the effective date of MM Docket No. 87-267, new applications will have domestic classes of "0A", "0B", "0C" or "0D". Dummy Data Switch 45 1 Indicates whether some of the parameters in this record are assumed values, rather than actual values. Possible values are: spaces nothing is assumed. D Something (undefined) is assumed in this record. V Antenna parameters affecting calculations in the vertical plane are assumed; antenna parameters affecting calculations in the ___ horizontal plane are not assumed. 1 Antenna parameters are assumed for parameters affecting calculations in both the horizontal and vertical planes; coordinates are valid. AM Engineering Data Base Page 13 21 April 1997 2 Coordinates are assumed; antenna parameters are valid. 3 The coordinates are assumed, and antenna parameters are assumed for parameters affecting calculations in both the horizontal and vertical planes. Latitude Dir 46 1 The direction for the latitude. It is "N" for North Latitude, and "S" for South Latitude. Latitude Degrees 47 2 The degrees portion of the latitude. Latitude Minutes 49 2 The minutes portion of the latitude. Latitude Seconds 51 2 The seconds portion of the latitude. Longitude Dir 53 1 The direction for the longitude. It is "W" for West Longitude, and "E" for East Longitude. Longitude Degrees 54 3 The degrees portion of the longitude. Longitude Minutes 57 2 The minutes portion of the longitude. Longitude Seconds 59 2 The seconds portion of the longitude. Bad Data Switch 61 1 Indicates whether some of the parameters in this record are known to be bad. (For example, the coordinates in the data base are what a foreign country notified to us, but those coordinates are in the middle of the ocean.) Possible values are: spaces No bad data. B Some (undefined) data is known to be bad. V Antenna parameters affecting calculations in the vertical plane are known to be bad; antenna parameters affecting calculations ___ in the horizontal plane are not known to be bad. 1 Coordinates are known to be bad. 2 Antenna parameters affecting calculations in both the horizontal and vertical planes are known to be bad. 3 The coordinates and antenna AM Engineering Data Base Page 14 21 April 1997 parameters affecting calculations in both the horizontal and vertical planes are known to be bad. Power 62 9 The nominal power of the station, as defined in Section 73.14, in kilowatts. This is not necessarily the effective radiated power, the transmitter power, the antenna input power, etc. There is an implied decimal point between characters 4 and 5. Read it in FORTRAN with an F9.5 format. # of T-S Stations 71 1 The number of stations which share time with this station. No. of towers 72 2 The number of towers in the antenna system. This is one for non-directional stations. Maximum is 17. If it is below 10, there is a leading zero. T-S Call Sign 1 74 9 Call sign of the first station which shares time with this station. T-S Call Sign 2 83 9 Call sign of the second station which shares time with this station. T-S Call Sign 3 92 9 Call sign of the third station which shares time with this station. T-S Call Sign 4 101 9 Call sign of the fourth station which shares time with this station. Updater 110 6 This indicates which agency last updated this record. Possible values are: FCC Updated by the Federal Communications Commission IFRB Updated by the International Frequency Registration Board Initially, this field will not be loaded; therefore, any value other than "IFRB" should be interpreted as "FCC". Periodically, the FCC receives data from IFRB showing the current values in the Region 2 data base. Rather than re-key everything, the FCC simply merges data from the IFRB data base into the FCC data base. This field shows which agency is responsible for the AM Engineering Data Base Page 15 21 April 1997 data. Can Coord Status 116 1 The Canadian Coordination Status. If this is a U.S. record, this refers to the status of our notification to Canada. If this is a Canadian record, this refers to the status of the Canadian notification to the U.S. If this is neither a U.S. nor Canadian record, this should be blank. Possible values are: A Notification that is accepted. B Notification that is accepted with conditions; see remarks. O Notification that is objected to. P Pending status (e.g., awaiting additional data, awaiting clarification). U Unstudied. spaces Not applicable to this record; for example, a Mexican record. Mex Coord Status 117 1 The Mexican Coordination Status. If this is a U.S. record, this refers to the status of our notification to Mexico. If this is a Mexican record, this refers to the status of the Mexican notification to the U.S. If this is neither a U.S. nor Mexican record, this should be blank. Possible values are: A Notification that is accepted. B Notification that is accepted with conditions; see remarks. O Notification that is objected to. P Pending status (e.g., awaiting additional data, awaiting clarification). U Unstudied. spaces Not applicable to this record; for example, a Canadian record. R2 Coord Status 118 1 The Region 2 Coordination Status. If this is a U.S. record, this refers to the status of our notification to the IFRB. If this is not a U.S. record, this refers to the status of the IFRB notification to the U.S. Possible values are: A Notification that is accepted. B Notification that is accepted with conditions; see remarks. AM Engineering Data Base Page 16 21 April 1997 O Notification that is objected to. P Pending status (e.g., awaiting additional data, awaiting clarification). U Unstudied. spaces Not applicable to this record. Tower 1 param. 119 68 Parameters for tower 1. See the separate description of the tower parameters. Tower 2 param. 187 68 Parameters for tower 2. Tower 3 param. 255 68 Parameters for tower 3. City 323 27 The city in which the station is licensed or proposed. State 350 2 The state or province in which the station is licensed or proposed. The possible codes depend on the country. Here are the possibilities: For the United States (country is "US"), we have the following abbreviations for the states, etc.: AK Alaska. AL Alabama. AR Arkansas. AS American Samoa. AZ Arizona. CA California. CO Colorado. CT Connecticut. DC The District of Columbia DE Delaware. FL Florida. FM the Federated States of Micronesia, which is a part of the Caroline Islands. GA Georgia. GU Guam. HI Hawaii. IA Iowa. ID Idaho. IL Illinois. IN Indiana. KS Kansas. KY Kentucky. LA Louisiana. AM Engineering Data Base Page 17 21 April 1997 MA Massachusetts. MD Maryland. ME Maine. MH the Republic of the Marshall Islands. MI Michigan. MN Minnesota. MO Missouri. MP the Northern Marianas. MS Mississippi. MT Montana. NC North Carolina. ND North Dakota. NE Nebraska. NH New Hampshire. NJ New Jersey. NM New Mexico. NV Nevada. NY New York. OH Ohio. OK Oklahoma. OR Oregon. PA Pennsylvania. PR Puerto Rico. PW the Republic of Palou, which is part of the Caroline Islands. RI Rhode Island. SC South Carolina. SD South Dakota. TN Tennessee. TX Texas. UT Utah. VA Virginia. VI the U.S. Virgin Islands (not the British Virgin Islands). VT Vermont. WA the state of Washington (not Washington, DC). WI Wisconsin. WV West Virginia. WY Wyoming. For Canada (country is "CA"), we have the following abbreviations for the Canadian provinces: AB Alberta. BC British Columbia MB Manitoba NB New Brunswick AM Engineering Data Base Page 18 21 April 1997 NF Newfoundland NS Nova Scotia NT Northwest Territories ON Ontario PE Prince Edward Island QU Quebec SA Saskatchewan YU Yukon For Mexico (country is "MX"), we have the following abbreviations for the Mexican states: AG Aguascalientes BN Baja California North BS Baja California South CH Chihuahua CI Coahuila CL Colima CM Campeche CS Chiapas DF Federal District DU Durango GR Guerrero GT Guanajuato HG Hidalgo JA Jalisco MC Michoacan ML Morelos MX Mexico NA Nayarit NL Nuevo Leon OA Oazaca PU Puebla QE Queretaro QR Quintana Roo SI Sinaloa SL San Luis Potosi SO Sonora TA Tamaulipas TB Tabasco TL Tlaxcala VC Vera Cruz YC Yucatan ZA Zacatecas Call Sign 352 7 The Call Sign of the station or application. For applications and construction permits which do not have Call Signs a value of "NEW" is used. AM Engineering Data Base Page 19 21 April 1997 Filler 359 3 Unused. IFRB Plan Date 362 6 Date that this station was entered into the IFRB Plan, in YYMMDD format. Initially, this will be blank as this is loaded; a blank does ___ not necessarily mean that this station is not in the IFRB Plan. Q factor 368 12 Q for the standard pattern formula in Section 73.150 of the FCC Rules. When this is blank, Q according to the Rules should be computed and used. When this is non-blank (including when it is zero), this value of Q should be used as a special Q. There is an implied decimal between characters 4 and 5. Use a FORTRAN F12.8 format with this. Units are __________ millivolts per meter at one kilometer. Antenna Mode 380 3 The mode of the complete antenna system. It indicates whether directional or non-directional, number of patterns, etc. For example: DA1, DA2, DAN, ND1, ND2. Complete Schedule 383 1 The Complete Schedule for this station. Distinguish this from Hours of Operation. Possible values are: D Daytime only. N Nighttime only. U Unlimited time. L Limited time. H Specified Hours. For example, a DA2 station has different patterns for daytime and nighttime. Thus, there would be a daytime logical record and a nighttime logical record. The hours of operation would be "D" in the daytime record, and "N" in the nighttime record, but the complete schedule would be "U" in both records. IFRB List 384 1 An indicator of which IFRB list this appears on. It could be either List A or List B. In the beginning, however, this will be blank because we have not loaded this information. It will also be blank for operations which are not notified. No. augmentations 385 2 The number of augmentations. Minimum is AM Engineering Data Base Page 20 21 April 1997 zero; maximum is 28. If it is below 10, there is a leading zero. Comment 387 76 Comment inserted by the Data Base Management Staff. Augmentation #1 463 21 The parameters for the first augmentation. See the separate description of the augmentation parameters. ========================================================================== If the Format Version in the Header Record is 100, then the following description of the RMS and the Filler following the RMS apply: ========================================================================== RMS 484 6 The RMS of the pattern, in millivolts per __________ meter at one kilometer. For a directional station (i.e., more than one tower), this is the RMS at the nominal power. For a non-directional station (i.e., one tower), this is the RMS at one kilowatt. The RMS is the root-mean-square of the radiation in all directions in the horizontal plane. There is an implied decimal between characters 4 and 5. Use a FORTRAN F6.2 format with this. Filler 490 14 Unused. ========================================================================== If the Format Version in the Header Record is 101, then the following description of the RMS and the Filler following the RMS apply: ========================================================================== RMS 484 7 The RMS of the pattern, in millivolts per __________ meter at one kilometer. For a directional station (i.e., more than one tower), this is the RMS at the nominal power. For a non-directional station (i.e., one tower), this is the RMS at one kilowatt. The RMS is the root-mean-square of the radiation in all directions in the horizontal plane. There is an implied decimal between characters 5 and 6. Use a FORTRAN F7.2 format with this. Filler 491 13 Unused. AM Engineering Data Base Page 21 21 April 1997 ========================================================================== E sub u 504 6 The value of E sub u for this station, _____ according to the Region 2 Agreement. Note: ____ _____ ___ __ ______ __ ___ _______ ___ This value may be loaded in for various FCC ________ ___ __ __ ___ ________ __________ studies, but it is not updated. Therefore, __ ________ ______ __ ______ __ ____ ______ no reliance should be placed on this value. Filler 510 6 Unused. Change List No. 516 5 The Change List Number of the change list associated with this record. If this field is "ORIG", it refers to the original NARBA list. If this field is "USCAN", it refers to the original list in the U.S.-Canadian Agreement if the Change List Date is 840117 or to the separate Class IV listing if the Change List Date is 841215. If this field is "USMEX", it refers to the U.S.-Mexican Class IV power increase agreement if the Change List Date is 841215. For foreign stations, the change list number refers to the latest list which had a change affecting engineering parameters. Change List Date 521 6 The date of the change list in YYMMDD format. Reserved NP 527 9 Reserved for a future use. Filler 536 1 Unused. Notified Status 537 1 The status of records with regard to international notifications. Possible values are: A Negotiated Priority; not notified in operation. O Notified in Operation. P Notified Proposed Operation. T Informally coordinated proposal. U Not Notified. Z Test record. Limiting Call 538 9 The Call Sign of the station which limits this station's hours of operation. IFRB Serial No. 547 9 The Serial Number assigned to this record by the IFRB. This will initially be blank because we have not loaded the information. It will also be blank for non-notified AM Engineering Data Base Page 22 21 April 1997 records. This is left-justified. Last Update date 556 6 The date of the last update of this record. This is in YYMMDD format. Filler 562 27 Unused. Notified Pattern 589 1 The type of the antenna pattern which has been notified to (or by) foreign countries. Possible values are: T Theoretical S Standard A Augmented Filler 590 4 Unused. Reserved for BC 594 7 Reserved for Biased Coordinates; this is not loaded yet. AM Engineering Data Base Page 23 21 April 1997 Items 2 and 3 Following is the description for items 2 and 3. The description for both is identical, except that item 2 covers towers 4 through 10, while item 3 covers towers 11 through 17. Data Element Begins Length Description Frequency 1 4 See above. Control Number 5 6 See above. Item Number 11 2 See above. Since this is either item 2 or 3, this will have a value of either "02" or "03". Filler 13 18 Unused. Tower 4/11 param. 31 68 Parameters for tower 4 (if item 2) or tower 11 (if item 3). See the separate description of the tower parameters. Tower 5/12 param. 99 68 Parameters for tower 5 (if item 2) or tower 12 (if item 3). Tower 6/13 param. 167 68 Parameters for tower 6 (if item 2) or tower 13 (if item 3). Tower 7/14 param. 235 68 Parameters for tower 7 (if item 2) or tower 14 (if item 3). Tower 8/15 param. 303 68 Parameters for tower 8 (if item 2) or tower 15 (if item 3). Tower 9/16 param. 371 68 Parameters for tower 9 (if item 2) or tower 16 (if item 3). Tower 10/17 param 439 68 Parameters for tower 10 (if item 2) or tower 17 (if item 3). Filler 507 94 Unused. AM Engineering Data Base Page 24 21 April 1997 Item 4 Following is the description of the format for Item 4: Data Element Begins Length Description Frequency 1 4 See above. Control Number 5 6 See above. Item Number 11 2 See above. Since this is item 4, this will have a value of "04". Filler 13 18 Unused. Aug #2 param. 31 21 Parameters for augmentation #2. See the separate description for the augmentation parameters. Aug #3 param. 52 21 Parameters for augmentation #3. Aug #4 param. 73 21 Parameters for augmentation #4. Aug #5 param. 94 21 Parameters for augmentation #5. Aug #6 param. 115 21 Parameters for augmentation #6. Aug #7 param. 136 21 Parameters for augmentation #7. Aug #8 param. 157 21 Parameters for augmentation #8. Aug #9 param. 178 21 Parameters for augmentation #9. Aug #10 param. 199 21 Parameters for augmentation #10. Aug #11 param. 220 21 Parameters for augmentation #11. Aug #12 param. 241 21 Parameters for augmentation #12. Aug #13 param. 262 21 Parameters for augmentation #13. Aug #14 param. 283 21 Parameters for augmentation #14. Aug #15 param. 304 21 Parameters for augmentation #15. Aug #16 param. 325 21 Parameters for augmentation #16. Aug #17 param. 346 21 Parameters for augmentation #17. Aug #18 param. 367 21 Parameters for augmentation #18. AM Engineering Data Base Page 25 21 April 1997 Aug #19 param. 388 21 Parameters for augmentation #19. Aug #20 param. 409 21 Parameters for augmentation #20. Aug #21 param. 430 21 Parameters for augmentation #21. Aug #22 param. 451 21 Parameters for augmentation #22. Aug #23 param. 472 21 Parameters for augmentation #23. Aug #24 param. 493 21 Parameters for augmentation #24. Aug #25 param. 514 21 Parameters for augmentation #25. Aug #26 param. 535 21 Parameters for augmentation #26. Aug #27 param. 556 21 Parameters for augmentation #27. Aug #28 param. 577 21 Parameters for augmentation #28. Filler 598 3 Unused. AM Engineering Data Base Page 26 21 April 1997 Tower Parameters Following is a description of the parameters used for each tower. Each of these parameters is stored beginning at the starting position for each tower. Data Element Begins Length Description Field Ratio 1 9 The ratio of the fields radiated by each tower. There is an implied decimal between characters 2 and 3. Use a FORTRAN F9.7 format with this. Electrical Height 10 5 The height of the radiator in electrical degrees. This is not normally the height above ground. Usually it is the height above insulator without obstruction lighting. There is an implied decimal between characters 3 and 4. Use a FORTRAN F5.2 format with this. Phasing 15 8 The relative phasing for this tower in electrical degrees. Normally, this value would be between -360 and +360. However, to avoid problems which would result with both FORTRAN and COBOL trying to read this as a negative number (FORTRAN expects minus signs, while COBOL expects overpunches), 360 is added to this field before it is stored in the data base. Therefore, 360 should be subtracted from this before it is printed. If this is to be used only for calculations, 360 need not be subtracted because this is used only for calculations with trigonometric functions, and: fun (x) = fun (x+360) when fun is a trigonometric function. There is an implied decimal between characters 4 and 5. Use a FORTRAN F8.4 format with this. Spacing 23 8 The spacing of this tower from the origin or from the immediately preceeding tower, depending on the value of the tower reference switch (described below), in electrical degrees. There is an implied decimal between characters 4 and 5. Use a FORTRAN F8.4 format with this. AM Engineering Data Base Page 27 21 April 1997 Orientation 31 7 The orientation of this tower from the origin or from the immediately preceeding tower, depending on the value of the tower reference switch (described below), in electrical degrees. There is an implied decimal between characters 3 and 4. Use a FORTRAN F7.4 format with this. Tower Ref Switch 38 1 The tower reference switch, which indicates whether the spacing and orientation of this is with respect to the origin or the immediately preceeding tower. Possible values are: blank or 0 with respect to origin 1 with respect to immediately preceeding tower TL/Sec Switch 39 1 The top-loaded/sectionalized switch, which indicates whether this tower is a normal tower, or top-loaded, or sectionalized. Possible values are: blank or 0 normal tower. 1 top-loaded tower. 2 thru 9 sectionalized tower. A thru Z sectionalized tower. Values of 2 and above are used for the different types of sectionalized towers. The characters A thru Z should be converted to integer values. The character A should be decoded as integer 10, the character B as integer 11, etc. Subroutine GETFTH in the FCC computer program RADIAT should be used to determine more precise meanings of the various values of the top-loaded/sectionalized switch. However, note that if the value is blank or 0 (i.e., a normal tower), the formula for vertical radiation in Section 73.160(b)(1) in the FCC Rules is used; if the value is 1 (i.e., a top-loaded tower), the formula for vertical radiation in Section 73.160(b)(2) is used; and if the value is 2 (i.e., the most common sectionalized tower), the formula for vertical radiation in Section 73.160(b)(3) is used. Section 73.160 does not include formulas for other values of the AM Engineering Data Base Page 28 21 April 1997 top-loaded/sectionalized switch; refer to subroutine GETFTH. Keep in mind that subroutine GETFTH expects the top-loaded/sectionalized switch to be one more than the value stored in the data base. A 40 4 Parameter A takes on many possible definitions depending on the value of the top-loaded/sectionalized switch. When the top-loaded/sectionalized switch is 1 (i.e., the tower is top-loaded), then A is the "A" used in the top-loaded formula in section 73.160(b) of the FCC Rules; it is stored as electrical degrees. When the top-loaded/sectionalized switch is 2 (i.e., the first type of sectionalized tower), then A is the "A" used in the sectionalized formula in section 73.160(b) of the FCC Rules; it is stored as electrical degrees. See subroutine GETFTH for the other possibilities for A for other values of the top-loaded/sectionalized switch. There is an implied decimal between characters 3 and 4. Use a FORTRAN F4.1 format with this. B 44 5 Parameter B takes on many possible definitions depending on the value of the top-loaded/sectionalized switch. When the top-loaded/sectionalized switch is 1 (i.e., the tower is top-loaded), then B is the "B" used in the top-loaded formula in section 73.160(b) of the FCC Rules; it is stored as electrical degrees. When the top-loaded/sectionalized switch is 2 (i.e., the first type of sectionalized tower), then B is the "B" used in the sectionalized formula in section 73.160(b) of the FCC Rules; it is stored as electrical degrees. See subroutine GETFTH for the other possibilities for B for other values of the top-loaded/sectionalized switch. There is an implied decimal between characters 3 and 4. Use a FORTRAN F5.2 format with this. C 49 5 Parameter C takes on many possible definitions, depending on the value of the top-loaded/sectionalized switch. When the top-loaded/sectionalized switch is 1 (i.e., a top-loaded tower), C is not used. When the top-loaded/sectionalized switch is 2 (i.e., AM Engineering Data Base Page 29 21 April 1997 the first type of sectionalized tower), C is the "C" in the formula for sectionalized towers in Section 73.160(b) in the FCC Rules; it is stored as electrical degrees. See subroutine GETFTH for other possibilities for C. There is an implied decimal between characters 3 and 4. Use a FORTRAN F5.2 format with this. D 54 5 Parameter D takes on many possible definitions, depending on the value of the top-loaded/sectionalized switch. When the top-loaded/sectionalized switch is 1 (i.e., a top-loaded tower), D is not used. When the top-loaded/sectionalized switch is 2 (i.e., the first type of sectionalized tower), D is the "D" in the formula for sectionalized towers in Section 73.160(b) in the FCC Rules; it is stored as electrical degrees. See subroutine GETFTH for other possibilities for D. There is an implied decimal between characters 3 and 4. Use a FORTRAN F5.2 format with this. Filler 59 10 Unused. AM Engineering Data Base Page 30 21 April 1997 Augmentation Parameters Following is a description of the parameters used with each augmentation. The numbering for the character positions begins with the first character for each augmentation. Data Element Begins Length Description Central Azimuth 1 7 The Central Azimuth of the augmentation, in degrees. See Section 73.152 of the FCC Rules. There is an implied decimal between characters 3 and 4. Use a FORTRAN F7.4 format with this. Span 8 7 The complete span of the augmentation, in degrees. See Section 73.152 of the FCC Rules. There is an implied decimal between characters 3 and 4. Use a FORTRAN F7.4 format with this. Rad at Cen. Az. 15 7 The Radiation at the central azimuth of augmentation, in millivolts per meter at one __________ kilometer. See Section 73.152 of the FCC Rules. This next part is tricky so don't try to figure it out unless you are wide awake: When the span of a subsequent augmentation overlaps the central azimuth of this augmentation, this radiation is the radiation ______ before applying the subsequent augmentation. However, previous augmentations have been applied in determining this radiation. There is an implied decimal between characters 5 and 6. Use a FORTRAN F7.2 format with this. End of Documentation for FCC AM Engineering Data Base Release Tape (AMDATA.DAT) AM Engineering Data Base Page 1 21 April 1997 FEDERAL COMMUNICATIONS COMMISSION Mass Media Bureau Audio Services Division AM Engineering Data Base for Public Release The AM Engineering Data Base is an unofficial secondary source. It is designed solely for use by FCC Engineers as an aid for processing applications, petitions for rulemaking, and notifications. The various data elements are the minimum deemed necessary for the stated purpose. Its usefulness to any other group or for any other purpose is coincidental. See Section 0.434 of the FCC Rules for a further warning and disclaimer. This description applies to the format in which the FCC's AM Engineering Data Base is provided on the internet or stored on magnetic tape for distribution outside of the FCC. In the FCC's VAX computer, the AM Engineering Data Base is stored as a relational data base. However, it is necessary to unload it into sequential files in order to copy it to tape or transfer it to the internet. This description applies to the tape format. The internet files have the same format as the tape files. The tape is recorded pursuant to ANSI X3.27-1978 (FIPS Pub 79) using variable length records in 2048-byte blocks. Although the second, third, fourth, and fifth files on this tape contain fixed-length records, the files are written on the tape as though they contained variable-length records. The first file contains records that are truly variable length. The volume identifier in the Volume-Header Label is "FCCAM". As this is being written, the characters are from the ASCII character set. However, it is possible that, in the future, there may be characters from the Latin Alpha 1 character set from ISO Standard 8859; these include accented characters, etc., and are an expansion to the ASCII character set. The tape contains five files. The files are: 1. The tape description(AMTEXT.TXT). This document is included on the tape so that users who receive the tapes on a periodic basis can compare the first file on each tape with the first file on the previous tape. If there are no changes, then the format and descriptions have not changed. However, if there are differences, it is necessary to review the first file on the new tape to determine what changes in format and/or descriptions have been made. The first file will also contain announcements about possible future changes. 2. The Primary AM Engineering Data Base (AMENG.DAT). This contains the engineering data for all existing and proposed stations, both foreign and domestic, in Region 2 (the Western Hemisphere). Pertinent engineering parameters, such as power, frequency, class, AM Engineering Data Base Page 2 21 April 1997 and coordinates, are included, as well as identifying information such as call sign, city, state, and country. 3. Tower parameters for the AM Engineering Data Base (AMENGTOW.DAT). This contains parameters for each tower in the data base. Engineering data such as field ratio, phasing, spacing, orientation, electrical height, and antenna types are included. 4. Augmentation parameters for the AM Engineering Data Base (AMENGAUG.DAT). This contains parameters for each augmentation in the data base. Engineering data such as central azimuth, span, radiation are included. 5. Comments for the AM Engineering Data Base (AMENGCOM.DAT). This contains any comments associated with records in the primary AM Engineering Data Base. Before describing the second, third, fourth, and fifth files on this tape, it is important to discuss the concepts used in the data base design. As mentioned above, the FCC stores the AM Engineering Data Base as a relational data base. For a good description of relational data bases, see An Introduction to Database Systems, Volume I, Fourth Edition, by C. J. Date, Addison-Wesley Publishing Co., 1986. The second, third, fourth, and fifth files on this tape are each a relation, or table, from the relational data base. Each record has a unique primary key. This key is a data element called "mainkey". The file AMENG.DAT includes records for all of the mainkeys. The other data base files (AMENGTOW.DAT, AMENGAUG.DAT, and AMENGCOM.DAT) contain mainkey values only for those records that have data elements. For example, if there are no comments for a certain station, the mainkey value for that station will not appear in the AMENGCOM.DAT file. The "mainkey" data element is 16 characters long, and is a hexadecimal representation of a 64-bit value. Do not assume that the records on this tape are sorted in any particular order. The relations (or tables) in a relational data base are logically stored in a random order. The remainder of this description covers the data elements in the AM Engineering Data Base, the tower and augmentations data, and related comments. The description includes the name of the data element, its starting position in the record, its length, and a definition of the element itself. All of the information is stored in character format; floating point numbers and integers are not used. Accordingly, the numbering for the beginning of the field and the length of the field is in characters. Numeric fields are right justified, and will have leading spaces rather AM Engineering Data Base Page 3 21 April 1997 than leading zeros to fill the field. If you obtained the tape from NTIS, and the tape is bad, contact NTIS. If you are having trouble with the tape structure, refer to ANSI standard X3.27-1978, particularly Section 6.2 entitled "Block Formats". Because the records are treated as variable length in all five files on the tape, Section 6.2.3, entitled "Variable-Length Records (D)", is especially pertinent. Please report any errors, omissions, etc., in the data to: Federal Communications Commission Mass Media Bureau Audio Services Division Computer Support Staff, Room 350 1919 M St., NW Washington, DC 20554 (202) 418-2789 or e-mail: gkalagia@fcc.gov Release Notes This is a complete revision of the data base format. Although the the field definitions remain the same as in the most recent release (May 17, 1995), a number of the field lengths have changed. In addition, fields which had been defined in the previous version of the data base, but not used, have been omitted in this new version. Finally the ordering of the fields has been revised, so that related fields are now grouped together. In the publicly released files, the header and trailer records have been eliminated. The coordinate reference system for the latitudes and longitudes given in this data base is the North American Datum of 1927 (NAD 27). The FCC is reviewing the steps required to convert to the North American Datum of 1983 (NAD 83). The Commission will issue further guidance on the conversion to NAD 83 as more information becomes available. Planned Future Changes 1. The tower registration number will be added for each tower. AM Engineering Data Base Page 4 21 April 1997 FCC Primary AM Engineering Data Base Following is a brief description of the data elements in the AM Engineering Data Base (AMENG.DAT). The description includes the name of the data element, its starting position in the record, its length, and a definition of the element itself. Data Element Begins Length Description Mainkey 1 16 A unique value for each record in this file. This is the "primary key" for this file. This should be regarded as a random value for each record. The mainkey is used to associate the data in this record with the corresponding record(s) in the AMENGTOW.DAT, AMENGAUG.DAT, and AMENGCOM.DAT files, if any. Frequency 17 4 The AM frequency, ranging from 540 through 1700. In Region 2, the frequencies are in 10 kHz increments. In Regions 1 and 3, the frequencies are in 9 kHz increments. Call Sign 21 12 The Call Sign of the station or application. For applications and construction permits which do not have Call Signs a value of "NEW" is used. Country 33 2 A two-character field indicating which country the station is located in. Following is a list of 2-character country abbreviations that are used. These correspond to those used in Federal Information Processing Standards (FIPS) Publication 10-3, February 9, 1984. However, the following list is an abbreviated version of FIPS Pub 10-3, covering only the abbreviations which we use. AC Antigua and Barbuda AR Argentina AV Anguilla BB Barbados BD Bermuda BF The Bahamas BH Belize BL Boliva BR Brazil CA Canada CI Chile AM Engineering Data Base Page 5 21 April 1997 CJ Cayman Islands CO Colombia CS Costa Rica CU Cuba DO Dominica DR Dominican Republic EC Ecuador ES El Salvador FA Falkland Islands (Islas Malvinas) FG French Guiana GJ Grenada GL Greenland GP Guadeloupe GT Guatemala GY Guyana HA Haiti HO Honduras JM Jamaica MB Martinique MH Montserrat MX Mexico NA Netherlands Antilles NS Suriname NU Nicaragua PA Paraguay PE Peru PM Panama SB St. Pierre and Miquelon SC St. Christopher and Nevis ST St. Lucia TD Trinidad and Tobago TK Turks and Caicos Islands US United States UY Uruguay VC St. Vincent and the Grenadines VE Venezuela VI British Virgin Islands State 35 2 The state or province in which the station is licensed or proposed. The possible codes depend on the country. Here are the possibilities: For the United States (country is "US"), we have the following abbreviations for the states, etc.: AK Alaska. AL Alabama. AR Arkansas. AM Engineering Data Base Page 6 21 April 1997 AS American Samoa. AZ Arizona. CA California. CO Colorado. CT Connecticut. DC The District of Columbia DE Delaware. FL Florida. FM the Federated States of Micronesia, which is a part of the Caroline Islands. GA Georgia. GU Guam. HI Hawaii. IA Iowa. ID Idaho. IL Illinois. IN Indiana. KS Kansas. KY Kentucky. LA Louisiana. MA Massachusetts. MD Maryland. ME Maine. MH the Republic of the Marshall Islands. MI Michigan. MN Minnesota. MO Missouri. MP the Northern Marianas. MS Mississippi. MT Montana. NC North Carolina. ND North Dakota. NE Nebraska. NH New Hampshire. NJ New Jersey. NM New Mexico. NV Nevada. NY New York. OH Ohio. OK Oklahoma. OR Oregon. PA Pennsylvania. PR Puerto Rico. PW the Republic of Palou, which is part of the Caroline Islands. RI Rhode Island. SC South Carolina. SD South Dakota. AM Engineering Data Base Page 7 21 April 1997 TN Tennessee. TX Texas. UT Utah. VA Virginia. VI the U.S. Virgin Islands (not the British Virgin Islands). VT Vermont. WA the state of Washington (not Washington, DC). WI Wisconsin. WV West Virginia. WY Wyoming. For Canada (country is "CA"), we have the following abbreviations for the Canadian provinces: AB Alberta. BC British Columbia MB Manitoba NB New Brunswick NF Newfoundland NS Nova Scotia NT Northwest Territories ON Ontario PE Prince Edward Island QU Quebec SA Saskatchewan YU Yukon For Mexico (country is "MX"), we have the following abbreviations for the Mexican states: AG Aguascalientes BN Baja California North BS Baja California South CH Chihuahua CI Coahuila CL Colima CM Campeche CS Chiapas DF Federal District DU Durango GR Guerrero GT Guanajuato HG Hidalgo JA Jalisco MC Michoacan ML Morelos AM Engineering Data Base Page 8 21 April 1997 MX Mexico NA Nayarit NL Nuevo Leon OA Oazaca PU Puebla QE Queretaro QR Quintana Roo SI Sinaloa SL San Luis Potosi SO Sonora TA Tamaulipas TB Tabasco TL Tlaxcala VC Vera Cruz YC Yucatan ZA Zacatecas City 37 30 The city in which the station is licensed or proposed. Latitude Dir 67 1 The direction for the latitude. It is "N" for North Latitude, and "S" for South Latitude. Latitude Degrees 68 2 The degrees portion of the latitude. Latitude Minutes 70 2 The minutes portion of the latitude. Latitude Seconds 72 2 The seconds portion of the latitude. Longitude Dir 74 1 The direction for the longitude. It is "W" for West Longitude, and "E" for East Longitude. Longitude Degrees 75 3 The degrees portion of the longitude. Longitude Minutes 78 2 The minutes portion of the longitude. Longitude Seconds 80 2 The seconds portion of the longitude. File No. Prefix 82 4 The prefix to the file number, right justified. The dash between the prefix and the ARN is not included in the data base. App Ref No (ARN) 86 10 The application reference number, or the numeric portion of the file number. This is left justified. It is of the form YYYYMMDDAA, where YYYY represents the year; MM represents the month (01-12); DD represents the day of the month; and AA is a AM Engineering Data Base Page 9 21 April 1997 two-character suffix. Domestic Status 96 1 The status of the record, according to current standing in FCC from viewpoint of FCC authorizations. Possible values are: A Application C Construction Permit D Deleted domestically, but not internationally. L License M A petition to move to the expanded band with no stereo preference. P Planned; an unapplied-for planned station which is internationally recognized. S A petition to move to the expanded band with a stereo preference. T Test spaces No domestic status. (For example, a Canadian station.) Cutoff Date 97 8 The Cutoff Date for records with a Domestic Status of "A". This is an 8-digit field in YYYYMMDD format. CP Expire Date 105 8 The date that the construction permit expires for records with a domestic status of "C". This is an 8-digit field in YYYYMMDD format. Filed 307 Date 113 8 The date that a FCC Form 307 (extension of CP) was filed, for records with a domestic status of "C". This is an 8-digit field in YYYYMMDD format. Filed Lic Date 121 8 The date that a license application was filed, for records with a domestic status of "C". This is an 8-digit field in YYYYMMDD format. Complete Schedule 129 1 The Complete Schedule for this station. Distinguish this from Hours of Operation. Possible values are: D Daytime only. N Nighttime only. U Unlimited time. L Limited time. H Specified Hours. AM Engineering Data Base Page 10 21 April 1997 For example, a DA2 station has different patterns for daytime and nighttime. Thus, there would be a daytime logical record and a nighttime logical record. The hours of operation would be "D" in the daytime record, and "N" in the nighttime record, but the complete schedule would be "U" in both records. Hours of Oper. 130 1 The operating hours during which the parameters in this record are used. Since the data base is an engineering data base, the hours of operation are used to tell which records are used in which studies. Thus, for example, a DA1 limited time station will have hours of operation of "U" because it is used in both daytime and nighttime studies; it does not mean that the station operates unlimited time. Distinguish this from the complete schedule. Possible values are: U Unlimited. I.e., both day and night, or portions thereof. N Nighttime. D Daytime. C Critical Hours. R Canadian Restricted. P Pre-sunrise. Critical Hours is that time from Sunrise to two hours after Sunrise, and from two hours before Sunset until Sunset, local time. During that time, certain stations may be operating with reduced facilities as a result of Section 73.187 of the Commission's Rules. Canadian Restricted hours are similar to Critical Hours, except that the restriction results from the January 17, 1984, U.S.-Canadian AM Agreement. See Appendix 8 to Annex 2. Canadian Restricted Hours are called "Critical Hours" in the U.S.-Canadian Agreement, but in the data base, we call them "Canadian Restricted Hours" to distinguish them from the domestically defined critical hours in Section 73.187. Canadian Restricted Hours is that from Sunrise to one and one-half hours after Sunrise, and from one and one-half hours before Sunset until Sunset, local time. U.S. stations operate AM Engineering Data Base Page 11 21 April 1997 with restricted hours because of Canadian stations, and vice-versa. Domestic Class 131 2 The Class of the station, according to the FCC Rules and/or NARBA and the Mexican Agreement. The first character is a numeric 0. The second character is alphabetic, in the range from A through D, inclusive, or spaces. The Domestic Class has been changed to those classes established by MM Docket No. 87-267. These classes are "0A", "0B", "0C" or "0D". Domestic Pattern 133 1 The type of directional antenna pattern, as authorized domestically. Possible values are: T Theoretical S Standard A Augmented Power 134 10 The nominal power of the station, as defined in Section 73.14, in kilowatts. This is not necessarily the effective radiated power, the transmitter power, the antenna input power, etc. There is an explicit decimal point after character 4. Read it in FORTRAN with an F10.5 format. RMS 144 8 The RMS of the pattern, in millivolts per meter at one kilometer. For a directional station (i.e., more than one tower), this is the RMS at the nominal power. For a non-directional station (i.e., one tower), this is the RMS at one kilowatt. The RMS is the root-mean-square of the radiation in all directions in the horizontal plane. There is an explicit decimal after character 5. Use a FORTRAN F8.2 format with this. Q factor 152 13 Q for the standard pattern formula in Section 73.150 of the FCC Rules. When this is blank, Q according to the Rules should be computed and used. When this is non-blank (including when it is zero), this value of Q should be used as a special Q. There is an explicit decimal after character 4. Use a FORTRAN F13.8 format with this. Units are millivolts per meter at one kilometer. AM Engineering Data Base Page 12 21 April 1997 Antenna Mode 165 3 The mode of the complete antenna system. It indicates whether directional or non-directional, number of patterns, etc. For example: DA1, DA2, DAN, ND1, ND2. No. of towers 168 2 The number of towers in the antenna system. This is one for non-directional stations. Maximum is 17. No. augmentations 170 2 The number of augmentations. Minimum is zero; maximum is 28. Dummy Data Switch 172 1 Indicates whether some of the parameters in this record are assumed values, rather than actual values. Possible values are: spaces nothing is assumed. D Something (undefined) is assumed in this record. V Antenna parameters affecting calculations in the vertical plane are assumed; antenna parameters affecting calculations in the horizontal plane are not assumed. 1 Antenna parameters are assumed for parameters affecting calculations in both the horizontal and vertical planes; coordinates are valid. 2 Coordinates are assumed; antenna parameters are valid. 3 The coordinates are assumed, and antenna parameters are assumed for parameters affecting calculations in both the horizontal and vertical planes. Bad Data Switch 173 1 Indicates whether some of the parameters in this record are known to be bad. (For example, the coordinates in the data base are what a foreign country notified to us, but those coordinates are in the middle of the ocean.) Possible values are: spaces No bad data. B Some (undefined) data is known to be bad. V Antenna parameters affecting calculations in the vertical plane are known to be bad; antenna parameters affecting calculations AM Engineering Data Base Page 13 21 April 1997 in the horizontal plane are not known to be bad. 1 Coordinates are known to be bad. 2 Antenna parameters affecting calculations in both the horizontal and vertical planes are known to be bad. 3 The coordinates and antenna parameters affecting calculations in both the horizontal and vertical planes are known to be bad. Notified Pattern 174 1 The type of the antenna pattern which has been notified to (or by) foreign countries. Possible values are: T Theoretical S Standard A Augmented Notified Status 175 1 The status of records with regard to international notifications. Possible values are: A Negotiated Priority; not notified in operation. O Notified in Operation. P Notified Proposed Operation. T Informally coordinated proposal. U Not Notified. Z Test record. Can Coord Status 176 1 The Canadian Coordination Status. If this is a U.S. record, this refers to the status of our notification to Canada. If this is a Canadian record, this refers to the status of the Canadian notification to the U.S. If this is neither a U.S. nor Canadian record, this should be blank. Possible values are: A Notification that is accepted. B Notification that is accepted with conditions; see remarks. O Notification that is objected to. P Pending status (e.g., awaiting additional data, awaiting clarification). U Unstudied. spaces Not applicable to this record; for example, a Mexican record. AM Engineering Data Base Page 14 21 April 1997 Mex Coord Status 177 1 The Mexican Coordination Status. If this is a U.S. record, this refers to the status of our notification to Mexico. If this is a Mexican record, this refers to the status of the Mexican notification to the U.S. If this is neither a U.S. nor Mexican record, this should be blank. Possible values are: A Notification that is accepted. B Notification that is accepted with conditions; see remarks. O Notification that is objected to. P Pending status (e.g., awaiting additional data, awaiting clarification). U Unstudied. spaces Not applicable to this record; for example, a Canadian record. R2 Coord Status 178 1 The Region 2 Coordination Status. If this is a U.S. record, this refers to the status of our notification to the IFRB. If this is not a U.S. record, this refers to the status of the IFRB notification to the U.S. Possible values are: A Notification that is accepted. B Notification that is accepted with conditions; see remarks. O Notification that is objected to. P Pending status (e.g., awaiting additional data, awaiting clarification). U Unstudied. spaces Not applicable to this record. Region 2 Class 179 1 The Class (A, B, or C) of the station, as notified to the International Frequency Registration Board (IFRB) pursuant to the Region 2 MF Broadcasting Agreement. IFRB Plan Date 180 8 Date that this station was entered into the IFRB Plan, in YYYYMMDD format. Initially, this will be blank as this is loaded; a blank does not necessarily mean that this station is not in the IFRB Plan. IFRB List 188 1 An indicator of which IFRB list this appears on. It could be either List A or List B. In the beginning, however, this will be blank AM Engineering Data Base Page 15 21 April 1997 because we have not loaded this information. It will also be blank for operations which are not notified. IFRB Serial No. 189 9 The Serial Number assigned to this record by the IFRB. This will initially be blank because we have not loaded the information. It will also be blank for non-notified records. This is left-justified. Change List No. 198 5 The Change List Number of the change list associated with this record. If this field is "ORIG", it refers to the original NARBA list. If this field is "USCAN", it refers to the original list in the U.S.-Canadian Agreement if the Change List Date is 19840117 or to the separate Class IV listing if the Change List Date is 19841215. If this field is "USMEX", it refers to the U.S.-Mexican Class IV power increase agreement if the Change List Date is 19841215. For foreign stations, the change list number refers to the latest list which had a change affecting engineering parameters. Change List Date 203 8 The date of the change list in YYYYMMDD format. Last Notify Date 211 8 The date when this record was last notified to a foreign country. This is an 8-digit in the format YYYYMMDD. Note that this will be empty for most records since we have not had the opportunity to load it. Last Notify Time 219 6 The time when this record was last notified to a foreign country. This is a 6-digit field in the format HHMMSS. Note that this will be empty for most records since we have not had the opportunity to load it. Updater 225 6 This indicates which agency last updated this record. Possible values are: FCC Updated by the Federal Communications Commission IFRB Updated by the International Frequency Registration Board Initially, this field will not be loaded; therefore, any value other than "IFRB" should AM Engineering Data Base Page 16 21 April 1997 be interpreted as "FCC". Periodically, the FCC receives data from IFRB showing the current values in the Region 2 data base. Rather than re-key everything, the FCC simply merges data from the IFRB data base into the FCC data base. This field shows which agency is responsible for the data. Last Update date 231 8 The date of the last update of this record, in YYYYMMDD format. Last Update time 239 6 The time of the last update of this record. This is a 6-digit field in the format HHMMSS. There are 244 characters in each record. AM Engineering Data Base Page 17 21 April 1997 Towers in the FCC AM Engineering Data Base Following is a brief description of the Tower data elements in the AM Engineering Data Base (AMENGTOW.DAT). The description includes the name of the data element, its starting position in the record, its length, and a definition of the element itself. Data Element Begins Length Description Mainkey 1 16 A unique value for each record in the AM Engineering Data Base file; this tower record is associated with that record. Tower Number 17 2 A 2-character field holding the number of the tower, up to a maximum of 17. Field Ratio 19 7 The ratio of the fields radiated by each tower. There is an explicit decimal after character 2. Use a FORTRAN F7.4 format with this. Phasing 26 8 The relative phasing for this tower in electrical degrees. The value will be between -360 and +360. There is an explicit decimal after character 4. Use a FORTRAN F8.3 format with this. A minus sign (-) is included if the value is negative. Electrical Height 34 5 The height of the radiator in electrical degrees. This is not normally the height above ground. Usually it is the height above insulator without obstruction lighting. There is an explicit decimal after character 3. Use a FORTRAN F5.1 format with this. Spacing 39 8 The spacing of this tower from the origin or from the immediately preceeding tower, depending on the value of the tower reference switch (described below), in electrical degrees. There is an explicit decimal after character 4. Use a FORTRAN F8.3 format with this. Orientation 47 8 The orientation of this tower from the origin or from the immediately preceeding tower, depending on the value of the tower reference switch (described below), in electrical degrees. There is an explicit decimal after character 4. Use a FORTRAN F8.3 format with AM Engineering Data Base Page 18 21 April 1997 this. Tower Ref Switch 55 1 The tower reference switch, which indicates whether the spacing and orientation of this is with respect to the origin or the immediately preceeding tower. Possible values are: blank or 0 with respect to origin 1 with respect to immediately preceeding tower TL/Sec Switch 56 2 The top-loaded/sectionalized switch, which indicates whether this tower is a normal tower, or top-loaded, or sectionalized. Possible values are: blank or 0 normal tower. 1 top-loaded tower. 2 and up sectionalized tower. Values of 2 and above are used for the different types of sectionalized towers. Subroutine GETFTH in the FCC computer program RADIAT should be used to determine more precise meanings of the various values of the top-loaded/sectionalized switch. However, note that if the value is blank or 0 (i.e., a normal tower), the formula for vertical radiation in Section 73.160(b)(1) in the FCC Rules is used; if the value is 1 (i.e., a top-loaded tower), the formula for vertical radiation in Section 73.160(b)(2) is used; and if the value is 2 (i.e., the most common sectionalized tower), the formula for vertical radiation in Section 73.160(b)(3) is used. Section 73.160 does not include formulas for other values of the top-loaded/sectionalized switch; refer to subroutine GETFTH. Keep in mind that subroutine GETFTH expects the top-loaded/sectionalized switch to be one more than the value stored in the data base. A 58 5 Parameter A takes on many possible definitions depending on the value of the top-loaded/sectionalized switch. When the top-loaded/sectionalized switch is 1 (i.e., the tower is top-loaded), then A is the "A" AM Engineering Data Base Page 19 21 April 1997 used in the top-loaded formula in section 73.160(b) of the FCC Rules; it is stored as electrical degrees. When the top-loaded/sectionalized switch is 2 (i.e., the first type of sectionalized tower), then A is the "A" used in the sectionalized formula in section 73.160(b) of the FCC Rules; it is stored as electrical degrees. See subroutine GETFTH for the other possibilities for A for other values of the top-loaded/sectionalized switch. There is an explicit decimal after character 3. Use a FORTRAN F5.1 format with this. B 63 6 Parameter B takes on many possible definitions depending on the value of the top-loaded/sectionalized switch. When the top-loaded/sectionalized switch is 1 (i.e., the tower is top-loaded), then B is the "B" used in the top-loaded formula in section 73.160(b) of the FCC Rules; it is stored as electrical degrees. When the top-loaded/sectionalized switch is 2 (i.e., the first type of sectionalized tower), then B is the "B" used in the sectionalized formula in section 73.160(b) of the FCC Rules; it is stored as electrical degrees. See subroutine GETFTH for the other possibilities for B for other values of the top-loaded/sectionalized switch. There is an explicit decimal after character 3. Use a FORTRAN F6.2 format with this. C 69 6 Parameter C takes on many possible definitions, depending on the value of the top-loaded/sectionalized switch. When the top-loaded/sectionalized switch is 1 (i.e., a top-loaded tower), C is not used. When the top-loaded/sectionalized switch is 2 (i.e., the first type of sectionalized tower), C is the "C" in the formula for sectionalized towers in Section 73.160(b) in the FCC Rules; it is stored as electrical degrees. See subroutine GETFTH for other possibilities for C. There is an explicit decimal after character 3. Use a FORTRAN F6.2 format with this. D 75 6 Parameter D takes on many possible definitions, depending on the value of the AM Engineering Data Base Page 20 21 April 1997 top-loaded/sectionalized switch. When the top-loaded/sectionalized switch is 1 (i.e., a top-loaded tower), D is not used. When the top-loaded/sectionalized switch is 2 (i.e., the first type of sectionalized tower), D is the "D" in the formula for sectionalized towers in Section 73.160(b) in the FCC Rules; it is stored as electrical degrees. See subroutine GETFTH for other possibilities for D. There is an explicit decimal after character 3. Use a FORTRAN F6.2 format with this. There are 80 characters in each record. AM Engineering Data Base Page 21 21 April 1997 Augmentations in the FCC AM Engineering Data Base Following is a brief description of the augmentation data elements in the AM Engineering Data Base (AMENGAUG.DAT). The description includes the name of the data element, its starting position in the record, its length, and a definition of the element itself. Data Element Begins Length Description Mainkey 1 16 A unique value for each record in the AM Engineering Data Base file; this augmentation record is associated with that record. Augmentation No. 17 2 A two-character field, holding the number of the augmentation, up to 28. Central Azimuth 19 5 The Central Azimuth of the augmentation, in degrees. See Section 73.152 of the FCC Rules. There is an explicit decimal after character 3. Use a FORTRAN F5.1 format with this. Span 24 5 The complete span of the augmentation, in degrees. See Section 73.152 of the FCC Rules. There is an explicit decimal after character 3. Use a FORTRAN F5.1 format with this. Rad at Cen. Az. 29 8 The Radiation at the central azimuth of augmentation, in millivolts per meter at one kilometer. See Section 73.152 of the FCC Rules. This next part is tricky so don't try to figure it out unless you are wide awake: When the span of a subsequent augmentation overlaps the central azimuth of this augmentation, this radiation is the radiation before applying the subsequent augmentation. However, previous augmentations have been applied in determining this radiation. There is an explicit decimal after character 5. Use a FORTRAN F8.2 format with this. There are 36 characters in each record. AM Engineering Data Base Page 22 21 April 1997 Comments in the FCC AM Engineering Data Base Following is a brief description of the comment data elements in the AM Engineering Data Base (AMENGCOM.DAT). The description includes the name of the data element, its starting position in the record, its length, and a definition of the element itself. Data Element Begins Length Description Mainkey 1 16 A unique value for each record in the AM Engineering Data Base file; this comment record is associated with that record. Comment Type 17 1 The type of comment. Possible values are: G General Comments I International Comments These are comments relating to our international agreements, and may reflect special requirements in the agreements or the results of special negotiations involving this station. Comment Number 18 3 A sequential number assigned to each comment of a particular type for a specific station. Sorting in order by mainkey, comment type, and comment number would group the comments in the proper order. This is right justified and an integer; if it is less than 100, there will be one or two leading spaces. Comment 21 76 A comment record associated with a record in the AM Engineering Data Base. A single record in the AM Engineering Data Base may have no comments associated, or it may have one or more comments associated. If there are no comments associated, there will be no record with that mainkey in this file. There are 96 characters in each record. End of Documentation for FCC AM Engineering Data Base Release Tape