Difference between revisions of "Develop auto tables"

From geofiction
Jump to navigation Jump to search
m
Line 7: Line 7:
 
*[[Template:Opq_data]]
 
*[[Template:Opq_data]]
 
*[[Template:Table_fill]]
 
*[[Template:Table_fill]]
 +
 +
==Workin overpass examples==
 +
 +
correct link:https://overpass.ogf.rent-a-planet.com/api/interpreter?data
 +
 +
<div class="mw-collapsible mw-collapsed">
 +
list of rivers
 +
<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">
 +
last edits
 +
<div class="mw-collapsible-content">
 +
::::::::<span class="mw-ui-button" role="button" aria-disabled="false">{{{1|[https://wiki.opengeofiction.net/index.php/OpenGeofiction:Recent_changesets?action=purge&titles=OpenGeofiction:Recent_changesets Refresh]}}}</span>{{#clear_external_data:}}
 +
{{#get_web_data:url=https://opengeofiction.net/api/0.6/changesets
 +
|format=xml
 +
|data=
 +
  changeset_id=/osm/changeset/@id
 +
,uid=/osm/changeset/@uid
 +
,user=/osm/changeset/@user
 +
,created_date=/osm/changeset/@created_at
 +
<!-- ,comment=/osm/changeset/tag[@k="comment"]/@v -->
 +
|use xpath
 +
}}
 +
{| class="wikitable sortable"
 +
! Changeset ID
 +
! User ID
 +
! User Name
 +
! Date and Time
 +
{{#display_external_table:template=ExternalDataTest01
 +
|data=changeset_id=
 +
  changeset_id
 +
,uid=uid
 +
,user=user
 +
,created_date=created_date
 +
}}
 +
|}
 +
</div></div>{{clear}}
 +
 +
  
 
==Simple tables==
 
==Simple tables==

Revision as of 17:26, 22 January 2023

Useful links

Workin overpass examples

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

list of rivers

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


last edits

Refresh
Changeset ID User ID User Name Date and Time
1608118 25343 raxx 2026-07-29 18:01:26
1608117 18 Easky30 2026-07-29 17:51:04
1608116 29515 Pole 2026-07-29 17:47:54
1608115 25343 raxx 2026-07-29 17:38:02
1608114 18 Easky30 2026-07-29 17:26:06
1608113 29272 Signal 2026-07-29 17:15:37
1608112 25870 Alexmar983 2026-07-29 17:12:35
1608111 14030 NorthTeaPower 2026-07-29 17:09:29
1608110 26752 114514aaa 2026-07-29 16:52:37
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


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://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 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=857"