Project

General

Profile

1
CREATE INDEX ON :table ("dwc_terms_institutionCode");
2

    
3
-- Remove institutions that we have direct data for
4
DELETE FROM :table
5
WHERE "dwc_terms_institutionCode" IN (
6
      'MO'
7
    , 'NY'
8
)
9
/* list obtained using:
10
SELECT DISTINCT dataprovider
11
FROM sourcelist
12
JOIN provider_count ON provider_count.dataprovider = sourcelist.name
13
WHERE source_id = source_by_shortname('SpeciesLink')
14
ORDER BY dataprovider
15
*/
16
;
(5-5/8)