| 1 |
<!DOCTYPE html> |
| 2 |
<html><head> |
| 3 |
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> |
| 4 |
<title>highlight.overpassql</title> |
| 5 |
<meta name="generator" content="KF5::SyntaxHighlighting - Definition (Overpass QL) - Theme (Breeze Dark)"/> |
| 6 |
</head><body style="background-color:#232629;color:#cfcfc2"><pre> |
| 7 |
<span style="color:#7a7c7d;">/* Overpass samples taken from</span> |
| 8 |
<span style="color:#7a7c7d;"> https://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_QL</span> |
| 9 |
<span style="color:#7a7c7d;"> https://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_API_by_Example</span> |
| 10 |
|
| 11 |
*/ |
| 12 |
|
| 13 |
<span style="color:#7a7c7d;">// single line comment with </span><span style="color:#ca9219;background-color:#451e1a;font-weight:bold;">TODO</span><span style="color:#7a7c7d;"> alerts</span> |
| 14 |
|
| 15 |
<span style="color:#7a7c7d;">/* multi-line comment with </span><span style="color:#81ca2d;background-color:#4d1f24;font-weight:bold;">###</span><span style="color:#7a7c7d;"> alerts </span>*/ |
| 16 |
|
| 17 |
[<span style="color:#8e44ad;">out</span>:json][<span style="color:#27aeae;">timeout</span>:<span style="color:#f67400;">25</span>]; |
| 18 |
<span style="color:#7a7c7d;">// gather results</span> |
| 19 |
( |
| 20 |
<span style="color:#7a7c7d;">// query part for: “amenity=post_box”</span> |
| 21 |
<span style="color:#8e44ad;">node</span>[<span style="color:#f44f4f;">"amenity"</span>=<span style="color:#f44f4f;">"post_box"</span>](<span style="color:#f67400;">52.0</span>, <span style="color:#f67400;">13.0</span>, <span style="color:#f67400;">54.0</span>, <span style="color:#f67400;">13.5</span>); |
| 22 |
<span style="color:#8e44ad;">way</span>[<span style="color:#f44f4f;">"amenity"</span>=<span style="color:#f44f4f;">"post_box"</span>](<span style="color:#27ae60;">{{bbox}}</span>); |
| 23 |
<span style="color:#8e44ad;">relation</span>[<span style="color:#f44f4f;">"amenity"</span>=<span style="color:#f44f4f;">"post_box"</span>](<span style="color:#27ae60;">{{bbox}}</span>); |
| 24 |
); |
| 25 |
<span style="color:#7a7c7d;">// print results</span> |
| 26 |
<span style="color:#8e44ad;">out</span> <span style="color:#7f8c8d;">body</span>; |
| 27 |
>; |
| 28 |
<span style="color:#8e44ad;">out</span> <span style="color:#7f8c8d;">skel</span> <span style="color:#7f8c8d;">qt</span>; |
| 29 |
|
| 30 |
|
| 31 |
[<span style="color:#8e44ad;">out</span>:csv(::<span style="color:#7f8c8d;">type</span>, <span style="color:#f44f4f;">"de:regionalschluessel"</span>, name, |
| 32 |
::<span style="color:#7f8c8d;">count</span>, ::<span style="color:#f44f4f;">"count:nodes"</span>, ::<span style="color:#f44f4f;">"count:ways"</span>, ::<span style="color:#f44f4f;">"count:relations"</span>)]; |
| 33 |
|
| 34 |
<span style="color:#7a7c7d;">//All areas with regional key (German: "Regionalschlüssel") starting with 057</span> |
| 35 |
<span style="color:#8e44ad;">area</span>[<span style="color:#f44f4f;">"de:regionalschluessel"</span>~<span style="color:#f44f4f;">"^057"</span>]; |
| 36 |
|
| 37 |
<span style="color:#7a7c7d;">// Count the pharmacies in each area</span> |
| 38 |
<span style="font-weight:bold;">foreach</span>->.regio( |
| 39 |
<span style="color:#7a7c7d;">// display details for the current area</span> |
| 40 |
.regio <span style="color:#8e44ad;">out</span>; |
| 41 |
|
| 42 |
<span style="color:#7a7c7d;">// Collect all Nodes, Ways and Relations with amenity=pharmacy in the current area</span> |
| 43 |
( <span style="color:#8e44ad;">node</span>(<span style="color:#8e44ad;">area</span>.regio)[amenity=pharmacy]; |
| 44 |
<span style="color:#8e44ad;">way</span>(<span style="color:#8e44ad;">area</span>.regio)[amenity=pharmacy]; |
| 45 |
<span style="color:#8e44ad;">rel</span>(<span style="color:#8e44ad;">area</span>.regio)[amenity=pharmacy];); |
| 46 |
|
| 47 |
<span style="color:#7a7c7d;">// Count the elements in the current area Area</span> |
| 48 |
<span style="color:#8e44ad;">out</span> <span style="color:#7f8c8d;">count</span>; |
| 49 |
); |
| 50 |
|
| 51 |
|
| 52 |
[<span style="color:#27aeae;">timeout</span>:<span style="color:#f67400;">300</span>] |
| 53 |
[<span style="color:#27aeae;">bbox</span>:<span style="color:#f67400;">51.08282186160976</span>,-<span style="color:#f67400;">12.8759765625</span>,<span style="color:#f67400;">55.986091533808384</span>,-<span style="color:#f67400;">1.86767578125</span>] |
| 54 |
[<span style="color:#8e44ad;">out</span>:csv(::<span style="color:#7f8c8d;">id</span>, ::<span style="color:#7f8c8d;">type</span>, name, <span style="color:#f44f4f;">"name:en"</span>, <span style="color:#f44f4f;">"name:ga"</span>)]; |
| 55 |
|
| 56 |
( <span style="color:#8e44ad;">node</span>[name][<span style="color:#f44f4f;">"name:en"</span>][<span style="color:#f44f4f;">"name:ga"</span>](<span style="font-weight:bold;">if</span>:(t[<span style="color:#f44f4f;">"name"</span>] != t[<span style="color:#f44f4f;">"name:en"</span>]) && (t[<span style="color:#f44f4f;">"name"</span>] != t[<span style="color:#f44f4f;">"name:ga"</span>])); |
| 57 |
<span style="color:#8e44ad;">way</span>[name][<span style="color:#f44f4f;">"name:en"</span>][<span style="color:#f44f4f;">"name:ga"</span>] (<span style="font-weight:bold;">if</span>:(t[<span style="color:#f44f4f;">"name"</span>] != t[<span style="color:#f44f4f;">"name:en"</span>]) && (t[<span style="color:#f44f4f;">"name"</span>] != t[<span style="color:#f44f4f;">"name:ga"</span>])); |
| 58 |
<span style="color:#8e44ad;">rel</span>[name][<span style="color:#f44f4f;">"name:en"</span>][<span style="color:#f44f4f;">"name:ga"</span>] (<span style="font-weight:bold;">if</span>:(t[<span style="color:#f44f4f;">"name"</span>] != t[<span style="color:#f44f4f;">"name:en"</span>]) && (t[<span style="color:#f44f4f;">"name"</span>] != t[<span style="color:#f44f4f;">"name:ga"</span>])); |
| 59 |
); |
| 60 |
<span style="color:#8e44ad;">out</span>; |
| 61 |
|
| 62 |
|
| 63 |
[<span style="color:#8e44ad;">out</span>:csv(<span style="color:#7f8c8d;">version</span>,<span style="color:#7f8c8d;">timestamp</span>,<span style="color:#7f8c8d;">changeset</span>,<span style="color:#7f8c8d;">count</span>)]; |
| 64 |
<span style="color:#8e44ad;">timeline</span>(<span style="color:#8e44ad;">relation</span>,<span style="color:#f67400;">2632934</span>); |
| 65 |
<span style="font-weight:bold;">for</span> (t[<span style="color:#f44f4f;">"created"</span>]) |
| 66 |
{ |
| 67 |
<span style="font-weight:bold;">retro</span>(_.val) |
| 68 |
{ |
| 69 |
<span style="color:#8e44ad;">rel</span>(<span style="color:#f67400;">2632934</span>); |
| 70 |
<span style="color:#8e44ad;">make</span> stat <span style="color:#7f8c8d;">version</span>=u(<span style="color:#7f8c8d;">version</span>()),<span style="color:#7f8c8d;">timestamp</span>=u(<span style="color:#7f8c8d;">timestamp</span>()),<span style="color:#7f8c8d;">changeset</span>=u(<span style="color:#7f8c8d;">changeset</span>()),<span style="color:#7f8c8d;">count</span>=u(<span style="color:#7f8c8d;">count_members</span>()); |
| 71 |
<span style="color:#8e44ad;">out</span>; |
| 72 |
} |
| 73 |
} |
| 74 |
|
| 75 |
|
| 76 |
[<span style="color:#27aeae;">timeout</span>:<span style="color:#f67400;">60</span>]; |
| 77 |
<span style="color:#8e44ad;">area</span>[<span style="color:#f44f4f;">"name"</span>=<span style="color:#f44f4f;">"Mayenne"</span>]->.boundaryarea; |
| 78 |
<span style="color:#8e44ad;">way</span>(<span style="color:#8e44ad;">area</span>.boundaryarea)[<span style="color:#f44f4f;">"building"</span>=<span style="color:#f44f4f;">"church"</span>]; |
| 79 |
<span style="font-weight:bold;">foreach</span>( |
| 80 |
<span style="color:#8e44ad;">node</span>(w)->.d; <span style="color:#7a7c7d;">// determine all nodes of a way</span> |
| 81 |
.n <span style="color:#8e44ad;">is_in</span>->.a; |
| 82 |
<span style="color:#8e44ad;">area</span>.a[name][boundary=administrative][admin_level~<span style="color:#f44f4f;">"^[2-8]$"</span>] -> .a; |
| 83 |
<span style="color:#8e44ad;">out</span> <span style="color:#7f8c8d;">center</span>; |
| 84 |
<span style="color:#8e44ad;">convert</span> <span style="color:#8e44ad;">way</span> ::=::, |
| 85 |
::<span style="color:#7f8c8d;">id</span> = <span style="color:#7f8c8d;">id</span>(), |
| 86 |
<span style="color:#8e44ad;">is_in</span>=a.<span style="color:#7f8c8d;">set</span>(<span style="color:#f44f4f;">"{"</span> + t[<span style="color:#f44f4f;">"admin_level"</span>] + <span style="color:#f44f4f;">":"</span> + t[<span style="color:#f44f4f;">"name"</span>] + <span style="color:#f44f4f;">"}"</span>); |
| 87 |
|
| 88 |
<span style="color:#8e44ad;">out</span>; |
| 89 |
); |
| 90 |
</pre></body></html> |