User:Rama

Babel user information
en-4 This user has near native speaker knowledge of English. fr-4 Cet utilisateur dispose de connaissances proches de la langue maternelle en français. de-2 Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau. it-1 Questo utente può contribuire con un livello elementare in italiano. es-1 Esta persona tiene un conocimiento básico del español.
Users by language

Scripts and tools

• User:Rama/common.js (main config)
• User:Rama/wikidata useful.js (config)
• copy

Examples of queries

• User:Rama/Imaginary museum

Egyptian steles of the Louvre

The following query uses these:

• Items: stele (Q178743)   , Department of Egyptian Antiquities of the Louvre (Q3044749)   

• Properties: instance of (P31)   , collection (P195)   , image (P18)   

Features: ImageGrid (Q24515278)   

#defaultView:ImageGrid
SELECT ?item ?itemLabel ?pic
WHERE
{
    ?item wdt:P31 wd:Q178743.     
    ?item  wdt:P195 wd:Q3044749.
    ?item wdt:P18 ?pic
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

Try it!

Check accession numbers

The following query uses these:

• Properties: collection (P195)   , inventory number (P217)   , image (P18)   

  SELECT DISTINCT ?item ?itemLabel ?dptLabel  ?inv ?img
  WHERE
  {
    ?item wdt:P195 ?dpt.
    ?item wdt:P217 ?inv.
    VALUES ?inv {"A 45"}.
    OPTIONAL{?item wdt:P18 ?img}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Statuettes of Bastet with photographs

The following query uses these:

• Items: figurine (Q16738862)   , figurine (Q1066288)   , statue (Q179700)   , Bastet (Q129106)   , Sekhmet (Q146104)   , Wadjet (Q146007)   

• Properties: instance of (P31)   , depicts (P180)   , image (P18)   

Features: ImageGrid (Q24515278)   

#defaultView:ImageGrid
SELECT distinct ?item ?itemLabel ?pic
WHERE
{
    VALUES ?statuette {wd:Q16738862 wd:Q1066288 wd:Q179700} # statuette or statue
    VALUES ?bastet {wd:Q129106 wd:Q146104 wd:Q146007} # Bastet or Sekhmet or Wadjet
    ?item wdt:P31 ?statuette.        # is a statuette or statue
    ?item  wdt:P180 ?bastet.         # subject is Bastet
    ?item wdt:P18 ?pic               # Pikz or it did not happen
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

Try it!

Chief Mousers of the Cabinet, by date

The following query uses these:

• Items: house cat (Q146)   , Chief Mouser to the Cabinet Office (Q198641)   

• Properties: instance of (P31)   , date of birth (P569)   , image (P18)   , position held (P39)   , start time (P580)   

  #defaultView:Timeline
  SELECT ?item ?itemLabel ?startdate (SAMPLE(?image) AS ?image)
  WHERE
  {
      ?item wdt:P31 wd:Q146.      
      ?item  p:P39 ?mouserOffice. 
      ?mouserOffice ps:P39 wd:Q198641.
      ?mouserOffice pq:P580 ?startdate .
  	#?item wdt:P569 ?startdate .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
      OPTIONAL { ?item wdt:P18 ?image }
  }
  GROUP BY ?item ?itemLabel ?startdate
  

Try it!

Microscopes

The following query uses these:

• Items: microscope (Q196538)   

• Properties: instance of (P31)   , subclass of (P279)   , image (P18)   

Features: ImageGrid (Q24515278)   

#defaultView:ImageGrid
SELECT ?item ?itemLabel ?pic
WHERE
{
    ?item wdt:P31/wdt:P279* wd:Q196538.      
    ?item wdt:P18 ?pic
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

Try it!

Art in Geneva

Works of art from FCAC or FMAC (contemporary art in Geneva)

The following query uses these:

• Items: Fonds cantonal d'art contemporain, Genève (Q27481225)   , Municipal Fund for Contemporary Art Geneva (Q16636570)   , Geneva University Hospitals (Q3145370)   , Geneva (Q71)   , Crédit cadre d'art contemporain (Q123859078)   , Fonds d'art contemporain de Meyrin (Q121890510)   

• Properties: collection (P195)   , coordinate location (P625)   , creator (P170)   , location (P276)   , image (P18)   , street address (P6375)   

Features: map (Q24515275)   

#defaultView:Map
SELECT ?item ?itemLabel ?pic ?locationLabel ?streetAddress ?geo ?authorLabel WHERE {
  VALUES ?institution {wd:Q27481225 wd:Q16636570 wd:Q3145370 wd:Q71 wd:Q123859078 wd:Q121890510} # selected institutions are FCAC, FMAC, HUG, City of Geneva, Fonds d'art de Carouge, Fonds d'art contemporain de Meyrin
  ?item wdt:P195 ?institution ;                   # item is in collection of one of the selected institutions
        wdt:P625 ?geo ;
        wdt:P170 ?author ;
        wdt:P276 ?location ;
  OPTIONAL { ?item wdt:P18 ?pic .}                # get the picture as well if we can
  OPTIONAL { ?location wdt:P6375 ?streetAddress .}         # get the street address of location
  # MINUS { ?item wdt:P18 [] } .  # that lack a picture
        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

Try it!

Geneva Lux

The following query uses these:

• Items: Geneva Lux (Q3070027)   

• Properties: collection (P195)   , coordinate location (P625)   , creator (P170)   , location (P276)   , image (P18)   , street address (P6375)   

Features: map (Q24515275)   

#defaultView:Map
SELECT ?item ?itemLabel ?pic ?locationLabel ?streetAddress ?geo ?authorLabel WHERE {
    ?item wdt:P195 wd:Q3070027 ;                   # item is in collection Geneva Lux
        wdt:P625 ?geo ;
        #wdt:P170 ?author ;
        wdt:P276 ?location ;
  OPTIONAL { ?item wdt:P18 ?pic .}                # get the picture as well if we can
  OPTIONAL { ?location wdt:P6375 ?streetAddress .}         # get the street address of location
  # MINUS { ?item wdt:P18 [] } .  # that lack a picture
        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

Try it!

Works of art by Albert Siegenthaler

The following query uses these:

• Items: Albert Siegenthaler (Q38082245)   

• Properties: creator (P170)   , coordinate location (P625)   , location (P276)   , image (P18)   , street address (P6375)   

Features: map (Q24515275)   

#defaultView:Map
SELECT ?item ?itemLabel ?pic ?locationLabel ?streetAddress ?geo WHERE {
  ?item wdt:P170 wd:Q38082245 ;                   # item is in collection of one of the selected institutions
        wdt:P625 ?geo ;
        wdt:P276 ?location ;
  OPTIONAL { ?item wdt:P18 ?pic .}                # get the picture as well if we can
  OPTIONAL { ?location wdt:P6375 ?streetAddress .}         # get the street address of location
  # MINUS { ?item wdt:P18 [] } .  # that lack a picture
        SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}

Try it!

Historical places

• LinkedPasts

Notes

• Racist and colonial monuments and heritage in Geneva