Difference between revisions of "Develop auto tables"

From geofiction
Jump to navigation Jump to search
m
 
(36 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
==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]]
 +
*[[List of autotables]]
  
−
==Simple tables==
+
Subtemplates
−
{| class="wikitable"
+
*[[Template:Atab_relation]]
−
! A
+
*[[Template:Atab_ogfquery]]
−
! B
+
*[[Template:Atab_thead]]
−
! C
+
*[[Template:Atab_table]]
−
{{!}}-
 
−
{{!}}aaaaaaa
 
−
{{!}}bbbbbbbbbbbbbbb
 
−
{{!}}ccccccccccc
 
−
|}
 
  
−
{| class="wikitable sortable"
+
==Sites for development==
−
! A
+
*[[Autotables_working]]
−
! B
+
*[[Autotables_test_simple]]
−
! C
+
*[[Autotables_modular]]
−
{{!}}-
+
*[[Autotables_overpass]]
−
{{!}}aaaaaaa
+
*[[Template:Table324]]
−
{{!}}bbbbbbbbbbbbbbb
+
*[[Template:Test_split_table]]
−
{{!}}ccccccccccc
 
−
|}
 
  
  
 +
==Tests==
  
 +
===Airport codes===
  
−
{{ #If:{{{collapsible|}}} |
+
https://overpass.opengeofiction.net/api/interpreter?data=(way%5B%22name%22%5D%5B%22iata%22%5D%3B)%3Bout%3B
−
{{ #If:{{{collapsed|}}} |
 
−
{{{!}} class="wikitable sortable mw-collapsible mw-collapsed;" |
 
−
{{{!}} class="wikitable sortable mw-collapsible" }} |
 
−
{{{!}} class="wikitable sortable" }} style="text-align:left; width:{{{width|500}}}px;"
 
−
|-
 
−
! class="unsortable" style="background:#{{{bgcolor|CCCCFF}}};" {{ #If:{{{column9tag|}}} |
 
−
colspan="9" | {{ #If:{{{column8tag|}}} |
 
−
colspan="8" | {{ #If:{{{column7tag|}}} |
 
−
colspan="7" | {{ #If:{{{column6tag|}}} |
 
−
colspan="6" | {{ #If:{{{column5tag|}}} |
 
−
colspan="5" | {{ #If:{{{column4tag|}}} |
 
−
colspan="4" | {{ #If:{{{column3tag|}}} |
 
−
colspan="3" | {{ #If:{{{column2tag|}}} |
 
−
colspan="2" | {{ #If:{{{column1tag|}}} |
 
−
colspan="1" }} }} }} }} }} }} }} }} }} | {{{topic|Table}}}
 
−
! class="unsortable" style="background:#{{{bgcolor|CCCCFF}}}; text-align:right; width:50px;" | {{Refresh}}
 
−
|-
 
−
{{ #If:{{{column1tag|}}} |
 
−
{{ #If:{{{column1sort|}}}{{{column1width|}}} |
 
−
! {{ #If:{{{column1sort|}}} |
 
−
class="unsortable" }} {{ #If:{{{column1width|}}} |
 
−
style="width:{{{column1width}}}px;" }} {{!}} | ! }} {{{column1name}}}
 
−
{{ #If:{{{column2tag|}}} |
 
−
{{ #If:{{{column2sort|}}}{{{column2width|}}} |
 
−
! {{ #If:{{{column2sort|}}} |
 
−
class="unsortable" }} {{ #If:{{{column2width|}}} |
 
−
style="width:{{{column2width}}}px;" }} {{!}} | ! }} {{{column2name}}}
 
−
{{ #If:{{{column3tag|}}} |
 
−
{{ #If:{{{column3sort|}}}{{{column3width|}}} |
 
−
! {{ #If:{{{column3sort|}}} |
 
−
class="unsortable" }} {{ #If:{{{column3width|}}} |
 
−
style="width:{{{column3width}}}px;" }} {{!}} | ! }} {{{column3name}}}
 
−
{{ #If:{{{column4tag|}}} |
 
−
{{ #If:{{{column4sort|}}}{{{column4width|}}} |
 
−
! {{ #If:{{{column4sort|}}} |
 
−
class="unsortable" }} {{ #If:{{{column4width|}}} |
 
−
style="width:{{{column4width}}}px;" }} {{!}} | ! }} {{{column4name}}}
 
−
{{ #If:{{{column5tag|}}} |
 
−
{{ #If:{{{column5sort|}}}{{{column5width|}}} |
 
−
! {{ #If:{{{column5sort|}}} |
 
−
class="unsortable" }} {{ #If:{{{column5width|}}} |
 
−
style="width:{{{column5width}}}px;" }} {{!}} | ! }} {{{column5name}}}
 
−
{{ #If:{{{column6tag|}}} |
 
−
{{ #If:{{{column6sort|}}}{{{column6width|}}} |
 
−
! {{ #If:{{{column6sort|}}} |
 
−
class="unsortable" }} {{ #If:{{{column6width|}}} |
 
−
style="width:{{{column6width}}}px;" }} {{!}} | ! }} {{{column6name}}}
 
−
{{ #If:{{{column7tag|}}} |
 
−
{{ #If:{{{column7sort|}}}{{{column7width|}}} |
 
−
! {{ #If:{{{column7sort|}}} |
 
−
class="unsortable" }} {{ #If:{{{column7width|}}} |
 
−
style="width:{{{column7width}}}px;" }} {{!}} | ! }} {{{column7name}}}
 
−
{{ #If:{{{column8tag|}}} |
 
−
{{ #If:{{{column8sort|}}}{{{column8width|}}} |
 
−
! {{ #If:{{{column8sort|}}} |
 
−
class="unsortable" }} {{ #If:{{{column8width|}}} |
 
−
style="width:{{{column8width}}}px;" }} {{!}} | ! }} {{{column8name}}}
 
−
{{ #If:{{{column9tag|}}} |
 
−
{{ #If:{{{column9sort|}}}{{{column9width|}}} |
 
−
! {{ #If:{{{column9sort|}}} |
 
−
class="unsortable" }} {{ #If:{{{column9width|}}} |
 
−
style="width:{{{column9width}}}px;" }} {{!}} | ! }} {{{column9name}}} }} }} }} }} }} }} }} }} }}
 
−
! class="unsortable" | Map
 
−
|-
 
−
{{#for_external_table:<nowiki/>
 
−
{{ #If:{{{column1tag|}}} |
 
−
{{!}} {{ #If:{{{column1link|}}} |
 
−
[[{{{{{{column1tag|}}}}}}]] | {{{{{{column1tag|}}}}}}
 
−
}}
 
−
{{ #If:{{{column2tag|}}} |
 
−
{{!}} {{ #If:{{{column2link|}}} |
 
−
[[{{{{{{column2tag|}}}}}}]] | {{{{{{column2tag|}}}}}}
 
−
}}
 
−
{{ #If:{{{column3tag|}}} |
 
−
{{!}} {{ #If:{{{column3link|}}} |
 
−
[[{{{{{{column3tag|}}}}}}]] | {{{{{{column3tag|}}}}}}
 
−
}}
 
−
{{ #If:{{{column4tag|}}} |
 
−
{{!}} {{ #If:{{{column4link|}}} |
 
−
[[{{{{{{column4tag|}}}}}}]] | {{{{{{column4tag|}}}}}}
 
−
}}
 
−
{{ #If:{{{column5tag|}}} |
 
−
{{!}} {{ #If:{{{column5link|}}} |
 
−
[[{{{{{{column5tag|}}}}}}]] | {{{{{{column5tag|}}}}}}
 
−
}}
 
−
{{ #If:{{{column6tag|}}} |
 
−
{{!}} {{ #If:{{{column6link|}}} |
 
−
[[{{{{{{column6tag|}}}}}}]] | {{{{{{column6tag|}}}}}}
 
−
}}
 
−
{{ #If:{{{column7tag|}}} |
 
−
{{!}} {{ #If:{{{column7link|}}} |
 
−
[[{{{{{{column7tag|}}}}}}]] | {{{{{{column7tag|}}}}}}
 
−
}}
 
−
{{ #If:{{{column8tag|}}} |
 
−
{{!}} {{ #If:{{{column8link|}}} |
 
−
[[{{{{{{column8tag|}}}}}}]] | {{{{{{column8tag|}}}}}}
 
−
}}
 
−
{{ #If:{{{column9tag|}}} |
 
−
{{!}} {{ #If:{{{column9link|}}} |
 
−
[[{{{{{{column9tag|}}}}}}]] | {{{{{{column9tag|}}}}}}
 
−
}} }} }} }} }} }} }} }} }} }}
 
−
{{!}} [[File:OGFmapicon.png|18px|link=]] <span class="plainlinks">[https://opengeofiction.net/{{{type}}}/{{{{{{type}}}_id}}} map]</span>
 
−
{{!}}-
 
−
}} |}
 
−
{{#clear_external_data:}}
 
−
|}
 
  
 +
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
  
−
==Request data from relation==
+
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
−
<pre>
 
−
{{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/312195/full
 
−
|format=xml
 
−
|data=
 
−
way_id=/osm/way/@id
 
−
,name=/osm/way/tag[@k='name']/@v
 
−
|use xpath
 
−
}}
 
−
{| class="wikitable"
 
−
! Nane
 
−
! Link
 
−
{{!}}-
 
−
{{#for_external_table:<nowiki/>
 
−
{{!}}{{{name}}}
 
−
{{!}}[http://opengeofiction.net/way/{{{way_id}}} click here]
 
−
{{!}}-
 
−
}} |}
 
−
{{#clear_external_data:}}
 
−
</pre>
 
  
−
{{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/312195/full
+
area["admin_level"="2"][name~"^(Merganien|Wyster)$"];)->.a;
−
|format=xml
 
−
|data=
 
−
way_id=/osm/way/@id
 
−
,name=/osm/way/tag[@k='name']/@v
 
−
|use xpath
 
−
}}
 
−
{| class="wikitable"
 
−
! Nane
 
−
! Link
 
−
{{!}}-
 
−
{{#for_external_table:<nowiki/>
 
−
{{!}}{{{name}}}
 
−
{{!}}[http://opengeofiction.net/way/{{{way_id}}} click here]
 
−
{{!}}-
 
−
}} |}
 
−
{{#clear_external_data:}}
 
−
 
 
−
 
 
−
 
 
−
 
 
−
 
 
−
{{#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/>
 
−
{{!}}-
 
−
{{!}}{{{wname}}}
 
−
{{!}}{{{wcity}}}
 
−
{{!}}[http://opengeofiction.net/way/{{{wid}}} (way {{{wid}}})]
 
−
}}
 
−
 
 
−
==x==
 
−
<pre>
 
−
<!-- request data-->
 
−
{{#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}}
 
−
<!-- create table-->
 
−
{| class="wikitable sortable"
 
−
! Name
 
−
! City
 
−
! Map
 
−
{{#for_external_table:<nowiki/>
 
−
{{!}}-
 
−
{{!}}{{{wname}}}
 
−
{{!}}{{{wcity}}}
 
−
{{!}}[http://opengeofiction.net/way/{{{wid}}} (way {{{wid}}})]
 
−
}}
 
−
|}
 
−
</pre>
 
  
−
==x==
+
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
  
−
{{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    = 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%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
−
| 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%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
−
| relation    = 311781
 
−
| type        = relation
 
−
| topic      = Rivers in Mergania: relations
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
===new relation===
+
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
−
{{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%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
−
| relation    = 312146
 
−
| type        = way
 
−
| topic      = Rivers in Mergania
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
{{MER-autoTable_rfrsh
 
−
| relation    = 312146
 
−
| type        = relation
 
−
| topic      = Rivers in Mergania
 
−
| width      = 550
 
−
| column1name = Name
 
−
| column1tag  = name
 
−
}}
 
  
−
{{clear}}
 
  
−
==Overpass testing==
 
  
−
{{#clear_external_data:}}
+
{{#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
−
{{#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
 
|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
Retrieved from "https://geofiction.lima-city.ch/index.php?title=Develop_auto_tables&oldid=1174"