Wikidata:WikiProject Sculpture

From Wikidata
Jump to navigation Jump to search
Nefertiti Bust (Q582172), 1352–1332 BCE; Neues Museum, Berlin

Welcome to WikiProject Sculpture, where we join forces to improve coverage and quality of the description of sculptures on Wikidata.


Members

[edit]

Add yourself

  1. Juandev (talk) 06:59, 24 September 2019 (UTC)[reply]
  2. Jimj wpg (talk) 14:28, 13 May 2020 (UTC)[reply]
  3. Spinster 💬
  4. Oravrattas (talk) 11:00, 8 June 2020 (UTC)[reply]
  5. MartinPoulter (talk) 05:51, 3 August 2024 (UTC)[reply]

Subpages

[edit]

In this Wikidataspace:

Wikidata talk:
WikiProject Sculpture


Showcase queries

[edit]

Counting

[edit]
#title:Count of sculptures known to Wikidata
SELECT (COUNT(DISTINCT ?item) AS ?count) WHERE {
?item wdt:P31/wdt:P279* wd:Q860861
}
Count of sculptures known to Wikidata
#title:Wikis with pages about individual sculptures
SELECT ?wiki ?wikinameLabel (COUNT(?site) AS ?count) WITH {SELECT DISTINCT ?item WHERE {
?item wdt:P31/wdt:P279? wd:Q860861 } } AS %toplist WHERE {
INCLUDE %toplist.
?site schema:about ?item ; schema:isPartOf ?wiki .
  OPTIONAL { ?wikiname wdt:P856 ?wiki }
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?wiki ?wikinameLabel ORDER BY DESC(?count)
Wikis with pages about individual sculptures

Image galleries

[edit]
#title:The most notable sculptures
#defaultView:ImageGrid
SELECT ?item ?itemLabel (SAMPLE(?img) AS ?image) WITH {SELECT DISTINCT ?item WHERE {
?item wdt:P31/wdt:P279? wd:Q860861.
?item wikibase:sitelinks ?sites. } ORDER BY DESC(?sites) LIMIT 100 } AS %toplist WHERE {
INCLUDE %toplist.
?item wdt:P18 ?img.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?item ?itemLabel
The most notable sculptures

The above query includes a lot of statues and public art with a permanent fixed location. The next query tries to exclude these.

#title:The most notable sculptures without a co-ordinate location
#defaultView:ImageGrid
SELECT ?item ?itemLabel (SAMPLE(?img) AS ?image) WITH {SELECT DISTINCT ?item WHERE {
?item wdt:P31/wdt:P279? wd:Q860861.
  MINUS {?item wdt:P625 []}
?item wikibase:sitelinks ?sites. } ORDER BY DESC(?sites) LIMIT 100 } AS %toplist WHERE {
INCLUDE %toplist.
?item wdt:P18 ?img.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?item ?itemLabel
The most notable sculptures without a co-ordinate location

Maps

[edit]
#title:Map of sculptures
#defaultView:Map{"hide": ["?coords", "?image"]}
SELECT ?item ?itemLabel (SAMPLE(?img) AS ?image) ?coords WHERE {
?item wdt:P31/wdt:P279? wd:Q860861;
  wdt:P625 ?coords;
  wdt:P18 ?img
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?item ?itemLabel ?coords
Map of sculptures
#title:Map of birthplaces of sculptors
#defaultView:Map{"hide": ["?coords"]}
SELECT DISTINCT ?sculptor ?sculptorLabel ?coords WITH {SELECT DISTINCT ?item WHERE {
?item wdt:P31/wdt:P279? wd:Q860861 }  } AS %list WHERE {
INCLUDE %list.
?item wdt:P170 ?sculptor. ?sculptor wdt:P19/wdt:P625 ?coords;
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Map of birthplaces of sculptors

External identifiers

[edit]
#title:External identifiers used for sculptures
SELECT ?id ?idLabel ?statedLabel (COUNT(?value) AS ?count) WITH {
  SELECT DISTINCT ?item WHERE {
     ?item wdt:P31/wdt:P279? wd:Q860861.
  }
} AS %subquery WHERE {
  INCLUDE %subquery .
  ?id wikibase:propertyType wikibase:ExternalId; wikibase:claim ?p; wikibase:statementProperty ?ps.
  ?item ?p [ ?ps ?value ] . OPTIONAL {?id wdt:P9073 ?stated}
#  ?id rdfs:label ?idlabel FILTER (lang(?idlabel) = "en").
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
} GROUP BY ?id ?idLabel ?statedLabel
ORDER BY DESC(?count)
External identifiers used for sculptures

See also

[edit]