-
Notifications
You must be signed in to change notification settings - Fork 0
/
qso_loc.yml
171 lines (168 loc) · 5.93 KB
/
qso_loc.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
title: QSO search by location
source: KD0FNR QSO log
source_url: https://github.com/hcarter333/rm-rbn-history/blob/482acf6ca68c4b612c5884bd995e92d8b67ac6d3/rm_rnb_history_pres.csv
about: rm-rbn-history
about_url: https://github.com/hcarter333/rm-rbn-history
extra_js_urls:
- https://www.gstatic.com/charts/loader.js
plugins:
datasette-media:
thumbnail:
sql: |-
select path as filepath, 200 as resize_height from photo_path where uuid=:key
photo:
sql: |-
select path as filepath from photo_path where uuid=:key
datasette-enrichments-gmap-geocode:
api_key:
$env: MAPS_API_KEY
datasette-enrichments-gmap-elevation:
api_key:
$env: MAPS_API_KEY
databases:
rm_toucans:
queries:
map_qsos_at_tx_from_tx:
sql: |-
select
rm_rnb_history_pres.tx_lng as longitude,
rm_rnb_history_pres.tx_lat as latitude,
rm_rnb_history_pres.timestamp,
rm_rnb_history_pres.dB,
rm_rnb_history_pres.Spotter,
rm_rnb_history_pres.QSL_link,
photo_path.path,
photo_path.uuid,
json_object(
'image',
'/-/media/thumbnail/' || uuid,
'title',
Spotter || ' de KD0FNR',
'description',
'rx_rst: ' || dB || ' timestamp: ' || rm_rnb_history_pres.timestamp
) as popup
from
rm_rnb_history_pres
LEFT JOIN photo_path ON rm_rnb_history_pres.QSL_link = photo_path.uuid
where
(db > 100 or db = 0)
and Intersects(
GeomFromGeoJSON(:freedraw),
MakePoint(
cast(longitude as float),
cast(latitude as float)
)
) = 1
order by
rm_rnb_history_pres.timestamp desc
title: Map tx side QSOs from transmitting station locations by searching drawn polygon
description_html: |-
<p>Map tx location of QSOs from transmitting station locations by searching drawn polygon around tx location
map_qsos_at_rx_from_tx:
sql: |-
select
rm_rnb_history_pres.tx_lng as longitude_t,
rm_rnb_history_pres.tx_lat as latitude_t,
rm_rnb_history_pres.rx_lng as longitude,
rm_rnb_history_pres.rx_lat as latitude,
rm_rnb_history_pres.timestamp,
rm_rnb_history_pres.dB,
rm_rnb_history_pres.Spotter,
rm_rnb_history_pres.QSL_link,
photo_path.path,
photo_path.uuid,
json_object(
'image',
'/-/media/thumbnail/' || uuid,
'title',
Spotter || ' de KD0FNR',
'description',
'rx_rst: ' || dB || ' timestamp: ' || rm_rnb_history_pres.timestamp
) as popup
from
rm_rnb_history_pres
LEFT JOIN photo_path ON rm_rnb_history_pres.QSL_link = photo_path.uuid
where
(db > 100 or db = 0)
and Intersects(
GeomFromGeoJSON(:freedraw),
MakePoint(
cast(longitude_t as float),
cast(latitude_t as float)
)
) = 1
order by
rm_rnb_history_pres.timestamp desc
title: Map rx side QSOs from transmitting station locations by searching drawn polygon
description_html: |-
<p>Map rx location of QSOs from transmitting station locations by searching drawn polygon around tx location
for_specific_rx_map_tx_locs:
sql: |-
select
rm_rnb_history_pres.tx_lng as longitude,
rm_rnb_history_pres.tx_lat as latitude,
rm_rnb_history_pres.timestamp,
rm_rnb_history_pres.dB,
rm_rnb_history_pres.Spotter,
rm_rnb_history_pres.QSL_link,
photo_path.path,
photo_path.uuid,
json_object(
'image',
'/-/media/thumbnail/' || uuid,
'title',
Spotter || ' de KD0FNR',
'description',
'rx_rst: ' || dB || ' timestamp: ' || rm_rnb_history_pres.timestamp
) as popup
from
rm_rnb_history_pres
LEFT JOIN photo_path ON rm_rnb_history_pres.QSL_link = photo_path.uuid
where
(
db > 100
or db = 0
)
and ("Spotter" like :p0)
order by
rm_rnb_history_pres.timestamp desc
title: Search for rx callsign and map tx site locations per QSO
description_html: |-
<p>Search for rx callsign and map tx site locations per QSO
build_kml_qso_map:
sql: |-
select
rm_rnb_history_pres.tx_lng as longitude,
rm_rnb_history_pres.tx_lat as latitude,
rm_rnb_history_pres.tx_lng,
rm_rnb_history_pres.tx_lat,
rm_rnb_history_pres.rx_lat,
rm_rnb_history_pres.rx_lng,
rm_rnb_history_pres.timestamp,
rm_rnb_history_pres.dB,
rm_rnb_history_pres.Spotter,
rm_rnb_history_pres.QSL_link,
photo_path.path,
photo_path.uuid,
json_object(
'image',
'/-/media/thumbnail/' || uuid,
'title',
Spotter || ' de KD0FNR',
'description',
'rx_rst: ' || dB || ' timestamp: ' || rm_rnb_history_pres.timestamp
) as popup
from
rm_rnb_history_pres
LEFT JOIN photo_path ON rm_rnb_history_pres.QSL_link = photo_path.uuid
where
(
db > 100
or db = 0
)
and ("Spotter" like :p0)
order by
rm_rnb_history_pres.timestamp desc
title: Build KML of QSOs
description_html: |-
<p>Downloads a KML map of the selected QSOs