Difference between revisions of "Develop auto tables"

From geofiction
Jump to navigation Jump to search
Line 138: Line 138:
  
  
==x==
+
==Request data from relation==
 
<pre>
 
<pre>
 
{{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/{{{relation}}}/full
 
{{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/{{{relation}}}/full
Line 158: Line 158:
 
</pre>
 
</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"
 +
! A
 +
! B
 +
! C
 +
{{#for_external_table:<nowiki/>
 +
{{!}}-
 +
{{!}}aaaaaaa
 +
{{!}}{{{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==
 
==x==

Revision as of 01:07, 1 August 2022

Simple tables

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



Table MER-refresh.png
Map

|}


Request data from relation

{{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/{{{relation}}}/full
|format=xml
|data=
 {{{type}}}_id=/osm/{{{type}}}/@id
{{ #If:{{{column1tag|}}} |
,{{{column1tag}}}=/osm/{{{type}}}/tag[@k='{{{column1tag}}}']/@v {{ #If:{{{column2tag|}}} |
,{{{column2tag}}}=/osm/{{{type}}}/tag[@k='{{{column2tag}}}']/@v {{ #If:{{{column3tag|}}} |
,{{{column3tag}}}=/osm/{{{type}}}/tag[@k='{{{column3tag}}}']/@v {{ #If:{{{column4tag|}}} |
,{{{column4tag}}}=/osm/{{{type}}}/tag[@k='{{{column4tag}}}']/@v {{ #If:{{{column5tag|}}} |
,{{{column5tag}}}=/osm/{{{type}}}/tag[@k='{{{column5tag}}}']/@v {{ #If:{{{column6tag|}}} |
,{{{column6tag}}}=/osm/{{{type}}}/tag[@k='{{{column6tag}}}']/@v {{ #If:{{{column7tag|}}} |
,{{{column7tag}}}=/osm/{{{type}}}/tag[@k='{{{column7tag}}}']/@v {{ #If:{{{column8tag|}}} |
,{{{column8tag}}}=/osm/{{{type}}}/tag[@k='{{{column8tag}}}']/@v {{ #If:{{{column9tag|}}} |
,{{{column9tag}}}=/osm/{{{type}}}/tag[@k='{{{column9tag}}}']/@v }} }} }} }} }} }} }} }} }}
|use xpath
}} }}


A B C

aaaaaaa Teststraße 1 click here
aaaaaaa Teststraße 2 click here
aaaaaaa Teststraße 3 click here
aaaaaaa Teststraße 4 click here
aaaaaaa Teststraße 5 click here
aaaaaaa Teststraße 6 click here
aaaaaaa Teststraße 7 click here
aaaaaaa Teststraße 8 click here



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.

Name City Map


x

<!-- 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