<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 09.09.17 07:09, Yuri Astrakhan
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAJGfNe_St=xitq++yb-OS3b1tBFgENVN9sF8PKE8jbCYxt6wTQ@mail.gmail.com">
<div dir="ltr">
<div>Hello mappers! Could anyone help with over 800 OSM objects
that are pointing to Wikipedia disambiguation pages?
Especially Polish community - 588. You can get the currently
broken ones by running the query below (you may want to modify
it a bit to list more relevant objects). If you feel brave,
there are also 25,000+ objects with incorrect Wikipedia tags.
Thanks!</div>
<div><br>
</div>
<div>Main: <a
href="https://wiki.openstreetmap.org/wiki/SPARQL_examples#OSM_objects_linking_to_Wikipedia_disambiguation_pages"
moz-do-not-send="true">OSM disambig query</a><br>
</div>
<div>Direct: <span style="color:rgb(0,0,0);white-space:pre-wrap"><a href="http://tinyurl.com/ya4lhmt8" moz-do-not-send="true">http://tinyurl.com/ya4lhmt8</a></span></div>
<div><br>
</div>
<div>Bad Wikipedia tag - could be because non-existent title, or
a redirect, or because Wikidata item hasn't been created yet: <a
href="https://wiki.openstreetmap.org/wiki/SPARQL_examples#Objects_whose_Wikipedia_tag_does_not_exist_in_Wikidata"
moz-do-not-send="true">query</a><br>
</div>
<div><br>
</div>
<div>The current statistics for Disambig pages, per
corresponding Wikipedia site:</div>
<div>// generated with <a href="http://tinyurl.com/yarkdy53"
moz-do-not-send="true">http://tinyurl.com/yarkdy53</a></div>
<div><br>
</div>
<div><a href="https://pl.wikipedia.org/" moz-do-not-send="true">https://pl.wikipedia.org/</a><span style="white-space:pre"> </span>588<br>
</div>
<div>
<div><a href="https://en.wikipedia.org/"
moz-do-not-send="true">https://en.wikipedia.org/</a><span style="white-space:pre"> </span>74</div>
<div>unknown<span style="white-space:pre"> </span>36</div>
<div><a href="https://de.wikipedia.org/"
moz-do-not-send="true">https://de.wikipedia.org/</a><span style="white-space:pre"> </span>24</div>
<div><a href="https://sv.wikipedia.org/"
moz-do-not-send="true">https://sv.wikipedia.org/</a><span style="white-space:pre"> </span>18</div>
<div><a href="https://cs.wikipedia.org/"
moz-do-not-send="true">https://cs.wikipedia.org/</a><span style="white-space:pre"> </span>17</div>
<div><a href="https://zh.wikipedia.org/"
moz-do-not-send="true">https://zh.wikipedia.org/</a><span style="white-space:pre"> </span>8</div>
<div><a href="https://uk.wikipedia.org/"
moz-do-not-send="true">https://uk.wikipedia.org/</a><span style="white-space:pre"> </span>7</div>
<div><a href="https://vi.wikipedia.org/"
moz-do-not-send="true">https://vi.wikipedia.org/</a><span style="white-space:pre"> </span>7</div>
<div><a href="https://ru.wikipedia.org/"
moz-do-not-send="true">https://ru.wikipedia.org/</a><span style="white-space:pre"> </span>5</div>
<div><a href="https://ja.wikipedia.org/"
moz-do-not-send="true">https://ja.wikipedia.org/</a><span style="white-space:pre"> </span>5</div>
</div>
<div>...</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
talk mailing list
<a class="moz-txt-link-abbreviated" href="mailto:talk@openstreetmap.org">talk@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="https://lists.openstreetmap.org/listinfo/talk">https://lists.openstreetmap.org/listinfo/talk</a>
</pre>
</blockquote>
<p>Hello Yuri,</p>
<p>I've just corrected couple of such disambiguation errors for "uk"
and "ru" Wikipedia versions. I noticed that after the correction
the corrected particular errors disappear from the consequent
query results. Not immediately, but after about 3 - 4 minutes.</p>
<p>Here is a query to display only errors for "ru" Wikipedia version
(or any other language version). I am not sure if it is optimal
but at least it displays correct results, - only for one language
version of Wikipedia.<br>
</p>
<p>SELECT ?osmId ?wdLabel ?wd ?wpTag WHERE {<br>
?osmId osmt:wikidata ?wd .<br>
OPTIONAL { ?osmId osmt:wikipedia ?wpTag . }<br>
?wd wdt:P31/wdt:P279* wd:Q4167410 .<br>
FILTER( STRSTARTS(STR(?wpTag), '<a class="moz-txt-link-freetext" href="https://ru.wikipedia">https://ru.wikipedia</a>')) .<br>
SERVICE wikibase:label { bd:serviceParam wikibase:language "ru" .
}<br>
}<br>
LIMIT 10</p>
<p>I have a question. If it is possible to display nodes on the OSM
map which has got the "wikidata=*" tag, but which do not have an
"image" statement on the Wikidata page with this tool? For
example, this Wikidata page does have already the "image"
statement: <a class="moz-txt-link-freetext" href="https://www.wikidata.org/wiki/Q17523970">https://www.wikidata.org/wiki/Q17523970</a><br>
</p>
<p>I am interested in Wikidata items which do not have an image
statement, but which are present on the OSM map.<br>
</p>
<p>It would be also interesting to display the list of Wikipedia
articles which have got the geographical coordinates in the
article itself, but which do not have wikipedia=* or wikidata=*
tag on the OSM map in the vicinity of the point with these
coordinates.</p>
<p><br>
</p>
<p>With best regards,</p>
<p>Oleksiy<br>
</p>
</body>
</html>