Difference between revisions of "Develop auto tables"

From geofiction
Jump to navigation Jump to search
(Created page with " ==x== {{clear}} ==Overpass testing== {{#clear_external_data:}} {{#get_web_data:url=https://ogfoverpass.rent-a-planet.com/api/interpreter?data=%28area%5B%22admi...")
 
 
(45 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
==Useful links==
 +
*[https://de.wikipedia.org/wiki/Hilfe:Tabellen Hilfe:Tabellen]
 +
*correct link:https://overpass.ogf.rent-a-planet.com/api/interpreter?data
 +
*[[Template:MER-autoTable rfrsh]]
 +
*[[Template:Table_rel]]
 +
*[[Template:Table_opq]]
 +
*[[List of autotables]]
  
 +
Subtemplates
 +
*[[Template:Atab_relation]]
 +
*[[Template:Atab_ogfquery]]
 +
*[[Template:Atab_thead]]
 +
*[[Template:Atab_table]]
  
 +
==Sites for development==
 +
*[[Autotables_working]]
 +
*[[Autotables_test_simple]]
 +
*[[Autotables_modular]]
 +
*[[Autotables_overpass]]
 +
*[[Template:Table324]]
 +
*[[Template:Test_split_table]]
  
  
 +
==Tests==
  
 +
===Airport codes===
  
 +
https://overpass.opengeofiction.net/api/interpreter?data=(way%5B%22name%22%5D%5B%22iata%22%5D%3B)%3Bout%3B
  
 +
https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname~%22^(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B(way(area.a)%5B%22name%22%5D%5B%22iata%22%5D%3B)%3Bout%3B
  
 +
https://overpass.opengeofiction.net/api/interpreter?data=(area%5Bname%3D%22Merganien%22%5D%5B%22admin_level%22%3D%222%22%5D%3B%20)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B
  
 +
https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%5D%5Bname~"^(Wyster|Merganien)$"%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B
  
 +
area["admin_level"="2"][name~"^(Merganien|Wyster)$"];)->.a;
  
 +
area["admin_level"="2"]["name"="Merganien"];)->.a;
  
 +
https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%5D%5Bname~%22%5E(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B
  
==x==
+
https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname%3D%22Merganien%22%5D%3B%20)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B
  
 +
https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname%3D%22Merganien%22%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B
  
{{clear}}
+
https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname~%22%5E(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B
==Overpass testing==
 
  
{{#clear_external_data:}}
+
https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname%7E%22%5E(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B
{{#get_web_data:url=https://ogfoverpass.rent-a-planet.com/api/interpreter?data=%28area%5B%22admin_level%22%5D%5B%22ogf%3Aid%22%3D%22UL02a%22%5D%3B%29-%3E.bndarea%3B%0A%28nwr%28area.bndarea%29%5Breligion%3D%27christian%27%5D%288.450638800331001%2C29.970703124999996%2C35.96022296929667%2C64.7314453125%29%3B%29%3Bout%20body%3B%3E%3Bout%20skel%20qt%3B
+
 
 +
https://overpass.opengeofiction.net/api/interpreter?data=(area%5Bname%7E%22%5E(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B
 +
 
 +
 
 +
 
 +
 
 +
{{#clear_external_data:}}{{#get_web_data:url=https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5B%22name%22%3D%22Kalm%22%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B
 
|format=xml
 
|format=xml
 
|data=
 
|data=
  wname=/osm/way/tag[@k='name']/@v
+
  way_id=/osm/way/@id,
,wcity=/osm/way/tag[@k='is_in:city']/@v
+
name=/osm/way/tag[@k='name']/@v,
,wid=/osm/way/@id
+
iata=/osm/way/tag[@k='iata']/@v
|use xpath}}
+
|use xpath
{| class="wikitable sortable"
+
}}
! Name
+
{| class="wikitable sortable mw-collapsible mw-collapsed"
! City
+
! width=500px; | Name
! Map
+
! width=100px; | IATA
 
{{#for_external_table:<nowiki/>
 
{{#for_external_table:<nowiki/>
 
{{!}}-
 
{{!}}-
{{!}}{{{wname}}}
+
{{!}}[http://opengeofiction.net/way/{{{way_id}}} {{{name}}}]
{{!}}{{{wcity}}}
+
{{!}}{{{iata}}}
{{!}}[http://opengeofiction.net/way/{{{wid}}} (way {{{wid}}})]
 
 
}}
 
}}
 
|}
 
|}
 +
{{#clear_external_data:}}

Latest revision as of 23:00, 3 May 2025

Useful links

Subtemplates

Sites for development


Tests

Airport codes

https://overpass.opengeofiction.net/api/interpreter?data=(way%5B%22name%22%5D%5B%22iata%22%5D%3B)%3Bout%3B

https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname~%22^(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B(way(area.a)%5B%22name%22%5D%5B%22iata%22%5D%3B)%3Bout%3B

https://overpass.opengeofiction.net/api/interpreter?data=(area%5Bname%3D%22Merganien%22%5D%5B%22admin_level%22%3D%222%22%5D%3B%20)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B

https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%5D%5Bname~"^(Wyster|Merganien)$"%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B

area["admin_level"="2"][name~"^(Merganien|Wyster)$"];)->.a;

area["admin_level"="2"]["name"="Merganien"];)->.a;

https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%5D%5Bname~%22%5E(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B

https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname%3D%22Merganien%22%5D%3B%20)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B

https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname%3D%22Merganien%22%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B

https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname~%22%5E(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B

https://overpass.opengeofiction.net/api/interpreter?data=(area%5B%22admin_level%22%3D%222%22%5D%5Bname%7E%22%5E(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B

https://overpass.opengeofiction.net/api/interpreter?data=(area%5Bname%7E%22%5E(Merganien%7CWyster)%24%22%5D%3B)-%3E.a%3B%20way%5B%22aeroway%22%3D%22aerodrome%22%5D(area.a)%3Bout%3B



Name IATA

Flugplatz Helster BTG
Segel- und Sportflugplatz Kürliser Heide PTR
Internationaler Flughafen August Judeskron Tarott-Hipplanken FRI
Verkehrsflugplatz Wenneberg-Koganth-Neuenburg FFL
Flughafen Forberg-Golbrünn LIL
Sportflugplatz Nedenauberg
Internationaler Flughafen Orlent
Verkehrslandeplatz Schürren/Honbracht
Flughafen Bütingen
Internationaler Flughafen Pern
Peus Telur Rasmus International Airport Viljanni
Internationaler Flughafen Nerschach
Internationaler Großflughafen Freistat
Flughafen Vennburg
Flugfeld Leutsch
Aerotheon Flugfeld Lilienthal