Amateur radio license map info

Welcome to my little spare time project. I've been working on this on and off for about a year as time and motivation allows.

This is more of an excuse to have some fun with Maps and Geocoding than anything else but it hopefully provides something interesting to play with. "Geocoding" means to convert physical addresses into longitude and latitude coordinates. Behind the scenes, this site has been slowly geocoding all active amateur radio addresses in the FCC license data. The FCC data includes all licenses which have a status of "active".

I've found it an interesting project with lots of little challenges. Some of this is because of the wide variation of population and therefore "ham density" throughout the country. I've had to balance that with performance issues both at the database query level and practical limitations of Google Maps. The data is also kind of messy with multiple licensees at one address and multiple addresses at the same location. This last issue is mostly due to spelling variations. In general, one marker appears on the map for each unique latitude / longitude point.

The performance / data quantity compromise I've come up with is that it searches within a 20 mile radius of the map center and has a limit of 200 location markers. The results are sorted by distance which means that the circle is complete until it hits the 200 markers. I haven't found a gridsquare that has more than 200 so if you center on a gridsquare, I think we always get all in that square.

The geocoding has been done over a long period using a combination of  Geocodio and Nominatim / OpenStreetMap. When there are no new addresses to geocode, it retries addresses that have previously failed. These sometimes succeed because of improved geocoding data.

A weekly import from the FCC usually happens late on Sunday, eastern time. Only those stations with a status of "active" are retained. About 1000 addresses are added and deleted each week. Geocoding the new addresses is usually complete by early Monday

Of course some addresses are PO Boxes and other mailing services. Addresses starting with "PO Box" are simply excluded. Also, many licensees are not active in the hobby. Be that as it may, it can be fun to play with the Street View feature of the maps to look for antennas.

Although I've only considered data from the USA, it's written in a generalized way so it can handle data from other countries but I'm not aware of any other countries who make their data publicly available.

It's built with Drupal 8. The code is all on Github here, here and here.

Anyway… I think it's pretty much "done" in terms of new features unless someone comes up with a good idea. I've probably spent way too much spare time on this already and it's time to get my antenna up again and do some QRP construction. Feedback is welcome. The easiest way is by email to tetranz (at) gmail.com

73
Ross  KT1F

Geocode report

StateNewSuccessfulNot FoundPO Box
AK 0 2212 115 1206
AL 0 11374 297 631
AP 0 3 115 11
AR 0 7309 161 724
AS 0 0 4 17
AZ 0 18897 264 1889
CA 0 97176 980 9695
CO 0 16605 241 1323
CT 0 7373 47 322
DC 0 499 2 26
DE 0 1730 11 74
FL 0 41177 278 1891
GA 0 17518 593 965
GU 0 3 128 129
HI 0 2936 140 961
IA 0 6111 124 278
ID 0 7566 251 1012
IL 0 19469 362 731
IN 0 14822 340 537
KS 0 7043 100 391
KY 0 8617 417 547
LA 0 5836 153 421
MA 0 13050 33 808
MD 0 10886 59 413
ME 0 4049 39 548
MI 0 20399 453 697
MN 0 11299 122 404
MO 0 13896 881 756
MP 0 1 63 167
MS 0 4756 349 380
MT 0 3147 57 703
NC 0 19909 195 1367
ND 0 1423 54 139
NE 0 3596 97 186
NH 0 5035 51 499
NJ 0 13414 149 536
NM 0 5661 182 935
NV 0 7098 126 840
NY 0 26268 204 1655
OH 0 27368 381 803
OK 0 8227 1032 849
OR 0 17716 196 2280
PA 0 23326 512 855
PR 0 1035 2450 1255
RI 0 1901 7 82
SC 0 9190 211 502
SD 0 1759 37 136
TN 0 17161 334 885
TX 0 49637 1159 3541
UT 0 16221 277 912
VA 0 19033 164 1129
VI 0 4 119 131
VT 0 1829 32 276
WA 0 30267 417 3488
WI 0 9852 1146 389
WV 0 5046 577 838
WY 0 1592 48 387
Totals 0 699327 17336 53552