Re: Compound Spot Filter

iain macdonnell - N6ML

If you see a spot database entry that you believe was incorrectly
included by your origin filter, right-click on it, and select "Display
spots of ... near ... in ...". That should show you all of the spots
that are included in that database entry. You will likely find that at
least one of them matches your origin criterion, but it may not be the
most recent one.


~iain / N6ML

On Tue, Mar 24, 2020 at 12:25 PM Hasan Schiers N0AN
<@Hasan> wrote:


I must be thick.

What I was looking for and finally settled on is this:

Band='6M' AND Mode='MSK144' AND ((NAE='Y') or (NAM='Y') or (NAW='Y'))

I wanted to see only spots from 6 meters and mode MSK144, and I only wanted to see them if they were heard (and subsequently spotted) in North America.

I have no interest in someone in the UK telling me they are seeing active stations in Germany on 6 meters.

If a station is not being heard anywhere in the USA, I'm not going to hear them, so why do I want them cluttering up my screen?

Am I somehow misinterpreting what the above filter does?

After a little more playing, I came up with the following Filter that eliminates mode, but collapses two bands which tend to show similar Es openings.

((Band='10M') or (Band='6M')) AND ((NAE='Y') or (NAM='Y') or (NAW='Y'))

Again, I'm interpreting this to say,

On either band, if someone from North America has heard any station, any mode, show it to me. If you are not from North America, leave me alone.

This appears to answer the question: Is 6 meters open from anywhere in the world to North America? .

Is the filter, as I have defined it doing what I asked it to do, or do I have a syntax error of some sort?

With respect to your other point:

+ For Es propagation on 6 meters, specifying a maximum distance between your QTH and the closest spotting station works best. I've never experienced an F2 opening on 6 meter.

This doesn't reflect what band conditions are actually like on 6 meters nearly every summer, at least in Missouri, Iowa, Texas, Colorado, etc:

Multi-Hop Es to Japan via FT8 is very common on 6 meters in the summer. Two years in a row, I have worked more than 30 JA stations on 6 meter multi-hop Es in a single day. (2018 and 2019)

I also worked EU and Africa both years on FT8, 6 meters.,..and it was clearly multi-hop sporadic E. The keys are mode, power and antennas. (in other words, EIRP)

All were on FT8, all involved a minimum of 500w out and all were using antennas with no less than 10 dBd gain.

Many USA operators experienced the same openings and while they were highly focused, they included Missouri to Japan and Texas to Japan as well.

And...all were spotted on PSKRreporter by stations from Ohio to Arizona. There was no F2 at the time, but there were E clouds all over the place.

It looks to me like SC can do the same thing with the filter example I used above:

((Band='10M') or (Band='6M')) AND ((NAE='Y') or (NAM='Y') or (NAW='Y'))

If those JAs show up this summer, this filter will spot them, unless I'm completely confused. When I ran this filter this morning it showed:

All the 6m MSK144 spots from my local WSJT-X
All the 6m MSK144 spots from N6WS
All the 6m FT8 Spots from N6WS
and a single 10m FT8 from N6WS

All those spots originated from North America.

Do I still have it wrong?

73, N0AN

On Tue, Mar 24, 2020 at 1:17 PM Dave AA6YQ <@AA6YQ> wrote:

+ AA6YQ comments below

I have an SQL filter set for Mode='MSK144'

and it works fine, but it is showing Spots from EU which are not useful on 6 meters.

I tried: Mode='MSK144' AND Origin="NA-M"

...and that didn't work, spots were found.

How do I create an SQL Filter that shows only spots for MSK144 and Spots originating from USA, Canada and Mexico? (for example)

Or, I could filter by spot source, since my spots for 6m MSK144 are generated by my copy of WSJT-X.

I know I could use the Origin and Mode buttons, but I wanted a one click solution.

+ SpotCollector displays entries for active DX stations, not spots. An active DX station can be spotted from many different locations. When you filter the Spot Database Display with


+ you are saying "show me all active DX stations that have been spotted from the middle of North America". You are not saying "show me all active DX stations that have been spotted from the middle of North America and have not been spotted from anywhere else on the planet"; there is an SQL expression that would accomplish this, but it would not be useful for DXing.

+ There are several good techniques for hiding the entries of active DX stations that you probably can't hear. These techniques are described here:


+ For Es propagation on 6 meters, specifying a maximum distance between your QTH and the closest spotting station works best. I've never experienced an F2 opening on 6 meters, and have never used a meteor scatter mode on 6 meters, so I can't recommend a specific technique for those; the above article presents the available techniques.

+ If you want to "roll your own" SQL filters for this purpose, study the following Spot Database Fields in



- Distance




- SPProb, LPProb

- ActualSNR, ActualSNRMin, ActualSNRMax

+ If you discover one or more useful new techniques, please share them here!


Dave, AA6YQ

Join to automatically receive all group messages.