The fcc FTP site is ftp.fcc.gov

The location of the data of interest is at
/pub/Bureaus/Wireless/Databases/uls/.

There are zip files (pipe delimited) in complete and the daily changed
files in daily.  Theres lots of info in documentation which includes
excel spreadsheets of the schema.  These will have to be converted to
sql statemtents.

The ULS is the database system that holds the data for Fixed and Mobile
wireless services.  This includes most two way systems and point to
multipoint (microwave) but not broadcast (AM, FM, TV) and not advanced
radio.

The database is really a database of applications.  It contains
application data submitted by wireless applicants.  

There are two families of tables, prefixed with 'a' and 'l'.  The 'a'
tables stand for application records that are pending being granted by
the fcc.  The 'l' tables have received licenses and may or may not be
operating.

Combined, the 'a' and 'l' zipfiles represent a specific service.  For
example, 'a_micro' and 'l_micro' contain the applications and licensed
data for microwave systems.  The different services have slightly
different layouts because they have different requirements.

I strongly suggest looking at LMcomm and LMpriv first.  These are the
fixed land mobile systems, and 90% of the entire database.  They also
have identical layouts.

There are a great deal of files in each zipfile, but here are the most
interesting:

hd: header data
ad: application detail
an: antenna data
lo: location data
fr: frequency data
em: emission data

There are others.  I can help you write meaningful queries that are
quite complex and will require optimization techniques.

Merlin


Fri, 4 Apr 2003 11:47:56 -0500
"Merlin Moncure" <merlin.moncure@rcsonline.com>
Re: [PERFORM] OSS database needed for testing
Merlin,

> The fcc FTP site is ftp.fcc.gov
> 
> The location of the data of interest is at
> /pub/Bureaus/Wireless/Databases/uls/.

Cool.   I'll tackle this in a week or two.  Right now, I'm being paid to 
convert a client's data and that'll keep me busy through the weekend ...

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


Fri, 4 Apr 2003 09:37:34 -0800
Josh Berkus <josh@agliodbs.com>
Re: [PERFORM] OSS database needed for testing
On Friday 04 April 2003 11:47, Merlin Moncure wrote:
> The location of the data of interest is at
> /pub/Bureaus/Wireless/Databases/uls/.

> wireless services.  This includes most two way systems and point to
> multipoint (microwave) but not broadcast (AM, FM, TV) and not advanced
> radio.

Also check out the cdbs files (which contain the broadcast stuff as well as 
more) at /pub/Bureaus/Mass_Media/Databases/cdbs/ (which I would be more 
interested in doing, since I am a broadcast engineer by profession....)
-- 
Lamar Owen
WGCR Internet Radio
1 Peter 4:11


Fri, 4 Apr 2003 14:08:31 -0500
Lamar Owen <lamar.owen@wgcr.org>
Re: [PERFORM] OSS database needed for testing
Lamar,

> Also check out the cdbs files (which contain the broadcast stuff as well as 
> more) at /pub/Bureaus/Mass_Media/Databases/cdbs/ (which I would be more 
> interested in doing, since I am a broadcast engineer by profession....)

Hey, if you're willing to do the text --> postgres conversions, I'll use 
whichever tables you want ...

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


Fri, 4 Apr 2003 11:27:16 -0800
Josh Berkus <josh@agliodbs.com>
Re: [PERFORM] OSS database needed for testing