Develop auto tables

Useful links

• Hilfe:Tabellen
• Template:MER-autoTable rfrsh
• Template:Table_rel
• Template:Table_opq
• Template:Rel_data
• Template:Opq_data
• Template:Table_fill

Workin overpass examples

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

list of airports

Name	Length (km)	Drains into

list of rivers

Name	Length (km)	Drains into

last edits

Refresh

Changeset ID	User ID	User Name	Date and Time
1550911	10082	Öllöjoumi	2025-12-11 11:22:54
1550910	25454	Arbhin	2025-12-11 11:07:29
1550909	10082	Öllöjoumi	2025-12-11 11:04:54
1550908	2236	William	2025-12-11 11:00:49
1550907	10082	Öllöjoumi	2025-12-11 10:51:34
1550906	1747	tparigo	2025-12-11 10:37:48
1550905	25551	Mantan	2025-12-11 10:35:50
1550904	10082	Öllöjoumi	2025-12-11 10:33:52
1550903	10082	Öllöjoumi	2025-12-11 10:21:12
1550902	28815	JasmineDM	2025-12-11 10:06:48
1550901	25890	cartographersurgeon	2025-12-11 10:01:44
1550900	10082	Öllöjoumi	2025-12-11 09:59:05
1550899	10082	Öllöjoumi	2025-12-11 09:44:25
1550898	25152	nejisadd	2025-12-11 09:42:12
1550897	10082	Öllöjoumi	2025-12-11 09:33:50
1550896	28159	GreenStumpyMonster	2025-12-11 09:09:57
1550895	401	Kalh79	2025-12-11 09:04:10
1550894	6358	cibrage	2025-12-11 08:52:28
1550893	28159	GreenStumpyMonster	2025-12-11 08:17:33
1550892	25890	cartographersurgeon	2025-12-11 08:04:02
1550891	28159	GreenStumpyMonster	2025-12-11 07:51:05
1550890	10082	Öllöjoumi	2025-12-11 07:41:25
1550889	10082	Öllöjoumi	2025-12-11 07:40:22
1550888	10082	Öllöjoumi	2025-12-11 07:36:16
1550887	10082	Öllöjoumi	2025-12-11 07:35:46
1550886	10082	Öllöjoumi	2025-12-11 07:30:52
1550885	10082	Öllöjoumi	2025-12-11 07:07:17
1550884	10082	Öllöjoumi	2025-12-11 07:05:01
1550883	10082	Öllöjoumi	2025-12-11 06:56:47
1550882	28159	GreenStumpyMonster	2025-12-11 06:50:36
1550881	178	bhj867	2025-12-11 06:41:43
1550880	19188	KTheBritMC	2025-12-11 06:41:40
1550879	22998	Tomikals	2025-12-11 06:33:07
1550878	21669	Kevin J	2025-12-11 05:45:39
1550877	10218	Arlo	2025-12-11 05:28:50
1550876	10218	Arlo	2025-12-11 05:26:02
1550875	10218	Arlo	2025-12-11 04:46:00
1550874	10218	Arlo	2025-12-11 04:43:45
1550873	954	BMSOUZA	2025-12-11 04:42:58
1550872	954	BMSOUZA	2025-12-11 04:37:19
1550871	10218	Arlo	2025-12-11 04:28:14
1550870	10218	Arlo	2025-12-11 04:23:51
1550869	26119	MxCo	2025-12-11 04:21:20
1550868	954	BMSOUZA	2025-12-11 04:19:00
1550867	10218	Arlo	2025-12-11 04:17:41
1550866	10218	Arlo	2025-12-11 04:11:50
1550865	954	BMSOUZA	2025-12-11 04:11:20
1550864	22595	Crarji	2025-12-11 03:31:37
1550863	6375	Hilsonbergman	2025-12-11 03:21:29
1550862	27601	Ominvar	2025-12-11 03:10:00
1550861	22595	Crarji	2025-12-11 03:07:19
1550860	22595	Crarji	2025-12-11 03:01:57
1550859	27600	ParrotMan	2025-12-11 02:11:03
1550858	1956	kingfries	2025-12-11 02:06:07
1550857	22595	Crarji	2025-12-11 01:47:02
1550856	1956	kingfries	2025-12-11 01:45:38
1550855	22595	Crarji	2025-12-11 01:45:34
1550854	26317	sergjack	2025-12-11 01:44:27
1550853	26317	sergjack	2025-12-11 01:20:54
1550852	1761	Brunanter	2025-12-11 00:55:18
1550851	1761	Brunanter	2025-12-11 00:51:04
1550850	10218	Arlo	2025-12-11 00:44:29
1550849	10218	Arlo	2025-12-11 00:31:16
1550848	2194	UN1TY	2025-12-11 00:21:38
1550847	22595	Crarji	2025-12-11 00:19:15
1550846	19188	KTheBritMC	2025-12-11 00:14:40
1550845	2194	UN1TY	2025-12-11 00:13:45
1550844	25913	Sweetykid	2025-12-11 00:10:37
1550843	25913	Sweetykid	2025-12-11 00:06:40
1550842	2194	UN1TY	2025-12-11 00:06:07
1550841	26855	MiniMapper	2025-12-10 23:47:00
1550840	5562	CartographerKing	2025-12-10 23:17:05
1550839	28432	Bakston	2025-12-10 23:15:32
1550838	28432	Bakston	2025-12-10 23:12:45
1550837	17027	Mapping Expert	2025-12-10 23:05:44
1550836	1463	No Way	2025-12-10 22:51:49
1550835	1463	No Way	2025-12-10 22:38:43
1550834	2236	William	2025-12-10 22:31:19
1550833	1463	No Way	2025-12-10 22:23:56
1550832	11647	curiomap	2025-12-10 22:06:42
1550831	25551	Mantan	2025-12-10 22:00:24
1550830	25559	bananaman101	2025-12-10 21:54:33
1550829	25559	bananaman101	2025-12-10 21:46:50
1550828	19073	Isol	2025-12-10 21:41:41
1550827	2194	UN1TY	2025-12-10 21:39:41
1550826	23033	Distel	2025-12-10 21:38:07
1550825	1602	Ūdilugbulgidħū	2025-12-10 21:28:40
1550824	1602	Ūdilugbulgidħū	2025-12-10 21:28:25
1550823	23033	Distel	2025-12-10 21:22:17
1550822	2236	William	2025-12-10 21:11:44
1550821	6697	pdplm	2025-12-10 20:55:41
1550820	27863	AR_FKU	2025-12-10 20:33:53
1550819	28159	GreenStumpyMonster	2025-12-10 20:22:52
1550818	28159	GreenStumpyMonster	2025-12-10 20:21:08
1550817	18	Easky30	2025-12-10 20:15:49
1550816	29752	opnwix	2025-12-10 19:57:39
1550815	22566	Olejowy	2025-12-10 19:38:17
1550814	5230	geoboi	2025-12-10 19:00:25
1550813	27863	AR_FKU	2025-12-10 18:47:15
1550812	27863	AR_FKU	2025-12-10 18:44:41

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://overpass.ogf.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:}} |}

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

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

Test count

Name	Length (km)	Drains into

Name	Length (km)	Drains into

}}ii6

uu

count=/osm/count/@total

count=/osm/count/tag[@k='total']/@v