+--------------------------------------------------------------+ | DATABASES CURRENTLY BEING USED BY WTS (AS OF JULY 15, 2003) | | ============================================================ | | NOTE: All *DOWNLOADABLE* Databases are Compressed as WinZip® | | files. This means WinZip® or a compatible program is needed | | to "unzip" (decompress) the files(s) before using. | | | | All downloadable databases are located on the Web at: | | | | http://www.dobe.com/wts/download.htm#3 | | | | If you are downloading any databases for USE with WTS, MAKE | | SURE that you place them in the WTS\DATABASES folder else | | WTS will not be able to find them. If you accepted the | | default location during installation, it will be located at: | | | | C:\Program Files\WTS\Databases\ | | | | This Document: DB_INFO.TXT Last Revised: 23Jul03 | +--------------------------------------------------------------+ "MASTER" MEDIUM WAVE STATION DATABASE (Variable Length Text Records) Distribution Filename = WTSMWDB.TXT Download Filename: WTSMWDB.ZIP WTS File Location (Sub-Directory): \DATABASES\WTSMWDB.TXT ==================================================================== DB Information - Record #1: MW0201 11Jul03 006978 ====== ======= ====== 123456789012345678901 0 1 2 Columns Field Description ========== =================== 001 - 006: Database ID # 007: Space Filler 008 - 014: Database "Last Revised" Date 015: Space Filler 016 - 021: Number of Records in Database Station Data - Records #2 through EOF (End of File) [Note sample record line below split to fit on page] WSTV 1340 ND1 C OH US 1.000 1.000 ----- 40.341667 -080.618889 ======= ==== === = == == ======= ======= ======= ========== =========== 123456789012345678901234567890123456789012345678901234567890123456789012 0 1 2 3 4 5 6 7 05.0 000 STEUBENVILLE ==== === =================== 3456789012345678901234567890 ... 7 8 9 0 1 Columns Field Description ========== =================== 001 - 007: Station Callsign 008: Space Filler 009 - 012: Frequency (KHz) 013: Space Filler 014 - 016: Antenna (FCC Designation) 017: Space Filler 018 - 018: Domestic Class (FCC Designation) 019: Space Filler 020 - 021: State/Province (2 Char FCC Abvr) 022: Space Filler 023 - 024: Country (2 Char FCC Abvr) 025: Space Filler 026 - 032: Daytime Power (KW), Left Justified, Space Padded - "-----" = N/A") 033: Space Filler 034 - 040: Nighttime Power (KW), Left Justified, Space Padded - "-----" = N/A) 041: Space Filler 042 - 048: Critical Hours Power (KW), Left J'fied, Spc Padded - "-----" = N/A) 049: Space Filler 050 - 059: Decimal Degrees Latitude (Rounded to 6 places to right of decimal point) 060: Space Filler 061 - 071: Decimal Degrees Longitude (Rounded to 6 places to right of decimal point) 072: Space Filler 073 - 076: Station's (Antenna Location) UTC Timezone Offset (-) 077: Space Filler 078 - 080: Flags (001 = Station does NOT observe Daylight Davings) [Currently (as of July 15, 2003) only "001" is being used] 081: Space Filler 082 - EOL: Station's (Antenna Location) City ("EOL"=End of Line) ------------------------------------------------------------------------------ "USER" MEDIUM WAVE STATION DATABASE (Variable Length Text Records) Distribution Filename = NONE Download Filename: NONE WTS File Location (Sub-Directory): \DATABASES\USERMWDB.TXT NOTE: THIS DATABASE IS *NOT* DOWNLOADABLE - It is CREATED by WTS upon initial installation or when the Build Database Command /BDB is used. This IS, however, the actual MW database that WTS uses for all searches and reports related to station lookups, etc. The difference between this and the "Master" (downloadable) database (WTSMWDB.TXT) is that this one incorporates distance and bearing information as relates to your specific geographic location. i.e. Your QTH. ============================================================================= DB Information - Record #1: MW0201 11Jul03 06978 Dist. & Bearings based on: 40.978100 -78.90473 ====== ======= ====== =============================================== 1234567890123456789012345678901234567890123456789012345678901234567890 0 1 2 3 4 5 6 7 Columns Field Description ========== =================== 001 - 006: Database ID # 007: Space Filler 008 - 014: Database "Last Revised" Date 015: Space Filler 016 - 021: Number of Records in Database 022: Space Filler 023 - EOL: Text Description (for your info only) showing your QTH Latitude and Longitude coordinates which were used to calculate the USERMWDB.TXT Distance and Bearing data. ("EOL" = "End of Line) Station Data - Records #2 through EOF (End of File) [Note sample record line below split to fit on page] WSTV 1340 ND1 C OH US 1.000 1.000 ----- 40.341667 -080.618889 ======= ==== === = == == ======= ======= ======= ========== =========== 123456789012345678901234567890123456789012345678901234567890123456789012 0 1 2 3 4 5 6 7 100.01 244.48 05.0 100 STEUBENVILLE ======== ====== ==== === =========================== 345678901234567890123456789012345678901234567890 ... 7 8 9 0 1 2 1 1 1 Columns Field Description ========== =================== 001 - 007: Station Callsign 008: Space Filler 009 - 012: Frequency (KHz) 013: Space Filler 014 - 016: Antenna (FCC Designation) 017: Space Filler 018 - 018: Domestic Class (FCC Designation) 019: Space Filler 020 - 021: State/Province (2 Char FCC Abvr) 022: Space Filler 023 - 024: Country (2 Char FCC Abvr) 025: Space Filler 026 - 032: Daytime Power (KW), Left Justified, Space Padded - "-----" = N/A") 033: Space Filler 034 - 040: Nighttime Power (KW), Left Justified, Space Padded - "-----" = N/A) 041: Space Filler 042 - 048: Critical Hours Power (KW), Left J'fied, Spc Padded - "-----" = N/A) 049: Space Filler 050 - 059: Decimal Degrees Latitude (Rounded to 6 places to right of decimal point) 060: Space Filler 061 - 071: Decimal Degrees Longitude (Rounded to 6 places to right of decimal point) 072: Space Filler 073 - 080: Distance Units from Your QTH to Station. (Miles, Kilos, Naut Miles) Rounded to 2 places to right of decimal point. Space padded to left of Integer. 081: Space Filler 082 - 087: Bearing Degrees TO station from your OTH. Rounded to 2 places to right of decimal point. Space padded to left of Integer. 088: Space Filler 089 - 092: Station's (Antenna Location) UTC Timezone Offset (-) 093: Space Filler 094: Flag: Your Distance Unit Preference: 1 = Miles, 2 = Kilometers, 3 = Nautical Miles 095: Flag: Not Currently Used - Will be always be Zero (0) 096: Flag: Daylight Davings: 1 = Does NOT Observe, 0 = DOES observe 097: Space Filler 098 - EOL: Station's (Antenna Location) City ("EOL" = End of Line) ------------------------------------------------------------------------------ U.S. AND CANADIAN TELEPHONE AREA CODES DATABASE (Variable Length Text Records) Distribution Filename = AC.TXT Download Filename: AC.ZIP WTS File Location (Sub-Directory): \DATABASES\AC.TXT ========================================================= DB Information - Record #1: AC0003 29Jun03 000310 [Same format as Medium Wave DB Above) Area Code Data - Records #2 through EOF (End of File) 201 NJ New Jersey, USA 123456789012345678901234567890 ... 0 1 2 3 Columns Field Description ======= ================= 001 - 003: Telephone Area Code 004: Space Filler 005 - 006: State or Province (2 Char FCC Abvr) 007: Space Filler 008 - EOL: State/Province and Country ("EOL" = End Of Line) (A Comma then space separates State/Province from Country) ------------------------------------------------------------------------------ STATION SLOGANS/KEYWORDS DATABASE (Variable Length Text Records) Distribution Filename = SLOGANS.TXT Download Filename: SLOGANS.ZIP WTS File Location (Sub-Directory): \DATABASES\SLOGANS.TXT =================================================================== DB Information - Record #1: SL0004 14Jun03 001571 [Same format as Medium Wave DB Above) Slogans/Keywords - Records #2 through EOF (End of File) 0530 CIAO CHOW AM 530 123456789012345678901234567890123456789012345678901234567890 .... 0 1 2 3 4 5 6 001 - 004: Frequency (KHz) 005: Space Filler 006 - EOL: Station Callsign then a space, then all keywords and slogans. It should be noted that THIS database is merely searched for keyword(s) or slogan "string" matches. If the search string is found, the entire record is retrieved. i.e. You could, for example, using the sample line above, search for 0530 and all records containing 0530 (regardless of WHERE in the record it appeared) would be retrieved. ("EOL" = End of Line) ------------------------------------------------------------------------------ U.S. ZIP CODE DATABASE (Variable Length Text Records) Distribution Filename = ZIPCODES.TXT Download Filename: ZIPCODES.ZIP WTS File Location (Sub-Directory): \DATABASES\ZIPCODES.TXT ================================================================== DB Information - Record #1: ZC0001 15Jun03 042182 [Same format as Medium Wave DB Above) U.S. Zip Codes - Records #2 through EOF (End of File) 00210 PORTSMOUTH, NH 123456789012345678901234567890 ... 0 1 2 3 Columns Field Description ======= ================= 001 - 005: 5-Digit U.S. Zip Code 006: Space Filler 007 - EOL: City/State Abvr. ("EOL" = End of Line) (A Comma and 1 space separates the City from State) ------------------------------------------------------------------------------