CREATE INDEX ON :table ("InstitutionCD");

-- Remove institutions that we have direct data for

DELETE FROM :table

WHERE "InstitutionCD" IN (

      'ACAD'

    , 'MT'

    , 'QFA'

    , 'TRT'

    , 'TRTE'

    , 'UBC'

    , 'WIN'

)

/* list obtained using:

SELECT provider

FROM sourcelist

JOIN provider_count ON

    level = 'top-level'

AND provider_count.provider = sourcelist.name

WHERE source_id = source_by_shortname('GBIF')

*/

;