query-1eee08c8659bd7cff4139ffde989364f

rq turtle/ttl

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

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