query-e51fa4406c26f0880847b485313df084
Borders between European Union and non European countries
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Map
SELECT distinct ?item ?itemLabel ?coord WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?item wdt:P31 wd:Q757292 .#checkpoints
?item wdt:P361*/wdt:P31/wdt:P279* wd:Q67147037 . #located on a UE border
?item wdt:P17*/wdt:P463* wd:Q458. #in a European Union country
MINUS { ?item wdt:P576 _:b2. } #Remove dissolved
MINUS { ?item wdt:P361 wd:Q3089219. } #Remove maritime borders
MINUS { ?item wdt:P361 wd:Q67457910. } #Remove municipal/cities borders
MINUS { ?item wdt:P361 wd:Q700754. } #Remove RFA-RDA borders
MINUS { ?item wdt:P361 wd:Q67218438. } #Remove air borders
OPTIONAL { ?item wdt:P625 ?coord. }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?coord"):::projected
v1("?item"):::projected
a4((" "))
a1((" "))
a2((" "))
a3((" "))
c9(["wd:Q67147037"]):::iri
c6(["wd:Q757292"]):::iri
c16(["wd:Q700754"]):::iri
c2(["bd:serviceParam"]):::iri
c12(["wd:Q458"]):::iri
c4(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c14(["wd:Q3089219"]):::iri
c15(["wd:Q67457910"]):::iri
c17(["wd:Q67218438"]):::iri
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c2 --"wikibase:language"--> c4
end
v1 --"wdt:P31"--> c6
v1 --"wdt:P361"--> a1
a1 --"wdt:P31"--> a2
a2 --"wdt:P279"--> c9
v1 --"wdt:P17"--> a3
a3 --"wdt:P463"--> c12
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P576"--> a4
end
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P361"--> c14
end
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P361"--> c15
end
subgraph minus3["MINUS"]
style minus3 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P361"--> c16
end
subgraph minus4["MINUS"]
style minus4 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P361"--> c17
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P625".-> v2
end