Quality control queries: Difference between revisions
Jump to navigation
Jump to search
| Line 31: | Line 31: | ||
order by ?label | order by ?label | ||
</pre> | </pre> | ||
[http://172.17.10.220:8834/embed.html Try it out!] | [http://172.17.10.220:8834/embed.html#%23%20Return%20all%20places%20that%20lack%20a%20Wikidata%20identifier.%20%0ASELECT%20%3Flabel%20%3Flink%0AWHERE%0A%7B%0A%20%3Fitem%20wdt%3AP8%20wd%3AQ10%20%3B%20rdfs%3Alabel%20%3Flabel%20.%0A%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP107%20%3Fid%20%7D%20.%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%20%0A%7D%0Aorder%20by%20%3Flabel Try it out!] | ||
Revision as of 17:53, 8 December 2020
Missing instance statements
- Return all items that are missing an "instance of" statement
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