query-1eee08c8659bd7cff4139ffde989364f
List of all towns and cities in Catalonia in Spanish language and in Catalan language 19:26, 7 December 2018 (UTC)) talk (Astur Thanks, -- ... Gerona/Girona Lérida/Lleida Alto Ampurdán/Alt Ampurdà Figueras/Figueres In this way:Hi i would like to get a list in two columns with all the towns and cities in Catalonia in Spanish language and in Catalan language,Hi, try this (show in a map, may be shown in a table too)
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?localisation ?label_es ?label_ca ?label_fr ?label_en ?coordinates
WHERE {
?localisation wdt:P31 wd:Q33146843.
?localisation wdt:P625 ?coordinates.
?localisation rdfs:label ?label_es filter (lang(?label_es) = "es").
?localisation rdfs:label ?label_ca filter (lang(?label_ca) = "ca").
?localisation rdfs:label ?label_fr filter (lang(?label_fr) = "fr").
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?coordinates"):::projected
v2("?label_ca"):::projected
v3("?label_es"):::projected
v1("?label_fr"):::projected
v4("?localisation"):::projected
c5(["wd:Q33146843"]):::iri
f0[["?label_fr = 'fr'"]]
f0 --> v1
f1[["?label_ca = 'ca'"]]
f1 --> v2
f2[["?label_es = 'es'"]]
f2 --> v3
v4 --"wdt:P31"--> c5
v4 --"wdt:P625"--> v5
v4 --"rdfs:label"--> v3
v4 --"rdfs:label"--> v2
v4 --"rdfs:label"--> v1