CREATE INDEX ON :table ("InstitutionCD"); -- Remove institutions that we have direct data for DELETE FROM :table WHERE "InstitutionCD" IN ( 'ACAD' , 'MT' , 'QFA' , 'TEX' , 'TRT' , 'TRTE' , 'UBC' , 'WIN' ) /* list obtained using the following on r9459: SELECT DISTINCT dataprovider FROM sourcelist JOIN provider_count ON provider_count.dataprovider = sourcelist.name WHERE source_id = source_by_shortname('GBIF') ORDER BY dataprovider */ ;