Shows information on LPFM facilities with §73.807 second-adjacent channel short spacing. This list was originally ran on July 7, 2024 and for those legacy records, shows all short-spacings at that time, including subsequent modifications where a waiver may have not been originally requested. This table will be updated overnight each day to add new application records. For the subsequent records, it will only list the short-spacings that were present at the time when the applicaiton was filed and will not include subsequent modifications.
|
column |
type |
description |
|
lpfm_lms_application_id |
varchar(36) |
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. This is the application ID of the LPFM facility being evaluated. |
|
fm_lms_application_id |
varchar(36) |
Application ID of the full-service FM or FM Translator facility that places a service contour into the FM Translator's interfering contour on second or third adjacent channsl. |
|
fx_facility_id |
int | Facility ID of the subject FM Translator. |
|
fm_facility_id |
int | Facility ID of the overlapping FM facility. |
| fm_station_class | varchar(6) |
Station class of the overlapping FM facility. |
|
fm_service |
varchar(2) | Service code of the overlapping FM facility. (FM = Full-service FM including Class D FM, FX = FM Translator). |
|
fx_sub_class |
int | REC Translator subclass of the short-spaced FM facility if that facility is a FM Translator. |
|
prvi |
varchar(1) |
Y if overlapping FM facility is in Puerto Rico or the Virgin Islands. |
|
dist_required |
int | Minimum distance separation required pursuant to §73.807. |
|
distance |
decimal(6,1) | Distance (to the tenths) between the facilities. |
|
distance_round |
int | Rounded distance between the facilities. |
|
contour_at_lpfm |
decimal(6,1) | Service contour of the potentially overlapping station at the subject FM Translator site. NOTE: If this value is 9999.0, this means that the contour is well in excess of at least 120 dBu, which would suggest a co-located or adjacent tower facility. |
|
overlap_zone |
int | Distance from the subject FM translator to the distance to the respective interfering contour of the subject FM translator based on a 40 dB U/D ratio. Distance is in meters. |
|
fm_overlap |
varchar(1) | Y = If there is contour overlap. N = if there is no detected overlap. |
