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
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
| 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:}} |}
Could not get 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 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 |
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 |
| Rivers in Mergania: ways | |
|---|---|
| Name | Map |
| Farau Way | |
| Farau Way |
| Rivers in Mergania: relations | |
|---|---|
| Name | Map |
| Farau Relation |
| Rivers in Mergania: relations | |
|---|---|
| Name | Map |
| Farau Relation | |
| Rivers in Mergania |
new relation
| Rivers in Mergania | |
|---|---|
| Name | Map |
| Rivers in Mergania | |
|---|---|
| Name | Map |
| Fluss z | |
| Bach y | |
| Fluss y | |
| Bach x | |
| Fluss x |
| Rivers in Mergania | |
|---|---|
| Name | Map |
| Fluss 1 | |
| Fluss 2 | |
| Bach 1 | |
| Rivers in Mergania |
further
| Aerotheon Group | ||||
|---|---|---|---|---|
| Name | Country | City | Products | Map |
| Aerotheon | Mergania | Gubenau | aircraft | |
| Aerotheon | Mergania | Lansing | aircraft | |
| Aerotheon Port II | Mergania | Lilienthal | aircraft | |
| Aerotheon | Mergania | Lilienthal | aircraft | |
| Aerotheon Port I | Mergania | Lilienthal | ||
| AEROTHEON Wing Technology Development Center | Mergania | Lillenthal | ||
Test count
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 |
|---|
| Name | Length (km) |
Drains into |
|---|
}}ii6
uu
count=/osm/count/@total
count=/osm/count/tag[@k='total']/@v