Geographic coordinates of FM service contours. 54 dBu for commercial Class B, 57 dBu for commercial Class B1 and 60 dBu for all others. For each application, there will be 36 lines of data representing all 360 radial directions.
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 |
azumuth |
int |
Starting azimuth of coordinates in this line. Multiply this value by 10. |
lat0 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 0) |
lon0 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 0) |
lat1 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 1) |
lon1 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 1) |
lat2 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 2) |
lon2 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 2) |
lat3 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 3) |
lon3 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 3) |
lat4 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 4) |
lon4 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 4) |
lat5 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 5) |
lon5 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 5) |
lat6 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 6) |
lon6 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 6) |
lat7 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 7) |
lon7 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 7) |
lat8 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 8) |
lon8 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 8) |
lat9 |
decimal(10,6) |
Geographic coordinates of latitude at ((azimuth x 10) + 9) |
lon9 |
decimal(10,6) |
Geographic coordinates of longitude at ((azimuth x 10) + 9) |
haat0~haat9 |
decimal(10,2) | Ten columns similar to how 'lat_' and 'lon_' are formatted that provides the height above average terrain along each radial. |
has_haat |
varchar(1) | Value of "Y" if REC has HAAT data for all 360 radials. |
haat_src |
varchar(1) | Source of terrain data used. (N = NED1, 2 = NED2, G = GLOBE) |
field0~field9 |
decimal(10,3) | Ten columns similar to how 'lat_' and 'lon_' are formatted that provides the relative field value along each radial. Used for directional antennas. For non-directional stations, these values will always be '1.000'. |
has_da |
varchar(1) |
Value of "Y" if the station has a directional antenna. Otherwise value will be "N" or blank for nondirectional facilities. |
last_update | timestamp |
Date and time when record was last updated (RECOT). |
Updated July 1, 2024