Property talk:P6494
Latest comment: 5 years ago by Marsupium in topic Candidates
Documentation
Incunabula Short Title Catalogue ID
number or ID in the Incunabula Short Title Catalogue
number or ID in the Incunabula Short Title Catalogue
[create Create a translatable help page (preferably in English) for this property to be included here]
Type “version, edition or translation (Q3331189)”: item must contain property “instance of (P31)” with classes “version, edition or translation (Q3331189)” or their subclasses (defined using subclass of (P279)). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P6494#Type Q3331189, SPARQL
Single value: this property generally contains a single value. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P6494#Single value, SPARQL
Distinct values: this property likely contains a value that is different from all other items. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P6494#Unique value, SPARQL (every item), SPARQL (by value)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P6494#Format, SPARQL
List of violations of this constraint: Database reports/Constraint violations/P6494#Format, SPARQL
Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P6494#Entity types
Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). List of violations of this constraint: Database reports/Constraint violations/P6494#Scope, SPARQL
Candidates
edit- Apart from those of the query from the proposal, here is a query for more candidates, for some of them their respective fitting editions (version, edition or translation (Q3331189)) should get a Incunabula Short Title Catalogue ID (P6494) statement: Try it! ; Try it!
SELECT DISTINCT ?item ?itemLabel ?pub ?inception ?istc WHERE { { ?item (wdt:P31/wdt:P279*) wd:Q3331189. ?item wdt:P577 ?pub. FILTER((?pub > (xsd:dateTime("1449-01-01T00:00:00Z"))) && (?pub < (xsd:dateTime("1501-01-01T00:00:00Z")))) } UNION { ?item (wdt:P31/wdt:P279*) wd:Q216665. } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr,la". } MINUS { ?item wdt:P195 wd:Q82133. } OPTIONAL { ?item wdt:P577 ?pub. } OPTIONAL { ?item wdt:P571 ?inception. } OPTIONAL { ?item wdt:P6494 ?istc. } } ORDER BY ?istc ?pub ?inception LIMIT 100
Cheers, --Marsupium (talk) 19:26, 25 February 2019 (UTC), query updated to exclude Bodleian exemplars Marsupium (talk) 20:26, 22 March 2020 (UTC) - And here the query used to bring the catalog code (P528) to this property via QuickStatements: Try it! ; Try it!
SELECT # ?item ?itemLabel ?qid ?P6494 WHERE { ?item p:P528 ?st. ?st ps:P528 ?value. ?st pq:P972 wd:Q634670. # Incunabula Short Title Catalogue BIND(SUBSTR(STR(?item), 32) AS ?qid) BIND(CONCAT('"', ?value, '"') AS ?P6494) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } LIMIT 100
- The values in catalog code (P528) don't have any special references, only reference URL (P854) with unspecific redirects, cf. here: Try it! ; Try it!. And I've removed them using this query:
SELECT ?prop ?propLabel ?count WHERE { { SELECT ?refProp (COUNT(?refProp) AS ?count) WHERE { ?item p:P528 ?statement. ?statement pq:P972 wd:Q634670. ?statement prov:wasDerivedFrom ?wdRef. ?wdRef ?refProp []. } GROUP BY ?refProp } ?prop wikibase:reference ?refProp. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC(?count)
Try it! ; Try it! --Marsupium (talk) 01:41, 26 February 2019 (UTC)# query that can be used to remove redundant values of P528 that are now in P6494: # download as CSV, put a minus sign in front of the second column and then run in QuickStatements SELECT #?item ?itemLabel ?value ?qid ?P528 #?istc WHERE { ?item p:P528 ?st. ?st ps:P528 ?value. ?st pq:P972 wd:Q634670. # Incunabula Short Title Catalogue # OPTIONAL { ?item wdt:P6494 ?istc. } BIND(SUBSTR(STR(?item), 32) AS ?qid) BIND(CONCAT('"', ?value, '"') AS ?P528) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } LIMIT 100