User:Multichill/Paintings to upload

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

This is a list of possible images of painting to upload to illustrate items on Wikidata. All data is based on Wikidata and uses a quite complicated query.

It grabs all paintings from Wikidata that use the property Commons compatible image available at URL (P4765), have an {{Institution}} and {{Creator}} here and the creator died before 1923. It lumps that all together in one convenient upload form. Please do upload images and add them to the Wikidata item (and remove the P4765). Feedback on the talk page.


This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WQS | PetScan | YASGUI | Find images Recent Changes | Query: SELECT ?item ?deathyear ?uploadurl ?filelink WHERE { ?item p:P4765 ?image . ?item wdt:P31 wd:Q3305213 . ?image ps:P4765 ?downloadurl . ?image pq:P2701 wd:Q2195 . ?image pq:P2699 ?sourceurl . ?image pq:P1476 ?title . ?image pq:P2093 ?creatorname . MINUS { ?image pq:P275 [] } # Focus on public domain here ?item wdt:P195 ?collection . ?collection wdt:P1612 ?institutiontemplate . BIND(CONCAT("[[:Institution:", ?institutiontemplate, "]]") AS ?institutiontemplatecode) . ?collection rdfs:label ?collectionLabel. FILTER(LANG(?collectionLabel) = "en"). ?collection wdt:P373 ?collectioncategory . ?item wdt:P170 ?creator . ?creator wdt:P1472 ?creatortemplate . BIND(CONCAT("[[:Creator:", ?creatortemplate, "]]") AS ?creatortemplatecode) . ?creator wdt:P570 ?dod . BIND(YEAR(?dod) AS ?deathyear) FILTER(?deathyear < 1923) . ?creator wdt:P373 ?creatorcategory . ?item wdt:P217 ?inv . BIND(REPLACE(CONCAT(?creatorname, " - ", ?title, " - ", ?inv, " - ", ?collectionLabel, ".jpg"), " ", "_") AS ?filename) . BIND(CONCAT("[[:File:", ?filename, "|file]]") AS ?filelink) . BIND(CONCAT("[[:Template:Su","bst:Artwork/subst]]\n\n[[:Template:","PD-Art]]\n\n[[:Template:Su", "bst:]]\n[[:Template:Su", "bst:]]\n") AS ?desc) BIND(CONCAT("[https://tools.wmflabs.org/url2commons/index.html?urls=", ENCODE_FOR_URI(CONCAT(REPLACE(STR(?downloadurl), "_", "\\$US\\$"), " ", ?filename)), "&desc=", ENCODE_FOR_URI(?desc), "]") AS ?uploadurl) } LIMIT 1000
label description creator collection Upload File
Anno 1640. Hendrik Casimir van Nassau sneuvelt voor Hulst painting by Karel Frederik Bombled Karel Frederik Bombled Amsterdam Museum [1] file
Tomb in North Africa painting by Mariano José Maria Bernardo Fortuny y Carbó Marià Fortuny Museum of Fine Arts [2] file
The Visitation painting by Meester van het Leven van Maria Master of the Life of the Virgin Museum Boijmans Van Beuningen [3] file
The Adoration of the Christ Child with Saint Francis of Assisi Receiving the Stigmata; Tobias and the Angel; Saint John the Baptist in the Wilderness; and the Penitent Saint Jerome painting by Biagio d’Antonio Andrea Verrocchio
Biagio d'Antonio
Yale University Art Gallery [4] file
Francois Pierre Guillaume Guizot painting by George Peter Alexander Healy George Peter Alexander Healy Smithsonian American Art Museum [5] file
Job and His Comforters painting by Luca Giordano Luca Giordano Smithsonian American Art Museum [6] file
Peasants and Cattle painting by Nicholaes Berchem Nicolaes Pieterszoon Berchem Smithsonian American Art Museum [7] file
End of auto-generated list.