root/inputs/GBIF/Specimen/postprocess.sql @ 7368
1 | 7229 | aaronmk | 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 | ;
|