====== WSPR GIS ====== Bringing WSPR data into the world of GIS! ===== Workflow ===== - Download & decompress zip from - http://www.wsprnet.org/drupal/downloads - Pull call into new CSV cat wsprspots*.csv | grep call > call_wsprspots.csv - Add fields to top of csv spotid,timestamp,reporter,reportergrid,snr,frequency,call,callgrid,power,drift,distance,azimuth,band,version,code - Geocode 2x, once for CallGrid, once for ReporterGrid. Outputs are reporterIsMe and callerIsMe, respectively. - Strip geocoder fields - Add i_am field to both. - Field calculate: reporterIsMe.i_am = reporter ; callerIsMe.i_am = caller - Merge reporterIsMe and callerIsMe - Add fields for: timedate, time, date, day_of_week, time_of_day, band - - timdate - calculate from epoch time: - - test