root/inputs/SpeciesLink/Specimen/postprocess.sql @ 8448
1 | 7247 | aaronmk | 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 provider
|
||
11 | FROM sourcelist
|
||
12 | JOIN provider_count ON
|
||
13 | level = 'top-level'
|
||
14 | AND provider_count.provider = sourcelist.name
|
||
15 | WHERE source_id = source_by_shortname('SpeciesLink')
|
||
16 | */
|
||
17 | ;
|