Ceci est une ancienne révision du document !
http://www.lespetitescases.net/ou-s-amuser-avec-sparql
Un point d'accès: http://wifo5-03.informatik.uni-mannheim.de/eurostat/
PREFIX countries: <http://wifo5-04.informatik.uni-mannheim.de/eurostat/resource/countries/> SELECT * WHERE { countries:Deutschland ?p ?o }
SELECT DISTINCT ?property ?hasValue ?isValueOf WHERE { { <http://wifo5-04.informatik.uni-mannheim.de/eurostat/resource/countries/Deutschland> ?property ?hasValue } UNION { ?isValueOf ?property <http://wifo5-04.informatik.uni-mannheim.de/eurostat/resource/countries/Deutschland> } } ORDER BY (!BOUND(?hasValue)) ?property ?hasValue ?isValueOf
PREFIX countries: <http://wifo5-04.informatik.uni-mannheim.de/eurostat/resource/countries/> SELECT DISTINCT ?name ?geocodeProvince ?parentCountryGeocode ?populationTotal WHERE { ?s rdf:type eurostat:regions. ?s eurostat:name ?name. ?s eurostat:geocode ?geocodeProvince. ?s eurostat:population_total ?populationTotal. ?s eurostat:parentcountry ?parentCountry. ?parentCountry eurostat:geocode ?parentCountryGeocode } ORDER BY ?parentCountryGeocode ?name
PREFIX countries: <http://wifo5-04.informatik.uni-mannheim.de/eurostat/resource/countries/> SELECT # MAX(?s) (count(*) as ?nombre) ?geocodeProvince DISTINCT MAX(?s) (GROUP_CONCAT(?name ; separator="|") as ?concatName) ?geocodeProvince MAX(?parentCountryGeocode) MAX(?populationTotal) (count(*) as ?nombre) WHERE { ?s rdf:type eurostat:regions. ?s eurostat:name ?name. ?s eurostat:geocode ?geocodeProvince. ?s eurostat:population_total ?populationTotal. ?s eurostat:parentcountry ?parentCountry. ?parentCountry eurostat:geocode ?parentCountryGeocode } GROUP BY ?geocodeProvince ORDER BY ?parentCountryGeocode ?name ?geocodeProvince