Hello everyone. As I read, the point of DBpedia Live is that you get more recent data compared to the “old” static dump of Wikipedia. However, when I try to get some data on virtuoso, I get some that have been edited 8-9 months ago.
For example, I want to get the top 10 cities with their lat & long by their population
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
PREFIX dbpedia: <http://dbpedia.org/resource>
PREFIX dbpprop: <http://dbpedia.org/property>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT DISTINCT ?citylabel ?countrylabel (MAX(?lat) AS ?lat) (MAX(?long) AS ?long) (MAX(?pop) AS ?pop)
WHERE {
{
?city rdf:type dbpedia-owl:City.
?city rdfs:label ?citylabel.
?city dbpedia-owl:country ?country.
?country rdfs:label ?countrylabel.
?city geo:lat ?lat .
?city geo:long ?long .
?city dbpedia-owl:populationTotal ?pop
FILTER ( lang(?countrylabel) = 'en' and lang(?citylabel) = 'en')
} UNION {
?city rdf:type dbpedia-owl:Town.
?city rdfs:label ?citylabel.
?city dbpedia-owl:country ?country.
?country rdfs:label ?countrylabel.
?city geo:lat ?lat .
?city geo:long ?long .
?city dbpedia-owl:populationTotal ?pop
FILTER ( lang(?countrylabel) = 'en' and lang(?citylabel) = 'en')
}}
GROUP BY ?citylabel ?countrylabel
ORDER BY DESC(?pop) LIMIT 10 OFFSET 0
When I run it here https://live.dbpedia.org/sparql, the first city is this one https://en.wikipedia.org/wiki/Bodwad with a population of 1000000000000. However, this data has been removed since 16th of July, 2020. Similar to the rest of the top cities.
How “live” is the DBpedia live?