Overpass Turbo: Culverts Under Highways

Karl60 · 2024-09-30T16:24:22.004Z

I’m trying to write an Overpass Turbo script that finds culverts that pass under a road. More specifically, where:

The culvert way has at least the tags:
tunnel=culvert
layer=-1

and the road way has at least the tag:
highway=*

So far I’ve got this with the help of ChatGPT:

[out:json][timeout:120];

// Find all ways tagged with tunnel=culvert and level=-1 within 50km of Blairgowrie, Scotland
way(around:50000, 56.5924, -3.3405)["tunnel"="culvert"]["level"="-1"]->.culvertWays;

// Find all ways tagged with highway=* within 50km of Blairgowrie, Scotland
way(around:50000, 56.5924, -3.3405)["highway"]->.highwayWays;

// Use proximity to find highway ways near culvert ways (within 30 meters)
way.culvertWays(around.highwayWays:30)->.culvertUnderHighway;

// Output the results
(way.culvertUnderHighway; >;);
out body;

Alas, this script gives no results in Overpass Turbo.
Can anyone assist?

alan_gr · 2024-09-30T17:06:51.020Z

You correctly mention the “layer” tag, but the query uses the “level” tag which is a different thing, normally used for building floors. That alone would explain the lack of output. I haven’t checked beyond that.

PHerison · 2024-09-30T18:53:06.896Z

Keep in mind that sometimes tunnel=* might lack a layer-tag!

Rainero · 2024-10-01T08:25:01.911Z

Here is a simple query that outputs all tunnel=culvert crossing highway=* in the bounding box:
https://overpass-turbo.eu/s/1S08
I didn’t use layer=-1, because it is not seldom missing like PHerison said.
With layer=-1 it would be
https://overpass-turbo.eu/s/1S0a

Karl60 · 2024-10-01T08:40:17.562Z

Well, that was an embarrassing mistake - many thanks to all.

Karl60 · 2024-10-01T08:48:19.801Z

Awesome, many thanks for the solution and the education.

Kogacarlo · 2024-10-01T10:34:57.476Z

ChatGPT is a laugh. Everything it outputs should be checked by humans.