Difference between revisions of "Develop auto tables"

From geofiction
Jump to navigation Jump to search
m
m
Line 1: Line 1:
 +
==Useful links==
 
*[https://de.wikipedia.org/wiki/Hilfe:Tabellen Hilfe:Tabellen]
 
*[https://de.wikipedia.org/wiki/Hilfe:Tabellen Hilfe:Tabellen]
 
*[[Template:MER-autoTable rfrsh]]
 
*[[Template:MER-autoTable rfrsh]]
Line 136: Line 137:
 
|}
 
|}
  
 
+
==Requesting data==
 
+
===Minimal example 1: use a relation===
==Request data from relation==
 
 
<pre>
 
<pre>
 
{{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/312195/full
 
{{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/312195/full
Line 159: Line 159:
 
</pre>
 
</pre>
  
{{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/312195/full
+
{| {{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/312195/full
 
|format=xml
 
|format=xml
 
|data=
 
|data=
Line 167: Line 167:
 
}}
 
}}
 
{| class="wikitable"
 
{| class="wikitable"
! Nane
+
! Name
 
! Link
 
! Link
 
{{!}}-
 
{{!}}-
Line 175: Line 175:
 
{{!}}-
 
{{!}}-
 
}} |}  
 
}} |}  
{{#clear_external_data:}}
+
{{#clear_external_data:}} |}
  
 +
===Minimal example 2: use an overpass querry===
 +
<pre>
 +
mmmmmmm
 +
</pre>
  
 
+
{| {{#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
 
{{#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
+
|use xpath
|use xpath}}
+
}}
{| class="wikitable sortable"
+
{| class="wikitable"
! Name
+
! Nane
! City
+
! Link
! Map
+
{{!}}-
 
{{#for_external_table:<nowiki/>
 
{{#for_external_table:<nowiki/>
 +
{{!}}{{{name}}}
 +
{{!}}[http://opengeofiction.net/way/{{{way_id}}} click here]
 
{{!}}-
 
{{!}}-
{{!}}{{{wname}}}
+
}} |}  
{{!}}{{{wcity}}}
+
{{#clear_external_data:}} |}  
{{!}}[http://opengeofiction.net/way/{{{wid}}} (way {{{wid}}})]
+
 
}}
+
 
 +
poopk
 +
 
  
==x==
 
 
<pre>
 
<pre>
 
<!-- request data-->
 
<!-- request data-->

Revision as of 01:32, 1 August 2022

Useful links

Simple tables

A B C
aaaaaaa bbbbbbbbbbbbbbb ccccccccccc
A B C
aaaaaaa bbbbbbbbbbbbbbb ccccccccccc



Table MER-refresh.png
Map

|}

Requesting data

Minimal example 1: use a relation

{{#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:}}
Name Link
Teststraße 1 click here
Teststraße 2 click here
Teststraße 3 click here
Teststraße 4 click here
Teststraße 5 click here
Teststraße 6 click here
Teststraße 7 click here
Teststraße 8 click here

Minimal example 2: use an overpass querry

mmmmmmm
Error while fetching data from 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: $2.
Error fetching URL: Could not resolve host: ogfoverpass.rent-a-planet.com
There was a problem during the HTTP request: 0 Error
Could not get 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 after 3 tries.
Nane Link


poopk


<!-- 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}}})]
}}
|}

x

Rivers in Mergania: nodes MER-refresh.png
Name Map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map


Rivers in Mergania: ways MER-refresh.png
Name Map
Farau Way OGFmapicon.png map
Farau Way OGFmapicon.png map


Rivers in Mergania: relations MER-refresh.png
Name Map
Farau Relation OGFmapicon.png map


new relation

Rivers in Mergania MER-refresh.png
Name Map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map


Rivers in Mergania MER-refresh.png
Name Map
Fluss z OGFmapicon.png map
Bach y OGFmapicon.png map
Fluss y OGFmapicon.png map
Bach x OGFmapicon.png map
Fluss x OGFmapicon.png map


Rivers in Mergania MER-refresh.png
Name Map
Fluss 1 OGFmapicon.png map
Fluss 2 OGFmapicon.png map
Bach 1 OGFmapicon.png map
Rivers in Mergania OGFmapicon.png map


Overpass testing

Could not get 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 after 3 tries.

Name City Map