liveembed

This app is a sandbox that directs SQL queries to Arne's amazingly fast WSPR spot database at wspr.live
The demo examples are from casual testing and may be buggy and better written. Check Arne's link for more info.

=> If your query results meet wspr.rocks needs the [run in wspr.rocks] button should display them successfully.

=> These are the db column names and spot values required for queries

db columns :id, time, band, rx_sign, rx_lat, rx_lon, rx_loc, tx_sign, tx_lat, tx_lon, tx_loc, distance, azimuth, rx_azimuth, frequency, power, snr, drift, version, code

bands : -1:LF, 0:MF, 1:160m, 3:80m, 5:60m, 7:40m, 10:30m, 14:20m, 18:17m, 21:15m, 24:12m, 28:10m, 50:6m, 70:4m, 144:2m, 432:70cm, 1296:23cm

dBm:W : 0:0.001, 3:0.002, 7:0.005, 10:0.01, 13:0.02, 17:0.05, 20:0.1, 23:0.2, 27:0.5, 30:1, 33:2, 37:5, 40:10, 43:20, 47:50, 50:100, 53:200, 57:500, 60:1000W

modes : code 1 = mode 2 (WSPR2,FST4W-120), code 2 = mode 15 (FST4W-900), code 4 = mode 5 (FST4W-300), code 8 = mode 30 (FST4W-1800)

• call signs must be uppercase single quoted 'VK7DIK' See the demos for more.
• power is in dBm (see conversion above). Distance is in kilometres. id is WSPRnet's unique spotnum.
• Arne's WSPR info includes the db field details, bands and mode mappings @ wspr.live
• The db vendor is ClickHouse, see their online reference

=> Compose your query below demos save... clear run query here run query in wspr.rocks

->

Database query responses and SQL syntax errors are displayed here. Click the table column labels to sort. - save your own queries to the Saved list. - saving an item using an existing name replaces the original. The Backup and Restore buttons are in the header of the dialog - the data is saved in JSON text format. - there are free JSON text editors online.