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.

 

Please note:  The white space translator (WST) data file structure is different from files that are generated from the CDBS database.  This difference in structure may cause errors in software that is designed to read/parse CDBS data files. WST tables that are not named history tables will contain only the latest information about the translator.

 

Read me file last update 11-19-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

 

****************************************************************************