query-600edfe006fb9660a24415c88d67cf69

rq turtle/ttl

Proliferate external-IDs from qualifiers and references to main statement (2021-07-06) Vladimir Alexiev: Request date: 6 July 2021, byLink to discussions justifying the requestparticipants of WikiProject Authority control Notified Chado07 Ecravo Lovelano מקף) talk (Hiperterminal S.v.Mering MrBenjo 沈澄心 Rhagfyr M.roszkowski AfricanLibrarian Back ache Silviafanti JordanTimothyJames Ahatd Pierre Tribhou NGOgo MasterRus21thCentury Jason.nlw RShigapov Kolja21 AhavaCohen moz Songceci CamelCaseNick Alessandra.Moi 1-Byte Silva Selva Uomovariabile Msuicat Matlin Pablo Busatto Carlobia Bargioni Sotho Tal Ker Epìdosis Iwan.Aucamp Daniel Mietchen Fuzheado Ettorerizza PKM ArthurPSmith Wikidelo Sic19 Jneubert Andy Mabbett Jonathan Groß Vladimir Alexiev none yet: Task description says that 22.7% of uses are as reference, and 0.1% as qualifier. Property_talk:P496Take a prop like ORCID: I bet that some of those uses are not reflected as main statement. I tried to make a query to find refs using external-ID that are not reflected as main statement, but hit timeouts. If you uncomment the first commented-out line below, you get a timeout, even though ?statement has only one incoming link: has no ORCID stated.(Q56085877)Ginny Hendricks states the ORCID iD of author ordinal 1 as 0000-0002-0353-2702, but that author (Q86246932)Crossref: The sustainable source of community-owned scholarly metadata Eg the paper

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?itemLabel ?wdt ?wdLabel ?id { # ?ref ?wdr ?statement {
  ?wd wikibase:propertyType wikibase:ExternalId; wikibase:directClaim ?wdt; wikibase:reference ?wdr.
  ?ref ?wdr ?id.
  ?statement prov:wasDerivedFrom ?ref.
  # ?item ?prop ?statement
  # filter not exists {?item ?wdt ?id}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} limit 10

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?id"):::projected v4("?ref") v6("?statement") v1("?wd") v3("?wdr") v2("?wdt"):::projected c7(["bd:serviceParam"]):::iri c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wikibase:ExternalId"]):::iri v1 --"wikibase:propertyType"--> c2 v1 --"wikibase:directClaim"--> v2 v1 --"wikibase:reference"--> v3 v4 -->v3--> v5 v6 --"prov:wasDerivedFrom"--> v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end