How to get only the most recent value from a Wikidata property?

by

Both your questions are duplicates, but I’ll try to add interesting facts to existing answers.

Question 1 is a duplicate of SPARQL query to get only results with the most recent date.

This technique does the trick:

FILTER NOT EXISTS {
    ?country p:P1081/pq:P585 ?hdi_date_ .
    FILTER (?hdi_date_ > ?hdi_date)
}

However, you should add this clause outside of OPTIONAL, it is not working inside of OPTIONAL (and I’m not sure this is not a bug).

Question 2 is a duplicate of Some cities aren’t instances of city or big city?

You can’t use wdt-predicates, because missing statements are not truthy.
They are normal-rank statements, but there is a preferred-rank statement.

Truthy statements represent statements that have the best non-deprecated rank for given property. Namely, if there is a preferred statement for property P2, then only preferred statements for P2 will be considered truthy. Otherwise, all normal-rank statements are considered truthy.

The reason why P1081 always has preferred statement is that this property is processed by PreferentialBot.

More Related Contents:

  1. Aggregating results from SPARQL query
  2. SPARQL: is there any path between two nodes?
  3. Exclude results from DBpedia SPARQL query based on URI prefix
  4. Why is dbpedia-owl:wikiPageRedirects not returning the full set of redirect links? (Sparql)
  5. get latitude and longitude of a place dbpedia
  6. Why does my SPARQL query return the URI of a resource instead of its name?
  7. wikidata get all properties with labels and values of an item
  8. Some cities aren’t instances of city or big city? Odd behaviour of Wikidata
  9. SPARQL query to get all class label with namespace prefix defined
  10. How to get all companies from DBPedia?
  11. How to extract information from a Wikipedia infobox?
  12. Is it possible to get the position of an element in an RDF Collection in SPARQL?
  13. Calculate length of path between nodes?
  14. Finding all steps in property path
  15. DBpedia Jena Query returning null
  16. Querying Open Data Communities Data with SPARQL
  17. Exploratory SPARQL queries?
  18. SPARQL property path queries with arbitrary properties
  19. Sparql query Subclass or EquivalentTo
  20. SPARQL functions in CONSTRUCT/WHERE
  21. SPARQL query to get all parent of a node

Leave a Comment