Thread:Project:Support desk/How to detect content (or non-content) categories from wiki dump files?/reply

Most of the software based categories can be found by using Special:TrackingCategories on a wiki instance.

As to the administrative categories, there is no other way than by traversing the parents of each category and seeing if they are part of en:Category:Wikipedia administration. Note however, that this is human maintained, there can be errors, causing you to exclude way more than you are expecting.