Go to FCC.gov
FCC Logo - Return to the FCC Home Page  
  Spectrum Utilization Study Software (SUSS)

Help | Advanced

|




Spectrum Utilization Study Software (SUSS)

Conversion programs and tools have been written by the FCC's Office of Engineering and Technology to convert assignment data extracted from the various Commission radios licensing systems into the MFFDBS format. These programs are written in Microsoft's Visual Basic Professional (version 6.0) using the MS Jet engine DAO, i.e., ACCESS 2003. The setup program, source code and program documentation are provided. The user is free to modify the programs to suit his or her own particular needs. Limited support is available.

PLEASE note that these programs are subject to change without notice -- use at your own risk!

Introduction: The software described below was developed by the Office of Engineering and Technology to conduct spectrum utilization studies needed in rulemaking process. This document (sussdoc.pdf) provides an overview what this software is and how to set it up to run. READ this document first. Download sussdoc.pdf now?

Master Frequency File Data Base System (MFFDBS) is a relational database containing technical and administrative information extracted from the various Federal Communication Commission's radio licensing system. The structure of this relational database has been designed to optimize the conducting of spectrum management and usage studies. Documentation describing file structure of MFFDBS is contained in the file mffstr.pdf. "mffstr.pdf" Download mffstr.pdf now?

Antenna Site Database (AntSiteDb) All the “convert” programs use a common antenna site data set. This requires the creating of a database which consists of “Registrations” files of the “Antenna Structure Registration” data set (see, “http://wireless.fcc.gov/cgi-bin/wtb-datadump.pl”) and the creation of “AntSiteDb’s A, B, C & D” tables using the program “Antenna Site Database” (“AntSiteDb”). The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "antsitedb.zip" Download antsitedb.zip now?

Convert Tower Data (CnvTwrData) is used to create a supplemental data set of antenna structures based on data found on the web. Many of the major commercial antenna tower companies along with the major cellular and PCS operators publish on the web information on their antenna site locations in the hopes of renting antenna space to other users. Some of these tower are also recorded in the “Antenna Structure Registration” database. Currently, this programs only handles the following nine data sets: American Telephone and Telegraph (AT&T), American Tower Corporation (ATC), Crown Castle International (CCI), Global Tower Partners (GTP), KGI Wireless (Kampen and Greenwell, Inc.), SBA (SBA Communications Corporation), Sprint, T-Mobile, TowerCo and Vangard Wireless. The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "cnvtwrdata.zip" Download cnvtwrdata.zip now?

Build Geographic Area Index Database (BldGAInd) is used to build a FIPS MS Access database using the flat ASCII file "fips_area_perimeter_data.dat". This database is needed to run the MffTools program. This database contains data that relates the FIPS code with the textual name of the State and County it represents. The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "bldgaind.zip" Download bldgaind.zip now?

Convert CDBS (CnvCdbs) converts assignment data extracted from the Media Bureaus' Consolidated Database System (CDBS) into relational database. CDBS containes licensing information on AM, FM and TV assignments. See Rule Part 74 for licensing information. The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "cnvcdbs.zip" Download cnvcdbs.zip now?

Convert COALS (CnvCoals) converts assignment data extracted from the Cable Services Bureaus' Cable Operations and Licensing System (COALS) into relational data base. See Rule Parts 76 and 78 for licensing information. The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "cnvcoals.zip" Download cnvcoals.zip now?

Convert IBFS (CnvIbfs) converts assignment data extracted from the International Bureaus' Filing System (IBFS) into relational database, See Rule Parts 73/74, 23 and 25 for licensing information. The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "cnvibfs.zip" Download cnvibfs.zip now?

Convert ULS (CnvUls) converts assignment data extracted from the Wireless Telecommunication Bureaus' Universal Licensing System (ULS) into relational database. This program can be used to process the following ULS systems: Aircraft (47 CFR Part 87), Cellular (47 CFR Part 22), Paging (47 CFR Part 22), Microwave (47 CFR Parts 74 and 101), Personal Communications Service (47 CFR Part 24), Instructional Television Fixed Service (ITFS) and Multipoint Distribution Service (MDS) (47 CFR Part 74 subpart I and 47 CFR Part 21 Subpart K) and Antenna Structure Registration (47 CFR Part 17). The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "cnvuls.zip" Download cnvuls.zip now?

Map Antenna Structure Registration (MapAsr) permits the user to extract, as MapInfo ‘mid’ and ‘mif’ files, all the structure records contained in a MS Access database created by the Convert Antenna Structure Registration (CnvAsr) program. The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "mapasr.zip". Download mapasr.zip now?

Master Frequency File Tools (MffTools) permits the user to extract radio assignment information from the Master Frequency File database system according to several extraction criteria and export the assignment data in MapInfo's "MIF" and "MID" format. The "MID" and "MIF" files can be view using either MapInfo Professional (any version) or any geographical information system (GIS) program that can process "MIF" and "MID" files. The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "mfftools.zip" Download mfftools.zip now?

Convert Antenna Structure Registration Database (CnvAsr) is used to build a MS Access database using ASR data. The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "cnvasr.zip" Download cnvasr.zip now?

Questions? Contact Donald Draper Campbell



last reviewed/updated 7/30/12


If you have questions about this web page, or would like more information pertaining to OET, please send e-mail to oetinfo@fcc.gov

Skip FCC Footer and Contact InfoFederal Communications Commission
445 12th Street SW
Washington, DC 20554
More FCC Contact Information...
Phone:  1-888-CALL-FCC (1-888-225-5322)
TTY:  1-888-TELL-FCC (1-888-835-5322)
Fax:  1-866-418-0232
- Privacy Policy
- Website Policies & Notices
- Required Browser Plug-ins
- Freedom of Information Act