The FCC publishes, on a weekly basis, a database of both the application and license data for microwave frequencies.
The database is separated into applications and licenses. The structure of the database is contained within approximately 25 .dat files which need to be integrated in order to make the data meaningful and whole.
Ideally, this would be accomplished through a SQL database, as the FCC provides the schema to reference these .dat files.
In summary, the requirements for what is needed are as follows:
• Working knowledge of SQL and a mainstream database management software.
• Data cleaning and continuity for loading the files into the database
• Proficient knowledge of SQL queries to summon the required data
• Ability to create a stored procedure, to facilitate weekly loading of published data
The data files and instructions are hosted at the following webpage:
[url removed, login to view]