Differences

This shows you the differences between two versions of the page.

--- wspr_gis [2022/11/02 14:03] – created millerjs
+++ wspr_gis [2024/11/14 02:30] (current) – external edit 127.0.0.1
@@ Line 3: / Line 3: @@
 Bringing WSPR data into the world of GIS!
+===== Workflow =====
+  - Download & decompress zip from - http://www.wsprnet.org/drupal/downloads
+  - Pull call into new CSV <code>cat wsprspots*.csv | grep call > call_wsprspots.csv</code>
+  - Add fields to top of csv <code>spotid,timestamp,reporter,reportergrid,snr,frequency,call,callgrid,power,drift,distance,azimuth,band,version,code</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