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=10}
Consolidated view of the same:
| group_type | db_groups |
|--------------|------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| content | wikipaffiliate | 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, plwikibooksmedia, wiktionaryptwikimedia, punjabiwikiquotemedia, romdwikisourcemedia, rswikinewsmedia, ruwikiversitymedia, sewikivoyagemedia, commonstrwikimedia, speciesuawikimedia, vewikidatamedia, wikifunctions bwikimedia |
| foundation | advisors, advisory, auditcom, boardgovcom, board, chair, collab, donate, ec| content | wikimpedia, execwikibooks, fdcwiktionary, foundationwikiquote, grantswikisource, iegcomwikinews, internalwikiversity, legalteamwikivoyage, officecommons, projectcomspecies, searchcomwikidata, transiwikifunctionteams |
| affiliate | amwikimedia, arwikimedia, azwikimedia, bdwikimedia, bewikimedia, brwikimedia, cawikimedia, cnwikimedia, cowikimedia, dkwikimedia, etwikimedia, fiwikimedia, gewikimedia, grwikimedia, hiwikimedia, id-internalwikimedia, idwikimedia, ilwikimedia, maiwikimedia, mkwikimediafoundation | advisors, mxwikimediaadvisory, ngwikimediaauditcom, nlwikimediaboardgovcom, nowikimediaboard, nycwikimediachair, nzwikimediacollab, pa-usecwikimedia, plwikimediaexec, ptwikimediafdc, punjabiwikimediafoundation, romdwikimediagrants, rswikimediaiegcom, ruwikimediainternal, sewikimedialegalteam, trwikimediaoffice, uawikimediaprojectcom, vewikimediasearchcom, wbwikimediaspcom, wg-entransitionteam |
| technical| functionaries | apiportalarbcom-cs, arbcom-de, arbcom-en, arbcom-fi, arbcom-nl, arbcom-ru, checkuser, labsombudsmen, loginsteward, mediawiki sysop-it |
| arbcom| governance | arbcom-cschapcom, electcom, meta, movementroles, otrs-wiki, arbcom-dequality, arbcom-enstrategy, arbcom-fitechconduct, arbcom-nlusability, arbcom-ru wg-en |
| incubation | betawikiversity, incubator, sources |
| governance | chapcom, checkuser, electcom, meta, movementroles, noboard-chapterswikimedia, ombudsmen, otrs-wiki, steward, strategy, sysop-itmisc | nostalgia, techconductoutreach, voteten |
| test | labtest, test2, testcommonschnical_documentation | apiportal, testlabs, testmediawikidata |
| misc | nostalgia, outreach, quality, spcom| technical_infrastructure | donate, tenlogin, thankyou, usabilityvote |
| wikimaniatest | labtest, test2, testcommons, test, testwikidata |
| wikimania | wikimania2005, wikimania2006, wikimania2007, wikimania2008, wikimania2009, wikimania2010, wikimania2011, wikimania2012, wikimania2013, wikimania2014, wikimania2015, wikimania2016, wikimania2017, wikimania2018, wikimaniateam, wikimania