| ... | ... | @@ -104,7 +104,7 @@ The results are set on 4 columns: |
|
|
|
|
|
|
|
**Note:** the following queries are based on [SPARQL](https://www.w3.org/TR/sparql11-query/), which is the query language for the databases based on semantics technologies.
|
|
|
|
|
|
|
|
#### 4\.1 Procedure to retrieve the data from ShowVoc:
|
|
|
|
#### 4\.1 Procedure to retrieve the data from Cellar:
|
|
|
|
|
|
|
|
- Access the page: http://publications.europa.eu/webapi/rdf/sparql
|
|
|
|
- Copy and paste one of the following query into the text editor (replace the existing one)
|
| ... | ... | @@ -121,22 +121,34 @@ PREFIX owl: <http://www.w3.org/2002/07/owl#> |
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
|
PREFIX org: <http://www.w3.org/ns/org#>
|
|
|
|
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#>
|
|
|
|
|
|
|
|
SELECT distinct ?concept_uri ?country_en WHERE {
|
|
|
|
values ?scheme {
|
|
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
|
|
}
|
|
|
|
?concept_uri a skos:Concept .
|
|
|
|
?concept_uri skos:prefLabel ?c_en .
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code?country_en WHERE {
|
|
|
|
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:prefLabel ?c_en .
|
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
|
filter(lang(?c_en) = "en")
|
|
|
|
|
|
|
|
?concept_uri org:hasMembership ?membership .
|
|
|
|
# Filtering on the memberhip to UNO
|
|
|
|
?country_uri org:hasMembership ?membership .
|
|
|
|
?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
|
|
|
|
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
|
} order by ?country_en
|
|
|
|
# Retrieval of the EU official code
|
|
|
|
?country_uri euvoc:xlNotation ?not_authority .
|
|
|
|
?not_authority rdf:value ?named_authority_code .
|
|
|
|
?not_authority dct:type <http://publications.europa.eu/resource/authority/notation-type/NAC> .
|
|
|
|
|
|
|
|
# Filtering out the deprecated and the retired concepts
|
|
|
|
filter not exists {?country_uri owl:deprecated ?true}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>}
|
|
|
|
|
|
|
|
} order by ?country_uri
|
|
|
|
```
|
|
|
|
|
|
|
|
#### 4\.3 UN Members (all EU languages):
|
| ... | ... | |
| ... | ... | |
