Quality control queries: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 37: | Line 37: | ||
</pre> | </pre> | ||
[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!] | [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!] | ||
== Checking in on the Andrews List editions == | |||
<pre> | |||
# list of editions associated with the Andrews biography that lack a pubilshed by statement, but might have a printed by statement | |||
SELECT ?label ?link ?printer WHERE { | |||
?edition wdt:P121 wd:Q1176 ; #wd:Q1176 is the Andrews bibliography | |||
rdfs:label ?label . | |||
OPTIONAL {?edition wdt:P32 ?printer }. | |||
BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?edition) , 'http://wikibase.svc/entity/', '' ))) AS ?link ) | |||
FILTER NOT EXISTS { ?edition wdt:P29 ?publisher }. | |||
} | |||
</pre> | |||
[http://172.17.10.220:8834/embed.html#%23%20list%20of%20editions%20associated%20with%20the%20Andrews%20biography%20that%20lack%20a%20pubilshed%20by%20statement%2C%20but%20might%20have%20a%20printed%20by%20statement%0ASELECT%20%3Flabel%20%3Flink%20%3Fprinter%20WHERE%20%7B%0A%20%3Fedition%20wdt%3AP121%20wd%3AQ1176%20%3B%20%23wd%3AQ1176%20is%20the%20Andrews%20bibliography%0A%20%20%20%20%20%20%20%20%20%20rdfs%3Alabel%20%3Flabel%20.%0A%20%20OPTIONAL%20%7B%3Fedition%20wdt%3AP32%20%3Fprinter%20%7D.%0A%20%20BIND%28IRI%28CONCAT%28%27http%3A%2F%2F10.5.32.142%3A8181%2Fwiki%2FItem%3A%27%2C%20REPLACE%28%20str%28%3Fedition%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%20FILTER%20NOT%20EXISTS%20%7B%20%3Fedition%20wdt%3AP29%20%3Fpublisher%20%7D.%0A%7D Try it out!] | |||
Revision as of 15:24, 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
Checking in on the Andrews List editions
# list of editions associated with the Andrews biography that lack a pubilshed by statement, but might have a printed by statement
SELECT ?label ?link ?printer WHERE {
?edition wdt:P121 wd:Q1176 ; #wd:Q1176 is the Andrews bibliography
rdfs:label ?label .
OPTIONAL {?edition wdt:P32 ?printer }.
BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?edition) , 'http://wikibase.svc/entity/', '' ))) AS ?link )
FILTER NOT EXISTS { ?edition wdt:P29 ?publisher }.
}