W3C home > Mailing lists > Public > public-lod@w3.org > December 2016

Re: Real Federated SPARQL Queries Required and Possible Collaboration

From: Kingsley Idehen <kidehen@openlinksw.com>
Date: Tue, 20 Dec 2016 12:21:26 -0500
To: public-lod@w3.org
Message-ID: <d40d5ea3-6a05-0d8f-fc26-1df370e343dd@openlinksw.com>
On 12/20/16 3:14 AM, Thomas Francart wrote:
> Hello
>
> Here is a query that fetches the country codes from (french) DBPedia
> for countries with the same name as skos:Concept in the UNESCO
> thesaurus (endpoint http://vocabularies.unesco.org/sparql) :
>
> PREFIX skos: <http://www.w3.org/2004/02/skos/core#
> <http://www.w3.org/2004/02/skos/core#>>
> PREFIX isothes: <http://purl.org/iso25964/skos-thes#
> <http://purl.org/iso25964/skos-thes#>>
> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#
> <http://www.w3.org/2000/01/rdf-schema#>>
> PREFIX dbo: <http://dbpedia.org/ontology/>
> SELECT ?pays ?isoCode ?concept ?nomDbpedia
> WHERE {
>     SERVICE <http://fr.dbpedia.org/sparql> {
>         ?pays a dbo:Country .
>         ?pays dbo:isoCodeRegion ?isoCode .
>         ?pays rdfs:label ?nomDbpedia .
>         FILTER(langMatches(lang(?nomDbpedia), 'en'))
>     }
>     ?collection isothes:superGroup
> <http://vocabularies.unesco.org/thesaurus/domain7
> <http://vocabularies.unesco.org/thesaurus/domain7>> .
>     ?collection skos:member ?concept .
>       ?concept skos:prefLabel ?labelThesaurus .
>     FILTER(langMatches(lang(?labelThesaurus), 'en'))
>     FILTER( UCASE(STR(?labelThesaurus)) = UCASE(STR(?nomDbpedia)) )
> }
>
> Direct query link :
>
> http://vocabularies.unesco.org/sparql-form/?query=PREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E+%0APREFIX+isothes%3A+%3Chttp%3A%2F%2Fpurl.org%2Fiso25964%2Fskos-thes%23%3E%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+dbo%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0ASELECT+%3Fpays+%3FisoCode+%3Fconcept+%3FnomDbpedia%0AWHERE+%7B%0A%09SERVICE+%3Chttp%3A%2F%2Ffr.dbpedia.org%2Fsparql%3E+%7B%0A++++%09%3Fpays+a+dbo%3ACountry+.%0A++++%09%3Fpays+dbo%3AisoCodeRegion+%3FisoCode+.%0A++++%09%3Fpays+rdfs%3Alabel+%3FnomDbpedia+.%0A++++%09FILTER(langMatches(lang(%3FnomDbpedia)%2C+%27en%27))%0A++++%7D%0A++++%3Fcollection+isothes%3AsuperGroup+%3Chttp%3A%2F%2Fvocabularies.unesco.org%2Fthesaurus%2Fdomain7%3E+.%0A++++%3Fcollection+skos%3Amember+%3Fconcept+.%0A++%09%3Fconcept+skos%3AprefLabel+%3FlabelThesaurus+.%0A++++FILTER(langMatches(lang(%3FlabelThesaurus)%2C+%27en%27))%0A++++FILTER(+UCASE(STR(%3FlabelThesaurus))+%3D+UCASE(STR(%3FnomDbpedia))+)%0A%7D+
> <http://vocabularies.unesco.org/sparql-form/?query=PREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E+%0APREFIX+isothes%3A+%3Chttp%3A%2F%2Fpurl.org%2Fiso25964%2Fskos-thes%23%3E%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+dbo%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0ASELECT+%3Fpays+%3FisoCode+%3Fconcept+%3FnomDbpedia%0AWHERE+%7B%0A%09SERVICE+%3Chttp%3A%2F%2Ffr.dbpedia.org%2Fsparql%3E+%7B%0A++++%09%3Fpays+a+dbo%3ACountry+.%0A++++%09%3Fpays+dbo%3AisoCodeRegion+%3FisoCode+.%0A++++%09%3Fpays+rdfs%3Alabel+%3FnomDbpedia+.%0A++++%09FILTER%28langMatches%28lang%28%3FnomDbpedia%29%2C+%27en%27%29%29%0A++++%7D%0A++++%3Fcollection+isothes%3AsuperGroup+%3Chttp%3A%2F%2Fvocabularies.unesco.org%2Fthesaurus%2Fdomain7%3E+.%0A++++%3Fcollection+skos%3Amember+%3Fconcept+.%0A++%09%3Fconcept+skos%3AprefLabel+%3FlabelThesaurus+.%0A++++FILTER%28langMatches%28lang%28%3FlabelThesaurus%29%2C+%27en%27%29%29%0A++++FILTER%28+UCASE%28STR%28%3FlabelThesaurus%29%29+%3D+UCASE%28STR%28%3FnomDbpedia%29%29+%29%0A%7D+>
>

