query-a718495818f560f0b26022a395380144

Placenames UK placenames ending in -by

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#>
#defaultView:Map
SELECT ?item ?itemLabel ?coord
WHERE 
{
    ?item wdt:P31/wdt:P279* wd:Q486972;
              wdt:P17 wd:Q145;
              rdfs:label ?itemLabel;
              wdt:P625 ?coord;
         FILTER (lang(?itemLabel) = "en") . 
         FILTER regex (?itemLabel, "(by)$").
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?coord"):::projected v2("?item"):::projected v1("?itemLabel"):::projected a1((" ")) c5(["wd:Q486972"]):::iri c7(["wd:Q145"]):::iri f0[["regex(?itemLabel,'(by)$')"]] f0 --> v1 f1[["?itemLabel = 'en'"]] f1 --> v1 v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c5 v2 --"wdt:P17"--> c7 v2 --"rdfs:label"--> v1 v2 --"wdt:P625"--> v3