This app is a simple point and click guide to help maximise communication by visualising current propagation.
The horizontal axis
Click any Month/Day label on the horizontal axis to zoom in to that day.
eg. clicking '10/09' would zoom to October 9th.
Go back in time
Click the 'Choose period' text to go back in time.
Spots in both directions are queried by default.
Click the text 'Choose location# 1' or 'Choose location# 2' to set a location as the transmit location.
The colours change to red and green as indicators.
Click a green label to reverse directionality.
Click a red label to cancel directionality.
Chart line Data Points
Mouse over the Band Legend on the left of the chart window to highlight each chart line and its data points.
Mouse over the data points on the chart lines to see their spot count.
Link to a Chart
The loc1 and loc2 values can be seen at the bottom of this page using your browser's 'view source' feature.
p is the period value, eg. p=30 generates a 30 day chart. p=24 generates a 24 hour chart.
v 3.1.0 Nov 13 Phil firstname.lastname@example.org
Default is [
], you can add and
clauses like [
and distance > 10000
] or [
and band = 28
The example query below is of the form used by this app.
• copy and paste it into wspr.rocks/livequeries
• in this app you can only insert extra text where the comment shows.
• ref to the wspr.rocks/livequeries/ site for more information.
formatDateTime(time, '%Y-%m-%d') as YMD,
count() as total,
countIf(band = -1) as LF,
countIf(band = 0) as MF,
countIf(band = 1) as 160m,
countIf(band = 3) as 80m,
countIf(band = 5) as 60m,
countIf(band = 7) as 40m,
countIf(band = 10) as 30m,
countIf(band = 14) as 20m,
countIf(band = 18) as 17m,
countIf(band = 21) as 15m,
countIf(band = 28) as 10m,
countIf(band = 50) as 6m
from wspr.rx where
time between today()-7 and today()
and (substring(rx_loc,1,2) in ['IO','JO'] or substring(tx_loc,1,2) in ['EN','EM'])
/* and your advanced text goes here */
group by YMD
order by YMD asc