Quality control queries: Difference between revisions
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
order by ?label | order by ?label | ||
</pre> | </pre> | ||
[http://172.17.10.220:8834/embed.html#SELECT%20%3Flabel%20%3Flink%0AWHERE%0A%7B%0A%20%3Fitem%20rdfs%3Alabel%20%3Flabel%20.%0A%20FILTER%28%28LANG%28%3Flabel%29%29%20%3D%20%22en%22%29%0A%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP8%20%3Ftype%20%7D%0A%20BIND%28IRI%28CONCAT%28%27http%3A%2F%2F10.5.32.142%3A8181%2Fwiki%2FItem%3A%27%2C%20REPLACE%28%20str%28%3Fitem%29%20%2C%20%27http%3A%2F%2Fwikibase.svc%2Fentity%2F%27%2C%20%27%27%20%29%29%29%20AS%20%3Flink%20%29%0A%7D%0Aorder%20by%20% | [http://172.17.10.220:8834/embed.html#SELECT%20%3Flabel%20%3Flink%0AWHERE%0A%7B%0A%20%3Fitem%20rdfs%3Alabel%20%3Flabel%20.%0A%20FILTER%28%28LANG%28%3Flabel%29%29%20%3D%20%22en%22%29%0A%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP8%20%3Ftype%20%7D%0A%20BIND%28IRI%28CONCAT%28%27http%3A%2F%2F10.5.32.142%3A8181%2Fwiki%2FItem%3A%27%2C%20REPLACE%28%20str%28%3Fitem%29%20%2C%20%27http%3A%2F%2Fwikibase.svc%2Fentity%2F%27%2C%20%27%27%20%29%29%29%20AS%20%3Flink%20%29%0A%7D%0Aorder%20by%20%3Flabel Try it out!] | ||
== Places without a Wikidata identifier (also check if they are really places) == | == Places without a Wikidata identifier (also check if they are really places) == | ||
Revision as of 17:52, 8 December 2020
Missing instance statements
Get a list of Item pages that lack an "instance of" declaration:
SELECT ?label ?link
WHERE
{
?item rdfs:label ?label .
FILTER((LANG(?label)) = "en")
FILTER NOT EXISTS { ?item wdt:P8 ?type }
BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?item) , 'http://wikibase.svc/entity/', '' ))) AS ?link )
}
order by ?label
Places without a Wikidata identifier (also check if they are really places)
# Return all places that lack a Wikidata identifier.
SELECT ?label ?link
WHERE
{
?item wdt:P8 wd:Q10 ; rdfs:label ?label .
FILTER NOT EXISTS { ?item wdt:P107 ?id } .
BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?item) , 'http://wikibase.svc/entity/', '' ))) AS ?link )
}
order by ?label