User talk:99of9

From Wikidata
Jump to navigation Jump to search
Logo of Wikidata

Welcome to Wikidata, 99of9!

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.
  • User options – including the 'Babel' extension, to set your language preferences.
  • Contents – The main help page for editing and using the site.
  • Project chat – Discussions about the project.
  • Tools – A collection of user-developed tools to allow for easier completion of some tasks.

Please remember to sign your messages on talk pages by typing four tildes (~~~~); this will automatically insert your username and the date.

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!

--Ricordisamoa 19:20, 16 May 2013 (UTC)

ERA journal data[edit]

Hi, any chance you might be able to provide a second opinion on the usefulness of the ERA 2010 journal rank at Wikidata:Property proposal/Creative work#ERA 2010 journal rank. Thanks. John Vandenberg (talk) 09:00, 21 April 2014 (UTC)

St Fethlimidh's Cathedral (Q2942322)[edit]

Hi, what is the point of this edit? Cheers. Pawel Marynowski (WMIE) (talk) 17:13, 27 July 2017 (UTC)

@Pawel Marynowski (WMIE): Kilmore (Q2778994) is a town in Australia. It could be replaced by the one in Ireland, but I didn't have time to track it down when I was doing that edit. The French Wikipedia where this error came from often doesn't do disambiguation well. --99of9 (talk) 21:49, 27 July 2017 (UTC)


Thanks for the SSC ID updates. I have just done some imports which I've been planning for a long time to apply all the LGAs and VICNAMES IDs for localities in Victoria, and I can see in the checking that the SSC 2016 applications are going great. I think I have identified all the localities where the same name is used for two different places, and I have set a "different from" property for those. I have done some cleanups for the State Suburb items created from Mix 'n' Match as well where I've seen them, but I'll tackle that more thoroughly later.

I agree about dating the area of electoral districts, I had a problem with QuickStatements when I tried it, however I will apply these later. I also have all the current (2016) federal electoral divisions for all localities - I can import these but they are about to change as there are five pending redistributions, so it could be useful to import the current ones, then end date them and do the new ones, which should aid in analysis of the changes and updates on Wikipedia. --Canley (talk) 00:30, 16 August 2017 (UTC)

I see from my huge number of watchlist notifications that you've started 2016 population imports! Best of luck, let me know if you need any help. --Canley (talk) 03:43, 27 August 2017 (UTC)
@Canley: Yes indeed. I realised that there's no point waiting until we have completed the mix-n-match, because most of the rest will be brand new items. And anyway, I can easily run the population upload again for those not already filled. So far so good. --99of9 (talk) 03:48, 27 August 2017 (UTC)

A property is ready to be created[edit]

Hello. May you have a look at Wikidata:Property proposal/order of battle? I'm ready to deal with it. Thierry Caro (talk) 18:18, 8 September 2017 (UTC)

NLA Id for Antonio Zampolli (Q23417477)[edit]

Hello, you undid one entry I made on the Wikidata item above, namely the NLA Id, with the subject "Where did that come from?". The answer is: this number comes from the VIAF info related to Zampolli, Antonio (linguist): check it by yourself, please, at - why do you state that is incorrect? If so, then also VIAF should be warned about that, since this reference is still considered as valid in the VIAF history, see at where the NLA item above was added on 2016-04-24. Where is the problem? Why is that "bad" and "not valid"? --L736E (talk) 14:49, 26 September 2017 (UTC)

@L736E: Thanks for responding. I now see the problem. You associated this identifier with the wrong property. I have now added your identifier to the item as NLA (Australia) ID (P409) instead of People Australia ID (P1315). Check out the property pages for full details and you'll notice the formatter URLs are quite different, and don't work for each other's codes. --99of9 (talk) 15:13, 26 September 2017 (UTC)
@L736E: And since I'm on this now, I've searched for this subject's People Australia ID (P1315) value of 1061207 and added it to the item. Notice that the new link from that statement now works at bringing up his page at Trove/people. --99of9 (talk) 15:17, 26 September 2017 (UTC)
Many thanks for the clarification. Actually, when looking for a property to add, I start typing a keyword (in this case "Australia") and very likely in the choice from the drop down menu I made the click on the wrong property inadvertely (Australia person instead of NLA, which was my intention). Thanks for fixing that and for completing the properties :) --L736E (talk) 15:21, 26 September 2017 (UTC)
@L736E: You're welcome. It turns out this is a very common mistake. I guess we should get a bot to map them all over to NLA (Australia) ID (P409).--99of9 (talk) 15:30, 26 September 2017 (UTC)

Edith Kawelohea McKinzie[edit]

you asked "wrong number, bad link, where did that come from?)",_Edith_Kawelohea,_1925-

sorry, I trusted VIAF to have it correct. Roseohioresident (talk) 01:14, 27 September 2017 (UTC)

@Roseohioresident: Thanks for getting back to me. Yours was for the same reason as the section above. --99of9 (talk) 01:54, 27 September 2017 (UTC)

Wikidata:Property proposal/LFH ID[edit]

Hello! May I get this created now? Thierry Caro (talk) 11:09, 6 October 2017 (UTC)

Thank you. I would not mind getting Wikidata:Property proposal/KNAU ID now, and if you have time. I can fill the new property with its dedicated properties by myself. I just need the creation itself. Thierry Caro (talk) 10:44, 7 October 2017 (UTC)

KNAU ID[edit]

Hello, you reverted my edit on the constraints of KNAU ID (P4302). I had removed the item requires statement constraint (Q21503247) occupation (P106)  athletics competitor (Q11513337), because it doesn't include subclasses of athletics competitor (Q11513337). So athletes with more specific occupations like sprinter (Q4009406) or pole vaulter (Q13464497) are reported as costraint violations. Therefore I think it the constraint should be removed again. Are you okay with that? --Entbert (talk) 12:32, 8 October 2017 (UTC)

@Entbert: Ah ok, thanks for the explanation. It's a pity we don't have a constraint that checks for subclasses like type constraint (Q21503250) does. I've reverted myself. --99of9 (talk) 23:15, 8 October 2017 (UTC)

item or property?[edit]

originally i thought it needs deleting

but is it a property in item clothing?

doesnt seem to make sense as it is

any thoughts?

JarrahTree (talk) 07:50, 1 November 2017 (UTC)

I don't understand your question. What has this got to do with clothing? If you mean that shires are not recognized as a specific subcategory of LGAs, then I have no knowledge on this, and therefore no comment. Also what do you mean by "item or property"? This is definitely not a property. --99of9 (talk) 23:41, 1 November 2017 (UTC)

I dont know - nuances/ambiguities/allusive usage/metaphors...

The creator was locked in 2014 or whenever - and no such thing exists - as an ignorant user I am trying to ascertain - what is the best way to put up a suggestion for deletion if it can be proved to not link with anything in the correct manner? JarrahTree (talk) 02:15, 3 November 2017 (UTC)

I would suggest first changing all usages of this item [1] to what you think is correct instead. Then once the item is unused, it can be proposed for deletion. --99of9 (talk) 02:27, 3 November 2017 (UTC)
thanks for that - apologies for my usual obscurantism :) JarrahTree (talk) 08:26, 5 November 2017 (UTC)
Looking at it - as an 'instance' it is fine - problem with thinking in terms of other wikis and not data - my problem not the instance :) JarrahTree (talk) 10:00, 8 November 2017 (UTC)
But adding an aka of the locality name against an entity that has the locality and a qualifier of either shire or council ?
The unqualified name usually infers the locality not the LGA JarrahTree (talk) 10:06, 8 November 2017 (UTC)
@JarrahTree: Ok, good to hear about the shire instances. Regarding the LGA aliases, it helps to have as many aliases as possible so that the search functions find them for us. For example, many of the ABS suburbs say which LGA they are in using only a single word. The locality should *also* have the single word as the alias. Anyone who types in the single word will get offered both (and all the equivalents in other countries, etc). --99of9 (talk) 10:08, 8 November 2017 (UTC)
Ta for explain - ABS suburbs - arrgh JarrahTree (talk) 10:23, 8 November 2017 (UTC)

Integers in QuickStatements[edit]

When you're importing a population integer value in QuickStatements 2, how do you do it without the "±0" variance? I'm sure I've managed to do it before but I can't remember how! Thanks, --Canley (talk) 00:39, 7 March 2018 (UTC)

@Canley: Here's a snippet of my file. I think I told QS2 that I was going to give it stuff formatted for QS1 (because I don't actually know what the QS2 format is).

Q991793 P1082 930 P459 Q33128542 P585 +2016-08-09T00:00:00Z/11 S854 "" Q990639 P1082 1144 P459 Q33128542 P585 +2016-08-09T00:00:00Z/11 S854 "" Q990636 P1082 16222 P459 Q33128542 P585 +2016-08-09T00:00:00Z/11 S854 "" Q979561 P1082 135443 P459 Q33128542 P585 +2016-08-09T00:00:00Z/11 S854 "" --99of9 (talk) 11:36, 7 March 2018 (UTC)

Brilliant, thank you! --Canley (talk) 22:53, 7 March 2018 (UTC)

Share your experience and feedback as a Wikimedian in this global survey[edit]

WMF Surveys, 18:57, 29 March 2018 (UTC)


Hi 99of9, I went to Researcher Search and then, at the bottom of the page, to Show all. I had to add this tab "&lang=english" to the url for the scraper been done in that language. The property has to be linked to the catalog. I asked for it to Magnus. Please be patient. And you don't have to thank me: I like scraping databases :) --Gerwoman (talk) 19:12, 12 April 2018 (UTC) By the way, not all the entries in Researchmap start with "read", for example this. I only realized the second attempt.

Magnus has already matched the catalog with the property. --Gerwoman (talk) 18:42, 16 April 2018 (UTC)

Reminder: Share your feedback in this Wikimedia survey[edit]

WMF Surveys, 01:40, 13 April 2018 (UTC)

Your feedback matters: Final reminder to take the global Wikimedia survey[edit]

WMF Surveys, 00:50, 20 April 2018 (UTC)

Place merges[edit]

I'm doing a lot of automated merges of (hopefully) duplicate places. If you notice any that you don't agree with, please feel free to revert (and leave a note here if you like). My process already considers things like identical (and singular) geonames IDs, substring relationships between the names in some languages, the number of sitelinks, and proximity of the coordinates. A sample query is here. Most of the merges result in the item generated for ceb-wiki being merged into the item from all other wikis, so I think it's useful en-masse, but I'm sure there will be some isolated cases where a merge is incorrect. If you do revert, please consider changing the geonames ID on one of the two items that got merged. --99of9 (talk) 05:39, 24 May 2018 (UTC)


Hello. As this is brand new and has never been used, you can probably exploit the accidental property creation for another to-be-created property, can't you? Whatever, sorry. Thierry Caro (talk) 01:15, 11 July 2018 (UTC)

I'm waiting for Wikidata:Property proposal/BIA PSY ID, for instance. Maybe is it a way to get it!? Thierry Caro (talk) 01:17, 11 July 2018 (UTC)
@Thierry Caro: Ok, good idea. --99of9 (talk) 01:24, 11 July 2018 (UTC)

OpenRefine ABS edits[edit]

Hi, I just noticed some of the recent "SSC info from ABS" edits to South Australian localities have added the same LGA when there already was one: for example Lower Hermitage (Q41720769), has added located in the administrative territorial entity (P131) = Adelaide Hills Council (Q353997) which was already listed, albeit with a object has role (P3831) qualifier. Can you have a look? --Canley (talk) 00:58, 13 July 2018 (UTC)

@Canley: Yeah, sorry about that. I think it's because the existing one has a qualifier on it, so openrefine interprets it as a subtly different statement. I'm a bit new to openrefine (which is great BTW), but I didn't figure out how to determine the correct qualifier automatically. I think the easiest way to stop it will be to remove the duplicates once they're all done. I can imagine writing a fairly simple SPARQL query to catch them, then putting it into quickstatements. --99of9 (talk) 01:25, 13 July 2018 (UTC)
Thanks, I thought it might be the qualifier! Should be no problem to clean up later, I think I even have a SPARQL query for just this issue. OpenRefine looks very interesting—it could be very useful for some heritage/WLM projects I'm working on. I'll also do a sweep of the new locality items you've added recently and fill in some of the other data like postcodes and electorates. --Canley (talk) 01:39, 13 July 2018 (UTC)
@Canley: I just thought of a way to get this qualifier into Openrefine. But I'm not sure it's quite right, because all of these (e.g. local government area of Victoria (Q1849126)) are instances of wikimedia list articles. This causes constraint violations. I think we need a paired item for each state which represents the concept itself. --99of9 (talk) 11:59, 15 July 2018 (UTC)
I agree, I'll sort it out now. --Canley (talk) 12:04, 15 July 2018 (UTC)
Thanks. --99of9 (talk) 12:22, 15 July 2018 (UTC)
Hmmm, just did a few but maybe I should create a new item for the list, then convert the current list item to an entity, otherwise I will need to convert all the current object has role qualfiers. --Canley (talk) 12:45, 15 July 2018 (UTC)
@Canley: If most of the other language wiki articles are lists, I think the way you are doing it is probably correct, even if it does require some mass switching of "object has role". --99of9 (talk) 12:48, 15 July 2018 (UTC)
Yep, I was thinking the same thing looking at the interlanguage links... That's OK, I can do the bulk conversion. --Canley (talk) 12:57, 15 July 2018 (UTC)

Courrier international source ID (P5554)[edit]

Hello. Before you get the Australian property created, you might be interested in this one. Thierry Caro (talk) 14:39, 1 August 2018 (UTC)

Oh! You should almost not have thanked me. For now I'm wondering if you would be nice enough to initiate one or two other properties for me! Like Wikidata:Property proposal/Institut culturel de Bretagne ID, Wikidata:Property proposal/Interbibly ID, Wikidata:Property proposal/Le Monde ID or Wikidata:Property proposal/Tebeosfera ID. Can you have a look? Thierry Caro (talk) 20:22, 1 August 2018 (UTC)
Or maybe Wikidata:Property proposal/CSDE Lynching Database ID too. I'll be happy with you just pushing the button and me then filling everything needed. Thierry Caro (talk) 20:23, 1 August 2018 (UTC)

data query at wp en[edit]

looks like your call sir - JarrahTree (talk) 14:18, 11 August 2018 (UTC)

Also - imho the remaining unmatched trove/newspapers shouldnt - they are very limited in life (mind you some are very mysterious dating) and really dont deserve a separate data item or article - the temptation was - from the evidence the way that the nla items line up - would be to have a 'second world war newspapers' mix item - but I think a piece by piece investigation of the entries/items might be needed to work out what the hell, so to speak JarrahTree (talk) 06:29, 30 August 2018 (UTC)

@JarrahTree: Thanks for working through them. I think the date ranges are based only on the dates they have copies for (and have scanned). So the actual duration of the newspaper may have been longer. I'll take another look at them sometime - the notability standards are a lot lower on wikidata, so we may end up catching more, but it's good to know you got the important ones. --99of9 (talk) 07:07, 30 August 2018 (UTC)

Australian heritage spreadsheets[edit]

Sorry, I missed your comment at User talk:Australian Monuments asking for the heritage register spreadsheets, here is the link. They should all have coordinates as well, including WA and Tasmania. --Canley (talk) 10:14, 19 August 2018 (UTC)

Ah ok, thanks. I've ended up making my own of WA and Tassie, so will cross check to spot any differences. Where did the coords come from? --99of9 (talk) 11:18, 19 August 2018 (UTC)
I extracted about 95% of them from the Tasmanian Heritage Register map layer on LISTmap, and Kerry reverse geocoded the rest from the addresses. --Canley (talk) 01:26, 20 August 2018 (UTC)

WikiProject newspapers[edit]

Thanks for your message about this project. I've done quite a bit of work on Welsh Newspapers and some of them have a good level of detail - my plan was to use infoboxes to get this information into Wikipedia. Is the group OK with Wikidata in infoboxes? Simon Cobb (Sic19 ; talk page) 22:31, 19 August 2018 (UTC)

property proposals[edit]

Hi Toby. Good to talk yesterday. I am struggling to find "the form" to fill in for a property proposal. I am hoping you might direct me to 1) a property proposal, and 2) "the form". Thanks. MargaretRDonald (talk) 20:23, 12 September 2018 (UTC)

@MargaretRDonald: you too, I was impressed that you picked my father. Go to Wikidata:Property_proposal/Authority_control and after you have typed in a property name, click "create request page". --99of9 (talk) 22:42, 12 September 2018 (UTC)
@99of9: Thanks, Tony. I will do that for the ID properties. I have another request: As you can see from [ Wikipedia: Velleia macrophylla, there are properties (P?) belonging to a taxa of being first described by x, in the year y, in the publication z, and on page w with url v , and similar properties (or the same) belonging to the author of the name. I have no idea how this is organised in wikidata, but when I hunt up a page which gives the words of an author giving the first description of a plant or the publication of a name, it seems to me that this information should be part of wikidata. (I plonked in the link to en:Velleia macrophylla so you could see what I mean.) Hoping you can give me a clue. MargaretRDonald (talk) 22:53, 12 September 2018 (UTC)
@MargaretRDonald: I think you will find this interesting: Wikidata:WikiProject_Taxonomy, in particular the Properties and qualifiers section. Also add your username to the participants list so you will get communications about discussions which affect Taxonomy items. As to your specific question, in my reading it looks like you can use property basionym (P566) and make a whole separate item for the original name, with all those details. But I also think the old synonyms should be listed as "also known as" column in the languages box (which I've just added for that species). --99of9 (talk) 00:06, 13 September 2018 (UTC)

Still struggling with a proposal[edit]

@99of9: Dear Toby, I am still struggling with just where to put/create a property proposal. I partially prepared a csv file:

Instance of ,P31,Wikidata property to identify taxa,Q42396390
Subject of this property,P1629,Northern Territory flora,
Wikidata property example,,Lawrencia squamata ( NT flora ID=3230),
Source website for the property,,,

and am hoping you will take it further and show me what you have done.. Help. MargaretRDonald (talk) 02:18, 18 September 2018 (UTC)

@MargaretRDonald: Did you see Wikidata:Property proposal/VicFlora ID, which Andy made on your behalf? To make one, go to Wikidata:Property_proposal/Authority_control and enter "Northern Territory flora ID" and click "create page request". Then fill out the fields in the page it opens (use Andy's as an example of what is needed in each field. I'll create later if you really don't want to, but this is a reasonably simple case to start on since it will be similar to the Victorian one, and they can be easily improved if you get anything wrong. --99of9 (talk) 07:17, 28 September 2018 (UTC)
@99of9: I've had a crack at it, Wikidata:Property proposal/NT Flora ID. Could you check it out and perhaps fix it where I have managed to misunderstand what was needed. MargaretRDonald (talk) 09:27, 28 September 2018 (UTC)

Nedlands PO[edit]

Former - former - former not current very different :) JarrahTree (talk) 06:29, 28 September 2018 (UTC)

The label is the plain name, without qualifiers, and does not need to be unique. The description and aliases can do the disambiguation. See Help:Label. --99of9 (talk) 07:06, 28 September 2018 (UTC)

Change of datatype for property P502[edit]

Good evening! Are you able to help me with this request as posted on the project discussion page? Breg Pmt (talk) 22:41, 13 October 2018 (UTC)

Sorry, I don't know enough about data types to be confident changing them. All the best. --99of9 (talk) 10:19, 14 October 2018 (UTC)


Could you use flood flag for (semi?)automatic edits next time? Also there are two problems: why are you adding Spanish/German/French/Latin/etc. names as English aliases? These names are correctly lang-tagged in DrugBank, but incorrectly added as en aliases; e.g. here only one alias is correct (however redundant, because the same name is added as a label – this is the second problem, there were no check before data import whether a name already exists in WD item). There are more edits that have no added value, e.g. this. This is quite annoying, because I cleaned up many items by manually deleting wrong aliases or correcting them and you added many more probably with one click in some tool. Wostr (talk) 19:00, 17 October 2018 (UTC)

@Wostr: Thanks for the note. I'll look into the flood flag. Sorry about lumping all the languages into English. Unfortunately the CCO dataset they offer does not tag the synonyms with languages, so I didn't pick this up before you mentioned it. The tool I was using is Openrefine (which of course involves a lot of work before the final click). It does check against existing aliases, but considers different capitalization to be distinct. I agree that alternate capitalization adds no extra value, but I don't think it's harmful, and even if it is, can be automatically screened. I think the additional aliases were worth some redundancy costs. What will be even more interesting are the hundreds-thousands of items I have not touched yet where Drugbank has different identifiers to Wikidata, which will need to be combed through fairly manually. --99of9 (talk) 22:35, 17 October 2018 (UTC)
Thanks for the answer. Indeed, with this dataset it is not possible to prevent the mentioned problems. Flood flag would be much appreciated though :) Wostr (talk) 20:39, 18 October 2018 (UTC)

Searching a website for IDs[edit]

Hi @99of9: I would like to pull out all the species with factsheets on Northern Territory flora, create a spreadsheet of names and NT flora IDs and then upload to wikidata using mix-n-match. How do I create such a spreadsheet? Cheers, MargaretRDonald (talk) 01:52, 10 November 2018 (UTC)