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 2226 114 1170
AL 0 11381 251 628
AP 0 2 120 10
AR 0 7302 128 701
AS 0 0 4 16
AZ 0 19098 289 1885
CA 0 97268 911 9568
CO 0 16942 224 1309
CT 0 7338 45 320
DC 0 495 1 25
DE 0 1737 8 73
FL 0 41305 248 1874
GA 0 17621 566 947
GU 0 3 137 134
HI 0 2892 123 963
IA 0 6130 122 275
ID 0 7738 260 1030
IL 0 19308 326 739
IN 0 14829 313 538
KS 0 6985 85 370
KY 0 8662 415 535
LA 0 5829 115 401
MA 0 13065 30 789
MD 0 10867 53 406
ME 0 4060 36 546
MI 0 20349 432 704
MN 0 11251 83 399
MO 0 13927 833 758
MP 0 2 60 160
MS 0 4718 343 370
MT 0 3191 54 699
NC 0 20135 156 1363
ND 0 1423 48 137
NE 0 3569 93 183
NH 0 5059 45 502
NJ 0 13289 135 535
NM 0 5641 132 915
NV 0 7260 123 828
NY 0 26085 163 1644
OH 0 27214 328 796
OK 0 8161 996 822
OR 0 17950 201 2275
PA 0 23203 439 853
PR 0 1120 2422 1252
RI 0 1898 5 81
SC 0 9239 207 495
SD 0 1758 39 138
TN 0 17324 334 881
TX 0 49990 692 3495
UT 0 16473 244 913
VA 0 19303 113 1159
VI 0 4 122 138
VT 0 1840 25 273
WA 0 30554 337 3475
WI 0 10832 150 394
WV 0 5123 434 819
WY 0 1627 47 383
Totals 0 702595 14759 53091