Revision 12003
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/SALVIAS/projects/postprocess.sql | ||
|---|---|---|
| 5 | 5 |
DELETE FROM :table WHERE allow_download_all = 0 |
| 6 | 6 |
-- includes all the projects at wiki.vegpath.org/2013-10-25_conference_call#SALVIAS-deduplication |
| 7 | 7 |
; -- runtime: 0.1 s ("72.820 ms") @starscream
|
| 8 |
/* |
|
| 9 |
"`ipr_specific` |
|
| 10 |
LONGTEXT, Values: unconstrained, DEFAULT: "There are no specific use conditions attached |
|
| 11 |
to this dataset. For general use conditions, see SALVIAS General Participant Agreement at |
|
| 12 |
http://www.salvias.net/eula/eula1.html" |
|
| 13 |
" (http://vegpath.org/fs/inputs/SALVIAS/_src/salvias_data_access_controls.txt) |
|
| 14 |
*/ |
|
| 15 |
DELETE FROM :table WHERE NOT COALESCE(ipr_specific = |
|
| 16 |
'There are no specific use conditions attached to this dataset. For general use conditions, see SALVIAS General Participant Agreement at http://www.salvias.net/eula/eula1.html' |
|
| 17 |
, false); -- runtime: 0.2 s ("157.295 ms") @starscream
|
|
| 8 | 18 |
|
| 9 | 19 |
|
| 10 | 20 |
-- remove institutions that we have direct data for |
Also available in: Unified diff
fix: inputs/SALVIAS/projects/postprocess.sql: remove private data that should not be publicly visible: remove projects that do not have "There are no specific use conditions attached to this dataset"