User talk:Edgars2007

Jump to: navigation, search

About this board

Logo of Wikidata

Welcome to Wikidata, Edgars2007!

Wikidata is a free knowledge base that you can edit! It can be read and edited by humans and machines alike and you can go to any item page now and add to this ever-growing database!

Need some help getting started? Here are some pages you can familiarize yourself with:

  • Introduction – An introduction to the project.
  • Wikidata tours – Interactive tutorials to show you how Wikidata works.
  • Community portal – The portal for community members.
  • Contents – The main help page for editing and using the site.
  • Project chat – Discussions about the project.
  • Tools – A collection of user-developed JavaScript tools to allow for easier completion of some tasks.

If you have any questions, please ask me on my talk page. If you want to try out editing, you can use the sandbox to try. Once again, welcome, and I hope you quickly feel comfortable here, and become an active editor for Wikidata.

Best regards! --Stryn (talk) 08:19, 22 February 2013 (UTC)

Previous discussion was archived at User talk:Edgars2007/Archive 1 on 2015-12-09.

Cavaliere grande (talkcontribs)

August 24 (Q2825) is surely not "ZHEN WANG" with this ID.~~~~

Reply to "Your Bot"

2 queries wanted for Chess players cleanup

15
Summary by Steak

Seems done.

Wesalius (talkcontribs)

Hi Edgars,

would you be of help once again and write 2 easy queries for me (I am a lost case, I cant construct them on my own :( ) that are listed in tasks no.4 and 5 at Wikidata:WikiProject Chess#Tasks ?

Edoderoo (talkcontribs)

query four will be: select ?item where {?item wdt:P2962 wd:Q1049520 . ?item wdt:P2962 wd:Q752119 }

Right now it lists 902 items, that are both Fide Master and International Master

Edoderoo (talkcontribs)

query five I can not make complete...

select ?item ?fideID ?title where {?item wdt:P1440 ?fideID . optional {?item wdt:P2962 ?title} filter (!bound (?title)) }

This query will show all items with P1440 and without P2962. But you wanted to filter by creator=hypobot and that part I can not add, and I'm not sure if that can be done in SparQL. But if it can be done, I would be pleased to see how.

Edgars2007 (talkcontribs)

Yes, Edo is right about creator=hypobot and SPARQL/Petscan. I have a work-around in mind.

Edgars2007 (talkcontribs)

Here is the list, if I didn't make any mistakes.

The "algorithm": get SPARQL results and get intersection with items, created by HypoBOT.

Wesalius (talkcontribs)

Thank you. Will act on these when there is consensus on notability + when the imports of all titles are done.

Steak (talkcontribs)

Wait. I dont see why we should remove the FIDE master title when an player is International Master. Titles are held for life, and FIDE also lists all titles, example: You dont need to be FIDE master to get the International Master title, so there is also no redundancy in this information.

Edoderoo (talkcontribs)

And the other players might be notable enough to stay on WikiData. For notability it is required that they have a reference to "some database", and that's what they all have.

Removing those items will not free up space, keeping them will not cause trouble, if it's up to me I would let them there now they are imported.

Steak (talkcontribs)

No, untitled players without other reasons to keep them should be deleted. But as long as the ICCF titles are not imported, it's too early to make such a query because there are players without a FIDE title but with an ICCF title.

Wesalius (talkcontribs)

User:Steak When I saw the players with Fide Master and International Master, I thought I made a mistake while running quickstatements, so if they are alright, then there is no problem.

User:Edoderoo - it was User:Steaks request to delete players that are not notable (dont hold title), if it is up to me, I wont delete them either, but truth is I am fine either way.

Steak (talkcontribs)

Well, if you made a mistake, then you should fix it, but if the players are actually FIDE masters and International Masters, then its fine.

Wesalius (talkcontribs)

Of course, that was why I made that a task in a first place. I do not know why you deleted the task...

Steak (talkcontribs)

Because I looked at the results of the query and chose three players where I looked up their titles. All three have both FM and IM title. So removing at all of these items the FIDE title would be wrong. Just remove it at that items where the players never have been FIDE master. Your task sounded as if you want to remove it at all items which are found by the query.

Wesalius (talkcontribs)

I would not know that till I had that query, so you were faster than me ;-)

Steak (talkcontribs)

Just keep in mind that when you check for the titles, the FIDE profile is in 90% of the cases incomplete. The full title history of the player can be found at the elo ratings at olimpbase.org.

Migrant (talkcontribs)

Hello Edgars2007. What do you think of ESBL.ee : Eesti spordi biograafiline leksikon (Q12361673) as a property-identifier ? Or is it out of scope since it is a less popular language ? Best regards Migrant.

Edgars2007 (talkcontribs)

Short answer - I think it's OK for a property. According to etwiki, it has 6tk articles, so it's pretty big one.

Long answer - later :)

Edgars2007 (talkcontribs)

Wikidata:Property proposal/ESBL ID

Migrant (talkcontribs)

Looks good, but your longer answer was put short but with action instead. That's the way i like it, at least this time... Best regards Migrant.

Reply to "ESBL.ee"
The-Pope (talkcontribs)

Hi there, I recently modified the code for the wikipedia:Template:ESPNcricinfo template on en.wikipedia to categorise any misalignment between the ID used in the template and the ID stored in wikidata, or if there was no P2697 statement at all in Wikidata. Currently there are over 600 pages listed in wikipedia:Category:Cricinfo maintenance that use the ESPNcricinfo template in en.wikipedia, but don't have a Wikidata P2697 statement. Is your bot able to do a sweep regularly though that category to add Wikidata statements? Thanks.

Edgars2007 (talkcontribs)

Hi!

