9

Taxonomist badge description states:

Create a tag used by 50 questions

and I was wondering if there's a way to know which tags were created by me.

So I searched on Stack Exchange Data Explorer and I found this query, but it clearly does not work well because it says that I created and tags, and as you can see in their relative info page Mario Kart 8 and Wrath of the lamb have different creators.

I've noticed that not every tag has a creator in the Tag info page, how does this work? Does it appear only after Taxonomist badge is awarded to the creator?

EDIT:
My theory seems incorrect, is tagged by 132 questions (so eligible to Taxonomist badge) but it does not have a creator.

  • 2
    I know the author of that query. It looks at the tag wiki author, not the tag creator. – JAL Jan 1 '17 at 23:43
  • 2
    @JAL Then it has nothing to do with taxonomist badge – pinckerman Jan 1 '17 at 23:57
  • 1
    Note that Taxonomist is a one-time only badge: The first BOI: Rebirth Question was asked by 3Ventic, who had already earned Taxonomist for [banished] - which does list him as creator. It's likely the tag info page only shows the 'creator' if they've actually earned Taxonomist for 'creating' that tag... – Robotnik Jan 8 '17 at 22:42
  • ^Likewise to the above, I created [pokemon-go] which doesn't list a 'creator' as I had previously earned Taxonomist for [pokemon-oras] – Robotnik Jan 8 '17 at 23:07
  • @Robotnik Oh, thank you for clarifying that. But is it possible to know which tags were created by me? – pinckerman Jan 8 '17 at 23:26
  • @pinckerman - Not easily - likely the only way would be to look through your 'tags' on your profile, then check who asked the first question (and even that can potentially be incorrect if the tag was added to an older question after-the-fact). – Robotnik Jan 8 '17 at 23:42
  • 1
    @Robotnik Ok, I give up... – pinckerman Jan 8 '17 at 23:44
2

Here's some stuff I've figured out:

  • The person who first uses the tag is the person who 'created' it - either by asking a question with it, or by editing it onto a question (with some caveats to do with deletion, merging and renaming tags).
  • There is a difference between creating a tag (i.e. using it on a question for the first time), and creating the tag wiki/excerpt (the informational pieces of the tag).
    • For the purposes of the Taxonomist badge (and the "created by" text on the tag info page) we care about the former.

Now, let's take a look at the Taxonomist badge:

Taxonomist: Create a tag used by 50 questions: 162 awarded

So wait, why is there only 162 badges awarded if we have over 260 tags with >= 50 questions? Well that's because you can only earn Taxonomist once, and those other tags have been created by members who have already earned Taxonomist on another tag.

You can click on the Taxonomist badge on the Badge page to see a list of all users who have been awarded the badge thus far and for which tag it was awarded. Going to that tag's info page will then show that the tag was created by that user.

For example: I was awarded the badge for creating but not , the former lists me as a creator but the latter doesn't. Likewise, in your example of Binding of Issac: Rebirth: 3ventic was awarded the badge for creating and his name appears on that tag's info page, but not the tag page, despite asking the initial question.

Thus the tag info page only shows the 'creator' if they've actually earned Taxonomist for 'creating' that tag.


To directly answer your question: How to know who created a tag?

  • View the tag's info page and look for the creator, or
  • Search for it in the Taxonomist awards page by clicking on the Badge on the Badge page and browsing the awards.

