EChO IMAGES:SPARQL/examples: Difference between revisions

Add links
From EChO_IMAGES
← Older edit
VisualWikitext
wb (first query)
mNo edit summary
 
(21 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=Queries=
= Queries on EChO IMAGES =
==Inventors==
==Inventors==
{{SPARQL|query=
{{SPARQL|query=
Line 12: Line 12:
}}
}}


===wikidata===
===Wikidata===
 
{{SPARQL|project=wd|query=
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
   ?item wdt:P31 wd:Q172839 .
   ?item wdt:P31 wd:Q172839 .
Line 20: Line 22:
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
}
}}


==image location==
==image location==
<sparql tryit="1">
{{SPARQL|query=
PREFIX wdt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct/>
PREFIX wbt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct/>
PREFIX wd: <https://wikibase.echoimages.labs.wikimedia.pt/entity/>
PREFIX wb: <https://wikibase.echoimages.labs.wikimedia.pt/entity/>




SELECT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE {
SELECT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE {
   ?item wdt:P3 wd:Q56 .
   ?item wbt:P3 wb:Q56 .
     ?item wdt:P6 ?image .
     ?item wbt:P6 ?image .
   ?item wdt:P10 ?location .  
   ?item wbt:P10 ?location .  
   ?item wdt:P13 ?inception .
   ?item wbt:P13 ?inception .
     ?item wdt:P28 ?method .
     ?item wbt:P28 ?method .
   OPTIONAL { ?item wdt:P16 ?creator . }
   OPTIONAL { ?item wbt:P16 ?creator . }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
}
}}


</sparql>
===Wikidata===
===wikidata===
{{SPARQL|project=wd|query=
SELECT DISTINCT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE {
SELECT DISTINCT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location ?depicoord WHERE {
   ?item wdt:P31/wdt:P279* wd:Q125191 .
   ?item wdt:P31/wdt:P279* wd:Q125191 .
   ?item wdt:P18 ?image .
   ?item wdt:P18 ?image .
  ?item wdt:P625 ?location .  
# ?item wdt:P625 ?location .
   ?item wdt:P571 ?inception .
   ?item wdt:P9149 ?depicoord .
    ?item wdt:P2079 ?method .
?item wdt:P571 ?inception .
  ?item wdt:P2079 ?method .
    
    
OPTIONAL { ?item wdt:P170 ?creator . }
OPTIONAL { ?item wdt:P170 ?creator . }
Line 50: Line 55:
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
}
 
}}


==Industry==
==Industry==
===Wikidata===
===Wikidata===
{{SPARQL|project=wd|query=
SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
   ?item wdt:P452 wd:Q1439700 .
   ?item wdt:P452 wd:Q1439700 .
Line 61: Line 66:
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
}
}}


==Women in photography==
==Women in photography==
 
===Wikidata===
===wikidata===
{{SPARQL|project=wd|query=
 
SELECT DISTINCT ?image ?item ?itemLabel ?birth ?country ?countryLabel WHERE {
SELECT DISTINCT ?image ?item ?itemLabel ?birth ?country ?countryLabel WHERE {
   ?item wdt:P106 wd:Q33231 .
   ?item wdt:P106 wd:Q33231 .
Line 83: Line 88:
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
}
}}
== Echoimages properties ==
* [https://tinyurl.com/bd6wnrsv All properties with their correspondent in Wikidata]
= Queries on Wikidata =
* [https://w.wiki/Qj8d All photographers]
* [https://w.wiki/Qj8e Countries of citizenship of photographers]
* [https://qlever.dev/wikidata/i4YAz6 List of the countries of citizenship with English label and coordinates (QLever)]
* [https://qlever.dev/wikidata/pKNkON List of female photographers with country of citizenship and birthdate (QLever)]
** [https://qlever.dev/wikidata/h4eTCe List of female photographers with country of citizenship (Bioimages) and birthdate (QLever)]
* [https://qlever.dev/wikidata/PDqUju List of female photographers with country of citizenship, birthdate, deathdate, image (QLever)]
** [https://qlever.dev/wikidata/e1QDW4 List of female photographers with country of citizenship (Bioimages), birthdate, deathdate, image (QLever)]
* [https://qlever.dev/wikidata/ymUpwn List of female photographers with country of citizenship, birthdate, image, no deathdate (QLever)]
** [https://qlever.dev/wikidata/O4ufa9 List of female photographers with country of citizenship (Bioimages), birthdate, image, no deathdate (QLever)]
** [https://qlever.dev/wikidata/zcP53c List of female photographers with country of citizenship (Echoimages), birthdate, image, no deathdate (QLever)]

Latest revision as of 10:40, 9 June 2026

Queries on EChO IMAGES

Inventors

PREFIX wbt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct/>
PREFIX wb: <https://wikibase.echoimages.labs.wikimedia.pt/entity/>

SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
  ?item wbt:P3 wb:Q66 .
  OPTIONAL { ?item wdt:P79 ?inventor . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!

Wikidata

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
  ?item wdt:P31 wd:Q172839 .
  
  OPTIONAL { ?item wdt:P61 ?inventor . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!

image location

PREFIX wbt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct/>
PREFIX wb: <https://wikibase.echoimages.labs.wikimedia.pt/entity/>


SELECT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE {
  ?item wbt:P3 wb:Q56 .
    ?item wbt:P6 ?image .
  ?item wbt:P10 ?location . 
  ?item wbt:P13 ?inception .
    ?item wbt:P28 ?method .
  OPTIONAL { ?item wbt:P16 ?creator . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!

Wikidata

SELECT DISTINCT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location ?depicoord WHERE {
  ?item wdt:P31/wdt:P279* wd:Q125191 .
  ?item wdt:P18 ?image .
 # ?item wdt:P625 ?location .
  ?item wdt:P9149 ?depicoord .
 ?item wdt:P571 ?inception .
   ?item wdt:P2079 ?method .
  
OPTIONAL { ?item wdt:P170 ?creator . }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!

Industry

Wikidata

SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
  ?item wdt:P452 wd:Q1439700 .
  

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!

Women in photography

Wikidata

SELECT DISTINCT ?image ?item ?itemLabel ?birth ?country ?countryLabel WHERE {
  ?item wdt:P106 wd:Q33231 .
  ?item wdt:P27 ?country .
 
 ?item wdt:P18 ?image .
# ?item wdt:P625 ?location . 
#  ?item wdt:P571 ?inception .
#   ?item wdt:P2079 ?method .
  
 ?item wdt:P569 ?birth;
                wdt:P21 wd:Q6581072;  
  FILTER (?birth > "1790-01-01"^^xsd:dateTime && ?birth < "2026-01-01"^^xsd:dateTime)
  
# OPTIONAL { ?item wdt:P170 ?creator . }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Try it!

Echoimages properties

Queries on Wikidata

Retrieved from "https://wikibase.echoimages.labs.wikimedia.pt/w/index.php?title=EChO_IMAGES:SPARQL/examples&oldid=5998"