Difference between revisions of "Develop auto tables"

From geofiction
Jump to navigation Jump to search
m
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
==Useful links==
 
==Useful links==
 
*[https://de.wikipedia.org/wiki/Hilfe:Tabellen Hilfe:Tabellen]
 
*[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:MER-autoTable rfrsh]]
 
*[[Template:Table_rel]]
 
*[[Template:Table_rel]]
 
*[[Template:Table_opq]]
 
*[[Template:Table_opq]]
−
*[[Template:Rel_data]]
 
−
*[[Template:Opq_data]]
 
−
*[[Template:Table_fill]]
 
 
*[[List of autotables]]
 
*[[List of autotables]]
  
−
==Workin overpass examples==
+
Subtemplates
 +
*[[Template:Atab_relation]]
 +
*[[Template:Atab_ogfquery]]
 +
*[[Template:Atab_thead]]
 +
*[[Template:Atab_table]]
 +
 
 +
==Sites for development==
 
*[[Autotables_working]]
 
*[[Autotables_working]]
 
*[[Autotables_test_simple]]
 
*[[Autotables_test_simple]]
 
*[[Autotables_modular]]
 
*[[Autotables_modular]]
 +
*[[Autotables_overpass]]
 +
*[[Template:Table324]]
 +
*[[Template:Test_split_table]]
  
−
correct link:https://overpass.ogf.rent-a-planet.com/api/interpreter?data
 
  
 +
==Tests==
  
−
==x==
+
===Airport codes===
  
 +
https://overpass.opengeofiction.net/api/interpreter?data=(way%5B%22name%22%5D%5B%22iata%22%5D%3B)%3Bout%3B
  
