Develop auto tables

From geofiction
Jump to navigation Jump to search

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
1607820 30250 Haksi Tiao 2026-07-28 07:45:01
1607819 25192 NM$l 2026-07-28 07:38:38
1607818 26752 114514aaa 2026-07-28 07:18:41
1607817 1368 Otto Yamamoto 2026-07-28 07:00:09
1607816 26752 114514aaa 2026-07-28 06:59:20
1607815 25192 NM$l 2026-07-28 06:44:29
1607814 30592 zlvh 2026-07-28 05:22:17
1607813 30250 Haksi Tiao 2026-07-28 05:17:21
1607812 27601 Ominvar 2026-07-28 05:16:28
1607811 27579 PoisonDog522 2026-07-28 05:12:03
1607810 1158 Y Knott 2026-07-28 04:56:54
1607809 1158 Y Knott 2026-07-28 04:55:34
1607808 1158 Y Knott 2026-07-28 04:53:33
1607807 21669 Kevin J 2026-07-28 04:51:53
1607806 26719 Lemuria 2026-07-28 04:43:41
1607805 26719 Lemuria 2026-07-28 04:42:53
1607804 26719 Lemuria 2026-07-28 04:42:33
1607803 12233 iiEarth 2026-07-28 04:39:47
1607802 1158 Y Knott 2026-07-28 04:34:55
1607801 30250 Haksi Tiao 2026-07-28 04:33:27
1607800 27600 ParrotMan 2026-07-28 04:28:19
1607799 1158 Y Knott 2026-07-28 04:21:59
1607798 1158 Y Knott 2026-07-28 04:13:15
1607797 17286 ItsTybear 2026-07-28 03:52:40
1607796 29019 stolas123 2026-07-28 03:38:16
1607795 19188 KTheBritMC 2026-07-28 02:43:06
1607794 1956 kingfries 2026-07-28 02:19:34
1607793 24720 blz 2026-07-28 02:10:07
1607792 30250 Haksi Tiao 2026-07-28 01:57:23
1607791 30081 CityGuy 2026-07-28 01:47:40
1607790 29951 TheRealStanPines 2026-07-28 01:40:12
1607789 29951 TheRealStanPines 2026-07-28 01:36:57
1607788 29951 TheRealStanPines 2026-07-28 01:33:18
1607787 29077 Vik 2026-07-28 01:28:46
1607786 29951 TheRealStanPines 2026-07-28 01:20:13
1607785 26719 Lemuria 2026-07-28 01:18:10
1607784 29951 TheRealStanPines 2026-07-28 01:11:21
1607783 2194 UN1TY 2026-07-28 01:07:48
1607782 1956 kingfries 2026-07-28 00:58:16
1607781 27398 Parivan 2026-07-28 00:54:25
1607780 2194 UN1TY 2026-07-28 00:52:34
1607779 1956 kingfries 2026-07-28 00:40:19
1607778 28535 SeñorR 2026-07-28 00:34:22
1607777 30655 NaR1108 2026-07-28 00:33:15
1607776 26719 Lemuria 2026-07-28 00:31:28
1607775 30655 NaR1108 2026-07-28 00:20:25
1607774 30655 NaR1108 2026-07-28 00:17:13
1607773 2194 UN1TY 2026-07-28 00:16:27
1607772 30655 NaR1108 2026-07-28 00:15:05
1607771 29077 Vik 2026-07-28 00:09:33
1607770 28112 qhfreddy 2026-07-28 00:08:08
1607769 27398 Parivan 2026-07-28 00:06:56
1607768 30655 NaR1108 2026-07-28 00:06:41
1607767 26243 Legoman 2026-07-28 00:01:00
1607766 27398 Parivan 2026-07-27 23:58:51
1607765 27398 Parivan 2026-07-27 23:51:53
1607764 30655 NaR1108 2026-07-27 23:48:41
1607763 27398 Parivan 2026-07-27 23:44:28
1607762 30655 NaR1108 2026-07-27 23:41:34
1607761 26855 MiniMapper 2026-07-27 23:39:29
1607760 30655 NaR1108 2026-07-27 23:37:15
1607759 27398 Parivan 2026-07-27 23:34:23
1607758 26093 nsenx 2026-07-27 23:33:56
1607757 27398 Parivan 2026-07-27 23:33:30
1607756 2194 UN1TY 2026-07-27 23:25:11
1607755 30655 NaR1108 2026-07-27 23:24:52
1607754 2194 UN1TY 2026-07-27 23:24:34
1607753 30081 CityGuy 2026-07-27 23:14:30
1607752 22733 Mie 2026-07-27 23:04:33
1607751 26752 114514aaa 2026-07-27 23:00:58
1607750 26855 MiniMapper 2026-07-27 22:34:46
1607749 26719 Lemuria 2026-07-27 22:11:46
1607748 1956 kingfries 2026-07-27 22:03:20
1607747 2194 UN1TY 2026-07-27 22:02:47
1607746 30260 3R1N 2026-07-27 21:54:30
1607745 1956 kingfries 2026-07-27 21:53:26
1607744 26719 Lemuria 2026-07-27 21:52:48
1607743 24578 Koziu 2026-07-27 21:49:22
1607742 2194 UN1TY 2026-07-27 21:40:42
1607741 26719 Lemuria 2026-07-27 21:35:32
1607740 30703 HT259 2026-07-27 21:31:14
1607739 27992 FoxoHorton4 2026-07-27 21:28:04
1607738 1956 kingfries 2026-07-27 21:21:34
1607737 28815 JasmineDM 2026-07-27 21:09:03
1607736 30703 HT259 2026-07-27 21:05:46
1607735 27398 Parivan 2026-07-27 21:01:08
1607734 26434 Bulest 2026-07-27 20:56:44
1607733 29515 Pole 2026-07-27 20:43:58
1607732 18 Easky30 2026-07-27 20:38:45
1607731 26855 MiniMapper 2026-07-27 20:37:23
1607730 27398 Parivan 2026-07-27 20:29:56
1607729 27398 Parivan 2026-07-27 20:24:59
1607728 30260 3R1N 2026-07-27 20:20:39
1607727 30081 CityGuy 2026-07-27 20:04:50
1607726 28815 JasmineDM 2026-07-27 19:53:28
1607725 29752 opnwix 2026-07-27 19:45:56
1607724 29515 Pole 2026-07-27 19:42:22
1607723 27992 FoxoHorton4 2026-07-27 19:38:38
1607722 22243 sudo91 2026-07-27 19:36:37
1607721 28815 JasmineDM 2026-07-27 19:33:03

