Revision 7250
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/REMIB/Specimen/postprocess.sql | ||
|---|---|---|
| 3 | 3 |
-- Remove institutions that we have direct data for |
| 4 | 4 |
DELETE FROM :table |
| 5 | 5 |
WHERE acronym IN ( |
| 6 |
'ARIZ' |
|
| 7 |
, 'MO' |
|
| 8 |
, 'NY' |
|
| 6 |
-- Comments are from e-mail from Brad Boyle on 2013-1-16 |
|
| 7 |
'MO' -- "all MO records in REMIB are also available from MO's own website" |
|
| 8 |
--, 'ARIZ' -- Some REMIB ARIZ specimens not yet in ARIZ itself |
|
| 9 |
--, 'NY' -- Some REMIB NY specimens not yet in NY itself |
|
| 9 | 10 |
) |
| 10 | 11 |
/* list obtained using: |
| 11 | 12 |
SELECT provider |
Also available in: Unified diff
inputs/REMIB/Specimen/postprocess.sql: Added back ARIZ, NY because some REMIB specimens for these datasources are not yet in the datasources themselves