−
{{MER-autoTable_rfrsh
+
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
−
| relation    = 311781
 
−
| type        = node
 
−
| topic      = Rivers in Mergania: nodes
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
{{MER-autoTable_rfrsh
+
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
−
| relation    = 311781
 
−
| type        = way
 
−
| topic      = Rivers in Mergania: ways
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
{{MER-autoTable_rfrsh
+
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
−
| relation    = 311781
 
−
| type        = relation
 
−
| topic      = Rivers in Mergania: relations
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
{{MER-autoTable_rfrsh
+
area["admin_level"="2"][name~"^(Merganien|Wyster)$"];)->.a;
−
| relation    = 311782
 
−
| type        = relation
 
−
| topic      = Rivers in Mergania: relations
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
===new relation===
+
area["admin_level"="2"]["name"="Merganien"];)->.a;
−
{{MER-autoTable_rfrsh
 
−
| relation    = 312146
 
−
| type        = node
 
−
| topic      = Rivers in Mergania
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
{{MER-autoTable_rfrsh
+
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
−
| relation    = 312146
 
−
| type        = way
 
−
| topic      = Rivers in Mergania
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
{{MER-autoTable_rfrsh
+
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
−
| relation    = 312146
 
−
| type        = relation
 
−
| topic      = Rivers in Mergania
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
===further===
+
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
−
{{MER-autoTable_rfrsh
 
−
| relation    = 340533
 
−
| type        = way
 
−
| topic      = Aerotheon Group
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
| column2name = Country
 
−
| column2tag  = is_in:country
 
−
| column3name = City
 
−
| column3tag  = is_in:city
 
−
| column4name = Products
 
−
| column4tag  = product
 
−
}}
 
−
{{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
  
−
===Test count===
+
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
−
{{#clear_external_data:}}
 
−
{{#get_web_data:url=https://overpass.ogf.rent-a-planet.com/api/interpreter?data=(area%5Bname%3D%22Guai%22%5D%5B%22admin_level%22%3D%222%22%5D%3B%20)-%3E.a%3B%20relation%5B%22type%22%3D%22waterway%22%5D%5B%22water%22%3D%22river%22%5D%5Bname%5D(area.a)%3Bout%3B
 
−
|format=xml
 
−
|order by=/osm/relation/tag[@k='name']/@v DESC
 
−
|data=
 
−
relation_id=/osm/relation/@id
 
−
,name=/osm/relation/tag[@k='name']/@v
 
−
,distance=/osm/relation/tag[@k='distance']/@v
 
−
,destination=/osm/relation/tag[@k='destination']/@v
 
−
,ref=/osm/relation/tag[@k='ref']/@v
 
−
|use xpath
 
−
}}
 
−
{| class="wikitable sortable"
 
−
! Name
 
−
! Length<br/>(km)<br>
 
−
! Drains into
 
−
{{#for_external_table:<nowiki/>
 
−
{{!}}-
 
−
{{!}}[http://opengeofiction.net/relation/{{{relation_id}}} {{{name}}}]
 
−
{{!}}{{{distance}}}
 
−
{{!}}[[{{{destination}}}]]
 
−
}}
 
−
|}
 
−
{{#clear_external_data:}}
 
  
 +
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}}
 
  
  
  
−
 
+
{{#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
−
{{#clear_external_data:}}{{#get_web_data:url=https://overpass.ogf.rent-a-planet.com/api/interpreter?data=(area%5B%22admin_level%22=2%5D%5B%22name%22=%22Merganien%22%5D;)-%3E.bndarea;%0A(node(area.bndarea)%5B%22highway%22%3D%22motorway%22%5D;way(area.bndarea)%5B%22highway%22%3D%22highway%22%5D;relation(area.bndarea)%5B%22highway%22%3D%22motorway%22%5D%3B)%3B%0Aout%20count%3B%3E%3Bout%20skel%20qt%3B
 
 
|format=xml
 
|format=xml
 
|data=
 
|data=
−
  count=/osm/way/tag[@k='highway']/@v
+
  way_id=/osm/way/@id,
−
|use xpath}}
+
name=/osm/way/tag[@k='name']/@v,
−
{| class="wikitable sortable"
+
iata=/osm/way/tag[@k='iata']/@v
−
! Name
+
|use xpath
−
! Length<br/>(km)<br>
 
−
! Drains into
 
−
{{#for_external_table:<nowiki/>
 
−
{{!}}-
 
−
{{!}}{{{count}}}
 
−
{{!}}ö
 
−
{{!}}l
 
 
}}
 
}}
−
|}
+
{| class="wikitable sortable mw-collapsible mw-collapsed"
−
{{#clear_external_data:}}
+
! width=500px; | Name
−
 
+
! width=100px; | IATA
−
 
 
−
 
 
−
}}ii{{{count|6}}}{{#for_external_table:{{{count}}} }}{{#clear_external_data:}}
 
−
 
 
−
 
 
−
uu
 
−
count=/osm/count/@total
 
−
 
 
−
count=/osm/count/tag[@k='total']/@v
 
−
 
 
−
 
 
−
<!--
 
−
==Overpass testing==
 
−
 
 
−
{{#clear_external_data:}}
 
−
{{#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
 
−
|format=xml
 
−
|data=
 
−
wname=/osm/way/tag[@k='name']/@v
 
−
,wcity=/osm/way/tag[@k='is_in:city']/@v
 
−
,wid=/osm/way/@id
 
−
|use xpath}}
 
−
{| class="wikitable sortable"
 
−
! Name
 
−
! City
 
−
! Map
 
 
{{#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}}})]
 
 
}}
 
}}
 
|}
 
|}
−
 
−
 
−
==From wiki==
 
 
{{#clear_external_data:}}
 
{{#clear_external_data:}}
−
{{#get_web_data:url=https://overpass.ogf.rent-a-planet.com/api/interpreter?data=[maxsize:10000000][timeout:30];area[name="Kojo"];nwr[diplomatic=embassy](area); (._;>;); out;
 
−
|format=xml
 
−
|data=
 
−
node_id=/osm/node/@id
 
−
,name=/osm/node/tag[@k='name']/@v
 
−
,notes=/osm/node/tag[@k='notes']/@v
 
−
|use xpath}}
 
−
{| class="wikitable sortable mw-collapsible mw-expanded"
 
−
! Name
 
−
! Notes
 
−
! Map
 
−
{{#for_external_table:
 
−
{{!}}
 
−
{{!}}{{{name}}}
 
−
{{!}}{{{notes}}}
 
−
{{!}}{{node|{{{node_id}}}|Embassy map}}
 
−
}}
 
−
|}-->
 

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
Retrieved from "https://geofiction.lima-city.ch/index.php?title=Develop_auto_tables&oldid=1174"