Project

General

Profile

« Previous | Next » 

Revision 9502

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/GBIF/Specimen/postprocess.sql, inputs/REMIB/Specimen/postprocess.sql: updated for providers in r9459, which adds TEX

View differences:

inputs/GBIF/Specimen/postprocess.sql
6 6 
      'ACAD'
7 7 
    , 'MT'
8 8 
    , 'QFA'
9 
    , 'TEX'
9 10 
    , 'TRT'
10 11 
    , 'TRTE'
11 12 
    , 'UBC'
12 13 
    , 'WIN'
13 14 
)
14 
/* list obtained using:
15 
/* list obtained using the following on r9459:
15 16 
SELECT DISTINCT dataprovider
16 17 
FROM sourcelist
17 18 
JOIN provider_count ON provider_count.dataprovider = sourcelist.name
inputs/REMIB/Specimen/postprocess.sql
7 7 
    'MO' -- "all MO records in REMIB are also available from MO's own website"
8 8 
    --, 'ARIZ' -- Some REMIB ARIZ specimens not yet in ARIZ itself
9 9 
    --, 'NY' -- Some REMIB NY specimens not yet in NY itself
10 
    , 'TEX'
10 11 
)
11 
/* list obtained using:
12 
/* list obtained using the following on r9459:
12 13 
SELECT DISTINCT dataprovider
13 14 
FROM sourcelist
14 15 
JOIN provider_count ON provider_count.dataprovider = sourcelist.name

Also available in: Unified diff