Ci-dessous, les différences entre deux révisions de la page.
thatcamp_2014:requete_dbpedia [2014/08/31 11:05] Francesco Beretta [Nombre d'universités dans dbpedia live] |
thatcamp_2014:requete_dbpedia [2014/10/29 12:03] |
||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
- | Chercher toutes les univesités | ||
- | <code> | ||
- | select count(*) | ||
- | where{ | ||
- | select distinct * | ||
- | where {?s dbpprop:type dbpedia:Public_university; | ||
- | georss:point ?localisation} | ||
- | #limit 10 | ||
- | } | ||
- | |||
- | </code> | ||
- | |||
- | ===== Nombre d'universités dans dbpedia live ===== | ||
- | |||
- | [31.08.2014} Résultat: 4303 | ||
- | <code> | ||
- | PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> | ||
- | PREFIX dbpedia: <http://dbpedia.org/resource/> | ||
- | PREFIX dbpprop: <http://dbpedia.org/property/> | ||
- | |||
- | SELECT (count(*) AS ?nombre) | ||
- | WHERE | ||
- | { SELECT DISTINCT * | ||
- | WHERE | ||
- | { SERVICE <http://dbpedia-live.openlinksw.com/sparql> | ||
- | { ?s dbpprop:type dbpedia:Public_university} | ||
- | } | ||
- | } | ||
- | |||
- | </code> | ||
- | |||
- | |||
- | [31.08.2014} Résultat: 4317 – vérifier pourquoi il y en a plus | ||
- | |||
- | <code> | ||
- | PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> | ||
- | PREFIX dbpedia: <http://dbpedia.org/resource/> | ||
- | PREFIX dbpprop: <http://dbpedia.org/property/> | ||
- | |||
- | SELECT (count(*) AS ?nombre) | ||
- | WHERE | ||
- | { SELECT DISTINCT * | ||
- | WHERE | ||
- | { SERVICE <http://dbpedia-live.openlinksw.com/sparql> | ||
- | { ?s dbpprop:type dbpedia:Public_university | ||
- | OPTIONAL | ||
- | { ?s dbpprop:city ?city | ||
- | { ?city dbpedia-owl:type dbpedia:City } | ||
- | } | ||
- | } | ||
- | } | ||
- | } | ||
- | |||
- | </code> | ||
- | |||
- | |||
- | ===== Jointure avec GEONAMES ===== | ||
- | En cours de test | ||
- | <code> | ||
- | PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> | ||
- | PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> | ||
- | PREFIX dbpedia: <http://dbpedia.org/resource/> | ||
- | PREFIX dbpprop: <http://dbpedia.org/property/> | ||
- | |||
- | SELECT * # (count(*) AS ?nombre) | ||
- | WHERE | ||
- | { SELECT DISTINCT * | ||
- | WHERE | ||
- | { SERVICE <http://dbpedia-live.openlinksw.com/sparql> | ||
- | {SELECT * WHERE { ?s dbpprop:type dbpedia:Public_university . | ||
- | ?s dbpprop:city ?city . | ||
- | ?city dbpedia-owl:type dbpedia:City . | ||
- | ?city <http://www.w3.org/2002/07/owl#sameAs> ?geonames | ||
- | |||
- | } | ||
- | limit 100} | ||
- | SERVICE <http://factforge.net/sparql> | ||
- | { SELECT * WHERE { ?geonames geo:lat ?lat . | ||
- | ?geonames geo:long ?lon} | ||
- | limit 1 | ||
- | } | ||
- | } | ||
- | }</code> |