Simple tables

A B C
aaaaaaa bbbbbbbbbbbbbbb ccccccccccc
A B C
aaaaaaa bbbbbbbbbbbbbbb ccccccccccc



Table MER-refresh.png
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

Table

Table MER-refresh.png
Map

x

Rivers in Mergania: nodes MER-refresh.png
Name Map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map


Rivers in Mergania: ways MER-refresh.png
Name Map
Farau Way OGFmapicon.png map
Farau Way OGFmapicon.png map


Rivers in Mergania: relations MER-refresh.png
Name Map
Farau Relation OGFmapicon.png map


Rivers in Mergania: relations MER-refresh.png
Name Map
Farau Relation OGFmapicon.png map
Rivers in Mergania OGFmapicon.png map


new relation

Rivers in Mergania MER-refresh.png
Name Map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map
OGFmapicon.png map


Rivers in Mergania MER-refresh.png
Name Map
Fluss z OGFmapicon.png map
Bach y OGFmapicon.png map
Fluss y OGFmapicon.png map
Bach x OGFmapicon.png map
Fluss x OGFmapicon.png map


Rivers in Mergania MER-refresh.png
Name Map
Fluss 1 OGFmapicon.png map
Fluss 2 OGFmapicon.png map
Bach 1 OGFmapicon.png map
Rivers in Mergania OGFmapicon.png map


further

Aerotheon Group MER-refresh.png
Name Country City Products Map
Aerotheon Mergania Gubenau aircraft OGFmapicon.png map
Aerotheon Mergania Lansing aircraft OGFmapicon.png map
Aerotheon Port II Mergania Lilienthal aircraft OGFmapicon.png map
Aerotheon Mergania Lilienthal aircraft OGFmapicon.png map
Aerotheon Port I Mergania Lilienthal OGFmapicon.png map
AEROTHEON Wing Technology Development Center Mergania Lillenthal OGFmapicon.png 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
Retrieved from "https://geofiction.lima-city.ch/index.php?title=Develop_auto_tables&oldid=861"