Template:OTUP

Query

Template documentation[View] [edit] [history] [Purge]

Overpass Turbo Ultra Postpass

Usage

• Highlights all syntax (Overpass QL, Postpass, MapCSS, YAML)
• Links with usable parts into both Turbo (no YAML) and Ultra (no OT settings)
• Has titles
• Collapsible
• Features most syntaxhighlight capabilities
  • Has a copy button
  • Number lines
  • Highlight lines
  • Link to lines

Notes

• Some parts have to be converted yourself
  • Some settings (eg data:sql ) vs type: postpass  ; or you can add both parts, which will be converted to use only the service-appropriate one correctly)
  • Shortcuts (eg bbox vs wsen )
• Single-line view has code preview on hover
  • No copy button
  • Some encoding are wrong

Syntax

loc works the same. endpoint is unified into server for convenience.

• mode=collapsed : Loads in collapsed view
• title= :
• caption= : Notes
• hightlightpart= + highlightlines= https://www.mediawiki.org/wiki/Extension:SyntaxHighlight#highlight
• id= https://www.mediawiki.org/wiki/Extension:SyntaxHighlight#linelinks
• Your code in these
  • YAML=
  • Turbo= : Curly bracket settings, only MapCSS highlighted
  • Overpass=
  • Postpass=

Parameters

Examples

Overpass only

{{OTUP|id=simpleexample|
Overpass=
[out:json][timeout:25];
{{((}}geocodeArea:Iceland{{))}}->.searchArea;
nwr["natural"="glacier"](area.searchArea);
out geom;
}}
[[#simpleexample_B-2|Jump to and highlight line 2 of part B (Overpass/Postpass)]]

Query

[out:json][timeout:25];
{{geocodeArea:Iceland}}->.searchArea;
nwr["natural"="glacier"](area.searchArea);
out geom;

Jump to and highlight line 2 of part B (Overpass/Postpass)

{{OTUP|mode=inline|
Overpass=
[out:json][timeout:25];
{{((}}geocodeArea:Iceland{{))}}->.searchArea;
nwr["natural"="glacier"](area.searchArea);
out geom;
}}

Query

Cross-service setting workaround

{{OTUP|title=Hulls, projections, buffers
|Turbo={{((}}data:sql,server=https://postpass.geofabrik.de/api/{{))}}
|YAML=
---
type: postpass
---
|Postpass=
WITH London AS
(
  SELECT osm_id, osm_type, tags, ST_ConvexHull(geom) AS geom
  FROM postpass_line
  WHERE 
  "osm_type"='R' AND "osm_id" IN ('106164', '3929584')
)
SELECT stations.osm_id, stations.osm_type, stations.tags, ST_Transform(ST_Buffer(ST_Transform(stations.geom,27700),805.67),4326)
FROM postpass_pointpolygon AS stations, London
WHERE
  ST_Intersects(stations.geom,London.geom) AND
  stations.tags->>'railway'='station'
|caption=Needs to be projected to get the distance correct (otherwise gets an ellipse from different lat and lon lengths), then reprojected back to be displayed in the tool. Some impreciseness along the M25 border from how convex hulls work.
}}

Hulls, projections, buffers

---
type: postpass
---

{{data:sql,server=https://postpass.geofabrik.de/api/}}

WITH London AS
(
  SELECT osm_id, osm_type, tags, ST_ConvexHull(geom) AS geom
  FROM postpass_line
  WHERE 
  "osm_type"='R' AND "osm_id" IN ('106164', '3929584')
)
SELECT stations.osm_id, stations.osm_type, stations.tags, ST_Transform(ST_Buffer(ST_Transform(stations.geom,27700),805.67),4326)
FROM postpass_pointpolygon AS stations, London
WHERE
  ST_Intersects(stations.geom,London.geom) AND
  stations.tags->>'railway'='station'

Needs to be projected to get the distance correct (otherwise gets an ellipse from different lat and lon lengths), then reprojected back to be displayed in the tool. Some impreciseness along the M25 border from how convex hulls work.

Overpass Turbo Turbo

{{OTUP|mode=collapsed|caption=Now you see me?|
Turbo=
{{((}}style:
node, way, relation 
{{(}}
  text: eval("tag('name') . ' (' . tag('wikidata') . ')'");
{{)}}
{{))}}
|
Overpass=
[out:json][timeout:25];
{{((}}geocodeArea:Iceland{{))}}->.searchArea;
nwr["natural"="glacier"](area.searchArea);
out geom;
}}

Query

{{style:
node, way, relation 
{
  text: eval("tag('name') . ' (' . tag('wikidata') . ')'");
}
}}

[out:json][timeout:25];
{{geocodeArea:Iceland}}->.searchArea;
nwr["natural"="glacier"](area.searchArea);
out geom;

Now you see me?

Query

Overpass Ultra MapLibre YAML Postpass

{{OTUP|title=Representative points|highlightpart=YAML|highlightlines=6-8,14|
YAML=
---
type: postpass
style:  
  layers:
    - type: fill
      filter: [==, [get, osm_type], W]
      fill-color: gray
      fill-opacity: 0.5
    - type: fill
      filter: [==, [get, osm_type], R]
      fill-color: black
      fill-opacity: 0.5
    - type: line
      filter: [==, [geometry-type], LineString]
      line-width: 10
---
|
Postpass=
SELECT osm_type, osm_id, tags, ST_Collect(ARRAY[geom, ST_MakeLine(ARRAY[ST_Centroid(geom), ST_PointOnSurface(geom), (MIC).center]::geometry[]), ST_Buffer((MIC).center,(MIC).radius)])
  FROM
  (
    SELECT osm_type, osm_id, tags, geom, ST_MaximumInscribedCircle(geom) AS MIC
      FROM postpass_pointpolygon
      WHERE 
        geom && ST_MakeEnvelope({{((}}wsen{{))}},4326) AND 
        tags->>'landuse'='residential' AND tags->>'residential'='apartments' 
  ) 
}}

Representative points

---
type: postpass
style:  
  layers:
    - type: fill
      filter: [==, [get, osm_type], W]
      fill-color: gray
      fill-opacity: 0.5
    - type: fill
      filter: [==, [get, osm_type], R]
      fill-color: black
      fill-opacity: 0.5
    - type: line
      filter: [==, [geometry-type], LineString]
      line-width: 10
---

SELECT osm_type, osm_id, tags, ST_Collect(ARRAY[geom, ST_MakeLine(ARRAY[ST_Centroid(geom), ST_PointOnSurface(geom), (MIC).center]::geometry[]), ST_Buffer((MIC).center,(MIC).radius)])
  FROM
  (
    SELECT osm_type, osm_id, tags, geom, ST_MaximumInscribedCircle(geom) AS MIC
      FROM postpass_pointpolygon
      WHERE 
        geom && ST_MakeEnvelope({{wsen}},4326) AND 
        tags->>'landuse'='residential' AND tags->>'residential'='apartments' 
  )

Representative points

See also

• {{[[Template:|]]}}

The above documentation is transcluded from Template:OTUP/doc. (edit | history)
Editors can experiment in this template's sandbox (Create | mirror) and testcases (Create) pages.
Add categories to the /doc subpage. Subpages of this template.