root/inputs/GBIF/Specimen/postprocess.sql @ 9309
1 |
CREATE INDEX ON :table ("InstitutionCD"); |
---|---|
2 |
|
3 |
-- Remove institutions that we have direct data for
|
4 |
DELETE FROM :table |
5 |
WHERE "InstitutionCD" IN ( |
6 |
'ACAD'
|
7 |
, 'MT' |
8 |
, 'QFA' |
9 |
, 'TRT' |
10 |
, 'TRTE' |
11 |
, 'UBC' |
12 |
, 'WIN' |
13 |
)
|
14 |
/* list obtained using:
|
15 |
SELECT provider
|
16 |
FROM sourcelist
|
17 |
JOIN provider_count ON
|
18 |
level = 'top-level'
|
19 |
AND provider_count.provider = sourcelist.name
|
20 |
WHERE source_id = source_by_shortname('GBIF')
|
21 |
*/
|
22 |
;
|