Main page
»
Structure & Content
»
current Structure of dBASE Format of ILG Database for dBASE and Excel Import
FLASH UPDATE (HFCC / WPLOT):
Flash-A25: December 6th (2302 UTC) FLASH-B24: December 6th (2302 UTC)
Quick UPDATE (Text/dBASE):
QUICK-A25: December 6th (2302 UTC) QUICK-B24: December 6th (2302 UTC)
LATEST REGULAR UPDATES:
A25: December 1st 2024 (2350 UTC) B24: December 1st 2024 (2350 UTC)
Latest Monitoring Statistics of March 3rd 2024 Facts that confirm the High Quality
current Structure of dBASE Format of ILG Database for dBASE and Excel Import
The current Structure of ILG Database
All files are including 1535 "Separator Lines" and the data field of GRAPHIC (Graphical Diagram) looks like this:
00##########06##########12##########18##### 6100
Other fields are filled with "#####". This should look like a black line to separate optically the 5 kHz steps
within the broadcasting bands and plus/minus 100 khz. ALso in use for 1 MHz steps.
If frequency allocations are changing also such lines are included giving details in the NOTES data field.
ILG data entries and information are based on old and current monitoring experiences made over the last 40 years...
Exclusive ILG data fields are NA,CA,SA,EU,AF,ME,AS,AU,PA since 1989 and the usage is exclusively only allowed to use by ILG Database and not by any other software
Effective from August 25th 2019
| Field No. |
FIELD_NAME | SIZE | DESCRIPTION | ADDITIONAL_INFORMATION | SPECIAL_ABBREVIATIONS |
| 1 | FREQ | 8/2 numeric |
Frequency in KHz | in some cases frequency rounded | Carrier Frequency of Utilty Stations (see also for center frequency in last column) |
| 2 | CFFREQ | 8/2 numeric |
Center Frequency in KHz | in some cases frequency rounded | important information for UTILITY station reception |
| 3 | PLAN | 4 | used old abbreviation for seasons based on old ITU broadcasting periods |
M: March/April,
J: May - August,
S: September/October,
D: November -February,
????: inactive,
====: standby / alternative
MJSD: full year operation |
|
| 4 | STATION | 30 | Station with full name | Name according to the official station identification | External & International Services in capital letters and Home Services in small letters |
| 5 | STN | 5 | Name of Station in short version | ||
| 6 | LOCATION | 26 | Location of Transmitter Site | the name of the Transmitter Site or main town and home port of ships (airborne, coastguard, navy, seaborne) | |
| 7 | LC | 2 | Transmitter Site by CIRAF Zone | LINK FOR DETAILS | |
| 8 | LONGI | 6 | Longitude | ILG gives degree and minute without dot and blank | old ILGRadio format |
| 9 | LATI | 5 | Latitude | ILG gives degree and minute without dot and blank | old ILGRadio format |
| 10 | POSITION | 20 | Position of Transmitter Site with Longitude and Latitude | LINK FOR DETAILS | ILG gives GOOGLE EARTH compatible format with degree, minute and second If Longitude and Latitude gives "00" for Seconds in both cases the transmitter site is not found so far. |
| 11 | ITU | 3 | Administration | 3 letter code of Aministration, official ITU Abbreviations LINK FOR DETAILS |
additionally listed:
TWN - Taiwan
Overseas Territories also given with own code, e.g.
ALS: Alaska
ASC: Ascension
GIB: Gibraltar
HWA: Hawaii
MRT: Martinique
REU: Reunion
|
| 12 | COUNTRY | 18 | Country | "Geographical" Name of the country | ILGRadio gives countries as the world looks like |
| 13 | TARGET | 8 | Target Area | External Services: main taget with details (see right) e.g. AF, AS, AU, CA, EU, ME, NA, PA, SA Home Services: in brackets with ADM country code |
further description:
e = east n = north s = south, w = west
ne = north-east
nw = north-west se = south-east sw = south-west |
| 14 | CIRAFZONES | 30 | CIRAF Zones | LINK FOR DETAILS | |
| 15 | NA | 2 | Target: North-America | "--" if not used | |
| 16 | CA | 2 | Target: Central America & Caribbean | "--" if not used | |
| 17 | SA | 2 | Target: South America | "--" if not used | |
| 18 | EU | 2 | Target: Europe | "--" if not used | |
| 19 | AF | 2 | Target: Africa | "--" if not used | |
| 20 | ME | 2 | Target: Middle East | "--" if not used | |
| 21 | AS | 2 | Target: Asia | "--" if not used | |
| 22 | AU | 2 | Target: Australia | "--" if not used | |
| 23 | PA | 2 | Target: Pacific | "--" if not used | |
| 24 | START | 4 | START Time (begin of broadcast) in UTC "Universal Time Co - Ordinated" | LINK FOR DETAILS | sign-on time of **59 minutes rounded by full hour
in various cases full-time broadcasts are divided in one hour blocks to make
ILG bandscans much more precisely
|
| 25 | STOP | 4 | STOP Time (end of broadcast) in UTC "Universal Time Co - Ordinated" | LINK FOR DETAILS | sign-off time of **59 minutes rounded by full hour
in various cases full-time broadcasts are divided in one hour blocks to make
ILG bandscans much more precisely
|
| 26 | LANGUAGE | 20 | Language of Programme | full name of language and dialect given | UTILITY Entries are starting with "DATA:" followed by details: CODES (Spy Radio) DATA (Data Transfer) EMAIL (E-Mail Transfer) FAX (Telefax) METEO (Weather Info) MORSE (CW) RADAR (Over the Horizon) TELEX (Telegraphy) TIMES (Time Signals) VOICE (Traffic/Information) |
| 27 | LNG | 3 | Abbreviation of Language | LINK FOR DETAILS |
Language code based on ISO 639-3 |
| 28 | GRAPHIC | 48 | Graphical Diagramm: the exact Occupation of each frequency is presented by the "Times by Lines" giving the Language of the broadcast. This is processed in a Time Scale of 24 hours with a precision of 30 minutes.
Exclusive ILG data field
|
If the transmitter is not on the air during ILGRadio publishing time only a line "------" is given instead ! |
Capital Letters: External / International / Home Service
Small Letters: SSB transmissions with clear voice
1: Sunday ... 7: Saturday
#: not daily
$: Monday-Friday
@:Monday-Saturday
=: Saturday/Sunday
?: inactive
-: standby (alternative)| : DRM
"!" is given at 6, 12 and 18 hours if this position is not used
|
| 29 | DAYS | 7 | Days | given in HFCC / ITU format |
Sundays:1
Monday: 2 Tuesday: 3 Wednesday: 4 Thurdsday: 5 Friday: 6 Saturday: 7 |
| 30 | POWER | 8/3 numeric |
Transmitter Power in kW (kiloWatt) |
for UTILITY stations correct power not confirmed in many cases | Power with MINUS VALUE e.g. -500 indicates Fake or wooden requirement of HFCC / ITU database |
| 31 | AZI | 3 numeric |
Azimut, maximum radiation of the antenna in degrees |
1 - 360 degree
0 = non direction
ATTENTION: HFCC gives 0 or 1 for 360 degree north !!!
|
for low power stations with dipole antennas 0 degree (non-directional) is given while both Azimut are given in REMARKS field |
| 32 | AWR | 3 numeric |
Angular Width of radiation main lobe (degrees / at 6dB point) | value based on data sheets of antenna manufacturers, detailed data for each MHz band vailable | |
| 33 | DB | 2 numeric |
DECIBEL, the Gain of the antenna in decibel (dBi) | value based on data sheets of antenna manufacturers, detailed data for each MHz band available | |
| 34 | AE | 2 numeric |
Angle of Elevation in Degrees, vert.elevation angle | data based on data sheets of antenna manufacturers, detailed data for each MHz band available | |
| 35 | ANTENNA | 10 | describes the Antenna / aerial in Types | Main Antenna Types: HR: Curtain Antenna HRS: Curtain Antenna slewable LPH: Log Periodic Hor. ND: Non-Directional/Dipole RHO: Rhombic |
|
| 36 | SLEW | 3 numeric |
Slew of Curtain Antenna | the Slew in degrees of slewable curtain antennas | |
| 37 | ANT | 3 | Antenna Type by number | the antenna code numer according HFCC e.g. 100 (AHR1/1/.3) ... 999 (special wide) |
|
| 38 | DATE | 4 | Date when schedule was updated in ILG database | MMYY Format | change in schedule during e.g. December 2022 gives entry in DATE with "2212" |
| 39 | FDATE | 6 | Date of START of Transmission | DDMMYY format | |
| 40 | TDATE | 6 | Date of STOP of Transmission | DDMMYY format | |
| 41 | REMARKS | 16 | Remarks | further details -if not weekly -notes on observations -additional information |
|
| 42 | STATUS | 1 | Status of Transmission | gives the value of data entry | C = confirmed I = inactive N = not confirmed X = Info Data (additional language / dialect information set) |
| 43 | MOD | 5 | Modulation First letter HFCC/ITU format followed by ILG Type information |
LINK FOR DETAILS | D = analog (AM) N = digital (DRM) T = Single Side Band FOLLOWED BY AM: Amplitude Modulation DIG: Digital (various) DRM:Digital Radio Mondiale ISB: Independent Side Band LSB: Lower Side Band USB: Upper Side Band |
| 44 | CLST | 2 | Transmission Type | Field under construction | BC: Broadcasting F: Fixed Station |
| 45 | FREEUSE | 6 | Designator of Modulation | some examples A3E: Sound (broadcasting) D7W: DRM A1A: Morse F1B: Telex F3C: Fax J3E: Voice J7D: Digital |
|
| 46 | LOC | 3 | Abbreviation of the Location | LINK FOR DETAILS | |
| 47 | BRC | 3 | Broadcaster | LINK FOR DETAILS | |
| 48 | FMO | 3 | the frequency managemnet organisation according to HFCC / ABU / ASBU / ITU | LINK FOR DETAILS |
|
| 49 | INFO | 11 | the INFO field for further information | information / name of the season | |
| 50 | AFRQ | 5 numeric |
Antenna Design Frequency of the used antenna:
given in kHz (kiloHertz)
|
data content processed by special ILG antenna tools according to technical transmitter site documents | |
| 51 | MONITORING | 15 | Matrix of the Year in Month order | months by number without a blanc | 1: January... 12: December e.g. a full year looks like this: 123456789101112 and November-February: 12.........101112 |
| 52 | NOTES | 30 | Additional Information, Modulation Type | LINK FOR SIGNAL IDENTIFICATION AND DETAILS | some popular examples used for Utility transmissions: ALE MIL-STD 188-110A ALE MIL-STD 188-141A ARQ 100Bd/500 CCIR 493-4/100Bd/170 DSC FSK 100Bd/170 FSK 50Bd/200...500 HFDL ARINC 1800Bd LINK-11 MIL-STD 6011 MFSK-8 THALES S-3000 MPSK-12 AT3004D (M5) PACTOR-1 100Bd/200 PACTOR-2 100Bd/200 PACTOR-3 QPSK/***Bd/*** QPSK-63 SAAB GRINTEC MHF-50 SITOR-B 100Bd/170 STANAG 4481 75Bd/850 STANAG 4285/300...1200L STANAG 4538/FLSU T-206/50Bd/500 T-600/50Bd/200...250 WFAX 120/576 |
| 53 | CALL | 50 | Call Sign | BROADCASTING: Calls for broadcasting only in use within the USA UTILITY: station identification: transmitter sites, ships, mobile units |
UTILITY: - full call sign -call sign sets in use - part of call sign with wildcard ( "*" ) for network or variable call signs |
| 54 | MDATE | 6 | Monitoring Date DDMMYY Format with day, year, month | this information verifies that station is/was really on air made by daily bandscans |
e.g. 101222 means monitored on December 10th 2022 |
| 55 | SDATE | 6 | Schedule Date DDMMYY Format with day, year, month |
this informations for broadcasting stations gives when frequency schedule was made or when HFCC upload was made | change in broadcasting schedule during e.g. December 10th 2022 gives entry in DATE with "101222" and all entries of the season of this FMO will be updated with this new date |
| 56 | REQ | 5 | Data Set Number | not in use at the moment | |
| 57 | G00 | 2 | UTC-Graphic: 0000-0100 hr | data field for filter function (set "G00" <> ". ") | |
| 58 | G01 | 2 | UTC-Graphic: 0100-0200 hr | data field for filter function (set "G01" <> ". ") | |
| 59 | G02 | 2 | UTC-Graphic: 0200-0300 hr | data field for filter function (set "G02" <> ". ") | |
| 60 | G03 | 2 | UTC-Graphic: 0300-0400 hr | data field for filter function (set "G03" <> ". ") | |
| 61 | G04 | 2 | UTC-Graphic: 0400-0500 hr | data field for filter function (set "G04" <> ". ") | |
| 62 | G05 | 2 | UTC-Graphic: 0500-0600 hr | data field for filter function (set "G05" <> ". ") | |
| 63 | G06 | 2 | UTC-Graphic: 0600-0700 hr | data field for filter function (set "G06" <> ". ") | |
| 64 | G07 | 2 | UTC-Graphic: 0700-0800 hr | data field for filter function (set "G07" <> ". ") | |
| 65 | G08 | 2 | UTC-Graphic: 0800-0900 hr | data field for filter function (set "G08" <> ". ") | |
| 66 | G09 | 2 | UTC-Graphic: 0900-1000 hr | data field for filter function (set "G09" <> ". ") | |
| 67 | G10 | 2 | UTC-Graphic: 1000-1100 hr | data field for filter function (set "G10" <> ". ") | |
| 68 | G11 | 2 | UTC-Graphic: 1100-1200 hr | data field for filter function (set "G11" <> ". ") | |
| 69 | G12 | 2 | UTC-Graphic: 1200-1300 hr | data field for filter function (set "G12" <> ". ") | |
| 70 | G13 | 2 | UTC-Graphic: 1300-1400 hr | data field for filter function (set "G13" <> ". ") | |
| 71 | G14 | 2 | UTC-Graphic: 1400-1500 hr | data field for filter function (set "G14" <> ". ") | |
| 72 | G15 | 2 | UTC-Graphic: 1500-1600 hr | data field for filter function (set "G15" <> ". ") | |
| 73 | G16 | 2 | UTC-Graphic: 1600-1700 hr | data field for filter function (set "G16" <> ". ") | |
| 74 | G17 | 2 | UTC-Graphic: 1700-1800 hr | data field for filter function (set "G17" <> ". ") | |
| 75 | G18 | 2 | UTC-Graphic: 1800-1900 hr | data field for filter function (set "G18" <> ". ") | |
| 76 | G19 | 2 | UTC-Graphic: 1900-2000 hr | data field for filter function (set "G19" <> ". ") | |
| 77 | G20 | 2 | UTC-Graphic: 2000-2100 hr | data field for filter function (set "G20" <> ". ") | |
| 78 | G21 | 2 | UTC-Graphic: 2100-2200 hr | data field for filter function (set "G21" <> ". ") | |
| 79 | G22 | 2 | UTC-Graphic: 2200-2300 hr | data field for filter function (set "G22" <> ". ") | |
| 80 | G23 | 2 | UTC-Graphic: 2300-2400 hr | data field for filter function (set "G23" <> ". ") | |
| 81 | GC | 24 | Geographic Coordinates with Latutude, Longitude | Calculated Values - based on Degrees Latitude and Longitude to seven decimal places | content is compatible to Google Earth and Google Maps (Brand Mark by Google LLC) |
| Size 567 |
All files are including 1535 "Separator Lines" and the data field of GRAPHIC (Graphical Diagram) looks like this:
00##########06##########12##########18##### 6100
Other fields are filled with "#####". This should look like a black line to separate optically the 5 kHz steps
within the broadcasting bands and plus/minus 100 khz. ALso in use for 1 MHz steps.
If frequency allocations are changing also such lines are included giving details in the NOTES data field.
ILG data entries and information are based on old and current monitoring experiences made over the last 40 years...
Copyright by ILG Software / Bernd Friedewald (DK9FI)