Here's my current set of #hotosm mapping initiatives — I classify projects based on keywords in TM2 project titles. I'm sure I've missed a few, but afaik there's no canonical listing.

get_cohort.sql

CREATE OR REPLACE FUNCTION get_cohort(TEXT) RETURNS TEXT AS $$
    BEGIN
        RETURN CASE 
            WHEN $1 ILIKE '%Missing Maps%' OR $1 ILIKE '%MissingMaps%' THEN 'Missing Maps'
            WHEN $1 ILIKE '%Ebola%' THEN 'Ebola response'
            WHEN $1 ILIKE '%Kaligandaki%' AND $1 ILIKE '%Landslide%' THEN 'Kaligandaki landslide'
            WHEN $1 ILIKE '%Nepal%' OR $1='<strong> IDP informal camps</strong>' THEN 'Nepal earthquake'
            -- WHEN $1 ILIKE '%Nepal%' OR $1 ILIKE '%Kaligandaki%' OR $1='<strong> IDP informal camps</strong>' THEN 'Nepal earthquake'
            WHEN $1 ILIKE '%Central African Republic%' OR $1 LIKE '%CAR%' THEN 'CAR'
            WHEN $1 ILIKE '%South Sudan%' THEN 'South Sudan'
            WHEN $1 ILIKE '%MapLesotho%' THEN 'MapLesotho'
            WHEN $1 ILIKE '%Peace Corps%' THEN 'Peace Corps'
            WHEN $1 ILIKE '%MapGive%' THEN 'MapGive'
            WHEN $1 ILIKE '%Gaza%' THEN 'Gaza settlements'
            WHEN $1 ILIKE '%Haiyan%' THEN 'Typhoon Haiyan'
            WHEN $1 ILIKE '%DRC%' THEN 'DRC'
            WHEN $1 ILIKE '%Ivory Coast%' THEN 'Ivory Coast'
            WHEN $1 ILIKE '%Malawi%' AND $1 ILIKE '%flood%' THEN 'Malawi flood preparedness'
            WHEN $1 ILIKE '%USAID%' THEN 'USAID' -- aka "Tanzania roads"
            WHEN $1 ILIKE '%Pam Cyclone%' THEN 'Cyclone Pam'
            WHEN $1 ILIKE '%Afghanistan EQ%' THEN 'Afghanistan earthquake'
            WHEN $1 ILIKE '%Hurricane Patricia%' THEN 'Hurricane Patricia'
            WHEN $1 ILIKE '%NE Nigeria Crisis%' OR $1 ILIKE '%Northeast Nigeria%' THEN 'NE Nigeria'
            WHEN $1 ILIKE '%Uganda%Community Mapping Project%' OR $1 ILIKE '%MapUganda%' OR $1 ILIKE '%Uganda%Bureau Of Statistics%' THEN 'MapUganda'
            WHEN $1 ILIKE '%Indonesia%' OR $1 ILIKE '%Raung%' OR $1 ILIKE '%East Java%' THEN 'Indonesia'
            WHEN $1 ILIKE '%Ecuador%' AND ($1 ILIKE '%Earthquake%' OR $1 ILIKE '%Eathquake%') AND ($1 ILIKE '%2016%' OR $1 ILIKE '%M7,8%') THEN 'Ecuador earthquake'
            WHEN $1 ILIKE '%Japan%' AND $1 ILIKE '%Earthquake%' AND $1 ILIKE '%2016%' THEN 'Japan earthquake'
            WHEN $1 ILIKE '%Togo%' AND $1 ILIKE '%meningitis%' THEN 'Togo meningitis'
            WHEN $1 ILIKE '%Cyclone%' AND $1 ILIKE '%Winston%' THEN 'Cyclone Winston'
            WHEN $1 ILIKE '%Kinshasa%' AND $1 ILIKE '%Flood%' THEN 'Kinshasa floods'
            WHEN ($1 ILIKE '%Coquimbo%' OR $1 ILIKE '%Chile%') AND $1 ILIKE '%earthquake%' THEN 'Chile earthquake'
            WHEN $1 ILIKE '%Myanmar%' AND $1 ILIKE '%Flood%' THEN 'Myanmar floods'
            WHEN ($1 ILIKE '%Croatia%' OR $1 ILIKE '%Bosnia Herzegovin%a%' OR $1 ILIKE '%Serbia%') AND $1 ILIKE '%flood%' THEN 'Croatia/BiH/Serbia floods'
            WHEN $1 ILIKE '%Matthew%' THEN 'Hurricane Matthew'
            WHEN $1 ILIKE '%Africa Indoor Residual Spraying Campaign%' THEN 'Africa IRS campaign'
            WHEN $1 ILIKE '%Sri Lanka Floods%' THEN 'Sri Lanka floods'
            WHEN $1 ILIKE '%Sri Lanka%' AND $1 ILIKE '%Preparedness%' THEN 'Sri Lanka preparedness'
            WHEN $1 ILIKE '%Uganda%' AND $1 ILIKE '%Tanzania%' AND $1 ILIKE '%Earthquake%' THEN 'Uganda/Tanzania earthquake'
            WHEN $1 ILIKE '%Tanzania Development Trust%' THEN 'Crowd2Map Tanzania'
            ELSE 'Other'
        END;
    END;
$$ LANGUAGE plpgsql;