Filtering data by AZIMUTH *and* DISTANCE - seeking your feedback

Gwyn Griffiths

Hi Curt
Your idea is not a million miles from a Grafana Dashboard I have available via the site.

I've attached a screenshot with example 'graphs' below. One can choose how many days to show - time is along the x axis, here 4 days.
Range is along the Y axis and the color represents number of spots in 'bins' that are 20 minutes in time and 200 km in range. One can select two bands and a reception location by 4-character grid, in this case 40 m top and 20 m bottom and IO90 (UK)  and one sets the direction (heading) at the receiver, and the 'beamwidth', here 275˚ with a 30˚ beamwidth, which from IO90 covers North America. The resolution in this plot does not do justice to the data.

Information on the Grafana Dashboards is at
However ... because of quantity of data etc. these plots using the Timescale database can take minutes to render. I am in the process of converting to use Clickhouse, but not done this one yet. I can prioritise if of interest to you.

Gwyn G3ZIL

Curt K7ZOO

Following some coaching from VK7JJ I'm attaching an answer to my question.  de K7ZOO

Curt K7ZOO

.....seeking feedback on this idea from a broad audience!

In a month or so I'd like to give a talk to a group here in Arizona, a group of DX'rs who haven't used WSPR to study propagation.  They have keen interest in contacting specific countries, of course...  so I think it might be very interesting if they could filter data as such:

a) FROM    a specific grid (in my case DM42 in southwestern United States / Arizona)
 b) TO         between a range of azimuthal angles
 c) TO          between a range of distances

In this manner, one could easily see when a specific band was open to a (roughly) rectangular section across the globe.  Honestly, I think it could be really cool to specify a rectangle of interest.  As an example, around Japan: and know when 15 meters was open to that country.  See the plots below as an example.

Is there a SQL command anyone could recommend?  (I really like VK7JJ's tool; in it one can use SQL; I reached out to him as well.  I confess to knowing nothing about SQL, though).

If you are developing analysis tools for WSPR data, or if you are consuming the data, I'm really curious to hear what you think about this filter idea!

Have a good day,

Curt / K7ZOO
University of Arizona Radio Station Manager, K7UAZ