| ... | @@ -6,25 +6,22 @@ The CSV files can be uploaded into Excel, while the links retrieving JSON can be |
... | @@ -6,25 +6,22 @@ The CSV files can be uploaded into Excel, while the links retrieving JSON can be |
|
|
|
|
|
|
|
**Note:** the data are directly retrieved from the triplestore of the Publications Office ([Cellar](https://publications.europa.eu/webapi/rdf/sparql)). The technical documentation attached to this page gives some information to develop any kind of custom query.
|
|
**Note:** the data are directly retrieved from the triplestore of the Publications Office ([Cellar](https://publications.europa.eu/webapi/rdf/sparql)). The technical documentation attached to this page gives some information to develop any kind of custom query.
|
|
|
|
|
|
|
|
[[_TOC_]]
|
|
##### _The following queries retrieve the official published data directly from the main triple store of the Publication._
|
|
|
|
|
|
|
|
|
[[_TOC_]]
|
|
|
|
|
|
|
|
### 1\.0 - Current official countries and their related english (preferred) labels :
|
|
### 1\.0 - Current official countries and their related english (preferred) labels :
|
|
|
|
|
|
|
|
#### 1\.1 Results in HTML:
|
|
#### 1\.1 Results in HTML:
|
|
|
|
|
|
|
|
The results are on 6 columns :
|
|
The results are on 2 columns :
|
|
|
|
|
|
|
|
- country_uri : the identifier of the country
|
|
- country_uri : the identifier of the country
|
|
|
- country_en : the preferred labels in English
|
|
- country_en : the preferred labels in English
|
|
|
- named_authority_code : official codes representing the country (it can be different from the ISO codes)
|
|
- named_authority_code : the official code referencing the code (which could be different from the ISO codes)
|
|
|
- ISO_31661_alpha2: the two-letter country codes based on ISO 3166-1
|
|
- iso_code
|
|
|
- ISO_31661_alpha3: the three-letter country codes based on ISO 3166-1
|
|
|
|
|
- ISO_31661_num: three-digit country codes based on ISO 3166-1
|
|
|
|
|
|
|
|
|
|
The SPARQL query is available under 4.7.
|
|
|
|
|
|
|
|
|
|
[Current countries and territories (HTML)](http://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+distinct+%3Fcountry_uri+%3Fnamed_authority_code%3Fcountry_en+WHERE+%7B%0D%0A%0D%0A++++%23+Retrieving+the+countries+and+their+english+preferred+labels+%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fc_en+.%0D%0A++++Bind%28str%28%3Fc_en%29+as+%3Fcountry_en%29%0D%0A++++filter%28lang%28%3Fc_en%29+%3D+%22en%22%29+%0D%0A++++%0D%0A++++%23+Filtering+on+the+memberhip+to+UNO%0D%0A++++%3Fcountry_uri+org%3AhasMembership+%3Fmembership+.%0D%0A++++%3Fmembership+org%3Aorganization+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcorporate-body%2FUNO%3E+.%0D%0A++++%3Fmembership+org%3Arole+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Frole%2FMEMBER%3E++.%0D%0A++++%0D%0A++++%23+Retrieval+of+the+EU+official+code%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.%0D%0A++++%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.%0D%0A++++%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.%0D%0A%0D%0A++++%23+Filtering+out+the+deprecated+and+the+retired+concepts%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+owl%3Adeprecated+%3Ftrue%7D%0D%0A++++filter+not+exists+%7B%0D%0A++++%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FRETIRED%3E%7D%0D%0A%0D%0A%7D++order+by+%3Fcountry_uri%0D%0A&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+)
|
|
[Current countries and territories (HTML)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fcountry_en++%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AtopConceptOf+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E++.%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FDEPRECATED%3E%7D%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29+%0D%0A++++bind+%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29%0D%0A%0D%0A+++++filter+%28%3Fcountry_uri+%21%3D+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2FOP_DATPRO%3E+%29%0D%0A%7D%0D%0A&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
#### 1\.2 Results in JSON:
|
|
#### 1\.2 Results in JSON:
|
|
|
|
|
|
| ... | @@ -35,13 +32,13 @@ The results have 2 fields : "country_uri" and "country_en". The values are retur |
... | @@ -35,13 +32,13 @@ The results have 2 fields : "country_uri" and "country_en". The values are retur |
|
|
"country_en": { "type": "literal", "value": "Burundi" }}
|
|
"country_en": { "type": "literal", "value": "Burundi" }}
|
|
|
```
|
|
```
|
|
|
|
|
|
|
|
[Current countries and territories (JSON)](http://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+distinct+%3Fcountry_uri+%3Fnamed_authority_code%3Fcountry_en+WHERE+%7B%0D%0A%0D%0A++++%23+Retrieving+the+countries+and+their+english+preferred+labels+%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fc_en+.%0D%0A++++Bind%28str%28%3Fc_en%29+as+%3Fcountry_en%29%0D%0A++++filter%28lang%28%3Fc_en%29+%3D+%22en%22%29+%0D%0A++++%0D%0A++++%23+Filtering+on+the+memberhip+to+UNO%0D%0A++++%3Fcountry_uri+org%3AhasMembership+%3Fmembership+.%0D%0A++++%3Fmembership+org%3Aorganization+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcorporate-body%2FUNO%3E+.%0D%0A++++%3Fmembership+org%3Arole+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Frole%2FMEMBER%3E++.%0D%0A++++%0D%0A++++%23+Retrieval+of+the+EU+official+code%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.%0D%0A++++%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.%0D%0A++++%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.%0D%0A%0D%0A++++%23+Filtering+out+the+deprecated+and+the+retired+concepts%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+owl%3Adeprecated+%3Ftrue%7D%0D%0A++++filter+not+exists+%7B%0D%0A++++%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FRETIRED%3E%7D%0D%0A%0D%0A%7D++order+by+%3Fcountry_uri%0D%0A&format=application%2Fsparql-results%2Bjson&timeout=0&debug=on&run=+Run+Query+)
|
|
[Current countries and territories (JSON)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fcountry_en++%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AtopConceptOf+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E++.%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FDEPRECATED%3E%7D%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29+%0D%0A++++bind+%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29%0D%0A%0D%0A+++++filter+%28%3Fcountry_uri+%21%3D+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2FOP_DATPRO%3E+%29%0D%0A%7D%0D%0A&format=application%2Fsparql-results%2Bjson&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
#### 1\.3 Results in CSV for Excel:
|
|
#### 1\.3 Results in CSV for Excel:
|
|
|
|
|
|
|
|
The triple store returns directly a CSV file (comma separated), with 3 columns: country_uri,named_authority_code, country_en.
|
|
The triple store returns directly a CSV file (comma separated), with 2 columns: country_uri and country_en.
|
|
|
|
|
|
|
|
[Current countries and territories (CSV) - for Excel](http://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+distinct+%3Fcountry_uri+%3Fnamed_authority_code%3Fcountry_en+WHERE+%7B%0D%0A%0D%0A++++%23+Retrieving+the+countries+and+their+english+preferred+labels+%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fc_en+.%0D%0A++++Bind%28str%28%3Fc_en%29+as+%3Fcountry_en%29%0D%0A++++filter%28lang%28%3Fc_en%29+%3D+%22en%22%29+%0D%0A++++%0D%0A++++%23+Filtering+on+the+memberhip+to+UNO%0D%0A++++%3Fcountry_uri+org%3AhasMembership+%3Fmembership+.%0D%0A++++%3Fmembership+org%3Aorganization+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcorporate-body%2FUNO%3E+.%0D%0A++++%3Fmembership+org%3Arole+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Frole%2FMEMBER%3E++.%0D%0A++++%0D%0A++++%23+Retrieval+of+the+EU+official+code%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.%0D%0A++++%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.%0D%0A++++%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.%0D%0A%0D%0A++++%23+Filtering+out+the+deprecated+and+the+retired+concepts%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+owl%3Adeprecated+%3Ftrue%7D%0D%0A++++filter+not+exists+%7B%0D%0A++++%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FRETIRED%3E%7D%0D%0A%0D%0A%7D++order+by+%3Fcountry_uri%0D%0A&format=text%2Fcsv&timeout=0&debug=on&run=+Run+Query+)
|
|
[Current countries and territories (CSV) - for Excel](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fcountry_en++%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AtopConceptOf+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E++.%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FDEPRECATED%3E%7D%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29+%0D%0A++++bind+%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29%0D%0A%0D%0A+++++filter+%28%3Fcountry_uri+%21%3D+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2FOP_DATPRO%3E+%29%0D%0A%7D%0D%0A&format=text%2Fcsv&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
### 2\.0 All countries and territories available in the dataset
|
|
### 2\.0 All countries and territories available in the dataset
|
|
|
|
|
|
| ... | @@ -98,19 +95,20 @@ The results are set on 4 columns: |
... | @@ -98,19 +95,20 @@ The results are set on 4 columns: |
|
|
|
|
|
|
|
### 4\.0 Retrieving new information and data
|
|
### 4\.0 Retrieving new information and data
|
|
|
|
|
|
|
|
**Note:** this data will only be officially published in september 2023.
|
|
**Note:** this data will only be officially published in september 2023 - they are available in ShowVoc as **Draft**.
|
|
|
|
|
|
|
|
**Note:** The following queries should be copy and paste into the user interface from Cellar to retrieve the information about Countries, territories and marine areas.
|
|
**Note:** The following queries should be copy and paste into ShowVoc to retrieve the new information about Countries and territories which are not officially published.
|
|
|
|
|
|
|
|
**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.
|
|
**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 Cellar:
|
|
#### 4\.1 Procedure to retrieve the data from ShowVoc:
|
|
|
|
|
|
|
|
- Access the page: http://publications.europa.eu/webapi/rdf/sparql
|
|
- Access the page: https://showvoc.op.europa.eu/#/datasets/Countries_and_territories/sparql
|
|
|
- Copy and paste one of the following query into the text editor (replace the existing one)
|
|
- Copy and paste one of the following query into the text editor (replace the existing one)
|
|
|
- In the list "Results Format", select the output format of the query (JSON, HTML, CSV)
|
|
- Press"Submit".
|
|
|
- Press"Run query".
|
|
- The results appear as a list.
|
|
|
- If you have selected HTML, the results will appear as a list.
|
|
- On the right side, click on "Save result as..." and select the type of export you need.
|
|
|
|
- The data retrieval is automatically launched.
|
|
|
|
|
|
|
|
#### 4\.2 UN Members (English preferred labels):
|
|
#### 4\.2 UN Members (English preferred labels):
|
|
|
|
|
|
| ... | @@ -121,34 +119,22 @@ PREFIX owl: <http://www.w3.org/2002/07/owl#> |
... | @@ -121,34 +119,22 @@ PREFIX owl: <http://www.w3.org/2002/07/owl#> |
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
PREFIX org: <http://www.w3.org/ns/org#>
|
|
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 ?country_uri ?named_authority_code?country_en WHERE {
|
|
|
|
|
|
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
SELECT distinct ?concept_uri ?country_en WHERE {
|
|
|
?country_uri a skos:Concept .
|
|
values ?scheme {
|
|
|
?country_uri skos:prefLabel ?c_en .
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
|
|
}
|
|
|
|
?concept_uri a skos:Concept .
|
|
|
|
?concept_uri skos:prefLabel ?c_en .
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
filter(lang(?c_en) = "en")
|
|
filter(lang(?c_en) = "en")
|
|
|
|
|
|
|
|
# Filtering on the memberhip to UNO
|
|
?concept_uri org:hasMembership ?membership .
|
|
|
?country_uri org:hasMembership ?membership .
|
|
|
|
|
?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
|
|
|
|
|
|
# Retrieval of the EU official code
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
?country_uri euvoc:xlNotation ?not_authority .
|
|
} order by ?country_en
|
|
|
?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):
|
|
#### 4\.3 UN Members (all EU languages):
|
| ... | @@ -156,60 +142,54 @@ SELECT distinct ?country_uri ?named_authority_code?country_en WHERE { |
... | @@ -156,60 +142,54 @@ SELECT distinct ?country_uri ?named_authority_code?country_en WHERE { |
|
|
The following query retrieves all the UN members with their labels in the 24 official EU languages (the header of the column are as follow : "?country\_" + language tag.
|
|
The following query retrieves all the UN members with their labels in the 24 official EU languages (the header of the column are as follow : "?country\_" + language tag.
|
|
|
|
|
|
|
|
```plaintext
|
|
```plaintext
|
|
|
|
|
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
PREFIX org: <http://www.w3.org/ns/org#>
|
|
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 ?country_uri ?named_authority_code ?country_en ?country_bg ?country_cs ?country_da ?country_de ?country_el ?country_es ?country_et ?country_fi ?country_fr ?country_ga ?country_hr ?country_it ?country_lt ?country_lv ?country_mt ?country_nl ?country_pl ?country_pt ?country_ro ?country_sk ?country_sl ?country_sv
|
|
SELECT distinct ?concept_uri ?country_en ?country_bg ?country_cs ?country_da ?country_de ?country_el
|
|
|
|
?country_es ?country_et ?country_fi ?country_fr ?country_ga ?country_hr ?country_it ?country_lt
|
|
|
|
?country_lv ?country_mt ?country_nl ?country_pl ?country_pt ?country_ro ?country_sk ?country_sl ?country_sv
|
|
|
|
|
|
|
|
WHERE {
|
|
WHERE {
|
|
|
# Retrieving the countries and their preferred labels
|
|
values ?scheme {
|
|
|
?country_uri a skos:Concept .
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
|
?country_uri skos:prefLabel ?c_en . Bind(str(?c_en) as ?country_en) filter(lang(?c_en) = "en")
|
|
}
|
|
|
?country_uri skos:prefLabel ?c_bg . Bind(str(?c_bg) as ?country_bg) filter(lang(?c_bg) = "bg")
|
|
?concept_uri a skos:Concept .
|
|
|
?country_uri skos:prefLabel ?c_cs . Bind(str(?c_cs) as ?country_cs) filter(lang(?c_cs) = "cs")
|
|
?concept_uri skos:prefLabel ?c_en . Bind(str(?c_en) as ?country_en) filter(lang(?c_en) = "en")
|
|
|
?country_uri skos:prefLabel ?c_da . Bind(str(?c_da) as ?country_da) filter(lang(?c_da) = "da")
|
|
?concept_uri skos:prefLabel ?c_bg . Bind(str(?c_bg) as ?country_bg) filter(lang(?c_bg) = "bg")
|
|
|
?country_uri skos:prefLabel ?c_de . Bind(str(?c_de) as ?country_de) filter(lang(?c_de) = "de")
|
|
?concept_uri skos:prefLabel ?c_cs . Bind(str(?c_cs) as ?country_cs) filter(lang(?c_cs) = "cs")
|
|
|
?country_uri skos:prefLabel ?c_el . Bind(str(?c_el) as ?country_el) filter(lang(?c_el) = "el")
|
|
?concept_uri skos:prefLabel ?c_da . Bind(str(?c_da) as ?country_da) filter(lang(?c_da) = "da")
|
|
|
?country_uri skos:prefLabel ?c_es . Bind(str(?c_es) as ?country_es) filter(lang(?c_es) = "es")
|
|
?concept_uri skos:prefLabel ?c_de . Bind(str(?c_de) as ?country_de) filter(lang(?c_de) = "de")
|
|
|
?country_uri skos:prefLabel ?c_et . Bind(str(?c_et) as ?country_et) filter(lang(?c_et) = "et")
|
|
?concept_uri skos:prefLabel ?c_el . Bind(str(?c_el) as ?country_el) filter(lang(?c_el) = "el")
|
|
|
?country_uri skos:prefLabel ?c_fi . Bind(str(?c_fi) as ?country_fi) filter(lang(?c_fi) = "fi")
|
|
?concept_uri skos:prefLabel ?c_es . Bind(str(?c_es) as ?country_es) filter(lang(?c_es) = "es")
|
|
|
?country_uri skos:prefLabel ?c_fr . Bind(str(?c_fr) as ?country_fr) filter(lang(?c_fr) = "fr")
|
|
?concept_uri skos:prefLabel ?c_et . Bind(str(?c_et) as ?country_et) filter(lang(?c_et) = "et")
|
|
|
?country_uri skos:prefLabel ?c_ga . Bind(str(?c_ga) as ?country_ga) filter(lang(?c_ga) = "ga")
|
|
?concept_uri skos:prefLabel ?c_fi . Bind(str(?c_fi) as ?country_fi) filter(lang(?c_fi) = "fi")
|
|
|
?country_uri skos:prefLabel ?c_hr . Bind(str(?c_hr) as ?country_hr) filter(lang(?c_hr) = "hr")
|
|
?concept_uri skos:prefLabel ?c_fr . Bind(str(?c_fr) as ?country_fr) filter(lang(?c_fr) = "fr")
|
|
|
?country_uri skos:prefLabel ?c_hu . Bind(str(?c_hu) as ?country_hu) filter(lang(?c_hu) = "hu")
|
|
?concept_uri skos:prefLabel ?c_ga . Bind(str(?c_ga) as ?country_ga) filter(lang(?c_ga) = "ga")
|
|
|
?country_uri skos:prefLabel ?c_it . Bind(str(?c_it) as ?country_it) filter(lang(?c_it) = "it")
|
|
?concept_uri skos:prefLabel ?c_hr . Bind(str(?c_hr) as ?country_hr) filter(lang(?c_hr) = "hr")
|
|
|
?country_uri skos:prefLabel ?c_lt . Bind(str(?c_lt) as ?country_lt) filter(lang(?c_lt) = "lt")
|
|
?concept_uri skos:prefLabel ?c_hu . Bind(str(?c_hu) as ?country_hu) filter(lang(?c_hu) = "hu")
|
|
|
?country_uri skos:prefLabel ?c_lv . Bind(str(?c_lv) as ?country_lv) filter(lang(?c_lv) = "lv")
|
|
?concept_uri skos:prefLabel ?c_it . Bind(str(?c_it) as ?country_it) filter(lang(?c_it) = "it")
|
|
|
?country_uri skos:prefLabel ?c_mt . Bind(str(?c_mt) as ?country_mt) filter(lang(?c_mt) = "mt")
|
|
?concept_uri skos:prefLabel ?c_lt . Bind(str(?c_lt) as ?country_lt) filter(lang(?c_lt) = "lt")
|
|
|
?country_uri skos:prefLabel ?c_nl . Bind(str(?c_nl) as ?country_nl) filter(lang(?c_nl) = "nl")
|
|
?concept_uri skos:prefLabel ?c_lv . Bind(str(?c_lv) as ?country_lv) filter(lang(?c_lv) = "lv")
|
|
|
?country_uri skos:prefLabel ?c_pl . Bind(str(?c_pl) as ?country_pl) filter(lang(?c_pl) = "pl")
|
|
?concept_uri skos:prefLabel ?c_mt . Bind(str(?c_mt) as ?country_mt) filter(lang(?c_mt) = "mt")
|
|
|
?country_uri skos:prefLabel ?c_pt . Bind(str(?c_pt) as ?country_pt) filter(lang(?c_pt) = "pt")
|
|
?concept_uri skos:prefLabel ?c_nl . Bind(str(?c_nl) as ?country_nl) filter(lang(?c_nl) = "nl")
|
|
|
?country_uri skos:prefLabel ?c_ro . Bind(str(?c_ro) as ?country_ro) filter(lang(?c_ro) = "ro")
|
|
?concept_uri skos:prefLabel ?c_pl . Bind(str(?c_pl) as ?country_pl) filter(lang(?c_pl) = "pl")
|
|
|
?country_uri skos:prefLabel ?c_sk . Bind(str(?c_sk) as ?country_sk) filter(lang(?c_sk) = "sk")
|
|
?concept_uri skos:prefLabel ?c_pt . Bind(str(?c_pt) as ?country_pt) filter(lang(?c_pt) = "pt")
|
|
|
?country_uri skos:prefLabel ?c_sl . Bind(str(?c_sl) as ?country_sl) filter(lang(?c_sl) = "sl")
|
|
?concept_uri skos:prefLabel ?c_ro . Bind(str(?c_ro) as ?country_ro) filter(lang(?c_ro) = "ro")
|
|
|
?country_uri skos:prefLabel ?c_sv . Bind(str(?c_sv) as ?country_sv) filter(lang(?c_sv) = "sv")
|
|
?concept_uri skos:prefLabel ?c_sk . Bind(str(?c_sk) as ?country_sk) filter(lang(?c_sk) = "sk")
|
|
|
|
|
?concept_uri skos:prefLabel ?c_sl . Bind(str(?c_sl) as ?country_sl) filter(lang(?c_sl) = "sl")
|
|
|
# Retrieval of the EU official code
|
|
?concept_uri skos:prefLabel ?c_sv . Bind(str(?c_sv) as ?country_sv) filter(lang(?c_sv) = "sv")
|
|
|
?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> .
|
|
|
|
|
|
|
?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:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
|
|
|
|
|
|
# Filtering out the deprecated and the retired concepts
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
filter not exists {?country_uri owl:deprecated ?true}
|
|
} order by ?country_en
|
|
|
filter not exists {
|
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>}
|
|
|
|
|
|
|
|
|
|
} order by ?country_uri
|
|
|
|
|
```
|
|
```
|
|
|
|
|
|
|
|
#### 4\.4 UN observers:
|
|
#### 4\.4 UN observers:
|
| ... | @@ -219,34 +199,33 @@ PREFIX owl: <http://www.w3.org/2002/07/owl#> |
... | @@ -219,34 +199,33 @@ PREFIX owl: <http://www.w3.org/2002/07/owl#> |
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
PREFIX org: <http://www.w3.org/ns/org#>
|
|
PREFIX org: <http://www.w3.org/ns/org#>
|
|
|
PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#>
|
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
|
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
|
|
|
|
|
|
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE {
|
|
SELECT distinct ?concept_uri ?country_en WHERE {
|
|
|
|
|
values ?scheme {
|
|
|
# Retrieving the countries and their english preferred labels
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
|
?country_uri a skos:Concept .
|
|
}
|
|
|
?country_uri skos:prefLabel ?c_en .
|
|
?concept_uri a skos:Concept .
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
|
|
filter(lang(?c_en) = "en")
|
|
optional {
|
|
|
|
|
?concept_uri skos:prefLabel ?c_en .
|
|
|
# Filtering on the memberships
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
?country_uri org:hasMembership ?membership .
|
|
filter(lang(?c_en) = "en")
|
|
|
|
filter not exists {
|
|
|
|
?concept_uri skos:altLabel ?altwithstar .
|
|
|
|
filter(contains(?altwithstar, "*"))
|
|
|
|
}
|
|
|
|
}
|
|
|
|
optional {
|
|
|
|
?concept_uri skos:altLabel ?altwithstar .
|
|
|
|
Bind(str(?altwithstar) as ?country_en)
|
|
|
|
filter(lang(?altwithstar) = "en")
|
|
|
|
filter(contains(?altwithstar, "*"))
|
|
|
|
}
|
|
|
|
?concept_uri org:hasMembership ?membership .
|
|
|
?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/UN_OBSERVER> .
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/UN_OBSERVER> .
|
|
|
|
|
|
|
|
# Filtering out the deprecated and the retired concepts
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
filter not exists {?country_uri owl:deprecated ?true}
|
|
|
|
|
filter not exists {
|
|
|
|
|
?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> .
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
} order by ?country_en
|
|
} order by ?country_en
|
|
|
```
|
|
```
|
|
|
|
|
|
| ... | @@ -256,27 +235,17 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE { |
... | @@ -256,27 +235,17 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE { |
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#>
|
|
|
|
|
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
|
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
|
|
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE {
|
|
SELECT distinct ?concept_uri ?country_en WHERE {
|
|
|
values ?scheme {
|
|
values ?scheme {
|
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
|
}
|
|
}
|
|
|
?country_uri a skos:Concept .
|
|
?concept_uri a skos:Concept .
|
|
|
?country_uri skos:prefLabel ?c_en .
|
|
?concept_uri skos:prefLabel ?c_en .
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
?country_uri skos:inScheme ?scheme .
|
|
?concept_uri skos:inScheme ?scheme .
|
|
|
filter(lang(?c_en) = "en")
|
|
filter(lang(?c_en) = "en")
|
|
|
filter not exists {?country_uri owl:deprecated ?true}
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
filter not exists {
|
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>
|
|
|
|
|
}
|
|
|
|
|
?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> .
|
|
|
|
|
|
|
|
|
|
} order by ?country_en
|
|
} order by ?country_en
|
|
|
```
|
|
```
|
|
|
|
|
|
| ... | @@ -288,92 +257,26 @@ The following query retrieves all the territories and marine areas with their la |
... | @@ -288,92 +257,26 @@ The following query retrieves all the territories and marine areas with their la |
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#>
|
|
|
|
|
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
|
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
|
|
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en
|
|
SELECT distinct ?concept_uri ?country_en WHERE {
|
|
|
WHERE {
|
|
|
|
|
values ?scheme {
|
|
values ?scheme {
|
|
|
<http://publications.europa.eu/resource/authority/country/0002>
|
|
<http://publications.europa.eu/resource/authority/country/0002>
|
|
|
<http://publications.europa.eu/resource/authority/country/0003>
|
|
<http://publications.europa.eu/resource/authority/country/0003>
|
|
|
}
|
|
}
|
|
|
?country_uri a skos:Concept .
|
|
?concept_uri a skos:Concept .
|
|
|
?country_uri skos:prefLabel ?c_en .
|
|
?concept_uri skos:prefLabel ?c_en .
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
?country_uri skos:inScheme ?scheme .
|
|
?concept_uri skos:inScheme ?scheme .
|
|
|
filter(lang(?c_en) = "en")
|
|
filter(lang(?c_en) = "en")
|
|
|
filter not exists {?country_uri owl:deprecated ?true}
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
filter not exists {
|
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
?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> .
|
|
|
|
|
} order by ?country_en
|
|
} order by ?country_en
|
|
|
```
|
|
```
|
|
|
|
|
|
|
|
**Note:** The disputed territories are also included into the results of this SPARQL query.
|
|
**Note:** The disputed territories are also included into the results of this SPARQL query.
|
|
|
|
|
|
|
|
#### 4\.7 Current official countries (only) and their related ISO codes:
|
|
#### 4\.7 Current countries and their related ISO codes:
|
|
|
|
|
|
|
|
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/>
|
|
|
|
|
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: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")
|
|
|
|
|
|
|
|
|
|
?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>
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#### 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 :
|
|
The following query retrieves all the current states, their related english (preferred) labels , and their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) :
|
|
|
|
|
|
|
|
```plaintext
|
|
```plaintext
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
| ... | @@ -385,20 +288,13 @@ PREFIX skos: <http://www.w3.org/2004/02/skos/core#> |
... | @@ -385,20 +288,13 @@ PREFIX skos: <http://www.w3.org/2004/02/skos/core#> |
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
|
|
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
|
|
|
|
|
|
|
|
SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2
|
|
SELECT ?country_uri ?country_en ?ISO_31661_alpha2 ?ISO_31661_alpha3 ?ISO_31661_num WHERE {
|
|
|
?ISO_31661_alpha3 ?ISO_31661_num
|
|
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
|
|
?country_uri a skos:Concept .
|
|
?country_uri a skos:Concept .
|
|
|
?country_uri skos:prefLabel ?c_label_en .
|
|
?country_uri skos:prefLabel ?c_label_en .
|
|
|
Bind(str(?c_label_en) as ?country_en) .
|
|
Bind(str(?c_label_en) as ?country_en) .
|
|
|
filter(lang(?c_label_en) = "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 {
|
|
optional {
|
|
|
?country_uri euvoc:xlNotation ?not_alpha2 .
|
|
?country_uri euvoc:xlNotation ?not_alpha2 .
|
| ... | @@ -420,68 +316,5 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
... | @@ -420,68 +316,5 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
filter not exists {
|
|
filter not exists {
|
|
|
?country_uri owl:deprecated ?dep
|
|
?country_uri owl:deprecated ?dep
|
|
|
}
|
|
}
|
|
|
filter not exists {
|
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>
|
|
|
|
|
}
|
|
|
|
|
}
|
|
}
|
|
|
|
|
``` |
|
|
```
|
|
\ No newline at end of file |
|
|
#### 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 memberstates 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 :
|
|
|
|
|
|
|
|
|
|
```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>
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
