The creator of WSPR Rocks, Phill VK7JJ has been very helpful and has helped show me how to access WSPR spots back to 2008 using the SQL feature.
Perhaps it is best I share from the email he sent me. Clearly, you will have to adapt the query to suite your needs, but you get the idea.
" 1. click the SQL tab in http://wspr.rocks and copy and paste the redish text below into the upper editing panel on the SQL page
2. click the [run query here] button to test your query. If it returns a bunch of spots rather than an error message that's good, so click the [run query in wspr.rocks] button to execute it in wspr.rocks.
The time, callsign and band criteria should just about be self explanatory, adjust the times to suit but retain the exact format.
If you end up exceeding the 5,000 spot display limit then let me know. If you want to get rid of the false decode of OH3FR then include this line in the query: and rx_sign != 'OH3FR'
73 Phil
select * from wspr.rx where
time between '2023-12-01 00:00:00' and '2024-01-24 00:00:00'
and tx_sign = 'G3XBM'
and band = 28
order by time desc "
3 comments:
Tnx for this Roger, 73 Bas
Just a notice that the last " in your query should be erased. 73, Bas
Hi Bas
I think I shall leave it as it is as it shows people how to get rid of false decodes.
Post a Comment