derenrich / borked-bot

wikidata bot doing lots of disparate things
GNU General Public License v3.0
8 stars 2 forks source link

youtube creator matched with Wikidata #4

Closed salgo60 closed 3 years ago

salgo60 commented 3 years ago

I am playing around with outdoor gyms see Wikidata:WikiProject_Outdoor_Gyms

One user case I can see is to see what videos are connected to an outdoor gym

--> Feature request: could we also get the account creating the video ? Best would be to match this account to a WIkidata account

Thanks user Salgo60 on WD

derenrich commented 3 years ago

Can you edit an item with how you think the bot should be updating the items in this case and link me to the diff? you want a qualifier on the youtube video with the uploader? what property do you think that should be?

salgo60 commented 3 years ago

Thanks I do a try and will try to check with more people e.g. @Ainali


Today we have: image

My suggestion is add also Property:P2397 "YouTube channel ID"

image

i.e.

User Story: As an user on Wikidata I would like to be able to see who has produced a video so that we can see the differencies of impact(nr of views) when different groups publish videos on a subject

Ainali commented 3 years ago

My suggestion is add also Property:P2397 "YouTube channel ID"

Oh, I like this idea, it would make it much easier to figure out the value of a single video and also make it possible to query for all videos in Wikidata by channel.

derenrich commented 3 years ago

ok so it sounds like as a first step you want videos tagged with the youtube channel they come from. that is easy enough though we'll have to change the set of allowed qualifiers on youtube videos. do you also want me to add a qualifier linking the video to the author/channel item? that is harder and could be done at query time in SPARQL

Ainali commented 3 years ago

Yes, tagging the videos with the youtube channel is enough. No need to add the author item explicitly as that query wouldn't be that hard.

derenrich commented 3 years ago

Ok the bot is updated to tag with the youtube channel. Here is the example edit: https://www.wikidata.org/w/index.php?title=Q240478&type=revision&diff=1464906124&oldid=1463818534 and the code for the change is https://github.com/derenrich/borked-bot/commit/6ac291d39b26f67b0af207b8a3f4165ff1d49ed5

Going back and filling this in for all existing videos will take a while though and my bot is engaged in a task that will take about 20 days so doing that will have to wait. Re-open this ticket if I forget to do it.