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" "antsitedb.zip" Download antsitedb.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 Join (MffJoin) combines the relational databases create by the above conversion programs into a single relational database. The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file "mffjoin.zip" Download mffjoin.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 ProViewer (version 5.0 or lower) or MapInfo Professional (any version) or any geographical information system (GIS) program that can process "MIF" and "MID" files. The program also generates text files that can be imported into DeLorme's "Street Atlas 2003 USA" or "Topo USA version 4.0" to display radio assignments in a similar mannor as with MapInfo products. 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?

Split ULS (SplitUls) is used to separate the output data file resulting from a selective search of the Universal Licensing System using the 'Query Download' method into the bulk data format of individual table files that can be processed by the CnvULS program, see http://wireless2.fcc.gov/UlsApp/UlsSearch/searchLicense. jsp The setup program and associated files, program documentation, database file structure and source code are all contained in the zipped file " SplitUls.zip " Download splituls.zip now?

Questions? Contact Donald Draper Campbell