Property talk:P6494

From Wikidata
Jump to navigation Jump to search

Documentation

Incunabula Short Title Catalogue ID
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)
Format “[a-z]{2}\d{8}: value must be formatted using this pattern (PCRE syntax). (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#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:
    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
    
    Try it! ; Try it!
    Cheers, --Marsupium (talk) 19:26, 25 February 2019 (UTC), query updated to exclude Bodleian exemplars Marsupium (talk) 20:26, 22 March 2020 (UTC)[reply]
  • And here the query used to bring the catalog code (P528) to this property via QuickStatements:
    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
    
    Try it! ; Try it!
  • The values in catalog code (P528) don't have any special references, only reference URL (P854) with unspecific redirects, cf. here:
    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!. And I've removed them using this query:
    # 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
    
    Try it! ; Try it! --Marsupium (talk) 01:41, 26 February 2019 (UTC)[reply]