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.
Directionality
Spots in both directions are queried by default.
Click the text 'Choose callsign' or 'Choose location' to set either one as the transmitter.
The colours change to red and green as indicators.
Click a green label to reverse direction.
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.
Personalise the callsign menu
Open the [
menu editor
]
The changes are saved in Local Storage within your browser.
v 4.0.0 Nov 26 Phil vk7jj at me dot com
Advanced search
Default is [
clear
], you can add
and clauses like [
and distance > 10000
] or [
and band = 28
] etc
[more]
The example query below is of the form used by this app.
• copy and paste it into
wspr.rocks/livequeries for testing.
• in this app you can only insert extra text where the comment shows.
• ref to the wspr.rocks/livequeries/ site for more information.
select
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 match(tx_sign,'^[Q0]')=0
/* and your advanced text goes here */
group by YMD
order by YMD asc
limit 1000