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 2-5-13
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_call_sign |
varchar(12) |
|
(6) |
inserted_date_stamp |
datetime |
|
(7) |
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_call_sign = translator call sign
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_call_sign |
varchar(12) |
|
(6) |
modification_type |
varchar(10) |
|
(7) |
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_call_sign = translator call sign
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) | source_id | varchar(255) |
|
(3) |
whtspace_id |
varchar(255) |
|
(4) |
prim_facility_id |
int |
|
(5) |
prim_call_sign |
varchar(12) |
|
(6) |
prim_comm_city |
varchar(20) |
|
(7) |
prim_comm_state |
varchar(2) |
|
(8) |
prim_channel |
int |
(9) |
prog_orig |
int |
|
(10) |
delivery_method |
varchar(1) |
|
(11) |
receiver_ant_str_reg |
varchar(12) |
|
(12) |
prog_orig_call_sign |
varchar(12) |
|
(13) |
prog_orig_channel |
int |
|
(14) |
prog_orig_facid |
int |
|
(15) |
call_sign_of_microwave |
varchar(12) |
|
(16) |
collocated_rec_ant |
varchar(3) |
|
(17) |
rx_lat_dir |
varchar(1) |
|
(18) |
rx_lat_deg |
int |
|
(19) |
rx_lat_min |
int |
|
(20) |
rx_lat_sec |
float |
|
(21) |
rx_lon_dir |
varcahr(1) |
|
(22) |
rx_lon_deg |
int |
|
(23) |
rx_lon_min |
int |
|
(24) |
rx_lon_sec |
float |
|
(25) |
modification_type |
varchar(10) |
|
(26) |
inserted_date_stamp |
datetime |
Column name description:
Counter = Row count value for table
source_id = ID for translator input source
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
prog_orig = Indicates program origination source
delivery_method = Source reception input type id
receiver_ant_str_reg = Antenna structure registration # for receiver antenna structure
prog_orig_call_sign = Call sign of program origination source
prog_orig_channel = Channel number of program origination source
prog_orig_facid = FACID of program origination source
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 latitude degree NAD 27
rx_lat_min = Receive antenna latitude minute NAD 27
rx_lat_sec = Receive antenna latitude second NAD 27
rx_lon_dir = Receive antenna longitude dir NAD 27
rx_lon_deg = Receive antenna longitude degree NAD 27
rx_lon_min = Receive antenna longitude minute NAD 27
rx_lon_sec = Receive antenna longitude second NAD 27
modification_type = List change type
inserted_date_stamp = Date and time of entry
******************************************************************************
File name: ws_history_input_channels
File description: History of actions for stations received by translators
|
No. |
Column Name |
Type |
|
------ |
------------------ |
------ |
|
(1) |
counter |
int |
| (2) | source_id | varchar(255) |
|
(3) |
whtspace_id |
varchar(255) |
|
(4) |
prim_facility_id |
int |
|
(5) |
prim_call_sign |
varchar(12) |
|
(6) |
prim_comm_city |
varchar(20) |
|
(7) |
prim_comm_state |
varchar(2) |
|
(8) |
prim_channel |
int |
(9) |
prog_orig |
int |
|
(10) |
delivery_method |
varchar(1) |
|
(11) |
receiver_ant_str_reg |
varchar(12) |
|
(12) |
prog_orig_call_sign |
varchar(12) |
|
(13) |
prog_orig_channel |
int |
|
(14) |
prog_orig_facid |
int |
|
(15) |
call_sign_of_microwave |
varchar(12) |
|
(16) |
collocated_rec_ant |
varchar(3) |
|
(17) |
rx_lat_dir |
varchar(1) |
|
(18) |
rx_lat_deg |
int |
|
(19) |
rx_lat_min |
int |
|
(20) |
rx_lat_sec |
float |
|
(21) |
rx_lon_dir |
varcahr(1) |
|
(22) |
rx_lon_deg |
int |
|
(23) |
rx_lon_min |
int |
|
(24) |
rx_lon_sec |
float |
|
(25) |
modification_type |
varchar(10) |
|
(26) |
inserted_date_stamp |
datetime |
Column name description:
Counter = Row count value for table
source_id = ID for translator input source
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
prog_orig = Indicates program origination source
delivery_method = Source reception input type id
receiver_ant_str_reg = Antenna structure registration # for receiver antenna structure
prog_orig_call_sign = Call sign of program origination source
prog_orig_channel = Channel number of program origination source
prog_orig_facid = FACID of program origination source
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 latitude degree NAD 27
rx_lat_min = Receive antenna latitude minute NAD 27
rx_lat_sec = Receive antenna latitude second NAD 27
rx_lon_dir = Receive antenna longitude dir NAD 27
rx_lon_deg = Receive antenna longitude degree NAD 27
rx_lon_min = Receive antenna longitude minute NAD 27
rx_lon_sec = Receive antenna longitude second NAD 27
modification_type = List change type
inserted_date_stamp = Date and time of entry
****************************************************************************