[Wikidata-bugs] [Maniphest] [Created] T155267: beta triples on query.wikidata.org (normalized units)

[WikidataFacts]

WikidataFacts created this task. WikidataFacts added projects: Wikidata, Wikidata-Query-Service. Herald added a subscriber: Aklapper. Herald added a project: Discovery.

TASK DESCRIPTION

Currently, there are 113761 triples with predicate http://wikiba.se/ontology-beta#quantityAmount on query.wikidata.org, which presumably should be http://wikiba.se/ontology#quantityAmount (wikibase:quantityAmount). This query counts them:

SELECT (SUM(?notBeta) AS ?countNotBeta) (SUM(?beta) AS ?countBeta) WHERE {
  {
    [] <http://wikiba.se/ontology#quantityAmount> [].
    BIND(1 AS ?notBeta).
  } UNION {
    [] <http://wikiba.se/ontology-beta#quantityAmount> [].
    BIND(1 AS ?beta).
  }
}

Link; current results: 394040, 113761.

I found them in a query related to normalized units (see tweet), but it seems not quite all full value nodes which have such a beta triple are reachable via psn: triples:

SELECT (SUM(?beta) AS ?countBeta) (SUM(?psnBeta) AS ?countPsnBeta) WHERE {
  ?node <http://wikiba.se/ontology-beta#quantityAmount> [].
  BIND(1 AS ?beta).
  OPTIONAL {
    ?property a wikibase:Property;
              wikibase:statementValueNormalized ?psn.
    [] ?psn ?node.
   BIND(1 AS ?psnBeta).
  }
}

Link; current results: 406484, 402826.

(Though there might be something wrong with that last query, because ?countBeta is much higher than in the first query. Are value nodes reused that much?)

TASK DETAIL

https://phabricator.wikimedia.org/T155267

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: WikidataFacts
Cc: Smalyshev, Aklapper, WikidataFacts, EBjune, mschwarzer, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs