Applications that have FM related engineering data will have data in this table. The key to this table is lms_application_id using application as the primary table. In addition, if applist_fm/eng_data = 'Y', then there should be an FM engineering record in this table.
NOTE: This information may not be authoritative for the facility that the FCC had actually granted, but in most cases, what was asked for is what was granted. Despite the data errors in FCC LMS raw data, especially on LPFM facilities; the information in the FCC released raw data reflects the granted parameters. This table only appears on records that involve FM engineering (MOD, L2C, CP). Geographic coordinates in LMS are NAD83.
This data is added at the time the application is filed. When the application is granted, the data is updated based on the information from the construction permit or license authorization.
column |
type |
description |
lms_application_id |
varchar(32) |
Primary index used for all applications. Corresponds with the FCC’s application identifier used in LMS and therefore can be used to cross reference with FCC raw data. Unless otherwise indicated, all relational tables in eLMS are linked by lms_application_id |
station_channel |
int |
Station channel (201~300) (201 = 88.1, 300 = 107.9) |
fac_type |
char(1) |
Type of facility: C = Commercial, N = Noncommercial |
station_class |
varchar(6) |
Class of broadcast station: A, B, B1, C, C0, C1, C2, C3, D, LP100 |
country_code |
varchar(2) |
Country that station is located in (US, CA, MX, BV) |
intl_class |
varchar(2) |
Class of station as recognized by FCC International Bureau |
rec_fx_subclass |
int |
REC FM translator subclass for purposes of determining LPFM protection: (1 or 2) less than 7.3 km (3, 4, or 5) between 7.3~13.3 km (6, 7, 8) more than 13.3 km |
lat |
double(10,7) |
Decimal latitude (NAD83) from equator. |
lon |
double(11,7) |
Decimal longitude (NAD83) from prime meridian. |
lat_deg |
int |
Latitude degrees |
lat_min |
int |
Latitude minutes |
lat_sec |
decimal(4,1) |
Latitude seconds |
lat_dir |
char(1) |
Latitude direction: N, S |
lon_deg |
int |
Longitude degrees |
lon_min |
int |
Longitude minutes |
lon_sec |
decimal(4,1) |
Longitude seconds |
lon_dir |
char(1) |
Longitude direction: E, W |
nad27_lat |
double(10,7) |
Decimal latitude converted to NAD27 |
nad27_lon |
double(11,7) |
Decimal latitude converted to NAD27 |
biased_lat |
double(11,7) |
Biased latitude based on NAD27 (for legacy applications) |
biased_lon |
double(11,7) |
Biased longitude based on NAD27 (for legacy applications) |
asr_status |
varchar(1) |
Status of antenna structure registration: N = Does not need an ASRN, Y = Has an ASRN, F=Coordination with the FAA filed. |
asrn |
int |
Antenna Structure Registration Number |
structure_type |
varchar(20) |
Type of structure that antenna is mounted on. |
overall_height |
float |
Overall height of antenna and support structure. |
site_elevation |
float |
Elevation of antenna site at ground level (above mean sea level) |
h_rcagl |
float |
Height above ground level – horizontal element |
v_rcagl |
float |
Height above ground level – vertical element |
h_haat |
float |
Height above average terrain – horizontal element |
v_haat |
float |
Height above average terrain – vertical element |
h_rcamsl |
float |
Radiation center height above mean sea level – horizontal element |
v_rcamsl |
float |
Radiation center height above mean sea level – vertical element |
h_erp |
float |
Effective radiated power in kW – horizontal element |
v_erp |
float |
Effective radiated power in kW – vertical element |
h_merp |
float |
Maximum effective radiated power in kW – horizontal element |
v_merp |
float |
Maximum effective radiated power in kW – vertical element |
tpo |
float |
Transmitter power output in kW |
antenna_type |
char(1) |
Antenna type: D = directional, N = nondirectional |
primary_station |
int |
Facility ID of the primary station this facility is rebroadcasting |
primary_station_type |
varchar(10) |
Not used at this time. |
delivery_type |
varchar(80) |
How the programming is delivered from the primary station to translator |
delivery_other |
varchar(80) |
Not used at this time. |
associated_service |
varchar(6) |
Service code of primary station for translator (AM, FM, FL=LPFM) |
ant_make |
varchar(80) |
Manufacturer of antenna |
ant_model |
varchar(80) |
Model number of antenna |
ant_sections |
int |
Number of sections (bays) that the antenna has |
ant_spacing |
int |
Spacing between antennas in wavelength (1.0 = full wave, 0.5 = half wave, etc.) |
ant_rotation |
int |
Rotation of antenna (CDBS import records only) |
haat_elms_calc |
varchar(1) |
LPFM record where HAAT and ERP were automatically calculated by eLMS. |
associated_app_id |
varchar(32) |
Application ID of the associated application (granted modification or license to cover) |
associated_file_number |
varchar(20) |
FCC LMS File number associated application |
last_update |
timestamp |
Last update of the record |