Project

General

Profile

« Previous | Next » 

Revision 9501

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/*/*/postprocess.sql: Remove institutions that we have direct data for: query to obtain list: updated for current schema

View differences:

postprocess.sql
9 9 
    --, 'NY' -- Some REMIB NY specimens not yet in NY itself
10 10 
)
11 11 
/* list obtained using:
12 
SELECT provider
12 
SELECT DISTINCT dataprovider
13 13 
FROM sourcelist
14 
JOIN provider_count ON
15 
    level = 'top-level'
16 
AND provider_count.provider = sourcelist.name
14 
JOIN provider_count ON provider_count.dataprovider = sourcelist.name
17 15 
WHERE source_id = source_by_shortname('REMIB')
16 
ORDER BY dataprovider
18 17 
*/
19 18 
;

Also available in: Unified diff