Revision 13164
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/SALVIAS/projects/postprocess.sql | ||
|---|---|---|
| 12 | 12 |
http://www.salvias.net/eula/eula1.html" |
| 13 | 13 |
" (http://vegpath.org/fs/inputs/SALVIAS/_src/salvias_data_access_controls.txt) |
| 14 | 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
|
|
| 15 |
DELETE FROM :table WHERE NOT COALESCE(ipr_specific IN ( |
|
| 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 |
/* datasets with ipr_specific = '' *are* actually redistributable. when this |
|
| 18 |
field is blank, this just means it was not yet updated with the string above. |
|
| 19 |
(Brad, http://wiki.vegpath.org/2014-04-17_conference_call#conditions-of-use) */ |
|
| 20 |
, '' |
|
| 21 |
), false); -- runtime: 0.2 s ("157.295 ms") @starscream
|
|
| 18 | 22 |
|
| 19 | 23 |
|
| 20 | 24 |
-- 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: preserve datasets with ipr_specific = '', because they are actually redistributable, according to Brad (http://wiki.vegpath.org/2014-04-17_conference_call#conditions-of-use)