The Office of Engineering and Technology (OET), and the Media Bureau (MB) have developed a web interface for updating the input channels of TV translators, Low Power TV (LPTV) and Class A TV stations. This data will be available to the white space internet database operators for inclusion in the white space database.
Read me file last update 8-15-12
The public files are available at the following URL:
http://transition.fcc.gov/ftp/Bureaus/MB/Databases/cdbs/
ftp://ftp.fcc.gov/pub/Bureaus/MB/Databases/cdbs/
These files are updated on a daily basis.
The files contain the data elements name, the data type and a brief description of the field.
The files have been compressed on a Unix system with zip (-l option).
They can be unzipped on a PC using PKUNZIP, WINZip, or similar utilities.
WHITE SPACE TOOL TABLES
******************************************************************************
******************************************************************************
File name: ws_delivery_method (Definition table)
File description: Translator signal reception method codes and definitions
No. Column Name Type
------ ------------------ ------
(1) Counter int
(2) delivery_method varchar (1)
(3) input_type varchar (255)
Column name description:
Counter = Row count value for table
delivery_method = Contains code for input method type
input_type = input code definition
******************************************************************************
File name: ws_translator_data
File description: Translator transmitter location and identification data. Current/active data in use by the translator
No. |
Column Name |
Type |
------ |
------------------ |
------ |
(1) |
Counter |
int |
(2) |
whtspace_id |
varchar(255) |
(3) |
frn |
varchar(10) |
(4) |
translator_facility_id |
int |
(5) |
translator_facility_sign |
varchar(12) |
(6) |
tx_lat_dir |
varchar(1) |
(7) |
tx_lat_deg |
int |
(8) |
tx_lat_min |
int |
(9) |
tx_lat_sec |
float |
(10) |
tx_lon_dir |
varchar(1) |
(11) |
tx_lon_deg |
int |
(12) |
tx_lon_min |
int |
(13) |
tx_lon_sec |
float |
(14) |
inserted_date_stamp |
datetime |
(15) |
updated_date_stamp |
datetime |
Column name description:
Counter = Row count value for table
whtspace_id = Unique ID for TV translator. Relates across data tables
frn = FCC Registration Number (FRN)
translator_facility_id = facility ID
translator_facility_sign = translator call sign
tx_lat_dir = latitude direction (translator) NAD 27
tx_lat_deg = Latitude degrees (translator) NAD 27
tx_lat_min = Latitude minutes (translator) NAD 27
tx_lat_sec = Latitude seconds (translator) NAD 27
tx_lon_dir = Longitude direction (translator) NAD 27
tx_lon_deg = Longitude degrees (translator) NAD 27
tx_lon_min = Longitude minutes (translator) NAD 27
tx_lon_sec = Longitude seconds (translator) NAD 27
inserted_date_stamp = Date and time of entry
updated_date_stamp = Date data was modified
*******************************************************************
File name: ws_history_translator_data
File description: Translator transmitter location and identification data transaction history. Lists all actions for translator
No. |
Column Name |
Type |
------ |
------------------ |
------ |
(1) |
Counter |
int |
(2) |
whtspace_id |
varchar(255) |
(3) |
frn |
varchar(10) |
(4) |
translator_facility_id |
int |
(5) |
translator_facility_sign |
varchar(12) |
(6) |
tx_lat_dir |
varchar(1) |
(7) |
tx_lat_deg |
int |
(8) |
tx_lat_min |
int |
(9) |
tx_lat_sec |
float |
(10) |
tx_lon_dir |
varchar(1) |
(11) |
tx_lon_deg |
int |
(12) |
tx_lon_min |
int |
(13) |
tx_lon_sec |
float |
(14) |
first_name |
varchar(20) |
(15) |
last_name |
varchar(20) |
(16) |
|
varchar(50) |
(17) |
telephone |
varchar(12) |
(18) |
telephone_ext |
int |
(19) |
modification_type |
varchar(10) |
(20) |
inserted_date_stamp |
datetime |
Column name description:
Counter = Row count value for table
whtspace_id = Unique ID for TV translator. Relates across data tables
frn = FCC Registration Number (FRN)
translator_facility_id = facility ID
translator_facility_sign = translator call sign
tx_lat_dir = latitude direction (translator) NAD 27
tx_lat_deg = Latitude degrees (translator) NAD 27
tx_lat_min = Latitude minutes (translator) NAD 27
tx_lat_sec = Latitude seconds (translator) NAD 27
tx_lon_dir = Longitude direction (translator) NAD 27
tx_lon_deg = Longitude degrees (translator) NAD 27
tx_lon_min = Longitude minutes (translator) NAD 27
tx_lon_sec = Longitude seconds (translator) NAD 27
first_name = User first name
last_name = User last name
email = User email
telephone = User contact telephone
telephone_ext = User phone ext.
modification_type = Data added/modified/deleted
inserted_date_stamp = Date and time of entry
**************************************************************************
File name: ws_translator_input_channels
File description: Contains active data for stations received by the translators
No. |
Column Name |
Type |
------ |
------------------ |
------ |
(1) |
counter |
int |
(2) |
whtspace_id |
varchar(255) |
(3) |
prim_facility_id |
int |
(4) |
prim_call_sign |
varchar(12) |
(5) |
prim_comm_city |
varchar(20) |
(6) |
prim_comm_state |
varchar(2) |
(7) |
prim_channel |
int |
(8) |
delivery_method |
varchar(1) |
(9) |
receiver_ant_str_reg |
varchar(12) |
(10) |
receive_transmitter_call_sign |
varchar(12) |
(11) |
receive_transmitter_channel |
int |
(12) |
receive_transmitter_fac_id |
int |
(13) |
call_sign_of_microwave |
varchar(12) |
(14) |
collocated_rec_ant |
varchar(3) |
(15) |
rx_lat_dir |
varchar(1) |
(16) |
rx_lat_deg |
int |
(17) |
rx_lat_min |
int |
(18) |
rx_lat_sec |
float |
(19) |
rx_lon_dir |
varcahr(1) |
(20) |
rx_lon_deg |
int |
(21) |
rx_lon_min |
int |
(22) |
rx_lon_sec |
float |
(23) |
inserted_date_stamp |
datetime |
(24) |
updated_date_stamp |
datetime |
Column name description:
Counter = Row count value for table
whtspace_id = Unique ID for TV translator. Relates across data tables
prim_facility_id = Signal source station facility ID
prim_call_sign = Signal source station call sign
prim_comm_city = Signal source station city
prim_comm_state = Signal source station state
prim_channel = Signal source station channel number
delivery_method = Source reception input type id
receiver_ant_str_reg = Antenna structure registration # for receiver antenna structure
receive_transmitter_call_sign = Signal source transmitter call sign
receive_transmitter_channel = Signal source transmitter channel number
receive_transmitter_fac_id = Signal source transmitter facility ID
call_sign_of_microwave = Signal source Microwave call sign
collocated_rec_ant = Antenna is/is not located with translator
rx_lat_dir = Receive antenna latitude dir NAD 27
rx_lat_deg = Receive antenna lat degree NAD 27
rx_lat_min = Receive antenna lat minute NAD 27
rx_lat_sec = Receive antenna lat second NAD 27
rx_lon_dir = Receive antenna longitude dir NAD 27
rx_lon_deg = Receive antenna lon degree NAD 27
rx_lon_min = Receive antenna lon minute NAD 27
rx_lon_sec = Receive antenna lon second NAD 27
inserted_date_stamp = Date and time of entry
updated_date_stamp = Date and time of modification
******************************************************************************
File name: ws_history_input_channels
File description: History of actions for stations received by translators
No. |
Column Name |
Type |
------ |
------------------ |
------ |
(1) |
counter |
int |
(2) |
whtspace_id |
varchar(255) |
(3) |
prim_facility_id |
int |
(4) |
prim_call_sign |
varchar(12) |
(5) |
prim_comm_city |
varchar(20) |
(6) |
prim_comm_state |
varchar(2) |
(7) |
prim_channel |
int |
(8) |
delivery_method |
varchar(1) |
(9) |
receiver_ant_str_reg |
varchar(12) |
(10) |
receive_transmitter_call_sign |
varchar(12) |
(11) |
receive_transmitter_channel |
int |
(12) |
receive_transmitter_fac_id |
int |
(13) |
call_sign_of_microwave |
varchar(12) |
(14) |
collocated_rec_ant |
varchar(3) |
(15) |
rx_lat_dir |
varchar(1) |
(16) |
rx_lat_deg |
int |
(17) |
rx_lat_min |
int |
(18) |
rx_lat_sec |
float |
(19) |
rx_lon_dir |
varchar(1) |
(20) |
rx_lon_deg |
int |
(21) |
rx_lon_min |
int |
(22) |
rx_lon_sec |
float |
(23) |
modification_type |
varchar(10) |
(24) |
updated_date_stamp |
datetime |
Column name description:
Counter = Row count value for table
whtspace_id = Unique ID for TV translator. Relates across data tables
prim_facility_id = Signal source station facility ID
prim_call_sign = Signal source station call sign
prim_comm_city = Signal source station city
prim_comm_state = Signal source station state
prim_channel = Signal source station channel number
delivery_method = Source reception input type id
receiver_ant_str_reg = Antenna structure registration # for receiver antenna structure
receive_transmitter_call_sign = Signal source transmitter call sign
receive_transmitter_channel = Signal source transmitter channel number
receive_transmitter_fac_id = Signal source transmitter facility ID
call_sign_of_microwave = Signal source Microwave call sign
collocated_rec_ant = Antenna is/is not located with translator
rx_lat_dir = Receive antenna latitude dir NAD 27
rx_lat_deg = Receive antenna lat degree NAD 27
rx_lat_min = Receive antenna lat minute NAD 27
rx_lat_sec = Receive antenna lat second NAD 27
rx_lon_dir = Receive antenna longitude dir NAD 27
rx_lon_deg = Receive antenna lon degree NAD 27
rx_lon_min = Receive antenna lon minute NAD 27
rx_lon_sec = Receive antenna lon second NAD 27
modification_type = Data added/modified/deleted
inserted_date_stamp = Date and time of entry
****************************************************************************