[OSM-talk] Selecting cycleways

[Rahkonen Jukka]

 Tobias Knerr wrote:
> 
> Martin Koppenhoefer wrote:
> Rahkonen Jukka wrote:
> >> OR highway=briddleway AND
> 
> "bridleway", but I guess that's just a typo.
> 
> >>   (bicycle=yes OR bicycle=designated OR bicycle=permissive) OR 
> >> highway is not null AND cycleway is not null
> 
> You might want check for cycleway=no here, there are a few 
> hundreds of them.
> 
> > I'd also have a look at tagwatch searching for "cycle" to 
> see all the 
> > possible variations.
> 
> I wouldn't do this. Just correct those "variations" (aka 
> errors) in the data if you care about them.
> 
> > I'm not a programmer but it seems to me that you're missing same 
> > parenthesis
> 
> Assuming AND binds more strongly than OR, the query seems correct.
> 
> Tobias Knerr

Thanks to both of you. I did not even try to write totally correct SQL,
I can handle it if I understand what variations I must search for. I
believe I have to simplify the final rendering step by creating an own
column to the database to collect the cycleways or otherwise the
on-demand queries are getting too complicated for my WMS server.

-Jukka-