Wikidata query to get country synonyms but not flag symbols

Question

I am using the following query to get a list of ISO countries with their details:

SELECT ?country ?countryLabel ?code  ?wikipedia ?countryAltLabel
WHERE
{
  ?country wdt:P297 ?code .
  OPTIONAL {     
                    ?wikipedia schema:about ?country .
                    ?wikipedia schema:isPartOf <https://en.wikipedia.org/>.
                    } .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

The results I am getting look like this:

Is there any way to remove flag symbols from the list of CountryAltLabels?

@StanislavKralin You should post that as an answer. – Tom Morris Jul 21 '20 at 18:09 — Tom Morris, Jul 21 '20 at 18:09

score 2 · Answer 1 · answered Jul 20 '20 at 13:17

2

It seems a little strange that their included as alt labels, but they should be relatively easily to filter out from the results. They will always be exactly two characters from RGI alphabet https://en.wikipedia.org/wiki/Regional_Indicator_Symbol

answered Jul 20 '20 at 13:17

Tom Morris

10,490
32
53

but how do I put a filter query? – Rachel Watson Jul 20 '20 at 15:35
1

maybe you could try converting them to lowercase and get the results. – Prasinus Albus Jul 21 '20 at 04:07

Stanislav Kralin · Accepted Answer · 2020-07-23T20:40:12.313

Three points:

Those flags are pairs of symbols from U+1F1E6—U+1F1FF, as suggested by Tom Morris.
The label service should be used in the manual mode.
A particular query execution order should be forced (via hint:Query hint:optimizer "None").

SELECT ?country ?countryLabel ?code ?wikipedia ?countryAltLabel ?alt {
  hint:Query hint:optimizer "None" . 
  ?country wdt:P297 ?code
  OPTIONAL { ?wikipedia schema:about ?country ; schema:isPartOf <https://en.wikipedia.org/> }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en".
    ?country skos:altLabel ?countryAltLabel ; rdfs:label ?countryLabel         
  } 
  BIND ( REPLACE(?countryAltLabel, "[-]{2}, |, ?[-]{2}", "") AS ?alt )
}

https://w.wiki/Xcv

Note that these and are not regular capital letters. One could write [\\x{1f1e6}-\\x{1f1ff}] instead.

Wikidata query to get country synonyms but not flag symbols

2 Answers2