Quality control queries: Difference between revisions
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
== Missing instance statements == | == Missing instance statements == | ||
Get a list of Item pages that lack an "instance of" declaration: | Get a list of Item pages that lack an "instance of" declaration: | ||
<pre> | <pre> | ||
# Return all items that are missing an "instance of" statement | |||
prefix wbb: <http://wikiba.se/ontology-beta#> | |||
prefix wb: <http://wikiba.se/ontology#> | |||
SELECT ?label ?link | SELECT ?label ?link | ||
WHERE | WHERE | ||
{ | { | ||
?item rdfs:label ?label . | ?item rdf:type ?wbitem ; | ||
rdfs:label ?label . | |||
FILTER(?wbitem in (wbb:Item, wb:Item)) | |||
FILTER((LANG(?label)) = "en") | FILTER((LANG(?label)) = "en") | ||
FILTER NOT EXISTS { ?item wdt:P8 ?type } | FILTER NOT EXISTS { ?item wdt:P8 ?type } | ||
| Line 16: | Line 21: | ||
order by ?label | order by ?label | ||
</pre> | </pre> | ||
[http://172.17.10.220:8834/embed.html# | [http://172.17.10.220:8834/embed.html#prefix%20wbb%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology-beta%23%3E%20%0Aprefix%20wb%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%20%0A%0ASELECT%20%3Flabel%20%3Flink%0AWHERE%0A%7B%0A%20%3Fitem%20rdf%3Atype%20%3Fwbitem%20%3B%0A%20%20%20%20%20%20%20rdfs%3Alabel%20%3Flabel%20.%20%20%20%20%0A%20FILTER%28%3Fwbitem%20in%20%28wbb%3AItem%2C%20wb%3AItem%29%29%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 15:04, 9 December 2020
Missing instance statements
Get a list of Item pages that lack an "instance of" declaration:
# Return all items that are missing an "instance of" statement
prefix wbb: <http://wikiba.se/ontology-beta#>
prefix wb: <http://wikiba.se/ontology#>
SELECT ?label ?link
WHERE
{
?item rdf:type ?wbitem ;
rdfs:label ?label .
FILTER(?wbitem in (wbb:Item, wb:Item))
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