Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
thatcamp_2014:donnees_de_la_communaute_europeenne [2014/10/14 08:14] Francesco Beretta [Un jeu de données de test] |
thatcamp_2014:donnees_de_la_communaute_europeenne [2014/10/14 18:59] Francesco Beretta [Requêtes dans Fuseki] |
||
---|---|---|---|
Ligne 11: | Ligne 11: | ||
[[http://datahub.io/dataset/linked-nuts|Linked NUTS]] | [[http://datahub.io/dataset/linked-nuts|Linked NUTS]] | ||
+ | [[http://ec.europa.eu/eurostat/ramon/index.cfm?TargetUrl=DSP_PUB_WELC|RAMON | ||
+ | Eurostat's Metadata Server ]] | ||
==== Le site utilisé – sans SPARQL ==== | ==== Le site utilisé – sans SPARQL ==== | ||
Ligne 91: | Ligne 93: | ||
ORDER BY ?parentCountryGeocode ?name ?geocodeProvince</code> | ORDER BY ?parentCountryGeocode ?name ?geocodeProvince</code> | ||
+ | |||
+ | ====== Requêtes dans Fuseki ====== | ||
+ | |||
+ | |||
+ | <code> | ||
+ | PREFIX dc: <http://purl.org/dc/elements/1.1/> | ||
+ | PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | ||
+ | PREFIX meg: <http://mon_espace.org/graph/> | ||
+ | PREFIX apf: <http://jena.hpl.hp.com/ARQ/property#> | ||
+ | PREFIX eus: <http://ec.europa.eu/eurostat/ramon/ontologies/geographic.rdf#> | ||
+ | PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> | ||
+ | PREFIX owl: <http://www.w3.org/2002/07/owl#> | ||
+ | PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | ||
+ | PREFIX fn: <http://www.w3.org/2005/xpath-functions#> | ||
+ | PREFIX eu_man: <http://wifo5-04.informatik.uni-mannheim.de/eurostat/resource/eurostat/> | ||
+ | |||
+ | SELECT ?country | ||
+ | WHERE | ||
+ | { SERVICE <http://wifo5-04.informatik.uni-mannheim.de/eurostat/sparql> | ||
+ | { ?country rdf:type eu_man:countries } | ||
+ | } | ||
+ | LIMIT 5 | ||
+ | </code> | ||
+ | |||
+ | |||
+ | <code> | ||
+ | PREFIX... | ||
+ | |||
+ | SELECT ?country ?sameAs | ||
+ | WHERE | ||
+ | { SERVICE <http://wifo5-04.informatik.uni-mannheim.de/eurostat/sparql> | ||
+ | { ?country rdf:type eu_man:countries | ||
+ | OPTIONAL | ||
+ | { ?country owl:sameAs ?sameAs | ||
+ | FILTER contains(xsd:string(?sameAs), "dbpedia") | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | LIMIT 10 | ||
+ | |||
+ | </code> | ||
+ | |||
+ | <code> | ||
+ | PREFIX ... | ||
+ | SELECT ?country ?label ?sameAs | ||
+ | WHERE | ||
+ | { SERVICE <http://wifo5-04.informatik.uni-mannheim.de/eurostat/sparql> | ||
+ | { ?country rdf:type eu_man:countries. | ||
+ | ?country rdfs:label ?label | ||
+ | OPTIONAL | ||
+ | { ?country owl:sameAs ?sameAs | ||
+ | FILTER contains(xsd:string(?sameAs), "dbpedia") | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | </code> | ||
+ | |||
+ | |||
+ | |||
+ | | ||
+ | <code> | ||
+ | PREFIX... | ||
+ | CONSTRUCT | ||
+ | { ?country rdfs:label ?label . | ||
+ | ?country owl:sameAs ?sameAs .} | ||
+ | WHERE | ||
+ | { SERVICE <http://wifo5-04.informatik.uni-mannheim.de/eurostat/sparql> | ||
+ | { ?country rdf:type eu_man:countries . | ||
+ | ?country rdfs:label ?label | ||
+ | OPTIONAL | ||
+ | { ?country owl:sameAs ?sameAs | ||
+ | FILTER contains(xsd:string(?sameAs), "dbpedia") | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | </code> | ||
+ | |||
+ | |||
+ | <code> | ||
+ | PREFIX... | ||
+ | |||
+ | INSERT { | ||
+ | GRAPH meg:countries_20141014 { | ||
+ | ?country rdfs:label ?label . | ||
+ | ?country owl:sameAs ?sameAs . | ||
+ | } | ||
+ | } | ||
+ | WHERE | ||
+ | { SERVICE <http://wifo5-04.informatik.uni-mannheim.de/eurostat/sparql> | ||
+ | { ?country rdf:type eu_man:countries . | ||
+ | ?country rdfs:label ?label | ||
+ | OPTIONAL | ||
+ | { ?country owl:sameAs ?sameAs | ||
+ | FILTER contains(xsd:string(?sameAs), "dbpedia") | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | </code> | ||
+ | |||
+ | <code> | ||
+ | PREFIX... | ||
+ | |||
+ | SELECT * | ||
+ | WHERE | ||
+ | { GRAPH <http://mon_espace.org/graph/countries_20141014> | ||
+ | { ?s ?p ?o } | ||
+ | } | ||
+ | </code> | ||
+ | |||
+ | ====== Vider un graphe sous Fuseki ====== | ||
+ | |||
+ | |||
+ | |||
+ | ATTENTION : la base est ainsi vidée | ||
+ | |||
+ | <code>DELETE | ||
+ | WHERE {?s ?p ?o} | ||
+ | |||
+ | Vérifier qu'elle est vide : | ||
+ | SELECT * | ||
+ | WHERE {?s ?p ?o} | ||
+ | </code> | ||
+ | |||
+ | |||
+ | |||
+ | Avec graphe | ||
+ | |||
+ | <code>DELETE WHERE | ||
+ | { | ||
+ | GRAPH ?g { | ||
+ | ?s ?p ?o . | ||
+ | } | ||
+ | }</code> | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | Vérifier que le graphe est vide : | ||
+ | |||
+ | <code>SELECT * | ||
+ | WHERE | ||
+ | { GRAPH ?g | ||
+ | { ?s ?p ?o } | ||
+ | } | ||
+ | </code> | ||