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).
Consolidated view of the same:
| group_type | db_groups |
|---|---|
| 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, noboard-chapterswikimedia, nowikimedia, nycwikimedia, nzwikimedia, pa-uswikimedia, plwikimedia, ptwikimedia, punjabiwikimedia, romdwikimedia, rswikimedia, ruwikimedia, sewikimedia, trwikimedia, uawikimedia, vewikimedia, wbwikimedia |
| content | wikipedia, wikibooks, wiktionary, wikiquote, wikisource, wikinews, wikiversity, wikivoyage, commons, species, wikidata, wikifunctions |
| foundation | advisors, advisory, auditcom, boardgovcom, board, chair, collab, ecwikimedia, exec, fdc, foundation, grants, iegcom, internal, legalteam, office, projectcom, searchcom, spcom, transitionteam |
| functionaries | arbcom-cs, arbcom-de, arbcom-en, arbcom-fi, arbcom-nl, arbcom-ru, checkuser, ombudsmen, steward, sysop-it |
| governance | chapcom, electcom, meta, movementroles, otrs-wiki, quality, strategy, techconduct, usability, wg-en |
| incubation | betawikiversity, incubator, sources |
| misc | nostalgia, outreach, ten |
| technical_documentation | apiportal, labs, mediawiki |
| technical_infrastructure | donate, login, thankyou, vote |
| test | labtest, test2, testcommons, test, testwikidata |
| wikimania | wikimania2005, wikimania2006, wikimania2007, wikimania2008, wikimania2009, wikimania2010, wikimania2011, wikimania2012, wikimania2013, wikimania2014, wikimania2015, wikimania2016, wikimania2017, wikimania2018, wikimaniateam, wikimania |