Difference between revisions of "Develop auto tables"

Revision as of 19: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
1608109	26719	Lemuria	2026-07-29 16:10:17
1608108	30655	NaR1108	2026-07-29 16:08:40
1608107	27398	Parivan	2026-07-29 16:05:34
1608106	24572	kengoman	2026-07-29 15:56:54
1608105	27189	Skymarines	2026-07-29 15:51:28
1608104	18	Easky30	2026-07-29 15:50:43
1608103	26719	Lemuria	2026-07-29 15:50:21
1608102	14030	NorthTeaPower	2026-07-29 15:50:05
1608101	27398	Parivan	2026-07-29 15:41:23
1608100	26066	Masyas	2026-07-29 15:37:42
1608099	28112	qhfreddy	2026-07-29 15:36:58
1608098	30561	Boyan	2026-07-29 15:36:08
1608097	30493	kk_gjz	2026-07-29 15:10:40
1608096	26979	lxgwsierra	2026-07-29 15:04:23
1608095	26856	jr000	2026-07-29 14:49:21
1608094	26979	lxgwsierra	2026-07-29 14:47:34
1608093	30521	MapeadorOGF	2026-07-29 14:47:16
1608092	24865	drgtgd	2026-07-29 14:46:01
1608091	1343	thosehlar	2026-07-29 14:31:26
1608090	15584	Izaland Terramorphing Committee	2026-07-29 14:23:50
1608089	30521	MapeadorOGF	2026-07-29 14:18:54
1608088	1343	thosehlar	2026-07-29 14:15:34
1608087	15584	Izaland Terramorphing Committee	2026-07-29 14:15:12
1608086	1343	thosehlar	2026-07-29 14:14:15
1608085	30655	NaR1108	2026-07-29 14:09:40
1608084	24865	drgtgd	2026-07-29 14:09:21
1608083	25870	Alexmar983	2026-07-29 14:08:47
1608082	26855	MiniMapper	2026-07-29 14:06:36
1608081	26855	MiniMapper	2026-07-29 14:06:32
1608080	25870	Alexmar983	2026-07-29 14:04:27
1608079	25870	Alexmar983	2026-07-29 14:03:18
1608078	25870	Alexmar983	2026-07-29 14:02:40
1608077	1343	thosehlar	2026-07-29 13:51:29
1608076	1343	thosehlar	2026-07-29 13:50:29
1608075	29019	stolas123	2026-07-29 13:41:51
1608074	30493	kk_gjz	2026-07-29 13:18:26
1608073	29019	stolas123	2026-07-29 13:17:38
1608072	29019	stolas123	2026-07-29 13:17:01
1608071	29019	stolas123	2026-07-29 13:06:18
1608070	29788	av8787	2026-07-29 13:01:21
1608069	28187	axaeve	2026-07-29 12:34:24
1608068	30655	NaR1108	2026-07-29 12:31:11
1608067	30655	NaR1108	2026-07-29 12:15:03
1608066	27398	Parivan	2026-07-29 11:51:47
1608065	27398	Parivan	2026-07-29 11:50:57
1608064	27398	Parivan	2026-07-29 11:50:14
1608063	27398	Parivan	2026-07-29 11:48:16
1608062	24826	walkingsophie	2026-07-29 11:47:42
1608061	27398	Parivan	2026-07-29 11:36:54
1608060	27960	eddie	2026-07-29 11:23:46
1608059	7443	Eevee	2026-07-29 11:17:51
1608058	24710	Dfltcher2	2026-07-29 10:54:38
1608057	24710	Dfltcher2	2026-07-29 10:42:44
1608056	24710	Dfltcher2	2026-07-29 10:38:59
1608055	7443	Eevee	2026-07-29 10:30:31
1608054	24710	Dfltcher2	2026-07-29 10:21:36
1608053	26855	MiniMapper	2026-07-29 10:21:14
1608052	27803	themapper53	2026-07-29 10:20:32
1608051	1139	Rasmus Rasmusson	2026-07-29 10:18:56
1608050	24710	Dfltcher2	2026-07-29 10:12:44
1608049	26979	lxgwsierra	2026-07-29 10:07:56
1608048	1343	thosehlar	2026-07-29 10:03:29
1608047	1343	thosehlar	2026-07-29 10:00:24
1608046	24710	Dfltcher2	2026-07-29 09:59:25
1608045	1343	thosehlar	2026-07-29 09:58:44
1608044	1139	Rasmus Rasmusson	2026-07-29 09:33:47
1608043	1343	thosehlar	2026-07-29 09:25:57
1608042	1343	thosehlar	2026-07-29 09:25:00
1608041	1343	thosehlar	2026-07-29 09:18:02
1608040	1343	thosehlar	2026-07-29 09:13:26
1608039	1343	thosehlar	2026-07-29 09:09:13
1608038	1343	thosehlar	2026-07-29 08:55:43
1608037	28067	saigyoujinoriko	2026-07-29 08:53:48
1608036	26979	lxgwsierra	2026-07-29 08:51:52
1608035	1343	thosehlar	2026-07-29 08:50:59
1608034	14030	NorthTeaPower	2026-07-29 08:43:57
1608033	2386	thermo_nuclear	2026-07-29 08:40:46
1608032	28067	saigyoujinoriko	2026-07-29 08:40:26
1608031	30250	Haksi Tiao	2026-07-29 08:34:07
1608030	28067	saigyoujinoriko	2026-07-29 08:29:47
1608029	30250	Haksi Tiao	2026-07-29 08:27:47
1608028	26979	lxgwsierra	2026-07-29 08:22:03
1608027	6375	Hilsonbergman	2026-07-29 08:21:35
1608026	1267	Leowezy	2026-07-29 07:56:55
1608025	28067	saigyoujinoriko	2026-07-29 07:18:50
1608024	28067	saigyoujinoriko	2026-07-29 07:10:07
1608023	28067	saigyoujinoriko	2026-07-29 07:04:51
1608022	28067	saigyoujinoriko	2026-07-29 07:03:17
1608021	28067	saigyoujinoriko	2026-07-29 06:59:48
1608020	27275	alomico	2026-07-29 06:29:28
1608019	27601	Ominvar	2026-07-29 06:13:19
1608018	30561	Boyan	2026-07-29 05:41:05
1608017	26979	lxgwsierra	2026-07-29 05:28:30
1608016	26979	lxgwsierra	2026-07-29 05:25:50
1608015	1158	Y Knott	2026-07-29 05:09:54
1608014	21669	Kevin J	2026-07-29 04:38:35
1608013	26979	lxgwsierra	2026-07-29 04:35:52
1608012	30250	Haksi Tiao	2026-07-29 04:34:39
1608011	26979	lxgwsierra	2026-07-29 04:29:05
1608010	30250	Haksi Tiao	2026-07-29 04:24:31

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