[NCARC] Hams in Colorado

[David Langenberg]

Michael Robinson wrote:
> Are you handy with databases?
> Do you have access to databases like qrz or similar?
> 
> I would like every name, callsign and address of every ham in Colorado,
> and Wyoming.
> I would like it in tab or comma delimited format.
> 
> Waddya got?

How's this:

https://filer.uchicago.edu/xythoswfs/webui/_xy-18761_1-t_ng8DYl8i

The link is good for 30 days.

For those interested you can download the FCC database from

http://wireless.fcc.gov/cgi-bin/wtb-datadump.pl

They also have up the SQL schema files for the tables.  The one you
would be interested in is the amateur license database specifically the
PUBACC_EN table and EN.dat file.  You will run into issues loading these
files into things like MySQL/Postgresql due to some bad data in the
file, but the database load utilities are usually nice enough to tell
you where in the file the bad characters are so you can fix by hand.
This last load I found 12 spots where a newline had crept in.  The fix
is to just join up the lines so that every line starts with EN.

For myself I generally take the EN.dat file then (in Linux) before I
attempt to load it into the database run dos2unix over it followed by
'iconv -c -t utf8'.  After you run iconv over it you'll still want to
run sed over it to remove any \ that are in there 'cat EN.dat | sed
's/\\//g' > EN.dat.fixed'.

Dave


-- 
***********************************************************
David Langenberg
Network Based Services
The University of Chicago
***********************************************************