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
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
|
# web/lib/api/v4/tag.rb
class Taginfo < Sinatra::Base
api(4, 'tag/combinations', {
:description => 'Find keys and tags that are used together with a given tag.',
:parameters => {
:key => 'Tag key (required).',
:value => 'Tag value (required).',
:query => 'Only show results where the other_key or other_value matches this query (substring match, optional).'
},
:paging => :optional,
:filter => {
:all => { :doc => 'No filter.' },
:nodes => { :doc => 'Only values on tags used on nodes.' },
:ways => { :doc => 'Only values on tags used on ways.' },
:relations => { :doc => 'Only values on tags used on relations.' }
},
:sort => %w( together_count other_tag from_fraction ),
:result => paging_results([
[:other_key, :STRING, 'Other key.'],
[:other_value, :STRING, 'Other value (may be empty).'],
[:together_count, :INT, 'Number of objects that have both this tag and other key (or tag).'],
[:to_fraction, :FLOAT, 'Fraction of objects with this tag that also have the other key (or tag).'],
[:from_fraction, :FLOAT, 'Fraction of objects with other key (or tag) that also have this tag.']
]),
:example => { :key => 'highway', :value => 'residential', :page => 1, :rp => 10, :sortname => 'together_count', :sortorder => 'desc' },
:ui => '/tags/highway=residential#combinations'
}) do
key = params[:key]
value = params[:value]
filter_type = get_filter()
if @ap.sortname == 'to_count'
@ap.sortname = ['together_count']
elsif @ap.sortname == 'from_count'
@ap.sortname = ['from_fraction', 'together_count', 'other_key', 'other_value']
elsif @ap.sortname == 'other_tag'
@ap.sortname = ['other_key', 'other_value']
end
cq = @db.count('db.tag_combinations')
total = (params[:query].to_s != '' ?
cq.condition("(key1=? AND value1=? AND (key2 LIKE '%' || ? || '%' OR value2 LIKE '%' || ? || '%')) OR (key2=? AND value2=? AND (key1 LIKE '%' || ? || '%' OR value2 LIKE '%' || ? || '%'))",
key, value, params[:query], params[:query], key, value, params[:query], params[:query]) :
cq.condition('(key1=? AND value1=?) OR (key2=? AND value2=?)', key, value, key, value)).
condition("count_#{filter_type} > 0").
get_first_value().to_i
has_this_key = @db.select("SELECT count_#{filter_type} FROM db.tags").
condition('key = ?', key).
condition('value = ?', value).
get_first_value()
res = (params[:query].to_s != '' ?
@db.select("SELECT p.key1 AS other_key, p.value1 AS other_value, p.count_#{filter_type} AS together_count, k.count_#{filter_type} AS other_count, CAST(p.count_#{filter_type} AS REAL) / k.count_#{filter_type} AS from_fraction FROM db.tag_combinations p, db.selected_tags k WHERE p.key1=k.skey AND p.value1=k.svalue AND k.svalue != '' AND p.key2=? AND p.value2=? AND ((p.key1 LIKE '%' || ? || '%') OR (p.value1 LIKE '%' || ? || '%')) AND p.count_#{filter_type} > 0
UNION SELECT p.key1 AS other_key, p.value1 AS other_value, p.count_#{filter_type} AS together_count, k.count_#{filter_type} AS other_count, CAST(p.count_#{filter_type} AS REAL) / k.count_#{filter_type} AS from_fraction FROM db.tag_combinations p, db.keys k WHERE p.key1=k.key AND p.value1='' AND p.key2=? AND p.value2=? AND ((p.key1 LIKE '%' || ? || '%') OR (p.value1 LIKE '%' || ? || '%')) AND p.count_#{filter_type} > 0
UNION SELECT p.key2 AS other_key, p.value2 AS other_value, p.count_#{filter_type} AS together_count, k.count_#{filter_type} AS other_count, CAST(p.count_#{filter_type} AS REAL) / k.count_#{filter_type} AS from_fraction FROM db.tag_combinations p, db.selected_tags k WHERE p.key2=k.skey AND p.value2=k.svalue AND k.svalue != '' AND p.key1=? AND p.value1=? AND ((p.key2 LIKE '%' || ? || '%') OR (p.value2 LIKE '%' || ? || '%')) AND p.count_#{filter_type} > 0
UNION SELECT p.key2 AS other_key, p.value2 AS other_value, p.count_#{filter_type} AS together_count, k.count_#{filter_type} AS other_count, CAST(p.count_#{filter_type} AS REAL) / k.count_#{filter_type} AS from_fraction FROM db.tag_combinations p, db.keys k WHERE p.key2=k.key AND p.value2='' AND p.key1=? AND p.value1=? AND ((p.key2 LIKE '%' || ? || '%') OR (p.value2 LIKE '%' || ? || '%')) AND p.count_#{filter_type} > 0", key, value, params[:query], params[:query], key, value, params[:query], params[:query], key, value, params[:query], params[:query], key, value, params[:query], params[:query]) :
@db.select("SELECT p.key1 AS other_key, p.value1 AS other_value, p.count_#{filter_type} AS together_count, k.count_#{filter_type} AS other_count, CAST(p.count_#{filter_type} AS REAL) / k.count_#{filter_type} AS from_fraction FROM db.tag_combinations p, db.selected_tags k WHERE p.key1=k.skey AND p.value1=k.svalue AND k.svalue != '' AND p.key2=? AND p.value2=? AND p.count_#{filter_type} > 0
UNION SELECT p.key1 AS other_key, '' AS other_value, p.count_#{filter_type} AS together_count, k.count_#{filter_type} AS other_count, CAST(p.count_#{filter_type} AS REAL) / k.count_#{filter_type} AS from_fraction FROM db.tag_combinations p, db.keys k WHERE p.key1=k.key AND p.value1 = '' AND p.key2=? AND p.value2=? AND p.count_#{filter_type} > 0
UNION SELECT p.key2 AS other_key, p.value2 AS other_value, p.count_#{filter_type} AS together_count, k.count_#{filter_type} AS other_count, CAST(p.count_#{filter_type} AS REAL) / k.count_#{filter_type} AS from_fraction FROM db.tag_combinations p, db.selected_tags k WHERE p.key2=k.skey AND p.value2=k.svalue AND k.svalue != '' AND p.key1=? AND p.value1=? AND p.count_#{filter_type} > 0
UNION SELECT p.key2 AS other_key, '' AS other_value, p.count_#{filter_type} AS together_count, k.count_#{filter_type} AS other_count, CAST(p.count_#{filter_type} AS REAL) / k.count_#{filter_type} AS from_fraction FROM db.tag_combinations p, db.keys k WHERE p.key2=k.key AND p.value2 = '' AND p.key1=? AND p.value1=? AND p.count_#{filter_type} > 0", key, value, key, value, key, value, key, value)).
order_by(@ap.sortname, @ap.sortorder) { |o|
o.together_count
o.other_key
o.other_value
o.from_fraction
}.
paging(@ap).
execute()
return {
:page => @ap.page,
:rp => @ap.results_per_page,
:total => total,
:url => request.url,
:data => res.map{ |row| {
:other_key => row['other_key'],
:other_value => row['other_value'],
:together_count => row['together_count'].to_i,
:to_fraction => (row['together_count'].to_f / has_this_key.to_f).round_to(4),
:from_fraction => row['from_fraction'].to_f.round_to(4)
} }
}.to_json
end
api(4, 'tag/distribution/nodes', {
:description => 'Get map with distribution of this tag in the database (nodes only). Will return empty image if there is no map available for this tag.',
:parameters => { :key => 'Tag key (required).', :value => 'Tag value (required).' },
:result => 'PNG image.',
:example => { :key => 'amenity', :value => 'post_box' },
:ui => '/tags/amenit=post_boxy#map'
}) do
key = params[:key]
value = params[:value]
content_type :png
@db.select('SELECT png FROM db.tag_distributions').
condition("object_type='n'").
condition('key = ?', key).
condition('value = ?', value).
get_first_value() ||
@db.select('SELECT png FROM db.key_distributions').
is_null('key').
get_first_value()
end
api(4, 'tag/distribution/ways', {
:description => 'Get map with distribution of this tag in the database (ways only). Will return empty image if there is no map available for this tag.',
:parameters => { :key => 'Tag key (required).', :value => 'Tag value (required).' },
:result => 'PNG image.',
:example => { :key => 'highway', :value => 'residential' },
:ui => '/tags/highway=residential#map'
}) do
key = params[:key]
value = params[:value]
content_type :png
@db.select('SELECT png FROM db.tag_distributions').
condition("object_type='w'").
condition('key = ?', key).
condition('value = ?', value).
get_first_value() ||
@db.select('SELECT png FROM db.key_distributions').
is_null('key').
get_first_value()
end
api(4, 'tag/josm/style/rules', {
:description => 'List rules and symbols for the given tag in JOSM styles.',
:parameters => {
:style => 'JOSM style (required).',
:key => 'Tag key (required).',
:value => 'Tag value (required).'
},
:paging => :optional,
:result => paging_results([
[:key, :STRING, 'Key'],
[:value, :STRING, 'Value'],
[:value_bool, :STRING, '"yes" or "no". Null if the value is not boolean.'],
[:rule, :STRING, 'JOSM style rule in XML format.'],
[:area_color, :STRING, 'Fill color for area (if area rule).'],
[:line_color, :STRING, 'Stroke color for line (if line rule).'],
[:line_width, :INT, 'Line width (if line rule).'],
[:icon, :STRING, 'Icon path (if icon rule).']
]),
:example => { :style => 'standard', :key => 'highway', :value => 'residential', :page => 1, :rp => 10 },
:ui => '/tags/highway=residential#josm'
}) do
style = params[:style]
key = params[:key]
value = params[:value]
total = @db.count('josm_style_rules').
# condition('style = ?', style).
condition('k = ?', key).
condition('v = ?', value).
get_first_value().to_i
res = @db.select('SELECT * FROM josm_style_rules').
# condition('style = ?', style).
condition('k = ?', key).
condition('v = ?', value).
order_by([:k, :v], 'ASC').
paging(@ap).
execute()
return get_josm_style_rules_result(total, res);
end
api(4, 'tag/stats', {
:description => 'Show some database statistics for given tag.',
:parameters => {
:key => 'Tag key (required).',
:value => 'Tag value (required).'
},
:result => no_paging_results([
[:type, :STRING, 'Object type ("all", "nodes", "ways", or "relations")'],
[:count, :INT, 'Number of objects with this type and tag.'],
[:count_fraction, :FLOAT, 'Number of objects in relation to all objects.']
]),
:example => { :key => 'amenity', :value => 'school' },
:ui => '/tags/amenity=school#overview'
}) do
key = params[:key]
value = params[:value]
out = []
# default values
['all', 'nodes', 'ways', 'relations'].each_with_index do |type, n|
out[n] = { :type => type, :count => 0, :count_fraction => 0.0 }
end
@db.select('SELECT * FROM db.tags').
condition('key = ? AND value = ?', key, value).
execute() do |row|
['all', 'nodes', 'ways', 'relations'].each_with_index do |type, n|
out[n] = {
:type => type,
:count => row['count_' + type].to_i,
:count_fraction => (row['count_' + type].to_f / get_total(type)).round_to(4)
}
end
end
return {
:total => 4,
:url => request.url,
:data => out
}.to_json
end
api(4, 'tag/wiki_pages', {
:description => 'Get list of wiki pages in different languages describing a tag.',
:parameters => { :key => 'Tag key (required)', :value => 'Tag value (required).' },
:paging => :no,
:result => no_paging_results([
[:lang, :STRING, 'Language code.'],
[:language, :STRING, 'Language name in its language.'],
[:language_en, :STRING, 'Language name in English.'],
[:title, :STRING, 'Wiki page title.'],
[:description, :STRING, 'Short description of tag from wiki page.'],
[:image, :HASH, 'Associated image.', [
[:title, :STRING, 'Wiki page title of associated image.' ],
[:width, :INT, 'Width of image.' ],
[:height, :INT, 'Height of image.' ],
[:mime, :STRING, 'MIME type of image.' ],
[:image_url, :STRING, 'Image URL' ],
[:thumb_url_prefix, :STRING, 'Prefix of thumbnail URL.' ],
[:thumb_url_suffix, :STRING, 'Suffix of thumbnail URL.' ]
]],
[:on_node, :BOOL, 'Is this a tag for nodes?'],
[:on_way, :BOOL, 'Is this a tag for ways?'],
[:on_area, :BOOL, 'Is this a tag for areas?'],
[:on_relation, :BOOL, 'Is this a tag for relations?'],
[:tags_implies, :ARRAY_OF_STRINGS, 'List of keys/tags implied by this tag.'],
[:tags_combination, :ARRAY_OF_STRINGS, 'List of keys/tags that can be combined with this tag.'],
[:tags_linked, :ARRAY_OF_STRINGS, 'List of keys/tags related to this tag.']
]),
:notes => 'To get the complete thumbnail image URL, concatenate <tt>thumb_url_prefix</tt>, width of image in pixels, and <tt>thumb_url_suffix</tt>. The thumbnail image width must be smaller than <tt>width</tt>, use the <tt>image_url</tt> otherwise.',
:example => { :key => 'highway', :value => 'residential' },
:ui => '/tags/highway=residential#wiki'
}) do
key = params[:key]
value = params[:value]
res = @db.execute('SELECT * FROM wikipages LEFT OUTER JOIN wiki_images USING (image) WHERE key = ? AND value = ? ORDER BY lang', key, value)
return get_wiki_result(res)
end
end
|