EChO IMAGES:SPARQL/examples: Difference between revisions
fix endpoint Wikidata |
|||
| Line 12: | Line 12: | ||
}} | }} | ||
=== | ===Wikidata=== | ||
{{SPARQL|query= | {{SPARQL|project=wd|query= | ||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | PREFIX wdt: <http://www.wikidata.org/prop/direct/> | ||
PREFIX wd: <http://www.wikidata.org/entity/> | PREFIX wd: <http://www.wikidata.org/entity/> | ||
| Line 23: | Line 23: | ||
} | } | ||
}} | }} | ||
==image location== | ==image location== | ||
{{SPARQL|query= | {{SPARQL|query= | ||
| Line 40: | Line 41: | ||
}} | }} | ||
=== | ===Wikidata=== | ||
{{SPARQL|query= | {{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 WHERE { | ||
?item wdt:P31/wdt:P279* wd:Q125191 . | ?item wdt:P31/wdt:P279* wd:Q125191 . | ||
| Line 56: | Line 57: | ||
==Industry== | ==Industry== | ||
===Wikidata=== | ===Wikidata=== | ||
{{SPARQL|query= | {{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 66: | Line 66: | ||
} | } | ||
}} | }} | ||
==Women in photography== | ==Women in photography== | ||
===Wikidata=== | |||
=== | {{SPARQL|project=wd|query= | ||
{{SPARQL|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 88: | Line 88: | ||
} | } | ||
}} | }} | ||
= Queries on Wikidata = | = Queries on Wikidata = | ||
* [https://w.wiki/Qj8d All photographers] | * [https://w.wiki/Qj8d All photographers] | ||
Revision as of 09:23, 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". }
}
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". }
}
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". }
}
Wikidata
SELECT DISTINCT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE {
?item wdt:P31/wdt:P279* wd:Q125191 .
?item wdt:P18 ?image .
?item wdt:P625 ?location .
?item wdt:P571 ?inception .
?item wdt:P2079 ?method .
OPTIONAL { ?item wdt:P170 ?creator . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Industry
Wikidata
SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
?item wdt:P452 wd:Q1439700 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
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". }
}
Queries on Wikidata
- All photographers
- Countries of citizenship of photographers
- List of the countries of citizenship with English label and coordinates (QLever)
- List of female photographers with country of citizenship and birthdate (QLever)
- List of female photographers with country of citizenship, birthdate, deathdate, image (QLever)
- List of female photographers with country of citizenship, birthdate, image, no deathdate (QLever)