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
1586716 22566 Olejowy 2026-05-04 21:18:03
1586715 14788 Geoc3ladus 2026-05-04 21:17:44
1586714 26856 jr000 2026-05-04 21:17:22
1586713 4711 logasa1 2026-05-04 21:16:28
1586712 1141 Imperator 2026-05-04 21:14:51
1586711 18 Easky30 2026-05-04 21:01:23
1586710 22998 Tomikals 2026-05-04 20:59:23
1586709 25969 MarchisioThePal 2026-05-04 20:57:59
1586708 1510 anakes 2026-05-04 20:57:00
1586707 28815 JasmineDM 2026-05-04 20:49:10
1586706 1510 anakes 2026-05-04 20:46:36
1586705 1510 anakes 2026-05-04 20:46:25
1586704 26434 Bulest 2026-05-04 20:29:58
1586703 30441 Glebb 2026-05-04 20:28:15
1586702 30441 Glebb 2026-05-04 20:27:28
1586701 26856 jr000 2026-05-04 20:27:25
1586700 30441 Glebb 2026-05-04 20:23:01
1586699 26856 jr000 2026-05-04 20:21:23
1586698 30441 Glebb 2026-05-04 20:21:09
1586697 22566 Olejowy 2026-05-04 20:20:48
1586696 26856 jr000 2026-05-04 20:16:23
1586695 26434 Bulest 2026-05-04 20:16:11
1586694 26855 MiniMapper 2026-05-04 20:13:01
1586693 28815 JasmineDM 2026-05-04 20:07:02
1586692 14612 Glauber 2026-05-04 19:39:34
1586691 12340 infinatious 2026-05-04 19:34:28
1586690 29951 TheRealStanPines 2026-05-04 19:31:37
1586689 12340 infinatious 2026-05-04 19:29:58
1586688 22566 Olejowy 2026-05-04 19:18:40
1586687 1017 ratsoff2u 2026-05-04 19:09:40
1586686 28388 xoxasochka 2026-05-04 19:06:21
1586685 18 Easky30 2026-05-04 19:01:21
1586684 16354 Gonzy 2026-05-04 18:58:28
1586683 1510 anakes 2026-05-04 18:50:08
1586682 18 Easky30 2026-05-04 18:48:54
1586681 1267 Leowezy 2026-05-04 18:48:30
1586680 1267 Leowezy 2026-05-04 18:46:58
1586679 1405 tule00 2026-05-04 18:23:22
1586678 30408 Avery 2026-05-04 18:13:25
1586677 28989 HugoC01 2026-05-04 18:02:41
1586676 29297 Pst42 2026-05-04 17:49:51
1586675 22998 Tomikals 2026-05-04 17:46:19
1586674 1017 ratsoff2u 2026-05-04 17:44:52
1586673 18 Easky30 2026-05-04 17:40:47
1586672 16354 Gonzy 2026-05-04 17:40:24
1586671 1017 ratsoff2u 2026-05-04 17:39:51
1586670 28815 JasmineDM 2026-05-04 17:38:47
1586669 22998 Tomikals 2026-05-04 17:33:39
1586668 1139 Rasmus Rasmusson 2026-05-04 17:30:02
1586667 28815 JasmineDM 2026-05-04 17:22:08
1586666 1139 Rasmus Rasmusson 2026-05-04 17:15:30
1586665 29020 kz-star 2026-05-04 17:11:43
1586664 1017 ratsoff2u 2026-05-04 17:10:59
1586663 28388 xoxasochka 2026-05-04 17:06:45
1586662 17286 ItsTybear 2026-05-04 17:06:10
1586661 1139 Rasmus Rasmusson 2026-05-04 16:58:38
1586660 28388 xoxasochka 2026-05-04 16:58:23
1586659 12340 infinatious 2026-05-04 16:57:36
1586658 28388 xoxasochka 2026-05-04 16:57:13
1586657 28815 JasmineDM 2026-05-04 16:50:10
1586656 30250 Haksi Tiao 2026-05-04 16:43:37
1586655 27948 dev_null_42 2026-05-04 16:42:49
1586654 25969 MarchisioThePal 2026-05-04 16:33:35
1586653 29029 林雨霞 2026-05-04 16:24:56
1586652 29068 Ďaq Deg Lińh Qiēd 2026-05-04 16:23:09
1586651 25343 raxx 2026-05-04 16:21:10
1586650 1017 ratsoff2u 2026-05-04 16:18:48
1586649 25343 raxx 2026-05-04 15:58:54
1586648 1956 kingfries 2026-05-04 15:53:57
1586647 25343 raxx 2026-05-04 15:52:44
1586646 28388 xoxasochka 2026-05-04 15:46:42
1586645 25343 raxx 2026-05-04 15:43:39
1586644 30250 Haksi Tiao 2026-05-04 15:40:59
1586643 28388 xoxasochka 2026-05-04 15:40:56
1586642 1956 kingfries 2026-05-04 15:39:34
1586641 28388 xoxasochka 2026-05-04 15:32:46
1586640 28388 xoxasochka 2026-05-04 15:32:09
1586639 28388 xoxasochka 2026-05-04 15:31:23
1586638 28388 xoxasochka 2026-05-04 15:30:41
1586637 1017 ratsoff2u 2026-05-04 15:27:40
1586636 29068 Ďaq Deg Lińh Qiēd 2026-05-04 15:13:32
1586635 1017 ratsoff2u 2026-05-04 15:06:04
1586634 1017 ratsoff2u 2026-05-04 15:01:40
1586633 30250 Haksi Tiao 2026-05-04 15:00:41
1586632 22566 Olejowy 2026-05-04 14:58:57
1586631 1017 ratsoff2u 2026-05-04 14:56:03
1586630 1017 ratsoff2u 2026-05-04 14:50:56
1586629 27788 pokenia_eidan 2026-05-04 14:47:04
1586628 13156 MarcustheMapper 2026-05-04 14:45:13
1586627 13156 MarcustheMapper 2026-05-04 14:43:17
1586626 1956 kingfries 2026-05-04 14:35:58
1586625 28084 kyunzi 2026-05-04 14:24:08
1586624 1017 ratsoff2u 2026-05-04 13:56:51
1586623 26066 Masyas 2026-05-04 13:44:05
1586622 22566 Olejowy 2026-05-04 13:30:08
1586621 2322 Toadwart 2026-05-04 13:05:18
1586620 11407 Martinawa 2026-05-04 13:02:33
1586619 28084 kyunzi 2026-05-04 12:59:22
1586618 30250 Haksi Tiao 2026-05-04 12:51:31
1586617 30250 Haksi Tiao 2026-05-04 12:49:00


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"