how to use more view filters in WSPRnet database spot query

6 posts / 0 new
Last post
DD5XX's picture
Last seen: 3 months 1 week ago
Joined: 2017/10/06 - 21:31
how to use more view filters in WSPRnet database spot query

Hello WSPR friends,

we have some standard filters that are available on database spot query function such as:

- Band
* dropdown fields = LF, MF, 160m, 80m, 60m, 40m, 30m, 20m, 17m, 15m, 12m, 10m, 6m, 4m, 2m, 70cm, 23cm

- Count
* input field integer values from 1 to 1000

- Call
* input field alphanumeric

- Reporter
* input field alphanumeric

- In Last
* dropdown fields = Hour, 12 Hours, 24 Hours, Week, Two Weeks

- Sorty By
* dropdown fields = Timestamp, Call, Reporter, Frequency, SNR, Power, Distance, Grid, km/Watt

- Checkboxes on = Reverse, Unique, Exclude Special Callsigns

For long-term and deeper analyzing purposes we often need more filter options and we are curious if there are any available for free?

Some examples: we want to use something like

- show us only those spots from calls whose power was 100mW between 500mW
- show us only those spots from calls who used power=200mW
- show us only those spots from reporters from my continent (or from my country, or which are max. 100km distant from me)
- do combinations like "show me all spots on 17m AND whose (power was not 500mW OR not 1W) AND callsign contains number 0

frankly said, there are so much possibilities and we often face issues when analyzing huge spot data. It's also cumbersome to get to older spot data because the database allows only a certain window frame (max. 2 weeks). I wonder at all if and how you can extend such filtering options without the need of programming something on your own.

Is anyone aware of a helpful solution to this? Looking forward to hear your comments. any thoughts?

Saki, DD5XX