| ... | ... | @@ -383,3 +383,59 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
}
|
|
|
|
}
|
|
|
|
```
|
|
|
|
#### 4\.9 Current EU member states, their official code, their preferred labels in english and their ISO codes:
|
|
|
|
|
|
|
|
The following query retrieves all the current EU member states, their official codes, their related english (preferred) labels , and their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) if they exists :
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#>
|
|
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
|
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
|
|
|
|
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
|
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
|
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
|
|
|
|
|
|
|
|
SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2
|
|
|
|
?ISO_31661_alpha3 ?ISO_31661_num
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:prefLabel ?c_label_en .
|
|
|
|
Bind(str(?c_label_en) as ?country_en) .
|
|
|
|
filter(lang(?c_label_en) = "en")
|
|
|
|
|
|
|
|
?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> .
|
|
|
|
|
|
|
|
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_alpha2 .
|
|
|
|
?not_alpha2 rdf:value ?ISO_31661_alpha2 .
|
|
|
|
?not_alpha2 dct:type <http://publications.europa.eu/resource/authority/notation-type/ISO_3166_1_ALPHA_2> .
|
|
|
|
}
|
|
|
|
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_alpha3 .
|
|
|
|
?not_alpha3 rdf:value ?ISO_31661_alpha3 .
|
|
|
|
?not_alpha3 dct:type <http://publications.europa.eu/resource/authority/notation-type/ISO_3166_1_ALPHA_3> .
|
|
|
|
}
|
|
|
|
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_num .
|
|
|
|
?not_num rdf:value ?ISO_31661_num .
|
|
|
|
?not_num dct:type <http://publications.europa.eu/resource/authority/notation-type/ISO_3166_1_NUM> .
|
|
|
|
}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri owl:deprecated ?dep
|
|
|
|
}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>
|
|
|
|
}
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
|
|
|
|
