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)

email

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

 

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