query-a4ef955a9a5fc1c0b257a24cbd088e6e
, etc.(P170)creator , (P547)commemorates , (P825)dedicated to , (P180)depicts . The idea is that these items could be worth looking into because they might be missing a connection like on Mastodon and on TwitterOriginally posted
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 ?monument ?monumentLabel ?person ?personLabel (SAMPLE(?coordinates_) AS ?coordinates) (SAMPLE(?image_) AS ?image) WHERE {
{
SELECT DISTINCT ?monument ?person WHERE {
?monument wdt:P31/wdt:P279* wd:Q4989906;
wdt:P138 ?person.
MINUS {
?monument ?wdt ?person.
FILTER(?wdt != wdt:P138)
}
?person wdt:P31 wd:Q5.
}
LIMIT 100
}
OPTIONAL { ?monument wdt:P625 ?coordinates_. }
OPTIONAL { ?monument wdt:P18 ?image_. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?monument ?monumentLabel ?person ?personLabel
LIMIT 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?coordinates")
v4("?coordinates_"):::projected
v7("?image")
v5("?image_"):::projected
v1("?monument"):::projected
v2("?person"):::projected
v3("?wdt")
a1((" "))
c3(["wd:Q4989906"]):::iri
c9(["bd:serviceParam"]):::iri
c5(["wd:Q5"]):::iri
c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v1 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c3
v1 --"wdt:P138"--> v2
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
f1[["?wdt != 'wdt:P138'"]]
f1 --> v3
v1 -->v3--> v2
end
v2 --"wdt:P31"--> c5
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P625".-> v4
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P18".-> v5
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end
bind4[/"sample(?coordinates_)"/]
v4 --o bind4
bind4 --as--o v6
bind5[/"sample(?image_)"/]
v5 --o bind5
bind5 --as--o v7