Code development platform for open source projects from the European Union institutions 🔵 EU Login authentication by SMS has been phased out. To see alternatives please check here

Skip to content

Changes

Page history
Update Home authored by Sebastien ALBOUZE's avatar Sebastien ALBOUZE
Show whitespace changes
Inline Side-by-side
Home.md
View page @ 367a63f6
...@@ -146,54 +146,61 @@ SELECT distinct ?concept_uri ?country_en WHERE { ...@@ -146,54 +146,61 @@ SELECT distinct ?concept_uri ?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 ?concept_uri ?country_en ?country_bg ?country_cs ?country_da ?country_de ?country_el 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
?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 {
values ?scheme { # Retrieving the countries and their preferred labels
<http://publications.europa.eu/resource/authority/country/0004> ?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 a skos:Concept . ?country_uri skos:prefLabel ?c_bg . Bind(str(?c_bg) as ?country_bg) filter(lang(?c_bg) = "bg")
?concept_uri skos:prefLabel ?c_en . Bind(str(?c_en) as ?country_en) filter(lang(?c_en) = "en") ?country_uri skos:prefLabel ?c_cs . Bind(str(?c_cs) as ?country_cs) filter(lang(?c_cs) = "cs")
?concept_uri skos:prefLabel ?c_bg . Bind(str(?c_bg) as ?country_bg) filter(lang(?c_bg) = "bg") ?country_uri skos:prefLabel ?c_da . Bind(str(?c_da) as ?country_da) filter(lang(?c_da) = "da")
?concept_uri skos:prefLabel ?c_cs . Bind(str(?c_cs) as ?country_cs) filter(lang(?c_cs) = "cs") ?country_uri skos:prefLabel ?c_de . Bind(str(?c_de) as ?country_de) filter(lang(?c_de) = "de")
?concept_uri skos:prefLabel ?c_da . Bind(str(?c_da) as ?country_da) filter(lang(?c_da) = "da") ?country_uri skos:prefLabel ?c_el . Bind(str(?c_el) as ?country_el) filter(lang(?c_el) = "el")
?concept_uri skos:prefLabel ?c_de . Bind(str(?c_de) as ?country_de) filter(lang(?c_de) = "de") ?country_uri skos:prefLabel ?c_es . Bind(str(?c_es) as ?country_es) filter(lang(?c_es) = "es")
?concept_uri skos:prefLabel ?c_el . Bind(str(?c_el) as ?country_el) filter(lang(?c_el) = "el") ?country_uri skos:prefLabel ?c_et . Bind(str(?c_et) as ?country_et) filter(lang(?c_et) = "et")
?concept_uri skos:prefLabel ?c_es . Bind(str(?c_es) as ?country_es) filter(lang(?c_es) = "es") ?country_uri skos:prefLabel ?c_fi . Bind(str(?c_fi) as ?country_fi) filter(lang(?c_fi) = "fi")
?concept_uri skos:prefLabel ?c_et . Bind(str(?c_et) as ?country_et) filter(lang(?c_et) = "et") ?country_uri skos:prefLabel ?c_fr . Bind(str(?c_fr) as ?country_fr) filter(lang(?c_fr) = "fr")
?concept_uri skos:prefLabel ?c_fi . Bind(str(?c_fi) as ?country_fi) filter(lang(?c_fi) = "fi") ?country_uri skos:prefLabel ?c_ga . Bind(str(?c_ga) as ?country_ga) filter(lang(?c_ga) = "ga")
?concept_uri skos:prefLabel ?c_fr . Bind(str(?c_fr) as ?country_fr) filter(lang(?c_fr) = "fr") ?country_uri skos:prefLabel ?c_hr . Bind(str(?c_hr) as ?country_hr) filter(lang(?c_hr) = "hr")
?concept_uri skos:prefLabel ?c_ga . Bind(str(?c_ga) as ?country_ga) filter(lang(?c_ga) = "ga") ?country_uri skos:prefLabel ?c_hu . Bind(str(?c_hu) as ?country_hu) filter(lang(?c_hu) = "hu")
?concept_uri skos:prefLabel ?c_hr . Bind(str(?c_hr) as ?country_hr) filter(lang(?c_hr) = "hr") ?country_uri skos:prefLabel ?c_it . Bind(str(?c_it) as ?country_it) filter(lang(?c_it) = "it")
?concept_uri skos:prefLabel ?c_hu . Bind(str(?c_hu) as ?country_hu) filter(lang(?c_hu) = "hu") ?country_uri skos:prefLabel ?c_lt . Bind(str(?c_lt) as ?country_lt) filter(lang(?c_lt) = "lt")
?concept_uri skos:prefLabel ?c_it . Bind(str(?c_it) as ?country_it) filter(lang(?c_it) = "it") ?country_uri skos:prefLabel ?c_lv . Bind(str(?c_lv) as ?country_lv) filter(lang(?c_lv) = "lv")
?concept_uri skos:prefLabel ?c_lt . Bind(str(?c_lt) as ?country_lt) filter(lang(?c_lt) = "lt") ?country_uri skos:prefLabel ?c_mt . Bind(str(?c_mt) as ?country_mt) filter(lang(?c_mt) = "mt")
?concept_uri skos:prefLabel ?c_lv . Bind(str(?c_lv) as ?country_lv) filter(lang(?c_lv) = "lv") ?country_uri skos:prefLabel ?c_nl . Bind(str(?c_nl) as ?country_nl) filter(lang(?c_nl) = "nl")
?concept_uri skos:prefLabel ?c_mt . Bind(str(?c_mt) as ?country_mt) filter(lang(?c_mt) = "mt") ?country_uri skos:prefLabel ?c_pl . Bind(str(?c_pl) as ?country_pl) filter(lang(?c_pl) = "pl")
?concept_uri skos:prefLabel ?c_nl . Bind(str(?c_nl) as ?country_nl) filter(lang(?c_nl) = "nl") ?country_uri skos:prefLabel ?c_pt . Bind(str(?c_pt) as ?country_pt) filter(lang(?c_pt) = "pt")
?concept_uri skos:prefLabel ?c_pl . Bind(str(?c_pl) as ?country_pl) filter(lang(?c_pl) = "pl") ?country_uri skos:prefLabel ?c_ro . Bind(str(?c_ro) as ?country_ro) filter(lang(?c_ro) = "ro")
?concept_uri skos:prefLabel ?c_pt . Bind(str(?c_pt) as ?country_pt) filter(lang(?c_pt) = "pt") ?country_uri skos:prefLabel ?c_sk . Bind(str(?c_sk) as ?country_sk) filter(lang(?c_sk) = "sk")
?concept_uri skos:prefLabel ?c_ro . Bind(str(?c_ro) as ?country_ro) filter(lang(?c_ro) = "ro") ?country_uri skos:prefLabel ?c_sl . Bind(str(?c_sl) as ?country_sl) filter(lang(?c_sl) = "sl")
?concept_uri skos:prefLabel ?c_sk . Bind(str(?c_sk) as ?country_sk) filter(lang(?c_sk) = "sk") ?country_uri skos:prefLabel ?c_sv . Bind(str(?c_sv) as ?country_sv) filter(lang(?c_sv) = "sv")
?concept_uri skos:prefLabel ?c_sl . Bind(str(?c_sl) as ?country_sl) filter(lang(?c_sl) = "sl")
?concept_uri skos:prefLabel ?c_sv . Bind(str(?c_sv) as ?country_sv) filter(lang(?c_sv) = "sv") # 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> .
?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> .
filter not exists {?concept_uri owl:deprecated ?true} # Filtering out the deprecated and the retired concepts
} order by ?country_en 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\.4 UN observers: #### 4\.4 UN observers:
...@@ -203,34 +210,36 @@ PREFIX owl: <http://www.w3.org/2002/07/owl#> ...@@ -203,34 +210,36 @@ 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 ?concept_uri ?country_en WHERE { SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE {
values ?scheme {
<http://publications.europa.eu/resource/authority/country/0004>
}
?concept_uri a skos:Concept .
optional { # Retrieving the countries and their english preferred labels
?concept_uri skos:prefLabel ?c_en . ?country_uri a skos:Concept .
?country_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")
filter not exists {
?concept_uri skos:altLabel ?altwithstar . # Filtering on the memberships
filter(contains(?altwithstar, "*")) ?country_uri org:hasMembership ?membership .
}
}
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> .
filter not exists {?concept_uri owl:deprecated ?true} # 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>}
# 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
``` ```
#### 4\.5 Disputed territories: #### 4\.5 Disputed territories:
...@@ -239,18 +248,29 @@ SELECT distinct ?concept_uri ?country_en WHERE { ...@@ -239,18 +248,29 @@ SELECT distinct ?concept_uri ?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 ?concept_uri ?country_en WHERE { SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE {
values ?scheme { values ?scheme {
<http://publications.europa.eu/resource/authority/country/0004> <http://publications.europa.eu/resource/authority/country/0004>
} }
?concept_uri a skos:Concept . ?country_uri a skos:Concept .
?concept_uri skos:prefLabel ?c_en . ?country_uri skos:prefLabel ?c_en .
Bind(str(?c_en) as ?country_en) Bind(str(?c_en) as ?country_en)
?concept_uri skos:inScheme ?scheme . ?country_uri skos:inScheme ?scheme .
filter(lang(?c_en) = "en") filter(lang(?c_en) = "en")
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>
}
?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
``` ```
#### 4\.6 Territories and marine areas: #### 4\.6 Territories and marine areas:
... ...
......

For further information about the platform and support, please see https://code.europa.eu/info/about