Foundations Of Amateur Radio

Foundations of Amateur Radio Have you ever had a day when nothing you started actually got anywhere? I've had a fortnight like that. Several weeks ago I wrote a couple of articles about emergency communications and its tenuous relationship with our hobby. As a result I managed to get a week ahead of myself and started using that week to do some long overdue analysis of the WSPR or Weak Signal Propagation Reporter data set. I've started this process several times and I finally had a whole fortnight to come to grips with 6.7 billion rows of data. Spoiler alert, it hasn't happened yet. The data contains a record of every reception report uploaded to WSPRnet.org since Tuesday 11 March 2008 at 22:02 UTC. It's published in compressed comma separated value text files and after previously spending weeks of wrangling I managed to convert each one into an sqlite3 database. This wrangling was required because some amateurs used commas in their callsigns or grid squares, or backslashes, or both, and SQLite import isn't