| ... | ... | @@ -318,13 +318,15 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
|
filter(lang(?c_en) = "en")
|
|
|
|
|
|
|
|
# Filtering the territories and the marine areas
|
|
|
|
?country_uri skos:inScheme ?scheme .
|
|
|
|
|
|
|
|
# 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>
|
|
|
|
}
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>}
|
|
|
|
|
|
|
|
# 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> .
|
| ... | ... | @@ -353,39 +355,43 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the current countries and their english preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:inScheme <http://publications.europa.eu/resource/authority/country/0001> .
|
|
|
|
?country_uri skos:prefLabel ?c_label_en .
|
|
|
|
Bind(str(?c_label_en) as ?country_en) .
|
|
|
|
filter(lang(?c_label_en) = "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> .
|
|
|
|
|
|
|
|
# Retrieving the 2 alpha ISO codes (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieving the 3 alpha ISO codes (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieving the numerical ISO codes (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Filtering out the deprecated and the retired concepts
|
|
|
|
filter not exists {?country_uri owl:deprecated ?dep}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri owl:deprecated ?dep
|
|
|
|
}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>
|
|
|
|
}
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>}
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
| ... | ... | @@ -407,40 +413,42 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
?ISO_31661_alpha3 ?ISO_31661_num
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the current countries, territories and marine areas, and their english preferred labels
|
|
|
|
?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")
|
|
|
|
|
|
|
|
# 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> .
|
|
|
|
|
|
|
|
|
|
|
|
# Retrieving the 2 alpha ISO codes (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieving the 3 alpha ISO codes (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieving the numerical ISO codes (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Filtering out the deprecated and the retired concepts
|
|
|
|
filter not exists {?country_uri owl:deprecated ?dep}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri owl:deprecated ?dep
|
|
|
|
}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>
|
|
|
|
}
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>}
|
|
|
|
}
|
|
|
|
```
|
|
|
|
#### 4\.9 Current EU member states, their official code, their preferred labels in english and their ISO codes:
|
| ... | ... | |
| ... | ... | |