1 |
9644
|
aaronmk
|
CREATE INDEX ON :table ("institution_code");
|
2 |
|
|
|
3 |
|
|
-- Remove institutions that we have direct data for
|
4 |
|
|
DELETE FROM :table
|
5 |
|
|
WHERE institution_code IN (
|
6 |
|
|
'ACAD'
|
7 |
|
|
, 'ARIZ'
|
8 |
|
|
, 'BRIT'
|
9 |
|
|
, 'MO'
|
10 |
|
|
, 'MT'
|
11 |
|
|
, 'NY'
|
12 |
|
|
, 'QFA'
|
13 |
|
|
, 'TEX'
|
14 |
|
|
, 'TRT'
|
15 |
|
|
, 'TRTE'
|
16 |
|
|
, 'U'
|
17 |
|
|
, 'UBC'
|
18 |
|
|
, 'WIN'
|
19 |
|
|
)
|
20 |
|
|
/* list obtained using the following on r9459:
|
21 |
|
|
SELECT DISTINCT dataprovider
|
22 |
|
|
FROM sourcelist
|
23 |
|
|
JOIN provider_count ON provider_count.dataprovider = sourcelist.name
|
24 |
|
|
WHERE source_id = source_by_shortname('GBIF')
|
25 |
|
|
ORDER BY dataprovider
|
26 |
|
|
*/
|
27 |
|
|
;
|