[OSM-talk] Selecting cycleways

[Martin Koppenhoefer]

2009/8/17 Rahkonen Jukka <Jukka.Rahkonen at mmmtike.fi>:
> I would like to render a map that highlights all the cycleways. Could
> the tagging
> specialists on the list check if this query would give me what I want
> and correct if there is something wrong or missing?
>
> WHERE highway=cycleway
> OR highway=footway AND
>   (bicycle=yes OR bicycle=designated OR bicycle=permissive)
> OR highway=path AND
>   (bicycle=yes OR bicycle=designated OR bicycle=permissive)
> OR highway=briddleway AND
>   (bicycle=yes OR bicycle=designated OR bicycle=permissive)
> OR highway is not null AND cycleway is not null
> #I cannot handle cycleway=opposite_lane or left/right thing in
> #rendering yet so I do not care
>
> Should I add also 'OR bicycle=official'?

yes, if you want all of them I'd recommend to (maybe depends on the
area in which you're mapping).
I'd also have a look at tagwatch searching for "cycle" to see all the
possible variations.

I'm not a programmer but it seems to me that you're missing same
parenthesis, e.g.
where highway=cycleway
or (highway=footway and (x1 or x2 or x3))
or (path and cycleway)
or ...

cheers,
Martin