Revision 11490
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/SALVIAS/projects/postprocess.sql | ||
|---|---|---|
| 1 | 1 |
SELECT util.search_path_append('util');
|
| 2 | 2 |
|
| 3 | 3 |
|
| 4 |
-- remove private data that should not be publicly visible |
|
| 5 |
DELETE FROM :table WHERE allow_download_all = 0 |
|
| 6 |
-- includes all the projects at wiki.vegpath.org/2013-10-25_conference_call#SALVIAS-deduplication |
|
| 7 |
; -- runtime: 0.1 s ("72.820 ms") @starscream
|
|
| 8 |
|
|
| 9 |
|
|
| 4 | 10 |
-- remove institutions that we have direct data for |
| 5 | 11 |
DELETE FROM :table |
| 6 | 12 |
WHERE project_name IN ( |
Also available in: Unified diff
inputs/SALVIAS/projects/postprocess.sql: remove private data that should not be publicly visible (this was probably already removed by the plotMetadata.AccessCode filter in salvias_plots.~.clean_up.sql)