Revision 11489
Added by Aaron Marcuse-Kubitza over 11 years ago
inputs/SALVIAS/projects/postprocess.sql | ||
---|---|---|
1 |
SELECT util.search_path_append('util'); |
|
2 |
|
|
3 |
|
|
4 |
-- remove institutions that we have direct data for |
|
5 |
DELETE FROM :table |
|
6 |
WHERE project_name IN ( |
|
7 |
/* from mailto:bboyle@email.arizona.edu?Brad_Boyle.2013-10-28:12:27.Re:+Removing+duplicates+from+SALVIAS+plots , |
|
8 |
wiki.vegpath.org/2013-10-25_conference_call#SALVIAS-deduplication : */ |
|
9 |
-- Madidi |
|
10 |
'Madidi Transects' |
|
11 |
, 'Madidi Permanent Plots' |
|
12 |
, 'Madidi Savana Line Transects' |
|
13 |
-- VegBank |
|
14 |
, 'INW Vegetation Plots' |
|
15 |
); -- runtime: 10 s ("10193.125 ms") @starscream |
Also available in: Unified diff
inputs/SALVIAS/projects/postprocess.sql: remove institutions that we have direct data for (Madidi, VegBank)