Search found 109 matches

by hpaulsen
Thu Oct 29, 2009 3:44 pm
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

How do you limit the list of hams to a single ward or stake? (Or are you?) For example, here in Layton, UT there are 2 zip codes to search with, but 11 stakes with over 100 wards and branches. I don't. I'm using zipcodes. I spent some time creating a geocoding service based on Census 2009 data so t...
by hpaulsen
Thu Oct 29, 2009 2:51 pm
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

I have not looked at the database, but if the Group Code is A, B, C, or D, then it is an indication of the level of qualification of the licensee, Extra, Advanced, General, or Novice. The values in the Group Code field are indeed A, B, C, or D. However, there is also an Operator Class field which h...
by hpaulsen
Thu Oct 29, 2009 9:30 am
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

This is the page where you can download the FCC ULS databases either weekly or a daily update of them. Thanks. This is actually what I was using, since the FCC doesn't have a programmatic API. That's why it broke when my server decided to change the MySQL hosting server. (Unfortunately, it adds sig...
by hpaulsen
Mon Oct 26, 2009 1:57 pm
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

RussellHltn wrote:How are you accessing the information? I went to http://wireless2.fcc.gov/UlsApp/UlsSearch/results.jsp and I see "status".


Well, I feel foolish - I was working from the "application" data by mistake. I'll get back to work on it....
by hpaulsen
Mon Oct 26, 2009 6:46 am
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

Although my server is running moderately smoothly (though slowly), I have discovered what I believe to be a critical glitch in the official FCC license database - the "License Status" field (of HD.dat) is no longer populated. This field shows whether a license has expired, was terminated, or is stil...
by hpaulsen
Mon Oct 19, 2009 7:25 am
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

Can you be more specific regarding how the HAM reports will be affected? I assume that the HAM reports won't be available until the SQL issue is resolved. Do I also assume that everyone who's currently using WardMap for HAM reports would have to update their program once the sql problem is fixed? T...
by hpaulsen
Mon Oct 19, 2009 5:26 am
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

Alas, that is the case. My web host had promised that their update would not affect the sql server, but it did, so I have to change all my db references. Unfortunately, I can't yet due to other maintenance issues.

Note that this sql server problem will affect WardMap's HAM information, as well.
by hpaulsen
Thu Oct 15, 2009 5:06 am
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

I've tracked down the major problem with the membership.csv file not being mapped. It was related to the phone number fields, of which there are two. Both fields had additional text after the phone number; (Cell, Home, Work). That should not be the case. I'm not doing any type checking on the phone...
by hpaulsen
Wed Oct 14, 2009 10:11 pm
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

The message "Address could not be accurately placed." is not there. All addresses are listed however they're all in parenthesis (xxxxxx). I would expect a few address errors, but the entire 80 member database is a bit unexpected. And what happens if you select one of the offending addresses, then c...
by hpaulsen
Wed Oct 14, 2009 5:17 pm
Forum: General Clerk Discussions
Topic: Another mapping program
Replies: 81
Views: 20681

But one thing to check is whether there is a "Preferred Name" field in Membership.csv. If the unit has "Use Full Names" selected under the MLS System Options at the time the export is taken, the "Preferred Name" column will be absent entirely and all the other columns will be offset by one position...

Go to advanced search