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 2225 122 1192
AL 0 11384 292 629
AP 0 2 113 11
AR 0 7312 157 717
AS 0 0 4 16
AZ 0 18924 269 1896
CA 0 97265 983 9677
CO 0 16674 234 1320
CT 0 7364 46 319
DC 0 504 1 27
DE 0 1730 11 75
FL 0 41325 289 1890
GA 0 17547 592 960
GU 0 3 138 135
HI 0 2925 137 961
IA 0 6128 119 275
ID 0 7591 252 1008
IL 0 19445 362 729
IN 0 14827 334 538
KS 0 7042 92 391
KY 0 8652 408 547
LA 0 5818 151 421
MA 0 13062 33 804
MD 0 10894 61 410
ME 0 4039 39 542
MI 0 20382 451 701
MN 0 11322 114 397
MO 0 13927 861 754
MP 0 1 62 167
MS 0 4736 348 376
MT 0 3160 56 700
NC 0 19944 200 1370
ND 0 1429 50 142
NE 0 3589 97 184
NH 0 5046 52 500
NJ 0 13367 146 540
NM 0 5717 146 939
NV 0 7125 122 844
NY 0 26264 193 1647
OH 0 27347 375 803
OK 0 8231 1030 844
OR 0 17749 199 2282
PA 0 23279 513 852
PR 0 1067 2447 1261
RI 0 1894 7 83
SC 0 9179 213 508
SD 0 1755 38 136
TN 0 17241 335 880
TX 0 49689 1150 3536
UT 0 16262 269 912
VA 0 19094 139 1135
VI 0 4 119 132
VT 0 1825 31 275
WA 0 30338 414 3496
WI 0 9879 1129 393
WV 0 5051 565 838
WY 0 1600 48 387
Totals 0 700175 17158 53504