Thread

1. Re: [PERFORM] OSS database needed for testing

   Merlin Moncure <merlin.moncure@rcsonline.com> — 2003-04-04T16:47:56Z

   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
   
   
   

2. Re: [PERFORM] OSS database needed for testing

   Josh Berkus <josh@agliodbs.com> — 2003-04-04T17:37:34Z

   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
   
   
   

3. Re: [PERFORM] OSS database needed for testing

   Lamar Owen <lamar.owen@wgcr.org> — 2003-04-04T19:08:31Z

   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
   
   
   

4. Re: [PERFORM] OSS database needed for testing

   Josh Berkus <josh@agliodbs.com> — 2003-04-04T19:27:16Z

   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