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
1587675	401	Kalh79	2026-05-09 10:46:58
1587674	30454	TheMakkiMan14	2026-05-09 10:41:00
1587673	30454	TheMakkiMan14	2026-05-09 10:34:53
1587672	21685	Halvarda	2026-05-09 10:33:40
1587671	3225	zhenkang	2026-05-09 10:21:20
1587670	25343	raxx	2026-05-09 10:18:28
1587669	30408	Avery	2026-05-09 10:14:05
1587668	16354	Gonzy	2026-05-09 10:12:34
1587667	25551	Mantan	2026-05-09 10:03:26
1587666	2533	stjur	2026-05-09 10:01:12
1587665	27081	trainsgb	2026-05-09 09:57:51
1587664	22426	Aad	2026-05-09 09:53:16
1587663	29066	AmiCridosa	2026-05-09 09:51:26
1587662	22426	Aad	2026-05-09 09:50:00
1587661	22426	Aad	2026-05-09 09:48:23
1587660	1139	Rasmus Rasmusson	2026-05-09 09:46:56
1587659	27275	alomico	2026-05-09 09:46:53
1587658	4711	logasa1	2026-05-09 09:46:33
1587657	22426	Aad	2026-05-09 09:45:31
1587656	401	Kalh79	2026-05-09 09:43:14
1587655	27788	pokenia_eidan	2026-05-09 09:43:11
1587654	29066	AmiCridosa	2026-05-09 09:32:50
1587653	28388	xoxasochka	2026-05-09 09:29:29
1587652	12292	Pav	2026-05-09 09:19:19
1587651	1139	Rasmus Rasmusson	2026-05-09 09:14:47
1587650	12292	Pav	2026-05-09 09:11:22
1587649	12292	Pav	2026-05-09 09:04:05
1587648	28388	xoxasochka	2026-05-09 09:03:59
1587647	12292	Pav	2026-05-09 08:51:33
1587646	401	Kalh79	2026-05-09 08:50:02
1587645	401	Kalh79	2026-05-09 08:43:25
1587644	30009	Frederikcastell	2026-05-09 08:42:23
1587643	28067	saigyoujinoriko	2026-05-09 08:36:43
1587642	16354	Gonzy	2026-05-09 08:18:27
1587641	28067	saigyoujinoriko	2026-05-09 08:14:31
1587640	28067	saigyoujinoriko	2026-05-09 08:03:03
1587639	27948	dev_null_42	2026-05-09 07:51:02
1587638	28067	saigyoujinoriko	2026-05-09 07:49:31
1587637	25890	cartographersurgeon	2026-05-09 07:49:23
1587636	28067	saigyoujinoriko	2026-05-09 07:11:45
1587635	28067	saigyoujinoriko	2026-05-09 07:08:05
1587634	1368	Otto Yamamoto	2026-05-09 07:06:52
1587633	1368	Otto Yamamoto	2026-05-09 07:02:31
1587632	2725	ruadh	2026-05-09 06:49:27
1587631	28067	saigyoujinoriko	2026-05-09 06:49:08
1587630	28067	saigyoujinoriko	2026-05-09 06:46:20
1587629	28067	saigyoujinoriko	2026-05-09 06:28:39
1587628	28067	saigyoujinoriko	2026-05-09 06:10:21
1587627	29020	kz-star	2026-05-09 06:02:37
1587626	232	Ernestpkirby	2026-05-09 05:58:32
1587625	28084	kyunzi	2026-05-09 05:52:01
1587624	28067	saigyoujinoriko	2026-05-09 05:41:07
1587623	28067	saigyoujinoriko	2026-05-09 05:38:49
1587622	28084	kyunzi	2026-05-09 05:37:32
1587621	11647	curiomap	2026-05-09 05:16:13
1587620	28067	saigyoujinoriko	2026-05-09 05:09:37
1587619	28067	saigyoujinoriko	2026-05-09 05:05:13
1587618	28067	saigyoujinoriko	2026-05-09 04:51:28
1587617	22998	Tomikals	2026-05-09 04:47:09
1587616	11647	curiomap	2026-05-09 04:42:52
1587615	28084	kyunzi	2026-05-09 04:34:36
1587614	22595	Crarji	2026-05-09 04:30:50
1587613	27275	alomico	2026-05-09 04:20:38
1587612	11647	curiomap	2026-05-09 04:18:53
1587611	26119	MxCo	2026-05-09 04:17:05
1587610	1761	Brunanter	2026-05-09 04:01:22
1587609	27275	alomico	2026-05-09 03:54:45
1587608	28084	kyunzi	2026-05-09 03:39:10
1587607	5562	CartographerKing	2026-05-09 03:34:35
1587606	28067	saigyoujinoriko	2026-05-09 03:26:49
1587605	28084	kyunzi	2026-05-09 03:22:25
1587604	28067	saigyoujinoriko	2026-05-09 03:02:09
1587603	28084	kyunzi	2026-05-09 03:01:54
1587602	28067	saigyoujinoriko	2026-05-09 02:58:35
1587601	30419	ntstocky	2026-05-09 02:48:43
1587600	28084	kyunzi	2026-05-09 02:41:53
1587599	30419	ntstocky	2026-05-09 02:37:36
1587598	30419	ntstocky	2026-05-09 02:31:02
1587597	30419	ntstocky	2026-05-09 02:26:08
1587596	1761	Brunanter	2026-05-09 02:15:33
1587595	30419	ntstocky	2026-05-09 02:12:10
1587594	28067	saigyoujinoriko	2026-05-09 02:10:39
1587593	30419	ntstocky	2026-05-09 02:10:34
1587592	28084	kyunzi	2026-05-09 02:09:06
1587591	30419	ntstocky	2026-05-09 02:09:04
1587590	30419	ntstocky	2026-05-09 02:08:24
1587589	17286	ItsTybear	2026-05-09 02:03:49
1587588	29007	ntnmchdo	2026-05-09 02:01:36
1587587	27579	PoisonDog522	2026-05-09 01:55:58
1587586	29007	ntnmchdo	2026-05-09 01:50:17
1587585	23845	Brothie	2026-05-09 01:47:39
1587584	27290	Berdly	2026-05-09 01:46:23
1587583	22998	Tomikals	2026-05-09 01:34:32
1587582	30260	3R1N	2026-05-09 01:26:12
1587581	1761	Brunanter	2026-05-09 01:22:55
1587580	3225	zhenkang	2026-05-09 01:20:40
1587579	26856	jr000	2026-05-09 01:18:31
1587578	24720	blz	2026-05-09 01:17:03
1587577	22998	Tomikals	2026-05-09 01:16:08
1587576	30260	3R1N	2026-05-09 01:15:33

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