If it isn't in one of those places and the 50 question threshold has been met, it's either created by someone who already has the badge (either by asking a question or by editing it in to someone else's), or created by someone who has left the site, and you will need to manually search for it:

  1. Navigate to the first question asked in that tag (by using the 'newest' tab and going to the last page)
    • A lot of the time, this will the be tag 'creator', but may not be if the tag has been added after-the-fact or if the initial question was deleted.
    • Check any edits to see if the tag was added at a later date. If it has, there's no easy way to determine which was 'first' save for cross referencing edit dates.
  2. If the OP (or editor) still exists on the site, visit their profile badge list and look for Taxonomist.
    • If they have it awarded, clicking on the badge will show which tag they got it for.
    • If the OP doesn't exist anymore (is anonymous or had their account removed, then the Taxonomist badge is 'lost' for this tag - it can never be awarded).
    • If the OP doesn't have the badge, and there are no edits to their initial question that add the tag, then it's likely the actual 'first question' has been deleted, and - contrary to what I thought earlier - only mods can search for deleted questions to determine this.

This is the only general way I can think of to manually determine who 'created' a tag. There are probably some SEDE queries to help with the majority of this searching (except for deleted questions which aren't available on SEDE)

  • 1
    This is probably the most we can do about this and I'll accept your answer, although my initial question "which tags were created by me" still remains. I've looked several SEDE queries but they don't seem to work properly, I always get strange results. As I said, I give up. – pinckerman Jan 9 '17 at 23:46
  • With regard to searching for deleted questions, even if you have the reputation such that you can use the ‘deleted:yes’ parameter, you can still only see your own deleted posts through search. It's not a matter of reputation for option 3, it's whether you're a diamond mod or not. – grg Jan 10 '17 at 18:22
  • @grgarside huh. It's hard to keep track of what is a mod permission vs a 10k+ permission, I could've sworn I was able to search deleted stuff before modship :-) – Robotnik Jan 10 '17 at 20:11
4

So I don't know the full internal workings of the tag system, but I know that if a tag is renamed or merged the creator of the new tag will be the person who performed the merge. However, I know that this is taken into account in the taxonomist logic, so if you create a tag and it's renamed you still get the badge.

  • 2
    Oh this is useful. But what's wrong with "t̨ag͘ sys͜t͡em̧" text? – pinckerman Jan 1 '17 at 13:32
  • 2
    @pinckerman Not sure, it just happens every time I type tag ͞sys̢tem – fredley Jan 1 '17 at 21:08
2

I couldn't see a straight forward way of pulling this out of the data.

The following query will list all the tags you changed via your edits:

select text, creationdate from posthistory where userid = 87579 and text like '%<%>%'

You will need to manually check the tags. I guess that once you are okay with them you can update the query's where clause to include a creationdate after your last manual check. Note that the results will also show entries if you used "<" and ">" characters.

However, for questions it seems a lot trickier. You can use this query:

select tags, creationdate from posts where owneruserid = 87579 and posttypeid = 1 and lasteditdate is null

This will give you tags used for all your questions where there have been no future edits. If there was an edit, and it was by you, the previous query should show tag changes.

I didn't manage to write a query that allowed you to see all the original tags in edited questions. For example, if you create a new question that has since been edited to remove tags. You will need to join a modified version of the 2 previous queries to check for tag changes on your questions.

Finally, I haven't looked at tag merging.


I've noticed that not every tag has a creator in the Tag info page, how does this work? Does it appear only after Taxonomist badge is awarded to the creator?

I think you are correct. Oddly, none of these tags have a listed owner:

select * from tags where count = 50

But these do:

select * from tags where count = 51
  • Ok, thank you for the proof. Btw the only table with a OwnerUserId is TagSynonyms, I have no idea where the tag owner is saved. – pinckerman Jan 4 '17 at 17:01
  • @pinckerman - the listed owner could be driven by a join on the badges table – user101016 Jan 4 '17 at 17:09
  • I want to find the tags created by me, but if I run select * from TagSynonyms where OwnerUserId = 87579 I get an empty list, so a join won't give me anything. – pinckerman Jan 4 '17 at 17:16
  • @pinckerman - That would suggest you have no tag synonyms. Is that correct? – user101016 Jan 4 '17 at 17:19
  • Right, but I have created tags. I don't know where to find the owner in the database. I doubt the tag owner is searched in the Taxonomist badge owners. – pinckerman Jan 4 '17 at 17:33
  • @pinckerman - There is nothing in the tag table to show the owner. It is going to be a case of some long winded table joins to get the data in one query. From the available data it seems that the owner is populated only when the badge table is populated, and appears to only occur when the count is 51 (as seen in the current data). – user101016 Jan 4 '17 at 21:48
  • It seems plausible that when the badge is earned this triggers the owner binding. But I don't understand, they have to keep trace of the owner once a tag is created in some way. Btw you may be right, the whole query is probably long and complex to replicate. – pinckerman Jan 4 '17 at 23:23
  • 1
    I've found an exception to your theory: binding-of-isaac-rebirth is tagged 132 times but does not have a creator. – pinckerman Jan 7 '17 at 4:02
  • This scenario explained in this answer: meta.gaming.stackexchange.com/a/12208/101016 – user101016 Jan 10 '17 at 23:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .