[Score-database] Re: HOla

[Kenneth E. Harker]

On Tue, Feb 15, 2005 at 01:18:07PM -0800, George Fremin III K5TR wrote:
> 
> 
> Welcome,
> 
> 
> There are only four of us on here so far:
> 
> n2mg
> w0db
> kg5u
> k5tr

You can officially add me to the list.  I'll help out where I can.

> The corrections are in at least two places I know of for the 
> contests:

Actually, I've noticed that the printed corrections can appear
in any of four places:

* A subsequent contest result article (not necessarily for the same
  contest - i.e. a correction for the 10 Meter contest might appear the 
  following month in the writeup for the RTTY Roundup, or it might appear
  twelve months later in the next 10 Meter Contest writeup.)
* Contest Corral (in the years when that column exists.)
* Operating News (in the years when that column exists.)
* On the same page as contest anouncements.

The thing to do would be to look in all four place in each QST and
just record any printed corrections regardless of the contest, and
then later we can sort them by contest.

> The format that was used for the 10 meter contest database
> is what is on the ARRL web page in the scores database.

Specifically, what I built for the 10 meter contest were tab-delimited 
text files with the same fields as the tab-delimited text files you can
download from the ARRLWeb.  You can check them out an example at:
http://www.arrl.org/arrl10/Years/91arrl10.tab  Different years have slightly
different fields depending on whether or not there were power categories,
or whether or not hours or contest clubs were recorded.  But, that's 
entirely consistent with the ARRLWeb files.

Once I built all the tab-delimited files, I then wrote a simple script 
to load them into a MySQL database (which I also populated with some 
meta-data tables) and another simple script to pull out the record scores.

The database schema is (at a high level):

scores
  countries
    prefix
    name
    continent
  divisions
    section
    name
    division
  arrl10
    section
    category
    call
    station
    ops
    score
    qsos
    mults
    year
  solar
    contest (i.e. "arrl10")
    year
    flux
    kp
    ap

So, we can add new tables like "arrlsscw" or "cqwwssb" or whatever, with 
the relevant data fields specific to their contest, and they can share 
the countries, divisions, and solar table data.  I only have solar data 
loaded for the 10 Meter Contest so far.  The dataase schema is still 
flexible - there's no reason we can't change things.

-- 
Kenneth E. Harker WM5R
kenharker at kenharker.com
http://www.kenharker.com/