User:Battleofalma/Congruence Engine
A Salts Mill connection to the collection of Science Museums Group?Edit
Beginning to assemble and collect the relevant places, people and their relationshipsEdit
Salts Mill: The Mill, built by Titus Salt in 1853.
Eventually ends up in hands of John Wilmer Field (place of burial St Paul's, Shipley). Lived at Heaton Hall ERROR Wrong Heaton Hall... Heaton Hall (Correct Heaton Hall!) Inherited manors of Heaton and acquired Shipley.
His daughter Mary Parsons/Field married William Parsons, 3rd Earl of Rosse.
Earl of Rosse built the Leviathan of Parsonstown of which the Mirror for the Great Rosse Telescope, 1844-1846 is in the Science Museum Group collection, is also depicted by a model of the telescope
First queries after improving ownership data of Shipley and HeatonEdit
SELECT ?item ?itemLabel ?ownerLabel ?work ?workLabel ?depictedLabel ?imageLabel #added a Label here
WHERE { ?item wdt:P31 wd:Q2116450 . #manor estates
?item wdt:P131 wd:Q22905 . #located in Bradford
?item wdt:P127 ?owner . #with owners
?owner wdt:P800 ?work . #has notable work
?work wdt:P1299 ?depicted .
OPTIONAL { ?depicted wdt:P18 ?image . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } #added labelservice here
}
Limit 10
#Manor estates of Shipley and Heaton and their connection to the Leviathan of Parsonstown and its depictions
#defaultView:Graph
SELECT ?item ?itemLabel ?ownerLabel ?work ?workLabel ?depictedLabel ?imageLabel ?ownerimageLabel ?workimageLabel #added a Label here
WHERE { ?item wdt:P31 wd:Q2116450 . #manor estates
?item wdt:P131 wd:Q22905 . #located in Bradford
?item wdt:P127 ?owner . #with owners
?owner wdt:P18 ?ownerimage . #image of owner
?owner wdt:P800 ?work . #has notable work
?work wdt:P18 ?workimage . #work has image
?work wdt:P1299 ?depicted .
OPTIONAL { ?depicted wdt:P18 ?image . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } #added labelservice here
}
Limit 10
Version using Martin's graph query templateEdit
#defaultView:Graph
SELECT ?item1 ?image ?item1Label ?item2 ?image2 ?item2Label ?edgeLabel
WITH { SELECT ?item1 WHERE {
VALUES ?item1 {wd:Q105786786 wd:Q7406198 wd:Q459970 wd:Q105777188 wd:Q105786786 wd:Q310121 wd:Q105439204 wd:Q674773 wd:Q3296235 wd:Q310121 wd:Q75304117}
} } AS %item1
WITH {SELECT (?item1 AS ?item2) WHERE {INCLUDE %item1} } AS %item2
WHERE {
INCLUDE %item1.
INCLUDE %item2.?item1 ?prop ?item2.
?edge ?dummy ?prop ; rdf:type wikibase:Property
OPTIONAL {?item1 wdt:P18 ?image}
OPTIONAL {?item2 wdt:P18 ?image2}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
#defaultView:Graph
SELECT ?item1 ?image ?item1Label ?item2 ?image2 ?item2Label ?edgeLabel
WITH { SELECT ?item1 WHERE {
VALUES ?item1 {wd:Q105786786 wd:Q7406198 wd:Q459970 wd:Q105777188 wd:Q112253124 wd:Q105786786 wd:Q310121 wd:Q1421532 wd:Q105439204 wd:Q674773 wd:Q7810332 wd:Q3296235 wd:Q838920 wd:Q310121 wd:Q75304117}
} } AS %item1
WITH {SELECT (?item1 AS ?item2) WHERE {INCLUDE %item1} } AS %item2
WHERE {
INCLUDE %item1.
INCLUDE %item2.?item1 ?prop ?item2.
?edge ?dummy ?prop ; rdf:type wikibase:Property
OPTIONAL {?item1 wdt:P18 ?image}
OPTIONAL {?item2 wdt:P18 ?image2}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}