A project manipulating historic wspr spots to produce interesting statistics and graphs
To run the project locally without tomcat run:
mvn appengine:devserver
Alternatively a WAR file can be produced using
mvn clean package
Data can be loaded in to mysql directly using the following SQL statement:
load data concurrent local infile 'wsprspots-2017-01.csv' replace into table wsprDB.wsprspot fields terminated by ',' (spotid,@spot,reporter,reporters_Locator,snr,frequency,callsign,tx_Locator,tx_power,drift,distance,azimuth,band,version,code) set spot_time=from_unixtime(@spot);