579
edits
Project:SPARQL/examples: Difference between revisions
→Admin
(→Admin) |
|||
| Line 1,611: | Line 1,611: | ||
</sparql> | </sparql> | ||
=== Comparison of uses of item v free text === | |||
<sparql tryit="1"> | |||
# A number of properties have "item" and "free text" versions; a query to fetches both versions in each case to facilitate comparison of their uses. | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | |||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | |||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | |||
PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | |||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | |||
SELECT distinct ?itemLabel ?prop_label ?qual_label ?qual_value ?qual_valueLabel ?item ?qual_prop | |||
# most of these are used in qualifiers - only P72, P71 and P88 found in main (and only a handful of uses of free text?) | |||
#?item ( bnp:P88|bnp:P91 | bnp:P72|bnp:P71) ?s . | |||
## the pairs | |||
#P21 evidence (free text) / P20 evidence (item) | |||
#P79 item exhibited / P80 item exhibited (free text) | |||
#P78 of / P66 of (free text) | |||
#P91 specific reference information / P88 specific reference information (free text) | |||
#P31 street address (free text) / P100 street address (item) | |||
#P72 was delegate at (free text) / P71 was delegate at (item) | |||
WHERE { | |||
?item ?p ?s . | |||
?prop wikibase:claim ?p; | |||
rdfs:label ?prop_label. filter(lang(?prop_label)="en-gb") . | |||
?s ( bnpq:P21|bnpq:P20 | bnpq:P80|bnpq:P79 | bnpq:P66|bnpq:P78 | bnpq:P88|bnpq:P91 | bnpq:P31|bnpq:P100 | bnpq:P72|bnpq:P71 ) ?qual_value . | |||
?s ?qual_p ?qual_value . | |||
?qual_prop wikibase:qualifier ?qual_p; | |||
wikibase:propertyType ?qual_prop_type ; | |||
rdfs:label ?qual_label. filter(lang(?qual_label)='en-gb') . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". } | |||
} | |||
order by ?qual_label ?prop_label ?itemLabel | |||
</sparql> | |||
==Tools for batch processing and quality assurance work== | ==Tools for batch processing and quality assurance work== | ||