13

Phase 3: Delete and Lock

Continuing with our our cleanup of "identification request", as detailed in this proposal.

I would ask the CMs to do the following as the final part of our three-phase process to remove identification questions from our community.

  • Please delete all "identification-requests" without a question score of 4 or higher AND at least an answer with a score of 3 or higher.
  • Please apply a historical lock on ALL questions tagged with (and tag synonyms, as needed).
    • If it's not any extra work, please give a brief synopsis of the number of questions that were deleted and the number that will remain locked.

As always, please let us know if you have questions or comments on the details or procedures made in this post.

SeeYa

Farewell .

A Final Adieu

7

This has been completed. 1637 were deleted, and 396 locked. As with closing before, the questions will appear as deleted or locked by me.

  • 1
    This question was closed as an ID request, but since it wasn't tagged as such, it seems to have been overlooked. – Maroon Jun 9 '16 at 20:36
  • Oh, yeah, I did the cleanup for the tag, so questions that have been mistagged since the tag was blacklisted were not caught in this. Those should be deleted by the community as they come in, much like they're being closed. – JNat Jun 10 '16 at 6:41
1

For verification and archival purpose, I have compiled the list of questions to be deleted with post ID, title and score, based on the conditions above.

The list above is generated from this query, which will stop working next week, when Data Explorer is refreshed with a new dump.

select p.id as [Post Link], p.title, p.answercount, p.score, q.score
from posts p left join (
  select a.parentid, max(a.score) as score
  from posts a
  where a.posttypeid = 2
  group by a.parentid
) q on p.id = q.parentid
where p.tags like '%<identification-request>%'
and (p.score < 4 or q.score < 3 or q.score is null)

After fixing a derp in my query, the number of questions to be removed (1638) now more or less matches the number from JNat's post (1637), with the exception of one post which has been removed earlier by Oded. The one exception aside, I have confirmed that both delete lists contain the same questions.

The number of remaining questions (396) matches the number currently on the site, so there seems to be no hiccup in the process. For extra precaution, I have compared and confirmed that the list of questions from Data Explorer matches the list from JNat's post.

Note that the remaining questions cannot be accessed via when they are locked. Hopefully, the tag is still recorded in the question, so that the search query still works.

  • 1
    Looking at some posts I had made under the tag, the tag seems to be still preserved in the locked questions themselves. – Maroon Jun 9 '16 at 19:09

You must log in to answer this question.

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