Page MenuHomePhabricator

SPARQL: copyright representatives in a museum + result
Closed, ResolvedPublic

Description

Create a SPARQLquery to show the following: Percentage of makers in Museum Boijmans van Beuningen that are represented by Pictoright/CISAC and percentage of makers that are represented by other copyright representatives and the percentage of makers that are not represented by a copyright representative at all.

Edo: this information can only be taken out of wikdata, if the data is actually in there ;-) But lets give it a try...

Event Timeline

Edoderoo updated the task description. (Show Details)Nov 22 2019, 10:48 AM

https://w.wiki/CW9

select ?item ?itemLabel ?makerLabel ?representedLabel where
{

?item wdt:P276 wd:Q679527 .    #locatie Boymans van Beuningen
?item wdt:P170 ?maker .        #bepalen wie de maker is
#?maker wdt:P1875 wd:Q2377084 . #de maker is aangesloten bij Pictoright
?maker wdt:P1875 ?represented  #represented by any org
       {service wikibase:label {bd:serviceParam wikibase:language "nl"}}

} order by ?represented

I found 154 items that do not have a maker at all.
Obviously they will not be shown in the above query, and might influence the outcome of the calculated percentages

https://w.wiki/CWT
select ?item ?itemLabel ?makerLabel ?representedLabel where
{

?item wdt:P276 wd:Q679527 .    #locatie Boymans van Beuningen
OPTIONAL {?item wdt:P170 ?maker} .        #bepalen wie de maker is

{service wikibase:label {bd:serviceParam wikibase:language "nl"}}
FILTER (!bound(?maker))

}

Almost 8000 items have a maker that has no defined representation.
I think that is correct for most of them, but if we miss the representation on some of the makers, it will also influence the percentage you calculate. Looking critically at the outcome of the below query can therefor increase the quality of the data, and the quality of the final calculated percentage

https://w.wiki/CWU
select ?item ?itemLabel ?makerLabel ?representedLabel where
{

?item wdt:P276 wd:Q679527 . #locatie Boymans van Beuningen
?item wdt:P170 ?maker . #bepalen wie de maker is
#?maker wdt:P1875 wd:Q2377084 . #de maker is aangesloten bij Pictoright
OPTIONAL {?maker wdt:P1875 ?represented} #represented by any org

FILTER (!bound(?represented))
     {service wikibase:label {bd:serviceParam wikibase:language "nl"}}

} order by ?represented

Edoderoo renamed this task from SPARQL: copyright representatives in a museum to SPARQL: copyright representatives in a museum + result.Nov 22 2019, 1:05 PM

If anyone has additional queries or remarks to this request, feel free to add!

Edoderoo closed this task as Resolved.Dec 18 2019, 5:49 PM