Difference between revisions of "Develop auto tables"

Revision as of 18:06, 22 January 2023

Useful links

Workin overpass examples

correct link:https://overpass.ogf.rent-a-planet.com/api/interpreter?data

list of airports

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

Name	Length (km)	Drains into

list of rivers

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

Name	Length (km)	Drains into

last edits

Refresh

Changeset ID	User ID	User Name	Date and Time
1564456	29951	TheRealStanPines	2026-02-03 19:47:12
1564455	4597	ADB52	2026-02-03 19:47:11
1564454	12833	theruler	2026-02-03 19:45:04
1564453	29981	Кріц	2026-02-03 19:41:05
1564452	14001	Taka	2026-02-03 19:30:10
1564451	6326	jba487_14	2026-02-03 19:28:20
1564450	25343	raxx	2026-02-03 19:27:32
1564449	18	Easky30	2026-02-03 19:23:59
1564448	25343	raxx	2026-02-03 19:23:41
1564447	29981	Кріц	2026-02-03 19:17:42
1564446	18	Easky30	2026-02-03 19:16:04
1564445	12833	theruler	2026-02-03 19:13:37
1564444	27579	PoisonDog522	2026-02-03 19:08:03
1564443	26855	MiniMapper	2026-02-03 19:06:16
1564442	25343	raxx	2026-02-03 19:03:01
1564441	29951	TheRealStanPines	2026-02-03 19:00:19
1564440	25343	raxx	2026-02-03 18:59:51
1564439	29981	Кріц	2026-02-03 18:57:47
1564438	26855	MiniMapper	2026-02-03 18:54:25
1564437	6326	jba487_14	2026-02-03 18:49:13
1564436	12833	theruler	2026-02-03 18:49:04
1564435	29981	Кріц	2026-02-03 18:42:31
1564434	25343	raxx	2026-02-03 18:41:17
1564433	26855	MiniMapper	2026-02-03 18:40:55
1564432	6326	jba487_14	2026-02-03 18:38:19
1564431	26855	MiniMapper	2026-02-03 18:35:07
1564430	29951	TheRealStanPines	2026-02-03 18:34:19
1564429	25343	raxx	2026-02-03 18:34:01
1564428	18	Easky30	2026-02-03 18:30:56
1564427	28112	qhfreddy	2026-02-03 18:22:24
1564426	26855	MiniMapper	2026-02-03 18:19:52
1564425	29951	TheRealStanPines	2026-02-03 18:18:24
1564424	30009	Frederikcastell	2026-02-03 18:15:35
1564423	28815	JasmineDM	2026-02-03 18:14:41
1564422	29951	TheRealStanPines	2026-02-03 18:09:16
1564421	29951	TheRealStanPines	2026-02-03 18:07:07
1564420	25870	Alexmar983	2026-02-03 18:03:48
1564419	29981	Кріц	2026-02-03 18:01:32
1564418	28815	JasmineDM	2026-02-03 17:56:38
1564417	12833	theruler	2026-02-03 17:53:31
1564416	29951	TheRealStanPines	2026-02-03 17:43:45
1564415	27600	ParrotMan	2026-02-03 17:24:55
1564414	29951	TheRealStanPines	2026-02-03 17:17:40
1564413	29951	TheRealStanPines	2026-02-03 17:13:53
1564412	5230	geoboi	2026-02-03 17:13:34
1564411	26979	lxgwsierra	2026-02-03 16:58:48
1564410	29515	Pole	2026-02-03 16:54:30
1564409	23033	Distel	2026-02-03 16:50:42
1564408	29951	TheRealStanPines	2026-02-03 16:49:34
1564407	28815	JasmineDM	2026-02-03 16:48:41
1564406	30009	Frederikcastell	2026-02-03 16:45:11
1564405	25343	raxx	2026-02-03 16:41:54
1564404	29951	TheRealStanPines	2026-02-03 16:37:43
1564403	25343	raxx	2026-02-03 16:24:48
1564402	1267	Leowezy	2026-02-03 16:23:35
1564401	29951	TheRealStanPines	2026-02-03 16:22:06
1564400	25343	raxx	2026-02-03 16:21:38
1564399	10082	Öllöjoumi	2026-02-03 16:17:03
1564398	29886	Manfred	2026-02-03 16:09:44
1564397	25343	raxx	2026-02-03 16:07:32
1564396	29951	TheRealStanPines	2026-02-03 16:06:31
1564395	25343	raxx	2026-02-03 16:06:20
1564394	26855	MiniMapper	2026-02-03 15:57:37
1564393	25343	raxx	2026-02-03 15:56:41
1564392	10082	Öllöjoumi	2026-02-03 15:55:53
1564391	23735	Juan Pablo Balam	2026-02-03 15:53:52
1564390	12833	theruler	2026-02-03 15:53:30
1564389	10082	Öllöjoumi	2026-02-03 15:52:51
1564388	17027	Mapping Expert	2026-02-03 15:51:24
1564387	25343	raxx	2026-02-03 15:49:54
1564386	23033	Distel	2026-02-03 15:49:45
1564385	28815	JasmineDM	2026-02-03 15:47:10
1564384	17027	Mapping Expert	2026-02-03 15:45:31
1564383	1747	tparigo	2026-02-03 15:42:28
1564382	10082	Öllöjoumi	2026-02-03 15:41:30
1564381	23033	Distel	2026-02-03 15:39:48
1564380	25343	raxx	2026-02-03 15:39:04
1564379	25343	raxx	2026-02-03 15:38:32
1564378	1822	ante44	2026-02-03 15:37:53
1564377	217	antoon	2026-02-03 15:37:27
1564376	1267	Leowezy	2026-02-03 15:37:23
1564375	29951	TheRealStanPines	2026-02-03 15:37:03
1564374	25343	raxx	2026-02-03 15:36:44
1564373	28815	JasmineDM	2026-02-03 15:35:11
1564372	23033	Distel	2026-02-03 15:35:10
1564371	25343	raxx	2026-02-03 15:33:29
1564370	10082	Öllöjoumi	2026-02-03 15:33:01
1564369	14030	NorthTeaPower	2026-02-03 15:31:13
1564368	29951	TheRealStanPines	2026-02-03 15:26:21
1564367	12833	theruler	2026-02-03 15:22:17
1564366	6326	jba487_14	2026-02-03 15:15:51
1564365	13652	Zytik	2026-02-03 15:11:40
1564364	6375	Hilsonbergman	2026-02-03 15:11:38
1564363	12833	theruler	2026-02-03 15:09:18
1564362	29951	TheRealStanPines	2026-02-03 15:01:51
1564361	26047	Taksine	2026-02-03 14:59:09
1564360	954	BMSOUZA	2026-02-03 14:50:25
1564359	18	Easky30	2026-02-03 14:48:59
1564358	1267	Leowezy	2026-02-03 14:48:56
1564357	954	BMSOUZA	2026-02-03 14:45:07

