SELECT util.search_path_append('util');

CREATE INDEX ON :table ("institution_code");

-- Remove institutions that we have direct data for

DELETE FROM :table

WHERE institution_code IN (

      'ACAD'

    , 'ARIZ'

    , 'BRIT'

    , 'MO'

    , 'MT'

    , 'NY'

    , 'QFA'

    , 'TEX'

    , 'TRT'

    , 'TRTE'

    , 'U'

    , '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

*/

;