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 (MIN(?s) as ?identifiant) (GROUP_CONCAT(?name ; separator="|") as ?concatName) ?geocodeProvince (MIN(?parentCountryGeocode) as ?siglePays) (MIN(?populationTotal) as ?population) (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