Simple tables

A	B	C
aaaaaaa	bbbbbbbbbbbbbbb	ccccccccccc

A	B	C
aaaaaaa	bbbbbbbbbbbbbbb	ccccccccccc

Table
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

{| {{#clear_external_data:}}
{{#get_web_data:url=https://ogfoverpass.rent-a-planet.com/api/interpreter?data=%28node%5B%22specialtag%22%3D%22Teststrassexyz%22%5D%3Bway%5B%22specialtag%22%3D%22Teststrassexyz%22%5D%3Brelation%5B%22specialtag%22%3D%22Teststrassexyz%22%5D%3B%29%3Bout%20body%3B%3E%3Bout%20skel%20qt%3B
|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:}} |}

Could not get URL https://ogfoverpass.rent-a-planet.com/api/interpreter?data=%28node%5B%22specialtag%22%3D%22Teststrassexyz%22%5D%3Bway%5B%22specialtag%22%3D%22Teststrassexyz%22%5D%3Brelation%5B%22specialtag%22%3D%22Teststrassexyz%22%5D%3B%29%3Bout%20body%3B%3E%3Bout%20skel%20qt%3B after 3 tries.

Nane	Link

Test subtemplates

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

Table

Table
Map

x

Rivers in Mergania: nodes
Name	Map
	map
	map
	map
	map
	map

Rivers in Mergania: ways
Name	Map
Farau Way	map
Farau Way	map

Rivers in Mergania: relations
Name	Map
Farau Relation	map

Rivers in Mergania: relations
Name	Map
Farau Relation	map
Rivers in Mergania	map

new relation

Rivers in Mergania
Name	Map
	map
	map
	map
	map
	map
	map
	map
	map
	map
	map
	map
	map
	map
	map
	map

Rivers in Mergania
Name	Map
Fluss z	map
Bach y	map
Fluss y	map
Bach x	map
Fluss x	map

Rivers in Mergania
Name	Map
Fluss 1	map
Fluss 2	map
Bach 1	map
Rivers in Mergania	map

further

Aerotheon Group
Name	Country	City	Products	Map
Aerotheon	Mergania	Gubenau	aircraft	map
Aerotheon	Mergania	Lansing	aircraft	map
Aerotheon Port II	Mergania	Lilienthal	aircraft	map
Aerotheon	Mergania	Lilienthal	aircraft	map
Aerotheon Port I	Mergania	Lilienthal		map
AEROTHEON Wing Technology Development Center	Mergania	Lillenthal		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

From wiki

Could not get URL https://overpass.ogf.rent-a-planet.com/api/interpreter?data=[maxsize:10000000][timeout:30];area[name="Kojo"];nwr[diplomatic=embassy](area);%20(._;>;);%20out; after 3 tries.

Name	Notes	Map

@@ Line 11: / Line 11: @@
 correct link:https://overpass.ogf.rent-a-planet.com/api/interpreter?data
+<div class="mw-collapsible mw-collapsed">
+list of airports
+<div class="mw-collapsible-content">
+{{#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:}}
+</div></div>{{clear}}
 <div class="mw-collapsible mw-collapsed">
@@ Line 70: / Line 100: @@
 |}
 </div></div>{{clear}}
 ==Simple tables==