root/inputs/GBIF/Specimen/postprocess.sql @ 9849
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 |
, 'TEX' |
10 |
, 'TRT' |
11 |
, 'TRTE' |
12 |
, 'UBC' |
13 |
, 'WIN' |
14 |
)
|
15 |
/* list obtained using the following on r9459:
|
16 |
SELECT DISTINCT dataprovider
|
17 |
FROM sourcelist
|
18 |
JOIN provider_count ON provider_count.dataprovider = sourcelist.name
|
19 |
WHERE source_id = source_by_shortname('GBIF')
|
20 |
ORDER BY dataprovider
|
21 |
*/
|
22 |
;
|