Dupes suddenly not zero anymore

Rob Robinett


---------- Forwarded message ---------
From: Phil <phil@...>
Date: Fri, Oct 29, 2021 at 3:38 PM
Subject: Re: Dupes suddenly not zero anymore
To: Rob Robinett <rob@...>
CC: John Huggins <john.huggins.ee@...>, <wsprdaemon@groups.io>

Hi Rob, John.

All the 60m data we get from WSPRnet's API for the 60m band is a mixture of  5.2Mhz and 5.3MHz spots.

Thus Arne's db  can only be queried on the basis of  band = 5  and the WD database where wd_band = '60' and both dbs return a mixture of 5.2Mhz and 5.3MHz spots.

There is a solution using advanced search based on frequency.

For wsprd.vk7jj.com   (accessing the WD Postgres db) you should select 60m from the band menu and then use either

and "MHz" < '5.3'    or    and "MHz" > '5.3'   as per the screen shot below.

For wspr.rocks (accessing Arne's ClickHouse db)  the syntax is different

and frequency < '5300000'     or    and frequency > '5300000' 

The same works for the 4m band or for different segments of the 2m band or for 27MHz, though in those cases the band menu should be set to "all bands".

The queries can be combined, eg for 70MHz  the Spanish allocation is 70.150 to 70.200   ref.  https://www.wsprnet.org/drupal/node/4836

and frequency > '70100000' 
and frequency < '70200000

Regards Phil.

On 30 Oct 2021, at 1:01 am, Rob Robinett <rob@...> wrote:

Hi John,

Yours is a common question, so I'm including the WD group in my response.

There are some stations  in the UK which transmit in two 60M channels at the same time.  WD treats the 60Mand 60eu bands as separate and doesn't (I think appropriately) reject one of them as a duplicate, so both are uploaded to wsprnet.org.

However Phil has only one column for the 60M band, so he can only treat those two spots as duplicates.   I have forgotten how I was previously able to find and display those duplicates on wspr.rocks.  Perhaps Phil can remind us.

Since only UK and perhaps some EU stations are authorized to transmit WSPR on 60M, only rx stations in Europe and the US East Coast like you, KD2OM and WA2TP report those phantom dups.




On Thu, Oct 28, 2021 at 6:48 AM John Huggins <john.huggins.ee@...> wrote:
Hi Rob,

While watching wspr.rocks, I, KX4O, seem to now be reporting some dupes...

<Screen Shot 2021-10-28 at 9.38.56 AM.png>

This has always been zero and I always figured my one instance of wsprdaemon was doing a good job of preventing dupes.

Then again, what do I know right?

This all began when I added the preamplifier so maybe I'm simply seeing better results.

Hmmm, now that I think of it, perhaps it's my recent changing of the config to include both 60 and 60eu.

I mention this because I sure don't want to upset the apple cart with induction into the "Rank of Shame" mentioned below.

<Screen Shot 2021-10-28 at 9.45.28 AM.png>

My guess is this is all fine, but who better to ask than you right?

John, kx4o

Rob Robinett
mobile: +1 650 218 8896

Rob Robinett
mobile: +1 650 218 8896

Join wsprdaemon@groups.io to automatically receive all group messages.