Hi Thomas,

I was looking at the query results page at:
http://vocabularies.unesco.org/sparql?default-graph-uri=&query=PREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E+%0D%0APREFIX+isothes%3A+%3Chttp%3A%2F%2Fpurl.org%2Fiso25964%2Fskos-thes%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+dbo%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0ASELECT+%3Fpays+%3FisoCode+%3Fconcept+%3FnomDbpedia%0D%0AWHERE+%7B%0D%0A%09SERVICE+%3Chttp%3A%2F%2Ffr.dbpedia.org%2Fsparql%3E+%7B%0D%0A++++%09%3Fpays+a+dbo%3ACountry+.%0D%0A++++%09%3Fpays+dbo%3AisoCodeRegion+%3FisoCode+.%0D%0A++++%09%3Fpays+rdfs%3Alabel+%3FnomDbpedia+.%0D%0A++++%09FILTER%28langMatches%28lang%28%3FnomDbpedia%29%2C+%27en%27%29%29%0D%0A++++%7D%0D%0A++++%3Fcollection+isothes%3AsuperGroup+%3Chttp%3A%2F%2Fvocabularies.unesco.org%2Fthesaurus%2Fdomain7%3E+.%0D%0A++++%3Fcollection+skos%3Amember+%3Fconcept+.%0D%0A++%09%3Fconcept+skos%3AprefLabel+%3FlabelThesaurus+.%0D%0A++++FILTER%28langMatches%28lang%28%3FlabelThesaurus%29%2C+%27en%27%29%29%0D%0A++++FILTER%28+UCASE%28STR%28%3FlabelThesaurus%29%29+%3D+UCASE%28STR%28%3FnomDbpedia%29%29+%29%0D%0A%7D+&format=application%2Fsparql-results%2Bxml&stylesheet=%2Fsparql-form%2Fxsl%2Fxml-to-html.xsl

Issue:

Links in the query results page aren't live i.e., I can't follow-my-nose
by clicking on them.

-- 
Regards,

Kingsley Idehen	      
Founder & CEO 
OpenLink Software   (Home Page: http://www.openlinksw.com)

Weblogs (Blogs):
Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
Blogspot Blog: http://kidehen.blogspot.com
Medium Blog: https://medium.com/@kidehen

Profile Pages:
Pinterest: https://www.pinterest.com/kidehen/
Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter: https://twitter.com/kidehen
Google+: https://plus.google.com/+KingsleyIdehen/about
LinkedIn: http://www.linkedin.com/in/kidehen

Web Identities (WebID):
Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this
        : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this




Received on Tuesday, 20 December 2016 17:22:01 UTC

This archive was generated by hypermail 2.3.1 : Tuesday, 20 December 2016 17:22:01 UTC