Often while working with `canonical_data.wikis`, I need to select only //content// wikis (i.e. filter out affiliate wikis, governance wikis, metawiki, foundationwiki etc.) This is not very straightforward, as some affiliate wikis have public `editability` and `visibility` and I need to explicitly define the project groups for `content` wikis every time. So it would be helpful to have a column that differentiate various types of wikis.
I had an initial conversation with @nshahquinn-wmf and did some work on mapping various groups to types. Here is my initial proposal (open to discussing the classification & the nomenclature).
{P58964, lines=7}
Consolidated view of the same:
| group_type | db_groups |
|--------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| content | wikipedia, wikibooks, wiktionary, wikiquote, wikisource, wikinews, wikiversity, wikivoyage, commons, species, wikidata, wikifunctions |
| foundation | advisors, advisory, auditcom, boardgovcom, board, chair, collab, donate, ecwikimedia, exec, fdc, foundation, grants, iegcom, internal, legalteam, office, projectcom, searchcom, transitionteam |
| affiliate | amwikimedia, arwikimedia, azwikimedia, bdwikimedia, bewikimedia, brwikimedia, cawikimedia, cnwikimedia, cowikimedia, dkwikimedia, etwikimedia, fiwikimedia, gewikimedia, grwikimedia, hiwikimedia, id-internalwikimedia, idwikimedia, ilwikimedia, maiwikimedia, mkwikimedia, mxwikimedia, ngwikimedia, nlwikimedia, nowikimedia, nycwikimedia, nzwikimedia, pa-uswikimedia, plwikimedia, ptwikimedia, punjabiwikimedia, romdwikimedia, rswikimedia, ruwikimedia, sewikimedia, trwikimedia, uawikimedia, vewikimedia, wbwikimedia, wg-en |
| technical | apiportal, labs, login, mediawiki |
| arbcom | arbcom-cs, arbcom-de, arbcom-en, arbcom-fi, arbcom-nl, arbcom-ru |
| incubation | betawikiversity, incubator, sources |
| governance | chapcom, checkuser, electcom, meta, movementroles, noboard-chapterswikimedia, ombudsmen, otrs-wiki, steward, strategy, sysop-it, techconduct, vote |
| test | labtest, test2, testcommons, test, testwikidata |
| misc | nostalgia, outreach, quality, spcom, ten, thankyou, usability |
| wikimania | wikimania2005, wikimania2006, wikimania2007, wikimania2008, wikimania2009, wikimania2010, wikimania2011, wikimania2012, wikimania2013, wikimania2014, wikimania2015, wikimania2016, wikimania2017, wikimania2018, wikimaniateam, wikimania