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:

inputs/GBIF/Specimen/postprocess.sql
12 12 
    , 'WIN'
13 13 
)
14 14 
/* list obtained using:
15 
SELECT provider
15 
SELECT DISTINCT dataprovider
16 16 
FROM sourcelist
17 
JOIN provider_count ON
18 
    level = 'top-level'
19 
AND provider_count.provider = sourcelist.name
17 
JOIN provider_count ON provider_count.dataprovider = sourcelist.name
20 18 
WHERE source_id = source_by_shortname('GBIF')
19 
ORDER BY dataprovider
21 20 
*/
22 21 
;
inputs/SpeciesLink/Specimen/postprocess.sql
7 7 
    , 'NY'
8 8 
)
9 9 
/* list obtained using:
10 
SELECT provider
10 
SELECT DISTINCT dataprovider
11 11 
FROM sourcelist
12 
JOIN provider_count ON
13 
    level = 'top-level'
14 
AND provider_count.provider = sourcelist.name
12 
JOIN provider_count ON provider_count.dataprovider = sourcelist.name
15 13 
WHERE source_id = source_by_shortname('SpeciesLink')
14 
ORDER BY dataprovider
16 15 
*/
17 16 
;
inputs/REMIB/Specimen/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