PROgramit - Frequency Databases

With the advent of the CD-ROM and the Internet, it has become rather easy and inexpensive to find frequency databases to suit your needs. A few of these are listed in the sidebar. Unfortunately, each author has chosen to use a different database structure, so you often need special SW to access these. PROgramit provides an Import feature to convert the most popular of these databases to the required format. Currently, the Probe, Percon and Scanware formats can be converted. By the time you read this, other formats will be supported including delimited ASCII text which can be produced by most any database access program.

PROgramit uses Microsoft Access for the underlying database, but you don't need Access to use the SW. The current version of the program provides you with some very basic editing functions that allow you to create and edit a Frequency Database. Table 1 shows the database format.
 

NAME TYPE/SIZE
Frequency  Text 12
Callsign Text 10 
DBA_Name Text 40
City  Text 20 
County  Text 30 
State  Text 24 
Latitude Text 6
Longitude  Text 7
Radio_Stat  Text 4
Class_Stat  Text 4
Priority (Default = False)  Boolean 1 
Lockout (Default = False)  Boolean 1 
Delay (Default = False)  Boolean 1 
Mode (0 = NA, 1 = AM, 2 = NFM, 3 = WFM)  Byte 1
Channel (Not Used)  Integer 2 
PLTone (Default = Blank)  Text 5
Spare1 (Default = Blank)  Text 12 
Spare 2 (Default = Blank)  Text 12 
Spare 3 (Default = False)  Boolean 1 
Spare 4 (Default = False)  Boolean 1 
Spare 5 (Default = 0)  Double 8 
Spare 6 (Default =0)  Double 8 
NumFreq (Frequency String Converted to Double)  Double 8 

Table 1- Structure of Frequency Database tables


Sources for the master database include:

1) The FCC WEB page at http://www.fcc.gov/wtb/databases.html 

2) Contact Datafiles for information about Probe Software at [email protected]

3) Percon Corp.
4906 Maple Springs/Ellery Rd.
Bemus Point, N.Y. 14712
Phone - 716 386-6015 (24 hrs. / 7 days a week)
Fax - 716-386-6013
http://www.perconcorp.com

4) Scanware Associates WEB page at and http://www.wvsc.wvnet.edu:80/~fcc/.


BACK