Hi,
to see what keys there are for rendering on my bicycle map, I query
the db for %cycle%:
SELECT key, count(*)
FROM (
SELECT (each(tags)).key
FROM planet_osm_line
) AS stat
WHERE key LIKE '%cycle%'
GROUP by key
ORDER by count DESC
As this is rather slow, I was trying to take the %cycle% to the inner
query. But how can I trigger the keys in 'tags'? And would that be
really faster?
Thanks for any hint,
Thomas