Wikidata

User:Battleofalma/Congruence Engine

< User:Battleofalma

A Salts Mill connection to the collection of Science Museums Group? edit

Beginning to assemble and collect the relevant places, people and their relationships edit

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 Heaton edit 



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
Try it! 
#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
Try it!

Version using Martin's graph query template edit 

#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" }
}
Try it! 


#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" }
}
Try it!

Occupations edit 

SELECT ?item ?itemLabel ?artistLabel #added a Label here for artist as well.

WHERE { ?item wdt:P31 wd:Q12737077  . #instance of occupation, 
        ?item wdt:P279 wd:Q33394058 . #subclass of manual worker 

       
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } #added labelservice here
      
      }
Try it!

Occupations that have Field of Work property edit 

SELECT DISTINCT ?item ?itemLabel ?location ?locationLabel ?creator ?creatorLabel 

WHERE { ?item (wdt:P31/wdt:P279*) wd:Q12737077 . #Occupations showing fields of work
        ?item wdt:P101 ?field .
        

               
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr". }
              
              }
Try it!

Occupations that have subclass Textile Worker edit 

SELECT ?item ?itemLabel ?artistLabel #added a Label here for artist as well.

WHERE { ?item wdt:P31 wd:Q12737077  . #instance of occupation, 
        ?item wdt:P279 wd:Q66035178 . #subclass of textile worker

       
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } #added labelservice here
      
      }
Try it!

Mills map edit 

#defaultView:Map

SELECT DISTINCT ?item ?itemLabel ?location ?locationLabel ?creator ?creatorLabel ?coords

WHERE { ?item (wdt:P31/wdt:P279*) wd:Q46398483 .
       ?item wdt:P276 ?location .
       ?location wdt:P625 ?coords
        #location coordinates to show map
      
        

               
       SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
              
              }
Try it!

Connecting a Bobbin Turner to the Great Ross Telescope to Other Mill Workers edit

Source is Weaste Heritage Trail 


#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
              wd:Q121082721
wd:Q121082723
wd:Q121082724
wd:Q121082726
wd:Q121082728
wd:Q121082729
wd:Q121082731
wd:Q121082732
wd:Q121082734
wd:Q121082751
wd:Q121082753
wd:Q121082754
wd:Q121082756
wd:Q121082757
wd:Q121082759
wd:Q121082761
wd:Q121082762
wd:Q121082764
wd:Q121082781
wd:Q121082783
wd:Q121082785
wd:Q121082786
wd:Q121082788
wd:Q121082790
wd:Q121082792
wd:Q121082793
wd:Q121082795
wd:Q121082810
wd:Q121082811
wd:Q121082813
wd:Q121082814
wd:Q121082816
wd:Q121082818
wd:Q121082819
wd:Q121082821
wd:Q121082822
wd:Q121082840
wd:Q121082841
wd:Q121082843
wd:Q121082845
wd:Q121082847
wd:Q121082848
wd:Q121082849
wd:Q121082850
wd:Q121082851
wd:Q121082868
wd:Q121082869
wd:Q121082871
wd:Q121082873
wd:Q121082875
wd:Q121082876
wd:Q121082877
wd:Q121082878
wd:Q66035178
wd:Q7406198
wd:Q7810332
wd:Q607081
                             wd:Q46398483
                             
                             
wd:Q946725 #cotton mill
                             wd:Q1421532 #Shipley
                             wd:Q121124637 #Mill worker
                           wd:Q1520790 #bobbin
                             wd:Q121125934 #Bobbins from a spinning machine
                             wd:Q287
                             wd:Q121127989
                             wd:Q30089737
                             wd:Q3973051
                             wd:Q62070119
                             wd:Q3844026
                             wd:Q12992
                             wd:Q121128809
                             
              
              }
} } 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" }
}
Try it!

Workshop edit

Workshop page

Retrieved from "https://www.wikidata.org/w/index.php?title=User:Battleofalma/Congruence_Engine&oldid=2146843620"