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