Page MenuHomePhabricator

beta triples on query.wikidata.org (normalized units)
Closed, ResolvedPublic

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?)

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Smalyshev claimed this task.
Smalyshev triaged this task as High priority.

Should be fine now