query-1997395b3b1478e58b6dddba74492bf5
Add OpenStreetMap relation ID (P402) to US counties (one time data import)
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT * { ?item wdt:P882 [] ; wdt:P17 wd:Q30. MINUS { ?item wdt:P402 [] } . }
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
a1((" "))
a2((" "))
c3(["wd:Q30"]):::iri
v1 --"wdt:P882"--> a1
v1 --"wdt:P17"--> c3
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P402"--> a2
end