NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

1
1

Hi -

I'm looking for help on crafting a query on Overpass Turbo. I'm asking for help because I think the query is one which if I get it right will be of real use to people. I want to look at cycle routes, and access barriers (for wheelchair use). I'm interested in barriers to entry/exit to the route, not just barriers actually on the route.

I've made an attempt at this already: http://overpass-turbo.eu/s/gaR

There was some substantial guesswork involved, and any Overpass expert will quickly see what's wrong with this I'm sure. It works, but not particularly well. I see the issues as problems in styling - but I'm assuming that the problems are actually because of my very limited understanding when it comes to recursion and combining queries.

Tips would be appreciated - and if anyone feels like crafting the query properly I'll not complain either. Many thanks in advance.

Thanks Rostranimin

asked 12 May '16, 13:09

Rostranimin's gravatar image

Rostranimin
2453412
accept rate: 0%

1

I read your question a couple of times now. Unfortunately I still couldn't figure out, what you're trying to achieve.

Could you explain in simple words, what problem you want to solve? Please don't think about any solutions yet, let alone any Overpass queries, only tell us about the real world problem you had in mind.

In particular, I didn't get what you mean by "barriers to entry/exit to the route" and in what way they are relevant to your problem. Can you provide some illustrative example, maybe even a picture or something?

(12 May '16, 16:40) mmd
2

Hi mmd. Sorry if I wasn't clear. The existing Overpass query is probably the quickest way to explain as it's close to what I want, but not very good (styling doesn't work properly for a start).

I want to use Openstreetmap to look for access barriers (related to disability) around cycle routes (i.e. routes mapped by relation). I want to find steps, bollards, gates, and cycle barriers (cycle_barrier) on the actual route, but preferably also beside it.

I'd like to display this on a map to the public.

I want to do this to answer a question I've been asked about a particular cycle route - so I'm proposing to provide a link to a pre-written Overpass-turbo query rather than trying to set up anything more long-term.... although longer term solutions would be interesting too.

I'm keen to use mapcss to give a basic style to the output from Overpass-turbo.

I'd like to set up the query so that the results are as easy to interpret as possible for a new user (so clicking on a displayed point shows the background data).

Thanks for any ideas on this.

(15 May '16, 12:58) Rostranimin

Thanks for your detailed explanations! We'll start with fixing the query, once that is done, we can continue styling the results.

I've changed your query in the following ways:

  • Cycling network is only returned for the bbox selected, instead of the whole cycling network, which happens to have a small portion within your bbox. This should highly reduce the amount of data returned.
  • Fixed the query part for barriers to properly take regular expressions into account ("~" operator instead of "=")
  • Instead of returning all barriers in your current bbox, I changed to query to only return barriers and steps within close proximity of the cycling network ways (up to 5 meters). This should reduce the number of non-relevant barriers.
  • To restrict the output to a certain cycling route, simply add an additional [ref=...] to the relation part of the query, like in the following example: relation["route"="bicycle"]["network"="ncn"][ref="62"]

[see query in overpass turbo, can't copy it here, as it gets completely mangled by the help site]

overpass turbo link: http://overpass-turbo.eu/s/gfb

Note: it is important to not show small features as POI in overpass turbo, otherwise the map will be cluttered with lots of irrelevant details. That's in the Menu underneath Settings -> Map -> Don't display small features as POIs. Enable this setting by clicking on it.

Regarding the styling:

  • highway=crossing etc. is currently shown on the map. Not sure what you want to do with those node on the cycling way, which already have some (unrelated) tags. Assuming you don't want to show those on the map, you could use the following query as a starting point: http://overpass-turbo.eu/s/gfe
permanent link

answered 16 May '16, 10:37

mmd's gravatar image

mmd
5.7k15388
accept rate: 37%

edited 16 May '16, 11:08

1

Thank you. I'll need to take a little while to read through these to understand them, but they certainly seem to do the job. These could be really useful to a number of people for real, and it'll be relatively easy for me to work forward with these as a basis (for instance selecting a particular cycle route just as you suggest). I couldn't have done this without help... too many separate ideas to juggle.

(16 May '16, 22:07) Rostranimin

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×483
×228
×85
×14
×12

question asked: 12 May '16, 13:09

question was seen: 4,855 times

last updated: 16 May '16, 22:07

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum