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 2236 116 1183
AL 0 11399 263 629
AP 0 2 114 11
AR 0 7337 149 713
AS 0 0 5 16
AZ 0 19030 267 1877
CA 0 97461 961 9653
CO 0 16792 214 1325
CT 0 7368 46 322
DC 0 500 1 27
DE 0 1726 10 74
FL 0 41401 270 1890
GA 0 17602 565 955
GU 0 3 140 134
HI 0 2926 136 965
IA 0 6118 118 271
ID 0 7650 250 1022
IL 0 19367 344 726
IN 0 14829 311 540
KS 0 7012 92 378
KY 0 8669 407 545
LA 0 5824 156 412
MA 0 13065 32 797
MD 0 10902 59 405
ME 0 4051 36 545
MI 0 20380 443 698
MN 0 11318 99 399
MO 0 13966 840 753
MP 0 2 61 166
MS 0 4733 343 375
MT 0 3184 54 708
NC 0 19965 203 1369
ND 0 1433 48 140
NE 0 3596 94 182
NH 0 5061 49 501
NJ 0 13323 136 542
NM 0 5690 142 934
NV 0 7173 122 839
NY 0 26221 175 1645
OH 0 27323 334 797
OK 0 8208 1005 839
OR 0 17878 200 2291
PA 0 23275 502 853
PR 0 1115 2448 1267
RI 0 1890 7 83
SC 0 9206 209 502
SD 0 1761 42 136
TN 0 17302 322 884
TX 0 50127 735 3528
UT 0 16375 244 913
VA 0 19210 131 1150
VI 0 5 123 142
VT 0 1833 28 273
WA 0 30523 377 3499
WI 0 9887 1122 392
WV 0 5122 468 829
WY 0 1615 44 384
Totals 0 701970 16212 53428