User talk:Bamyers99

Welcome to Wikidata, Bamyers99!

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, don't hesitate to ask on Project chat. 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! Liuxinyu970226 (talk) 02:00, 1 December 2014 (UTC)

Property:P268

Hello, I see that you added some Bibliothèque nationale de France ID (P268) like here https://www.wikidata.org/w/index.php?title=Q20895083&diff=prev&oldid=246961749 It's nice but there is problem of syntax with this identifier : we have to remove the "cb". The precedent edition gives this http://catalogue.bnf.fr/ark:/12148/cbcb120526478 instead of http://catalogue.bnf.fr/ark:/12148/cb120526478 . I have done the correction for this one. Best regards. --Shonagon (talk) 22:35, 31 August 2015 (UTC)

Correction done for the others. Regards --Shonagon (talk) 22:47, 31 August 2015 (UTC)

Thanks for the note. It appears that User:KrBot fixes them. I will remove the cb when I add new ones. --Bamyers99 (talk) 22:54, 31 August 2015 (UTC)

Invitation to Wikidata user study

Dear Bamyers99,
I am a researcher of the Web and Internet Science group of the University of Southampton.
Together with a group of other researchers from the same University, we are currently conducting a research aiming to discover how newcomers become full participants into the Wikidata community. We are interested in understanding how the usage of tools, the relationships with the community, and the knowledge and application of policy norms change from users' first approach to Wikidata to their full integration as fully active participants.
This study will take place as an interview, either by videotelephony, e.g. Skype, phone, or e-mail, according to the preference of the interviewees. The time required to answer all the questions will likely be about an hour. Further information can be found on the Research Project Page Becoming Wikidatians: evolution of participation in a collaborative structured knowledge base.
Any data collected will be treated in the strictest confidentiality, no personal information will be processed for the purpose of the research. The study, which has submission number 20117, has received ethical approval following the University of Southampton guidelines.
We aim at gathering about 20 participants, chosen among experienced Wikidata users who authored a large number of contributions.
Should you be interested in taking part or wish to receive further information, you can contact us by writing to the e-mail address ap1a14+wikidata_user_study@ecs.soton.ac.uk.
Thank you very much, your help will be much appreciated!
--Alessandro Piscopo (talk) 09:07, 26 May 2016 (UTC)

Data behind Wikidata Class Browser

I tried out the Wikidata Class Browser which is interesting especially for the hierarchy of the classes. But I am more interested in the number of direct and indirect instances of the most used classes. Can you share the full list of all 1,3 Mio classes? Then, I could filter myself the most used of them, or maybe aggregate some of these into reasonable groups. --Zuphilip (talk) 15:11, 25 November 2017 (UTC)

@Zuphilip: The raw data is available at wdsubclasstotals.tsv (file size 28 M).

Layout: qid, root (Y/N), direct child count, indirect child count, direct instance count, indirect instance count, is list of count

--Bamyers99 (talk) 18:05, 25 November 2017 (UTC)

Thank you very much! I extracted from these data a list as a wanted: https://www.wikidata.org/wiki/User:Zuphilip/wd-statistics --Zuphilip (talk) 22:26, 25 November 2017 (UTC)

Find A Grave cemetery ID

Are you adding the missing ones by hand, or using an automated tool? Have you thought about us importing every cemetery from Findagrave that we do not have already? --RAN (talk) 04:43, 12 February 2018 (UTC)

@Richard Arthur Norton (1958- ): I was just working on the Find a Grave memorial ID constraint violations and Find A Grave cemetery ID constraint violations. Although I plan on adding ones with a Find A Grave Cemetery link in enwiki (and other large wikis) that don't have P2025 from this quarry query. --Bamyers99 (talk) 15:04, 12 February 2018 (UTC)

I would love to construct a bot to add in every cemetery not represented in Wikidata, adding them one a time is tedious. How would I go about starting that project, do I suggest it somewhere? 10 years ago Findagrave had a lot of duplicates under various synonyms, now they are all sorted out. --RAN (talk) 15:15, 12 February 2018 (UTC)

@Richard Arthur Norton (1958- ): Here is a good place to start: Wikidata:Data donation. --Bamyers99 (talk) 19:44, 12 February 2018 (UTC)

CWGC data editing

Hi there. I left a message on your talk page on en-Wikipedia, but realised that here might be a better place to discuss. See here. Carcharoth (talk) 15:11, 5 March 2018 (UTC)

@Carcharoth: I am working from two different lists to add CWGC ids to Wikidata. 1) I downloaded the CWGC website casualty list and matched on name and date of death with Wikidata name and date of death. That task is complete. 2) I am now matching on external links from enwiki to CWGC. I have about a 1000 more links to check. Thanks for fixing to CWGC property mixups. The mixups would have eventually shown up in the CWGC burial ground ID constraint report or the CWGC person ID constraint report. --Bamyers99 (talk) 15:50, 5 March 2018 (UTC)

Thanks for explaining. I will now know to ask around on Wikidata before taking on big mix-n-match tasks that are better done by those with the tools for it. :-) About the CWGC external links, some care is needed as the links will in many cases not match directly with a Wikidata entry. If you have time to look at en:w:User talk:Carcharoth/Pages using CWGC links and think about how to handle the uses where the match is not one-to-one, maybe we could ensure a consistent approach is taken? In many cases the cemeteries are not mentioned in articles on the cemeteries, but instead in articles on the general location. There are also list articles and various other categories of articles. On my attempt at mix-n-match, from the 1626 and 1708 (total: 3334) articles in those lists, there are around 693 that are direct matches, 934 that have a CWGC external link but no Wikidata value (these will mostly be articles on relatives of the casualties), and 1015 Wikidata values that don't have a CWGC link in the corresponding article (or at least no article in en-Wikipedia). This is not exact, as the article titles don't always match the Wikidata page name. One thing to be wary of is that the CWGC sometimes get the death date wrong, so there will be a few (rare) cases where the matches won't be found. Carcharoth (talk) 16:30, 5 March 2018 (UTC)

I am running into limitations with my ability to extract the data. Can you advise on how to get the names of the Wikipedia articles for the Wikidata pages listed here? There are too many cases of disambiguation for me to be able to match easily with the list of Wikipedia articles I have. Carcharoth (talk) 17:50, 5 March 2018 (UTC)

@Carcharoth: Is this query what you are looking for? Just press the blue button with the right facing triangle in it to run the query. --Bamyers99 (talk) 18:17, 5 March 2018 (UTC)

It might be. But the link doesn't work for me. I'll try and recreate the query from scratch. Carcharoth (talk) 18:23, 5 March 2018 (UTC)

# CWGC person ID with enwiki link
SELECT DISTINCT ?s ?sLabel ?article WHERE {
  ?s wdt:P1908 ?cwgcid .
    ?article schema:about ?s .
    ?article schema:inLanguage "en" .
    ?article schema:isPartOf <https://en.wikipedia.org/> .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
 }
 ORDER BY ?sLabel

Try it!

--Bamyers99 (talk) 18:36, 5 March 2018 (UTC)

That works! Many thanks for that. May I ask if: (a) you have finished your latest batch of data addition; and (b) what further plans you have to work with this data? I have some ideas (particularly related to identifying the relatives of the deceased who have articles, and to including gravestone inscriptions and memorials/burial locations where appropriate), but don't want to overlap or duplicate efforts too much. Would one aim be to end up with a list generated from the data at some point? I also have plans to update WP articles which lack a CWGC reference (but you may be able to do that quicker than I can). I do also (based on the UK Parliamentary War Memorials) have a list (in my userspace) of bereaved MPs and bereaved peers from both World Wars that I intend to return to at some point, with notes on which ones are lacking a citation to the relevant CWGC page. Carcharoth (talk) 14:59, 6 March 2018 (UTC)

@Carcharoth: I am done adding CWGC ids to Wikidata. I have no plans to do any more CWGC related tasks. --Bamyers99 (talk) 17:55, 6 March 2018 (UTC)

Understood. Many thanks for the edits, which will be incredibly useful for working out where work is needed. I may come back with more queries (about the queries like the one you set up above), or I may ask at the help area here. Carcharoth (talk) 18:07, 6 March 2018 (UTC)

Gresset

Hi Bamyers99,

the links towards Gresset's CTHS page doesn't seem to work. What's wrong, according to you?

Regards. Nomen ad hoc (talk) 18:42, 15 June 2018 (UTC).

@Nomen ad hoc: Wrong link, it is JUGLAR Joseph Clément for Clément Juglar (Q921074). --Bamyers99 (talk) 18:49, 15 June 2018 (UTC)

Yep, but curiously, [1] redirects towards Gresset's page... Nomen ad hoc (talk) 18:51, 15 June 2018 (UTC).

@Nomen ad hoc: I am not fluent in French, so I don't what the difference is between the two types of pages. I am just working on constraint violation reports: Wikidata:Database_reports/Constraint_violations/P2383#"Unique value" violations. --Bamyers99 (talk) 19:00, 15 June 2018 (UTC)

Ok, no matter. Good continuation. Nomen ad hoc (talk) 19:02, 15 June 2018 (UTC).

Adding of StadiumDB ID (P5288) to wikidata-entities for stadiums

Hello Bamyers. Thanks for adding several values of StadiumDB ID (P5288). See also World Stadium Database ID (P5289). Best regards Migrant (talk) 19:26, 5 October 2018 (UTC)

Navel Gazer by language?

Is there a way to use Navel Gazer or similar to identify users by the language(s) they are editing in? When I come across an edit in a language/ script I can't handle myself, I would like to have a possibility to contact accounts that are editing in this language (or at least script), preferably recently and (if the edit was about a language-specific property) ideally have used the same property themselves. --Daniel Mietchen (talk) 23:13, 3 February 2019 (UTC)

@Daniel Mietchen: Navel Gazer can now show user language addition counts. It has total counts of label, description, alias additions. I couldn't add 'language-specific property' counts because the language is not saved in the edit comment. Navel Gazer gets its information from edit comments. Sample language addition count query: French (fr) addition counts. --Bamyers99 (talk) 02:05, 5 February 2019 (UTC)

@Bamyers99: That looks great and addresses my use case — thanks! Could you add the addition of sitelinks into the count? There is also a kind of inverse use case — if I'd like to discuss something with a given user whom I do not know yet, I'd like to pick a language close to their comfort zone if possible but if they have no babel set and their most recent edits are all language-neutral, then I have to manually search for things like multilingual properties they may have used, or pick in the dark. Usually, this means resorting to English, which may not be the best option for me to discuss with them. So is there a way to include language info into the Navel Gazer results for a given user? I understand that language-specific properties do not leave a language trace in the edit summary that you are parsing, but what about adding a column for the data type of a property to the results page? This would allow to look specifically at things like Monolingual text or Sense. There is also a minor bug: if a user name contains a space, the tool is replacing this with a "+", which causes the links to break (see your example). I would have tried to fix this one myself but don't know where the code sits. --Daniel Mietchen (talk) 07:35, 5 February 2019 (UTC)

@Daniel Mietchen: Everything has been implemented/fixed. --Bamyers99 (talk) 00:14, 8 February 2019 (UTC)

Thanks, Bamyers99 — this looks great! --Daniel Mietchen (talk) 15:31, 14 February 2019 (UTC)

Hi! I really love Navel Gazer and I absolutely have to thank you for it. I have just a little report about Label, description, alias, sitelink additions: in my case I have 43915 for "it", 11903 for "en", 6581 for "pl" and 5980 for "de" ... but, if I search by Language code, I appear in the "top 50" only for "it" and "pl", not for "en" or "de" ... is there any reason? It's not just for me, but maybe it's not an isolated case. Can you control? Thank you very much again, --Epìdosis 16:10, 2 May 2019 (UTC)

@Epìdosis: I have added the rank to the report to indicate which 50 are included because of total count and which 50 for last months count. --Bamyers99 (talk) 20:38, 2 May 2019 (UTC)

Perfect, thank you! --Epìdosis 20:39, 2 May 2019 (UTC)

Hi Bamyers99, Same love for Navel Gazer from me ! and today I found out that you can pass the language in the URL like that: https://bambots.brucemyers.com/NavelGazer.php?langadd=br This is already really great; but this is just for addition, is there a parameter to do the same for change or deletion? (and a more general question, is the documentation and the code of Navel Gazer avalaible somewhere) Cheers, VIGNERON (talk) 09:43, 26 May 2021 (UTC)

@VIGNERON: I have added the url parameter names to the user interface. The program does not compute language specific changes/deletions. Computing additions met the use case above. There is no documentation. Source code for the user interface is here. Source code for the dump extractor is here. --Bamyers99 (talk) 18:50, 26 May 2021 (UTC)

Thanks a lot! Cheers, VIGNERON (talk) 06:13, 27 May 2021 (UTC)

Navel Gazer

Hi,

First of all, I must say that I love Navel Gazer and use it quite often. I was also very pleased to see that you added "Pseudo properties" for Lexemes. But is it me who doesn't understand something or are the numbers wrong for P-7 or P-10? (I'm pretty sure I did more edit for form representations or sense glosses)

Cheers, VIGNERON (talk) 13:08, 19 April 2019 (UTC)

@VIGNERON: I have performed a detailed analysis of your edit history. I hacked my dump scanner to dump out the comments from just your edits (1712294 edits as of 1 April 2019). I then ran the comments through sed (Q305876) to extract the action performed (first column below). Then I sorted and aggregated to get total counts. To relate the action to the user contributions list, the second column below is the comment template for English that is used to format comments. MediaWiki translation files: Wikibase en translation file (GitHub), Lexeme en translation file (GitHub)

Based on the analysis, I believe that Navel Gazer is properly reporting totals using the actions found in the comment strings.

Action	Contributions comment template (en)	Navel gazer	Count
wbsetdescription-add	Added [$2] description	-2	654472
wbcreateclaim-create	Created claim	Property added	402687
wbsetlabel-set	Changed [$2] label	Not reported	268474
wbsetdescription-set	Changed [$2] description	Not reported	121728
wbsetreference-add	Added reference to claim	Not reported	118409
wbsetlabel-add	Added [$2] label	-1	74361
wbsetclaim-create	Created {{PLURAL:$3|claim|claims}}	Property added	19419
wbremoveclaims-remove	Removed {{PLURAL:$1|claim|claims}}	Not reported	13199
wbsetsitelink-add	Added link to [$2]	-4	9249
wbsetclaim-update	Changed {{PLURAL:$3|claim|claims}}	Not reported	4714
undo	?	Not reported	4658
wbsetqualifier-add	Added {{PLURAL:$1|qualifier|qualifiers}}	Not reported	4265
wbeditentity-create	Created a new Item	Not reported	4242
wbsetaliases-add	Added [$2] {{PLURAL:$1|alias|aliases}}	-3	1002
wbeditentity-update	Changed an Item	Not reported	969
wbmergeitems-to	Merged Item into $3	Not reported	633
add-form	Added new Form $3 with {{PLURAL:$1|representation|representations}}	-6	626
wbmergeitems-from	Merged Item from $3	-5	587
wbcreateredirect	Redirected to $4	Not reported	564
clientsitelink-update	Page moved from [$3] to [$4]	Not reported	496
wbsetsitelink-remove	Removed link to [$2]	Not reported	482
wbeditentity-create-item	Created a new Item	Not reported	460
wbeditentity-override	Cleared an Item	Not reported	218
wbsetdescription-remove	Removed [$2] description	Not reported	202
wbsetaliases-remove	Removed [$2] {{PLURAL:$1|alias|aliases}}	Not reported	186
restore	?	Not reported	150
wbsetlabel-remove	Removed [$2] label	Not reported	111
add-sense	Added new Sense $3 with {{PLURAL:$1|[$2] gloss|glosses}}	-9	111
wbsetaliases-set	Set [$2] {{PLURAL:$1|alias|aliases}}	Not reported	108
wbsetsitelink-set	Changed link to [$2]	Not reported	101
add-form-grammatical-features	Added grammatical {{PLURAL:$1|feature|features}} of Form $3	-8	97
wbremovereferences-remove	Removed {{PLURAL:$3|reference|references}} from claim	Not reported	45
wbsetaliases-update	Updated [$2] {{PLURAL:$1|alias|aliases}}	Not reported	37
wbsetreference-set	Changed reference of claim	Not reported	29
wbsetlabeldescriptionaliases	Changed [$2] label, description and aliases	Not reported	24
wbsetclaim-update-qualifiers	Changed {{PLURAL:$4|one qualifier|$4 qualifiers}} of {{PLURAL:$3|claim|claims}}	Not reported	18
update-form-grammatical-features	Changed representations and/or grammatical features of Form $3	Not reported	15
add-sense-glosses	Added {{PLURAL:$1|[$2] gloss|glosses}} to Sense $3	-10	14
update-form-representations	Changed representations and/or grammatical features of Form $3	Not reported	10
add-form-representations	Added {{PLURAL:$1|representation|representations}} of Form $3	-7	3

--Bamyers99 (talk) 00:36, 21 April 2019 (UTC)

Thank you! re: schools and districts

Hi! I see how much work you've been doing adding schools and districts from the Common Core of Data. Thank you so much! I deeply appreciate your effort and how much you're improving coverage of educational institutions on Wikidata, especially adding NCES identifiers and relationships between schools and districts. Runner1928 (talk) 13:36, 17 May 2019 (UTC)

navel-gazing

I certainly have nothing against Merriam-Webster, but why not use a Wikimedia project? Arlo Barnes (talk) 21:31, 11 December 2019 (UTC)

@Arlo Barnes : Great idea. I have updated the link. --Bamyers99 (talk) 22:03, 11 December 2019 (UTC)

Unit converter script

Hello! I love your unit converter script, but I've noticed that errors build up quite rapidly as the converted figures get larger. I'm wondering if you'd be willing to extend the significant figures beyond three for greater accuracy. Perhaps to six decimal places in the conversion ratio? — Huntster (t @ c) 20:01, 12 January 2021 (UTC)

@Huntster: I have increased the conversion unit precision. --Bamyers99 (talk) 21:06, 12 January 2021 (UTC)

Fantastic! Everything looks much better at first glance. Thank you. — Huntster (t @ c) 21:56, 12 January 2021 (UTC)

Regarding your currency conversion, I see it trying to account for year (such as at Phobos (Q104922609)), but it's having a hard time for some reason. Notice different conversions for the same input at the example. Is there a preferred way to lay out the values so it converts properly? Thanks! — Huntster (t @ c) 20:30, 22 January 2021 (UTC)

@Huntster: I assume you are referring to the 2006 cost property not displaying an inflation adjusted amount, while the 2006 significant event cost qualifier is displaying one. I have fixed a bug so that they both display the adjusted amount. The 2020 ship acquired amount is not adjusted because I have not entered 2020 adjustments yet. --Bamyers99 (talk) 23:10, 22 January 2021 (UTC)

Understood! Thanks for being responsive, the script really is a fantastic accessory. :) — Huntster (t @ c) 01:18, 23 January 2021 (UTC)

It's strange, today I was checking Deimos (Q40426797) and Phobos (Q104922609), and the mid-2000s cost properties are again defaulting to 2019 inflation adjusted amount. Any ideas? — Huntster (t @ c) 16:14, 24 January 2021 (UTC)

@Huntster: Operating as designed. 2019 is the latest that I have entered inflation data for. I have not entered 2020 inflation data yet.--Bamyers99 (talk) 16:33, 24 January 2021 (UTC)

No no, I understand that. I'm speaking of the construction costs from 2005 and 2006. Another interesting case is at Space Environments Complex (Q4049845); since the Euro wasn't around in 1968, the conversion seems...malformed? — Huntster (t @ c) 18:49, 24 January 2021 (UTC)

@Huntster: Sorry, I assumed that you were using USD instead of EUR currency. I have added units conversion for the original year in addition to the inflation adjusted amount. I have inflation data that somebody synthesized for the combined countries of the Euro block going back to 1960. --Bamyers99 (talk) 20:27, 24 January 2021 (UTC)

I am using USD. As an example, the input is "312,000,000 United States dollar", conversion is "263,854,284 euro (2019)" but Point in Time is "2005" (and specifically "20 September 2005" in another location). I apologize if I am being unclear on anything. — Huntster (t @ c) 20:52, 24 January 2021 (UTC)

@Huntster: Sorry, I deployed the updated gadget to the wrong place. Give it another try. --Bamyers99 (talk) 06:11, 25 January 2021 (UTC)

Looks mostly right, now. It's showing "312,000,000 United States dollar, (250,766,355 euro (2005)), (263,854,284 euro (2019))", so that 2019 is still sneaking in. On the other hand, the 2020 conversion looks good, assuming the ratio is taken from, what, the July 1 split? Or is it the high/low average for the year? — Huntster (t @ c) 07:04, 25 January 2021 (UTC)

Question: for the user parameter "Bamyers99_UnitsConverter_currency = 'EUR';", is it possible to set more than one currency? Such as, 'USD,EUR' so it additionally shows the current year inflation value in USD? Also, when I set it to just USD, it converted $2,000,000,000 in 2011 to $1,848,483,485 in 2020, when it should be something like $2,301,172,021. Just an FYI. — Huntster (t @ c) 13:49, 20 September 2021 (UTC)

@Huntster: It only supports one currency. I have fixed the inflation adjusted number. Tested with Alpha Magnetic Spectrometer (Q622434) cost (P2130).

Thanks for the quick response as always :) — Huntster (t @ c) 23:42, 20 September 2021 (UTC)

Proposal of improvement to Navel Gazer - tags

Hi! As I've already said, I consider Navel Gazer a fantastic tool and I always suggest other users to have a look at it. I'm thinking about the following addition to the statistics already present: as of now, I don't know any way to find how many edits have been done by a user through semi-automatic tools; so, I suggest to add to the present sections ("Property additions", "Other actions", "Label, description, alias, sitelink additions") a fourth section named "Tools used" or "Tags" or something similar, listing the number of edits with a tag performed by the user (I would consider tags as "Widar [1.4]", "QuickStatements [1.5]", "Widar [1.3]" and all others referring to tools, not the ones as "redirect created" or "new editor changing statement" and similar ones; otherwise, we can choose to show all tags) and finally the number of edits without tags; there could also be, in addition to "User", "Property"/"Pseudo-properties" and "Language code", a tab "Tools" or "Tags" in which it would be possible to see which users have done more edits with a specific tag. Obviously this is just a proposal and it has no urgency at all, so feel free to have a look whenever you have time and if you find it useful and significant. Thanks and good night, --Epìdosis 00:03, 14 January 2021 (UTC)

@Epìdosis: I have done some preliminary analysis. The tag information is not in the database dump wikidatawiki-stub-meta-history.xml. It is stored in wikidatawiki-change_tag.sql.

Sample revision dump:

<revision>
      <id>948407982</id>
      <parentid>947522704</parentid>
      <timestamp>2019-05-24T22:34:28Z</timestamp>
      <contributor>
        <username>Kam Solusar</username>
        <id>4991</id>
      </contributor>
      <comment>/* wbcreateclaim-create:1| */ [[Property:P5905]]: 4020-56944, #quickstatements; #temporary_batch_1558736841614</comment>
      <model>wikibase-item</model>
      <format>application/json</format>
      <text bytes="149740" id="955875077" />
      <sha1>jpujzijffz4drxy39ft6bzk9atc2mip</sha1>
</revision>

Sample tag data for above revision:

MariaDB [wikidatawiki_p]> select * FROM change_tag,change_tag_def WHERE ct_rev_id = 948407982 AND ct_tag_id = ctd_id;
+-----------+-----------+-----------+-----------+-----------+-----------+--------+-----------------+------------------+-----------+
| ct_id     | ct_rc_id  | ct_log_id | ct_rev_id | ct_params | ct_tag_id | ctd_id | ctd_name        | ctd_user_defined | ctd_count |
+-----------+-----------+-----------+-----------+-----------+-----------+--------+-----------------+------------------+-----------+
| 311583001 | 985250530 |      NULL | 948407982 | NULL      |       594 |    594 | OAuth CID: 1253 |                0 |  47000918 |

"OAuth CID: 1253" would need to be looked up in localization data somewhere to get "QuickStatements [1.3]". I am in the middle of a multi-week project so it will be a while before I have a chance to look at this more thoroughly. --Bamyers99 (talk) 02:09, 14 January 2021 (UTC)

@Epìdosis: Tool usage is now available in NavelGazer. It only includes tools using OAuth. --Bamyers99 (talk) 02:06, 19 January 2021 (UTC)

Re: GNIS removal

Hi! In the Italian version it appears the warning of the presence of an "incorrect url" when there are two GNIS. I asked in a talk how to fix it and a user told me to delete one of them. I thought it was correct because the error warning disappeared but I'm sorry if I did something wrong.--Baseluna014 (talk) 22:16, 28 June 2021 (UTC)

Thank you thank you! You're great! A similar error appears with it:Template:MobyGames when there are two id. For instance in it:Jade Empire or it:The Banner Saga ("This property should only have a single value with the same tipo di versione qualifier")--Baseluna014 (talk) 05:56, 29 June 2021 (UTC)

Thank you for fixing my errors. Can you also fix the it:Template:MobyGames?Baseluna014 (talk) 06:21, 13 July 2021 (UTC)

I forwarded your suggestion to the italian template talk page, and I hope some user more expert than me can make the change. Thanks a lot. Baseluna014 (talk) 14:45, 13 July 2021 (UTC)

Navel Gazer

Hello, I've just discovered Navel Gazer which is a great tool, except it seems to not consider properties added as a qualifier or reference. For NOR numbering ID (P464) for example, it shows a total count of 194 [2] while the true total is over 5,400 [3] Would it be possible to include also these uses? Thanks. Ayack (talk) 12:51, 1 April 2022 (UTC)

@Ayack: Not possible with the current design which only looks at edit comments to determine property additions. --Bamyers99 (talk) 12:39, 2 April 2022 (UTC)

Understood, too bad. Thanks. Ayack (talk) 17:59, 2 April 2022 (UTC)

Wikidata:WikiProject Mountains

Hi Bamyers, a couple of years ago you made this edit, which looks reasonable. When compared to running the query today, the number of mountains with elevation above sea level (P2044) (which you increased from 49k to 327k) is back to around 78k mountains with an elevation. I tried running both queries, before and after your modification, and they return similar values. here you can see what I mean. Do you have any idea where all the mountains with an elevation went? --Arjoopy (talk) 22:09, 28 June 2022 (UTC)

@Arjoopy: I found one of probably multiple changes in the class hierarchy that may account for the difference. summit (Q207326) used to be a subclass of mountain (Q8502) per this version 19:01, May 30, 2018. --Bamyers99 (talk) 22:33, 28 June 2022 (UTC)

I doubt it. There are about 18k summits with an elevation, that brings us nothing close to the 327k before... --Arjoopy (talk) 08:35, 29 June 2022 (UTC)

CoordGlobe.js

Hey there. Is there any way to make this script work with instances of coordinate location that are subproperties? For example, the uses at Apollo 11 (Q43653). I want to fix the lunar coordinates under significant event>moon landing, but the script doesn't show up for that or any of the others. Thanks! — Huntster (t @ c) 03:40, 10 August 2022 (UTC)

@Huntster: Too much programming work. --Bamyers99 (talk) 19:45, 10 August 2022 (UTC)

Navel Gazer update

Hi! I see that during September Navel Gazer wasn't updated to 2022-09-01, but is remaining stuck on 2022-08-01. Could you have a look? Thanks, --Epìdosis 23:06, 26 September 2022 (UTC)

@Epìdosis: Oops, I ran the data extract, but only imported the "Tool usage" data. Am rerunning the extract, since I deleted the data files. It will take a couple of days. --Bamyers99 (talk) 01:01, 27 September 2022 (UTC)

@Epìdosis: The August totals are available. --Bamyers99 (talk) 13:20, 28 September 2022 (UTC)

Dams

Thanks for taking on that task. I have a huge spreadsheet that I was planning to import, but looks like you beat me to it! — Martin (MSGJ · talk) 07:27, 6 December 2022 (UTC)

@MSGJ: I am done adding ids for Dams in Japan number (P11235). Here is a query with the ones that I did not do for various reasons such as 1) No English name, 2) multiple ids per article ie. (PRE), (RE), 3) not found.

SELECT DISTINCT ?s ?sLabel WHERE {
  ?s wdt:P17 wd:Q17 .
  ?s wdt:P31/wdt:P279* wd:Q12323 .
  OPTIONAL {
    ?s wdt:P11235 ?damid .
  }
  FILTER ( !bound(?damid) ) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,fr,es,it,pl,nl,pt,sv,no,ar,cs,ca,ml,ms,az,ru" }
 }
 ORDER BY ?sLabel

Try it!

I also found one that has mixed up two different dams: Nokanan Dam (Q34882552) http://damnet.or.jp/cgi-bin/binranA/enAll.cgi?db4=0082 http://damnet.or.jp/cgi-bin/binranA/enAll.cgi?db4=0090 --Bamyers99 (talk) 19:13, 9 December 2022 (UTC)

Good work! I am using your data on articles such as en:List of dams in Fukui Prefecture. I've noticed that inception (P571) is sometimes used for start date and sometimes for completion date. I have been gradually moving the latter dates to service entry (P729). — Martin (MSGJ · talk) 10:26, 20 December 2022 (UTC)

Gadget statistics

Hi, I have spent a while to figure out what one has to do to have their script end up in Wikidata:Database reports/Gadget usage statistics, but it is still not clear to me. The script in question in my particular case is Wikidata:Tools/Enhance user interface#HaveWikibaseLabelLowercased. Or would it be impossible to add it to the dumb because it is Meta hosted? --Base (talk) 04:38, 22 June 2023 (UTC)

@Base: I have just added metawiki hosted gadgets to the report. --Bamyers99 (talk) 23:57, 22 June 2023 (UTC)

Thanks! --Base (talk) 00:24, 23 June 2023 (UTC)

Number of users per property

Hi! I was thinking about a little addition to the data displayed by Wikidata Navel Gazer, if it's not too complex: for properties (e.g. https://bambots.brucemyers.com/NavelGazer.php?property=P396) it presently shows Total count (total number of additions) and Last month (number of additions last month); could it also show Total user count (total number of users having made at least 1 addition) and Users last month (number of users having made at least 1 addition last month)? Thanks very much in advance as always, --Epìdosis 08:41, 15 July 2023 (UTC)

@Epìdosis:  Done --Bamyers99 (talk) 19:09, 15 July 2023 (UTC)

Hi! As of now, for properties (e.g. https://bambots.brucemyers.com/NavelGazer.php?property=P396), NavelGazer shows some very interesting data like Total count, Last month, Total user count, Users last month, First use, Last use. These six fields could be interstingly applied also to tools (e.g. https://bambots.brucemyers.com/NavelGazer.php?toolid=0) and to languages (e.g. https://bambots.brucemyers.com/NavelGazer.php?langadd=it); maybe for languages the last two are superflous. As always, I hope it is not too difficult. Thanks again! --Epìdosis 19:57, 30 August 2023 (UTC)

@Epìdosis: The totals are now available for tools and languages. First and last use are not available for tools with the current design. This is due to the fact that only the last months edit tags are used to compute tool usage. --Bamyers99 (talk) 23:21, 30 August 2023 (UTC)

how does it do counts in NavelGazer

I was wondering how it does the counting. If I look at P235 then the counts are a lot lower than I expected. There are plenty of chemical entities with P235's created since 2013-06-04 (probably a few hundred thousand). Does the count exclude P235 statement creations, perhaps?

PS, I like to cite the NavelGazer in an upcoming Scholia Chemistry paper. Do I just cite the repository?

The counting relies on specially formatted edit comments when a property is added to an item. Some automated edits do not use the specific format that NavelGazer recognizes. They could be adding multiple properties in one edit or making other changes in the same edit. I have updated the property display to use the actual count for 'Total count' and added an 'unknown' user to the user list. Re: Citation - I don't know how it should be cited. NavelGazer is not an official Wikidata program. It is a volunteer project that I created. No warranty is made as to the accuracy of the information.

Bamyers99 (talk) 21:48, 5 November 2023 (UTC)

Thanks! The 'unknown' addition is extremely helpful! Egon Willighagen (talk) 06:44, 6 November 2023 (UTC)

Thank you!

Thank you for all the imports for the recent botany properties that I proposed! AdamSeattle (talk) 22:10, 5 December 2023 (UTC)

Caleb L. Howe (Q118108827)

It would be cool if you fixed the issue next time instead of just reverting the edit and leaving nothing. It's not like there wasn't a reference. Adamant1 (talk) 08:15, 11 December 2023 (UTC)

@Adamant1: In other news, active editor wants others to fix their mess. --Bamyers99 (talk) 15:10, 11 December 2023 (UTC)

Spare me the condescension. Mistakes happen. I correct other people's "messes" all the time. The revert feature isn't there just to revert edits your to lazy to correct on your own. If your going to have that bad of an attitude about it though, then be my guest and just leave it for someone else to deal with next time. Adamant1 (talk) 19:28, 11 December 2023 (UTC)

Ah yes, somebody who thinks their time is more valuable than everybody elses. --Bamyers99 (talk) 19:39, 11 December 2023 (UTC)

Yeah, sure. That's why I said I spend time fixing other people's mistakes. I swear people on here love to project their own issues on to other people. Your the one who can't be bothered to fix a simple location but I'm the who thinks my time is more valuable than other peoples. Right, right. --Adamant1 (talk) 15:06, 12 December 2023 (UTC)