OpenSeaMap-dev:Lights-WP-WD: Unterschied zwischen den Versionen

Aus OpenSeaMap-dev
Wechseln zu: Navigation, Suche
(Die Seite wurde neu angelegt: „{|border="0" cellpadding="6" cellspacing="0" width="100%" !style="background:#E3E3E3;" | Deutsch !style="background:#E3E3E3;…“)
 
K (OSM)
 
(4 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
{|border="0" cellpadding="6" cellspacing="0" width="100%"
+
{| border="0" cellpadding="6" cellspacing="0" width="100%"
!style="background:#E3E3E3;" | [[OpenSeaMap-dev:De:Lights-WP-WD|Deutsch]]
+
! style="background:#E3E3E3;" | [[OpenSeaMap-dev:De:Lights-WP-WD|Deutsch]]
!style="background:#E3E3E3;" | [[OpenSeaMap-dev:Lights-WP-WD|English]]
+
! style="background:#E3E3E3;" | [[OpenSeaMap-dev:Lights-WP-WD|English]]
!style="background:#E3E3E3; width:100%;" |  
+
! style="background:#E3E3E3; width:100%;" |  
 
|}
 
|}
  
  
please translate...
+
[[File:Leuchtfeuer mit Wikidata auf OpenSeaMap.jpg|right|300px]]
 +
[[Datei:Lights-WP-WD.jpg|thumb|Structure]]
 +
 
 +
Store all lighthouses-/lights-data in '''Wikidata''', <br> and from there show together with article-links und pictures in '''OpenSeaMap'''.
 +
 
 +
== Aim ==
 +
; Nautical lights in Wikidata
 +
: store all lighthouse-/lights-data in [[wikipedia:de:Wikidata|Wikidata]]. <br> You can use the data from there as you like:
 +
:* in all WP-articles
 +
:* in WP-infoboxes
 +
:* in all lists in any combinations
 +
:* across languages
 +
: By this, you need to catch the data only once for the whole world, and maintain it central.
 +
 
 +
; Lights in OpenSeaMap
 +
: Show all lights on OpenSeaMap:
 +
:* Positions as marker in OpenSeaMap
 +
:* Link to Wikipedia
 +
:* Pictures from Commons
 +
:* Data from OSM/Wikidata
 +
 
 +
== Daten ==
 +
{| class="wikitable"
 +
! Source || Number || Link || Remarks
 +
|-
 +
| OSM || 40'000 ||  ||
 +
|-
 +
| Wikipedia:de || 1390 ||  || 1390 list items, 430 Articles
 +
|-
 +
| Wikipedia:en || ~1225 ||  ||
 +
|-
 +
| Wikipedia:es ||  ||  ||
 +
|-
 +
| Commons ||  ||  ||
 +
|-
 +
| WP>OSM || 77 || [http://toolserver.org/~kolossos/osm-add-tags/index.php?lang=en&bbox=-180%2C-90%2C180%2C90&cat=Lighthouses_by_country&key=man_made&value=lighthouse&basedeep=3&types=node|ways|relation&request=Submit&iwl=yes] ||
 +
|}
 +
 
 +
=== OSM ===
 +
In OSM we have about 40'000 lights:
 +
 
 +
{| class="wikitable"
 +
! tag || Number || Remarks
 +
|-
 +
| seamark:type=light_major || 4557 || [http://taginfo.openstreetmap.org/search?q=seamark%3Atype%3Dlight_major]
 +
|-
 +
| seamark:type=light_minor || 32692 || [http://taginfo.openstreetmap.org/search?q=seamark%3Atype%3Dlight_minor]
 +
|-
 +
| seamark:type=light_vessel || 18 || [http://taginfo.openstreetmap.org/search?q=seamark%3Atype%3Dlight_vessel]
 +
|-
 +
| seamark:type=light_float || 58 || [http://taginfo.openstreetmap.org/search?q=seamark%3Atype%3Dlight_float]
 +
|}
 +
 
 +
[http://wiki.openstreetmap.org/wiki/OpenSeaMap/Lights Each object is described by attributes in a differentiated way.]
 +
 
 +
Queries via Overpass-API:
 +
[http://overpass-turbo.eu/s/2zG query link]
 +
<pre>
 +
[out:json];
 +
(
 +
  node["seamark:type"~"light_float|light_vessel|minor_light|major_light|light"]({{bbox}});>;
 +
  way["seamark:type"~"light_float|light_vessel|minor_light|major_light|light"]({{bbox}});>;
 +
);
 +
out;
 +
</pre>
 +
 
 +
=== Wikipedia ===
 +
==== Wikipedia:de ====
 +
In Wikipedia:de there are 1390 list items and 430 Articles <br>in this lists about lights:
 +
 
 +
{| class="wikitable"
 +
! List || Number || Artile || Remarks
 +
|-
 +
| [[wikipedia:de:Liste_von_Leuchttürmen_in_Europa|Lighthouses in Europe]]
 +
| 359 || 204 ||
 +
|-
 +
| [[wikipedia:de:Liste_der_Leuchttürme_in_Dänemark|Lighthouses in Europa-Dänemark]]
 +
| 98 || 17 ||
 +
|-
 +
| [[wikipedia:de:Liste_der_Leuchttürme_in_Norwegen|Lighthouses in Europa-Norwegen]]
 +
| 155 || 40 ||
 +
|-
 +
| [[wikipedia:de:Liste_der_Leuchttürme_in_Estland|Lighthouses in Europa-Estland]]
 +
| 45 || 4 ||
 +
|-
 +
| [[wikipedia:de:Liste_der_Leuchttürme_in_Friesland|Lighthouses in Europa-Friesland]]
 +
| 9 || 8 ||
 +
|-
 +
| [[wikipedia:de:Liste_von_Leuchttürmen_in_Spanien|Lighthouses in Europa-Spanien]]
 +
| 244 || 7 ||
 +
|-
 +
| [[wikipedia:de:Liste_der_Leuchttürme_in_England|Lighthouses in Europa-England]]
 +
| 72 || 13 ||
 +
|-
 +
| [[wikipedia:de:Liste_der_Leuchttürme_in_Schottland|Lighthouses in Europa-Schottland]]
 +
| 82 || 19 ||
 +
|-
 +
| [[wikipedia:de:Liste_von_Leuchttürmen_in_Afrika|Lighthouses in Afrika]]
 +
| 35 || 9 ||
 +
|-
 +
| [[wikipedia:de:Liste_von_Leuchttürmen_in_Asien|Lighthouses in Asien]]
 +
| 18 || 4 ||
 +
|-
 +
| [[wikipedia:de:Liste_der_Leuchttürme_in_Osttimor|Lighthouses in Asien-Osttimor]]
 +
| 3 || 0 || in Asien einarbeiten
 +
|-
 +
| [[wikipedia:de:Liste_amerikanischer_Leuchttürmen|Lighthouses in Amerika]]
 +
| 52 || 42 ||
 +
|-
 +
| [[wikipedia:de:Liste_australischer_Leuchttürme_und_Feuerschiffe|Lighthouses in Australien]]
 +
| 192 || 30 ||
 +
|-
 +
| [[wikipedia:de:Liste_der_Leuchttürme_in_Neuseeland|Lighthouses in Neuseeland]]
 +
| 26 || 23 ||
 +
|}
 +
 
 +
[[wikipedia:de:Kategorie:Leuchtturm_in_Europa|Kategory:Leuchtturm_in_Europa]] is used 298 times.
 +
 
 +
==== Infobox "Leuchtturm" ====
 +
'''de:''' [[wikipedia:de:Vorlage:Infobox_Leuchtturm|Vorlage:Infobox_Leuchtturm]] is used 42 articles.
 +
<br> [https://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Vorlagen/Werkstatt/Archiv_2012/1#Vorlage:Infobox_Leuchtturm Thaughts about Infobox]
 +
 
 +
'''en:''' [[wikipedia:en:Template:Infobox_lighthouse|Template:Infobox_lighthouse]] is used in 42 articles.
 +
<br> s.a. [[wikipedia:en:Template_talk:Infobox_lighthouse|Infobox_lighthouse Talk]]
 +
 
 +
==== Woring groups ====
 +
* [https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Lighthouses WikiProject_Lighthouses]
 +
* [https://de.wikipedia.org/wiki/Portal:Schifffahrt/Leuchtfeuer Portal:Schifffahrt/Leuchtfeuer]
 +
 
 +
=== Wikidata ===
 +
{| class="wikitable"
 +
! Class || Query || Number || Chart|| Remarks
 +
|-
 +
| [https://www.wikidata.org/wiki/Q44782 39715]
 +
| [http://tools.wmflabs.org/wikidata-todo/autolist.html?q=CLAIM%5B31:39715%5D Lighthouses]
 +
| 1687 (2014.04) <br>1997 (2014-11) <br>2136 (2015-03) <br>2333 (2016-03)
 +
| [https://tools.wmflabs.org/wiwosm/osm-on-ol/kml-on-ol.php?lang=en&uselang=en&zoom=3&lat=0&lon=0&classes=39715 Chart]
 +
|
 +
|}
 +
 
 +
Gibt es noch andere Klassen? (Leuchtfeuer, nautical light, ...)
 +
 
 +
=== Commons ===
 +
[[File:Leuchtturm_roter_sand.jpg|thumb|Bild]]
 +
 
 +
In Commons there are a few hundreds pictures [[commons:Lighthouse|commons:Lighthouse]] <br> and many categories and subcategories:
 +
* [[commons:Category:Lighthouses|Category:Lighthouses]]
 +
* 125 [[commons:Category:Lighthouses_by_country|Category:Lighthouses_by_coutry]]
 +
 
 +
== Example ==
 +
; Roter Sand
 +
: [http://map.openseamap.org/?zoom=13&mlat=53.85557&mlon=8.08198&mtext=Roter%20Sand&layers=BFTFFFTFFTT0FFFFFTFF OpenSeaMap]
 +
: Wikipedia: [https://de.wikipedia.org/wiki/Roter_Sand Roter_Sand]
 +
: Commons: [https://commons.wikimedia.org/wiki/Category:Leuchtturm_Roter_Sand Category:Leuchtturm_Roter_Sand]
 +
: Wikidata: [https://www.wikidata.org/wiki/Q220034 Q220034]
 +
: Resonator: [http://tools.wmflabs.org/reasonator/?q=Q220034 Q220034]
 +
: OSM-DB: [https://www.openstreetmap.org/node/635484478 node/635484478]
 +
 
 +
; Alte Weser
 +
: [http://map.openseamap.org/?zoom=14&mlat=53.86412&mlon=8.12756&mtext=Alte%20Weser&layers=BTTFFFTFFTT0FFFFFTFF OpenSeaMap]
 +
: Wikipedia: [https://de.wikipedia.org/wiki/Alte_Weser Alte_Weser]
 +
: Commons: [https://commons.wikimedia.org/wiki/Category:Leuchtturm_Alte_Weser Category:Leuchtturm_Alte_Weser]
 +
: Wikidata: [https://www.wikidata.org/wiki/Q436392 Q436392]
 +
: Resonator: [http://tools.wmflabs.org/reasonator/?q=Q436392 Q436392]
 +
: OSM-DB: [https://www.openstreetmap.org/node/538969144 node/538969144]
 +
 
 +
; Kiel
 +
: [http://map.openseamap.org/map/?zoom=18&mlat=54.49961&mlon=10.27368&mtext=Leuchtturm_Kiel&layers=BFTTFFTFFTF0FFFFFFFF OpenSeaMap]
 +
: Wikipedia: [https://de.wikipedia.org/wiki/Leuchtturm_Kiel Leuchtturm_Kiel]
 +
: Commons: [https://commons.wikimedia.org/wiki/Category:Leuchtturm_Kiel Category:Leuchtturm_Kiel]
 +
: Wikidata: [https://www.wikidata.org/wiki/Q1821432 Q1821432]
 +
: Resonator: [http://tools.wmflabs.org/reasonator/?q=Q1821432 Q1821432]
 +
: OSM-DB: [https://www.openstreetmap.org/node/330119702 node/330119702]
 +
 
 +
== ToDo ==
 +
=== Concept ===
 +
Wich data should be in which DB the "Master"?
 +
: OSM
 +
: WD
 +
 
 +
How we get the DBs congruent?
 +
 
 +
How we can manage inconsistencies?
 +
 
 +
=== Wikidata-classes ===
 +
We need a class for lights in WD.
 +
 
 +
This class has to picture this structures:
 +
: OSM-class "seamark:light"
 +
: [[wikipedia:de:Vorlage:Infobox_Leuchtturm|Vorlage:Infobox_Leuchtturm]]
 +
 
 +
All lights in WP needs to be entered as objects in this WD-class.
 +
 
 +
All lights in OSM needs to be entered as objects in this WD-class.
 +
 
 +
=== WP-link in OSM ===
 +
All lights in WP needs to be entered as WP-Link in OSM
 +
 
 +
=== Tools ===
 +
Script a tool/GUI which search all WP-links in OSM and write this into WD.
 +
 
 +
Script a tool/GUI which searches all OSM-lights and write this into WD. <br>
 +
 
 +
== Attribute-List ==
 +
{| class="wikitable"
 +
! Key || Value list || Typ || Source || Remarks
 +
|-
 +
| name:lol || * || str || OSM: seamark:name || ASCII
 +
|-
 +
| ref || a ##### || str || OSM: seamark:light:ref ||
 +
|-
 +
| lat || g,gggggg || real || OSM || - = Süd
 +
|-
 +
| lon || g,gggggg || real || OSM || + = West
 +
|-
 +
| hight_of_fire || ###,# || int || OSM: seamark:light:hight || Feuerhöhe
 +
|-
 +
| hight_of_tower || ###,# || int || OSM: seamark:landmark:hight || Turmhöhe
 +
|-
 +
| range:w || ## || int || OSM: seamark:light:range || Maximum of w/r/g
 +
|-
 +
| .. ||  ||  ||  ||
 +
|-
 +
|  ||  ||  ||  ||
 +
|-
 +
|  ||  ||  ||  ||
 +
|-
 +
|  ||  ||  ||  ||
 +
|-
 +
|  ||  ||  ||  ||
 +
|}
 +
 
 +
== Wikidata ==
 +
=== Data strukture ===
 +
[https://www.wikidata.org/wiki/Q776666 Exemple]
 +
 
 +
{| class="wikitable"
 +
! Field name || Typ || Format || Remarks || Exemple
 +
|-
 +
| ID || incrementel ||  ||  ||
 +
|-
 +
| right_ref-nr || String ||  ||  ||
 +
|-
 +
| position || Coordinate || LAT/LON ||  ||
 +
|-
 +
| name_lol || String || ASCII || like in List of Lights ||
 +
|-
 +
| name_local || String || UTF-8 || local language und writing system ||
 +
|-
 +
| wp-link || URL ||  ||  ||
 +
|-
 +
| commons-link || URL ||  ||  ||
 +
|-
 +
| light_hight || Quantity || m,mm || light hight about sea ||
 +
|-
 +
| .. ||  ||  ||  ||
 +
|}
 +
 
 +
== Exemple of OSM-Code ==
 +
OSM-code about "Alte Weser":
 +
 
 +
<pre>
 +
<?xml version='1.0' encoding='UTF-8'?>
 +
<osm version='0.6' upload='true' generator='JOSM'>
 +
  <bounds minlat='53.8629884' minlon='8.1265541' maxlat='53.8637962' maxlon='8.1282868' origin='CGImap 0.3.3 (29865 thorn-03.openstreetmap.org)' />
 +
  <node id='538969144' timestamp='2014-04-29T16:56:32Z' uid='449569' user='Nautic' visible='true' version='14' changeset='22026785' lat='53.8634041' lon='8.1275255'>
 +
    <tag k='building:height' v='40' />
 +
    <tag k='man_made' v='lighthouse' />
 +
    <tag k='name' v='Leuchtturm Alte Weser' />
 +
    <tag k='ref' v='B 1188' />
 +
    <tag k='seamark:fog_signal:category' v='horn' />
 +
    <tag k='seamark:fog_signal:group' v='AL' />
 +
    <tag k='seamark:fog_signal:period' v='60' />
 +
    <tag k='seamark:information' v='Fog detector light' />
 +
    <tag k='seamark:light:10:character' v='F' />
 +
    <tag k='seamark:light:10:colour' v='white' />
 +
    <tag k='seamark:light:10:radius' v='0.8' />
 +
    <tag k='seamark:light:10:sector_end' v='238' />
 +
    <tag k='seamark:light:10:sector_start' v='196' />
 +
    <tag k='seamark:light:11:character' v='F' />
 +
    <tag k='seamark:light:11:colour' v='white' />
 +
    <tag k='seamark:light:11:radius' v='0.8' />
 +
    <tag k='seamark:light:11:sector_end' v='352' />
 +
    <tag k='seamark:light:11:sector_start' v='288' />
 +
    <tag k='seamark:light:12:character' v='F' />
 +
    <tag k='seamark:light:12:colour' v='red' />
 +
    <tag k='seamark:light:12:radius' v='0.7' />
 +
    <tag k='seamark:light:12:sector_end' v='3' />
 +
    <tag k='seamark:light:12:sector_start' v='352' />
 +
    <tag k='seamark:light:1:character' v='F' />
 +
    <tag k='seamark:light:1:colour' v='white' />
 +
    <tag k='seamark:light:1:radius' v='0.8' />
 +
    <tag k='seamark:light:1:sector_end' v='17' />
 +
    <tag k='seamark:light:1:sector_start' v='3' />
 +
    <tag k='seamark:light:2:character' v='F' />
 +
    <tag k='seamark:light:2:colour' v='green' />
 +
    <tag k='seamark:light:2:radius' v='0.6' />
 +
    <tag k='seamark:light:2:sector_end' v='45' />
 +
    <tag k='seamark:light:2:sector_start' v='17' />
 +
    <tag k='seamark:light:3:character' v='F' />
 +
    <tag k='seamark:light:3:colour' v='white' />
 +
    <tag k='seamark:light:3:radius' v='0.8' />
 +
    <tag k='seamark:light:3:sector_end' v='74' />
 +
    <tag k='seamark:light:3:sector_start' v='45' />
 +
    <tag k='seamark:light:4:character' v='F' />
 +
    <tag k='seamark:light:4:colour' v='green' />
 +
    <tag k='seamark:light:4:radius' v='0.6' />
 +
    <tag k='seamark:light:4:sector_end' v='118' />
 +
    <tag k='seamark:light:4:sector_start' v='74' />
 +
    <tag k='seamark:light:5:character' v='F' />
 +
    <tag k='seamark:light:5:colour' v='white' />
 +
    <tag k='seamark:light:5:radius' v='0.8' />
 +
    <tag k='seamark:light:5:sector_end' v='123' />
 +
    <tag k='seamark:light:5:sector_start' v='118' />
 +
    <tag k='seamark:light:6:character' v='F' />
 +
    <tag k='seamark:light:6:colour' v='red' />
 +
    <tag k='seamark:light:6:radius' v='0.7' />
 +
    <tag k='seamark:light:6:sector_end' v='140' />
 +
    <tag k='seamark:light:6:sector_start' v='123' />
 +
    <tag k='seamark:light:7:character' v='F' />
 +
    <tag k='seamark:light:7:colour' v='green' />
 +
    <tag k='seamark:light:7:radius' v='0.6' />
 +
    <tag k='seamark:light:7:sector_end' v='175' />
 +
    <tag k='seamark:light:7:sector_start' v='140' />
 +
    <tag k='seamark:light:8:character' v='F' />
 +
    <tag k='seamark:light:8:colour' v='white' />
 +
    <tag k='seamark:light:8:radius' v='0.8' />
 +
    <tag k='seamark:light:8:sector_end' v='183' />
 +
    <tag k='seamark:light:8:sector_start' v='175' />
 +
    <tag k='seamark:light:9:character' v='F' />
 +
    <tag k='seamark:light:9:colour' v='red' />
 +
    <tag k='seamark:light:9:radius' v='0.7' />
 +
    <tag k='seamark:light:9:sector_end' v='196' />
 +
    <tag k='seamark:light:9:sector_start' v='183' />
 +
    <tag k='seamark:name' v='Alte Weser' />
 +
    <tag k='seamark:reference' v='B 1188' />
 +
    <tag k='seamark:type' v='landmark' />
 +
    <tag k='source' v='US NGA Pub. 114. 2011-04-02' />
 +
    <tag k='wikidata' v='Q436392' />
 +
    <tag k='wikipedia' v='de:Alte Weser' />
 +
  </node>
 +
</osm>
 +
</pre>
 +
 
 +
== Lösungen ==
 +
Hier sammeln wir Lösungen und Lösungs-Ideen.
 +
 
 +
=== Bilder aus Commons ===
 +
Zu einem Buch bibt es eine Bildersammlung: Buchtext, Portraits der Autoren ([https://tools.wmflabs.org/reasonator/?&q=22070167 WD-Beispiel])
 +
 
 +
=== Platzhalter für Artikel ===
 +
Beispiel für eine Article-Placeholder-Seite für ein Leuchtfeuer, für das noch kein Artikel existiert:
 +
https://nn.wikipedia.org/wiki/Spesial:AboutTopic/Q432291
 +
 
 +
Falls ein Artikel existiert, findet automatisch eine Weiterleitung statt. Man braucht also nur die Special:AboutTopic-Adresse und muss sich um nichts weiter kümmern.
 +
 
 +
Das funktioniert aktuell nur in sehr wenigen kleinen Wikis, in denen der Article-Placeholder ausgeliefert ist.

Aktuelle Version vom 2. Oktober 2016, 07:43 Uhr

Deutsch English


Leuchtfeuer mit Wikidata auf OpenSeaMap.jpg
Structure

Store all lighthouses-/lights-data in Wikidata,
and from there show together with article-links und pictures in OpenSeaMap.

Aim

Nautical lights in Wikidata
store all lighthouse-/lights-data in Wikidata.
You can use the data from there as you like:
  • in all WP-articles
  • in WP-infoboxes
  • in all lists in any combinations
  • across languages
By this, you need to catch the data only once for the whole world, and maintain it central.
Lights in OpenSeaMap
Show all lights on OpenSeaMap:
  • Positions as marker in OpenSeaMap
  • Link to Wikipedia
  • Pictures from Commons
  • Data from OSM/Wikidata

Daten

Source Number Link Remarks
OSM 40'000
Wikipedia:de 1390 1390 list items, 430 Articles
Wikipedia:en ~1225
Wikipedia:es
Commons
WP>OSM 77 ways|relation&request=Submit&iwl=yes]

OSM

In OSM we have about 40'000 lights:

tag Number Remarks
seamark:type=light_major 4557 [1]
seamark:type=light_minor 32692 [2]
seamark:type=light_vessel 18 [3]
seamark:type=light_float 58 [4]

Each object is described by attributes in a differentiated way.

Queries via Overpass-API: query link

[out:json];
(
  node["seamark:type"~"light_float|light_vessel|minor_light|major_light|light"]({{bbox}});>;
  way["seamark:type"~"light_float|light_vessel|minor_light|major_light|light"]({{bbox}});>;
);
out;

Wikipedia

Wikipedia:de

In Wikipedia:de there are 1390 list items and 430 Articles
in this lists about lights:

List Number Artile Remarks
Lighthouses in Europe 359 204
Lighthouses in Europa-Dänemark 98 17
Lighthouses in Europa-Norwegen 155 40
Lighthouses in Europa-Estland 45 4
Lighthouses in Europa-Friesland 9 8
Lighthouses in Europa-Spanien 244 7
Lighthouses in Europa-England 72 13
Lighthouses in Europa-Schottland 82 19
Lighthouses in Afrika 35 9
Lighthouses in Asien 18 4
Lighthouses in Asien-Osttimor 3 0 in Asien einarbeiten
Lighthouses in Amerika 52 42
Lighthouses in Australien 192 30
Lighthouses in Neuseeland 26 23

Kategory:Leuchtturm_in_Europa is used 298 times.

Infobox "Leuchtturm"

de: Vorlage:Infobox_Leuchtturm is used 42 articles.
Thaughts about Infobox

en: Template:Infobox_lighthouse is used in 42 articles.
s.a. Infobox_lighthouse Talk

Woring groups

Wikidata

Class Query Number Chart Remarks
39715 Lighthouses 1687 (2014.04)
1997 (2014-11)
2136 (2015-03)
2333 (2016-03)
Chart

Gibt es noch andere Klassen? (Leuchtfeuer, nautical light, ...)

Commons

Bild

In Commons there are a few hundreds pictures commons:Lighthouse
and many categories and subcategories:

Example

Roter Sand
OpenSeaMap
Wikipedia: Roter_Sand
Commons: Category:Leuchtturm_Roter_Sand
Wikidata: Q220034
Resonator: Q220034
OSM-DB: node/635484478
Alte Weser
OpenSeaMap
Wikipedia: Alte_Weser
Commons: Category:Leuchtturm_Alte_Weser
Wikidata: Q436392
Resonator: Q436392
OSM-DB: node/538969144
Kiel
OpenSeaMap
Wikipedia: Leuchtturm_Kiel
Commons: Category:Leuchtturm_Kiel
Wikidata: Q1821432
Resonator: Q1821432
OSM-DB: node/330119702

ToDo

Concept

Wich data should be in which DB the "Master"?

OSM
WD

How we get the DBs congruent?

How we can manage inconsistencies?

Wikidata-classes

We need a class for lights in WD.

This class has to picture this structures:

OSM-class "seamark:light"
Vorlage:Infobox_Leuchtturm

All lights in WP needs to be entered as objects in this WD-class.

All lights in OSM needs to be entered as objects in this WD-class.

WP-link in OSM

All lights in WP needs to be entered as WP-Link in OSM

Tools

Script a tool/GUI which search all WP-links in OSM and write this into WD.

Script a tool/GUI which searches all OSM-lights and write this into WD.

Attribute-List

Key Value list Typ Source Remarks
name:lol * str OSM: seamark:name ASCII
ref a ##### str OSM: seamark:light:ref
lat g,gggggg real OSM - = Süd
lon g,gggggg real OSM + = West
hight_of_fire ###,# int OSM: seamark:light:hight Feuerhöhe
hight_of_tower ###,# int OSM: seamark:landmark:hight Turmhöhe
range:w ## int OSM: seamark:light:range Maximum of w/r/g
..

Wikidata

Data strukture

Exemple

Field name Typ Format Remarks Exemple
ID incrementel
right_ref-nr String
position Coordinate LAT/LON
name_lol String ASCII like in List of Lights
name_local String UTF-8 local language und writing system
wp-link URL
commons-link URL
light_hight Quantity m,mm light hight about sea
..

Exemple of OSM-Code

OSM-code about "Alte Weser":

<?xml version='1.0' encoding='UTF-8'?>
<osm version='0.6' upload='true' generator='JOSM'>
  <bounds minlat='53.8629884' minlon='8.1265541' maxlat='53.8637962' maxlon='8.1282868' origin='CGImap 0.3.3 (29865 thorn-03.openstreetmap.org)' />
  <node id='538969144' timestamp='2014-04-29T16:56:32Z' uid='449569' user='Nautic' visible='true' version='14' changeset='22026785' lat='53.8634041' lon='8.1275255'>
    <tag k='building:height' v='40' />
    <tag k='man_made' v='lighthouse' />
    <tag k='name' v='Leuchtturm Alte Weser' />
    <tag k='ref' v='B 1188' />
    <tag k='seamark:fog_signal:category' v='horn' />
    <tag k='seamark:fog_signal:group' v='AL' />
    <tag k='seamark:fog_signal:period' v='60' />
    <tag k='seamark:information' v='Fog detector light' />
    <tag k='seamark:light:10:character' v='F' />
    <tag k='seamark:light:10:colour' v='white' />
    <tag k='seamark:light:10:radius' v='0.8' />
    <tag k='seamark:light:10:sector_end' v='238' />
    <tag k='seamark:light:10:sector_start' v='196' />
    <tag k='seamark:light:11:character' v='F' />
    <tag k='seamark:light:11:colour' v='white' />
    <tag k='seamark:light:11:radius' v='0.8' />
    <tag k='seamark:light:11:sector_end' v='352' />
    <tag k='seamark:light:11:sector_start' v='288' />
    <tag k='seamark:light:12:character' v='F' />
    <tag k='seamark:light:12:colour' v='red' />
    <tag k='seamark:light:12:radius' v='0.7' />
    <tag k='seamark:light:12:sector_end' v='3' />
    <tag k='seamark:light:12:sector_start' v='352' />
    <tag k='seamark:light:1:character' v='F' />
    <tag k='seamark:light:1:colour' v='white' />
    <tag k='seamark:light:1:radius' v='0.8' />
    <tag k='seamark:light:1:sector_end' v='17' />
    <tag k='seamark:light:1:sector_start' v='3' />
    <tag k='seamark:light:2:character' v='F' />
    <tag k='seamark:light:2:colour' v='green' />
    <tag k='seamark:light:2:radius' v='0.6' />
    <tag k='seamark:light:2:sector_end' v='45' />
    <tag k='seamark:light:2:sector_start' v='17' />
    <tag k='seamark:light:3:character' v='F' />
    <tag k='seamark:light:3:colour' v='white' />
    <tag k='seamark:light:3:radius' v='0.8' />
    <tag k='seamark:light:3:sector_end' v='74' />
    <tag k='seamark:light:3:sector_start' v='45' />
    <tag k='seamark:light:4:character' v='F' />
    <tag k='seamark:light:4:colour' v='green' />
    <tag k='seamark:light:4:radius' v='0.6' />
    <tag k='seamark:light:4:sector_end' v='118' />
    <tag k='seamark:light:4:sector_start' v='74' />
    <tag k='seamark:light:5:character' v='F' />
    <tag k='seamark:light:5:colour' v='white' />
    <tag k='seamark:light:5:radius' v='0.8' />
    <tag k='seamark:light:5:sector_end' v='123' />
    <tag k='seamark:light:5:sector_start' v='118' />
    <tag k='seamark:light:6:character' v='F' />
    <tag k='seamark:light:6:colour' v='red' />
    <tag k='seamark:light:6:radius' v='0.7' />
    <tag k='seamark:light:6:sector_end' v='140' />
    <tag k='seamark:light:6:sector_start' v='123' />
    <tag k='seamark:light:7:character' v='F' />
    <tag k='seamark:light:7:colour' v='green' />
    <tag k='seamark:light:7:radius' v='0.6' />
    <tag k='seamark:light:7:sector_end' v='175' />
    <tag k='seamark:light:7:sector_start' v='140' />
    <tag k='seamark:light:8:character' v='F' />
    <tag k='seamark:light:8:colour' v='white' />
    <tag k='seamark:light:8:radius' v='0.8' />
    <tag k='seamark:light:8:sector_end' v='183' />
    <tag k='seamark:light:8:sector_start' v='175' />
    <tag k='seamark:light:9:character' v='F' />
    <tag k='seamark:light:9:colour' v='red' />
    <tag k='seamark:light:9:radius' v='0.7' />
    <tag k='seamark:light:9:sector_end' v='196' />
    <tag k='seamark:light:9:sector_start' v='183' />
    <tag k='seamark:name' v='Alte Weser' />
    <tag k='seamark:reference' v='B 1188' />
    <tag k='seamark:type' v='landmark' />
    <tag k='source' v='US NGA Pub. 114. 2011-04-02' />
    <tag k='wikidata' v='Q436392' />
    <tag k='wikipedia' v='de:Alte Weser' />
  </node>
</osm>

Lösungen

Hier sammeln wir Lösungen und Lösungs-Ideen.

Bilder aus Commons

Zu einem Buch bibt es eine Bildersammlung: Buchtext, Portraits der Autoren (WD-Beispiel)

Platzhalter für Artikel

Beispiel für eine Article-Placeholder-Seite für ein Leuchtfeuer, für das noch kein Artikel existiert: https://nn.wikipedia.org/wiki/Spesial:AboutTopic/Q432291

Falls ein Artikel existiert, findet automatisch eine Weiterleitung statt. Man braucht also nur die Special:AboutTopic-Adresse und muss sich um nichts weiter kümmern.

Das funktioniert aktuell nur in sehr wenigen kleinen Wikis, in denen der Article-Placeholder ausgeliefert ist.