| ... | ... | @@ -276,9 +276,9 @@ SELECT distinct ?concept_uri ?country_en WHERE { |
|
|
|
|
|
|
|
**Note:** The disputed territories are also included into the results of this SPARQL query.
|
|
|
|
|
|
|
|
#### 4\.8 Current official countries only and their related ISO codes:
|
|
|
|
#### 4\.7 Current official countries (only) and their related ISO codes:
|
|
|
|
|
|
|
|
The following query retrieves all the current states, territories and marine areas, 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 :
|
|
|
|
The following query retrieves all the current 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):
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
| ... | ... | @@ -290,12 +290,10 @@ 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 {
|
|
|
|
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: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")
|
| ... | ... | @@ -333,7 +331,7 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
#### 4\.7 Current countries, territories and marines areas and their related ISO codes:
|
|
|
|
#### 4\.8 Current countries, territories and marines areas and their related ISO codes:
|
|
|
|
|
|
|
|
The following query retrieves all the current states, territories and marine areas, 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 :
|
|
|
|
|
| ... | ... | |
| ... | ... | |