OK, will do the import (probably in the weekend), but I really do suck in doing things regularly. Pinging will be fine :)

Reply to "ESPNcricinfo.com player ID (P2697)"
Edoderoo (talkcontribs)

Thanks for the script to list up the WTA players with an invalid code. I saw your bot is also working hard to fix the issue, way quicker then I can do this by hand. Do you have a script for that, and if so, in what language? I might be interested, especially when it runs on Python...

Edgars2007 (talkcontribs)

About edits by bot.

I scraped WTA ranking pages (till 19th page) and did simple name matching between SPARQL results and WTA scrape results. It got approx. 450 results.

Later edits by bot. Well, those are practically manual edits. Was using Google links from that SPARQL query I posted at WT:Tennis and put the new IDs in text editor and then simply fed up Python script, so that I don't have to edit at Wikidata myself.

Edoderoo (talkcontribs)

Aha, nice to know! It means that I will have to help (by hand ;-) to get the job done. I will start with all the Dutch players on the list, and afterwards pick some others too.

Reply to "WTA"
Thierry Caro (talkcontribs)

Hi there! You might be interested in voting on Wikidata:Property proposal/SRCBB ID and Wikidata:Property proposal/ESPN NBA ID. This would help in the development of {{Q|22674492}}. Can you have a look?

Reply to "Basketball"
Zetud (talkcontribs)

Hi. You created Q27020041. Don't you think it should be merged with Q1539532? Zetud (talk) 12:23, 7 February 2017 (UTC)

Edoderoo (talkcontribs)

The answer is in this edit: https://www.wikidata.org/w/index.php?title=Q27020041&diff=379913089&oldid=379912968

Edgars2007 (talkcontribs)

Yes, Edoderoo is right. Informally speaking, Q27020041 is for leagues, Q1539532 - clubs. There was disscusion about this on Project chat (I think around creation of Q27020041)

Reply to "Merge Q27020041 and Q1539532?"
Pigsonthewing (talkcontribs)

I've just spent a considerable amount of time preparing to import values for AFL Tables ID (P3547), as I said I would do, yesterday, in Property talk:P3547#Import. Please check property talk pages before embarking on a mass import; and use those pages to announce your own intentions.

Reply to "P3547 import"
MisterSynergy (talkcontribs)

Hey Edgars, do you happen to know whether Sports-Reference.com has an index of athletes, linked to their profiles? I’d like to crawl all rowing athletes before they shut down the site, but I can’t find a useful list of links to crawl on their site. An alternative would be to just crawl profiles linked from Wikidata, but then I’d miss all athletes without a Wikidata item (~50% of all Olympic rowers). Cheers!

Edgars2007 (talkcontribs)

Hi!

The only index, that I'm avare of, is this. But it isn't complete for some reason. Other idea would be to go trough all rowing events in SR and crawl athletes from there, but that adds complexity :)

MisterSynergy (talkcontribs)

Thanks! Yes, that adds quite some complexity. Right now I have a nice crawler, but it needs input in form of URLs or identifiers. I need a good idea how to solve that, quickly... :-)

I have thought about an import of all sports-reference profiles to Wikidata anyways. There are currently ~96.000 Wikidata items with sports-reference identifieres, and they have around 120.000 profiles to my knowledge. Thus, most of the athletes are already here anyway. However, I'm not aware of legal issues with such an approach and one needs a parser that is capable of extracting all the information from Sports-Reference profiles in HTML format. It's probably too late to do that before sports-reference shuts down. And I'm afraid about the promised future database's quality, to be honest.

Edgars2007 (talkcontribs)

When I'm adding participant of (P1344) with bot, sourcing it with SR, I'm also saving some data about athlete (their "infobox") into .txt file - when will have time (ha ha ha) will upload the data to WD. So theoretically, I have a (Python) scraper.

Reply to "Sports-Reference athlete index"
Migrant (talkcontribs)

Hello Edgars2007. I was about to create a new wikidata item for a retired speed skater and was looking for his Sports-reference.com-profile ID but it looks like that sportssite-part are about to be moved somewhere else, but not yet done. What is your suggestion to all those ID's at wikidata. See what page I've got to http://www.sports-reference.com/olympics/. Regards Migrant.

Migrant (talkcontribs)

Hmm, looks like the Sports-reference.com/olympics site is up again today but yesterday it wasn't. See also this blogpost http://olympstats.com/2016/08/21/the-olymadmen-and-olympstats-and-sports-reference/. Ps. Spoken with user Multichill, sjoerddebruin and Stryn on IRC-chat about it. Best regards Migrant.

Edgars2007 (talkcontribs)

Hi!

Looks like it will work till the new site will be available, so the problem is kind of solved, but my thoughts on question is: don't delete anything (from sportsperson items) and a) remove formatter URL (so links aren't clickable) or b) change the formatter URL to use archived version.

Migrant (talkcontribs)

Hello, I'm not deleting anything, I'm just adding Sports-reference ID's to new Wikidata-Items which I'm creating at NO:WP. If we need to change the formatter-URL later, we'll do that, but only when that is needed and not before. But I'm also wondering about the future of Olympic.org ID (P3171), will that maybe merge with our Sports-reference ID at the address of Olympic.org. Have you tried to login at OlyMADmen's own site Olympedia mentioned at the site of Olympstats.com to see what's there, I haven't. Btw. Will you do an update on your underpage of Sports ID's. I think that page gives a good overview of how many inclusions of different Sports ID's are in use at Wikidata. Ps. I'm leaving for this afternoon, but will be back later tonight. Best regards Migrant.

Edgars2007 (talkcontribs)

Updated the Sports ID subpage count. Don't know about other things you mentioned, sorry.

Reply to "Sports-reference.com {{P|P1447}}"