query-6bf45b742ee8a0b5e34c143727ef6d5e

Get OpenStreetMap nodes with inarisami label in wikipedia but without inarisami label in OSM

PREFIX osmt: https://wiki.openstreetmap.org/wiki/Key: PREFIX osmm: https://www.openstreetmap.org/meta/

SELECT DISTINCT ?item_smn (?Label_fi as ?wd_label_fi) ?osm_name_fi ?Label_smn ?osm WITH { SELECT ?item_smn ?Label_smn ?coord_smn WHERE { ?item_smn rdfs:label ?Label_smn filter (lang(?Label_smn) = "smn") . ?item_smn wdt:P17 wd:Q33 . ?item_smn wdt:P625 ?coord_smn . } } as %smn WHERE { INCLUDE %smn . ?item_smn rdfs:label ?Label_fi filter (lang(?Label_fi) = "fi") . ?item_smn wdt:P17 wd:Q33 . ?item_smn wdt:P625 ?coord_smn . FILTER(str(?Label_fi)!=str(?Label_smn))

SERVICE https://sophox.org/sparql { ?osm osmt:wikidata ?item_smn . ?osm osmm:type "n". ?osm osmt:name ?osm_name_fi . FILTER NOT EXISTS { ?osm osmt:name:smn ?osm_name_smn }
} } LIMIT 12001 Get OpenStreetMap nodes with inarisami label in wikipedia but without inarisami label in OSM

PREFIX osmt: https://wiki.openstreetmap.org/wiki/Key: PREFIX osmm: https://www.openstreetmap.org/meta/

SERVICE https://sophox.org/sparql { ?osm osmt:wikidata ?item_smn . ?osm osmm:type "n". ?osm osmt:name ?osm_name_fi . FILTER NOT EXISTS { ?osm osmt:name:smn ?osm_name_smn }
} } LIMIT 12001

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#>
# Get OpenStreetMap nodes with inarisami label in wikipedia but without inarisami label in OSM

PREFIX osmt: <https://wiki.openstreetmap.org/wiki/Key:>
PREFIX osmm: <https://www.openstreetmap.org/meta/>

SELECT DISTINCT ?item_smn (?Label_fi as ?wd_label_fi) ?osm_name_fi ?Label_smn ?osm WHERE
{
  {
SELECT ?item_smn ?Label_smn ?coord_smn WHERE {
 ?item_smn rdfs:label ?Label_smn filter (lang(?Label_smn) = "smn") .
 ?item_smn wdt:P17 wd:Q33 .
 ?item_smn wdt:P625 ?coord_smn .
}
}. 
 ?item_smn rdfs:label ?Label_fi filter (lang(?Label_fi) = "fi") .
 ?item_smn wdt:P17 wd:Q33 .
 ?item_smn wdt:P625 ?coord_smn .
 FILTER(str(?Label_fi)!=str(?Label_smn))

 SERVICE <https://sophox.org/sparql> { 
    ?osm osmt:wikidata ?item_smn .
    ?osm osmm:type "n".
    ?osm osmt:name ?osm_name_fi .
    FILTER NOT EXISTS { ?osm osmt:name:smn ?osm_name_smn }   
  } 
} 
LIMIT 12001

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?Label_fi"):::projected v2("?Label_smn"):::projected v4("?coord_smn") v3("?item_smn"):::projected v5("?osm"):::projected v7("?osm_name_fi"):::projected v6("?osm_name_smn") v8("?wd_label_fi") c5(["wd:Q33"]):::iri c11(["n"]):::literal f0[["str(?Label_fi) != str(?Label_smn)"]] f0 --> v1 f0 --> v2 f1[["?Label_fi = 'fi'"]] f1 --> v1 f2[["?Label_smn = 'smn'"]] f2 --> v2 v3 --"rdfs:label"--> v2 v3 --"wdt:P17"--> c5 v3 --"wdt:P625"--> v4 v3 --"rdfs:label"--> v1 v3 --"wdt:P17"--> c5 v3 --"wdt:P625"--> v4 subgraph s1["https://sophox.org/sparql"] style s1 stroke-width:4px; f3[["not "]] subgraph f3e0["Exists Clause"] e0v1 --https://wiki.openstreetmap.org/wiki/Key:name:smn--> e0v2 e0v1("?osm"):::projected e0v2("?osm_name_smn"):::projected end f3--EXISTS--> f3e0 f3 --> v5 f3 --> c8 f3 --> v6 v5 --https://wiki.openstreetmap.org/wiki/Key:name:smn--> v6 v5 --https://wiki.openstreetmap.org/wiki/Key:wikidata--> v3 v5 --https://www.openstreetmap.org/meta/type--> c11 v5 --https://wiki.openstreetmap.org/wiki/Key:name--> v7 end bind4[/"?Label_fi"/] v1 --o bind4 bind4 --as--o v8