|
1
|
SELECT util.search_path_append('util');
|
|
2
|
|
|
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
|
|
|
10
|
-- remove institutions that we have direct data for
|
|
11
|
DELETE FROM :table
|
|
12
|
WHERE project_name IN (
|
|
13
|
/* from mailto:bboyle@email.arizona.edu?Brad_Boyle.2013-10-28:12:27.Re:+Removing+duplicates+from+SALVIAS+plots ,
|
|
14
|
wiki.vegpath.org/2013-10-25_conference_call#SALVIAS-deduplication : */
|
|
15
|
-- Madidi
|
|
16
|
'Madidi Transects'
|
|
17
|
, 'Madidi Permanent Plots'
|
|
18
|
, 'Madidi Savana Line Transects'
|
|
19
|
-- VegBank
|
|
20
|
, 'INW Vegetation Plots'
|
|
21
|
-- most of the 13139 removed plots are from duplicates (13699 - 560)
|
|
22
|
); -- runtime: 10 s ("10193.125 ms") @starscream
|
|
23
|
|
|
24
|
|
|
25
|
-- remove example data
|
|
26
|
DELETE FROM :table
|
|
27
|
WHERE project_name IN (
|
|
28
|
/* from mailto:bboyle@email.arizona.edu?Brad_Boyle.2013-10-28:12:27.Re:+Removing+duplicates+from+SALVIAS+plots ,
|
|
29
|
wiki.vegpath.org/2013-10-25_conference_call#SALVIAS-deduplication : */
|
|
30
|
'nsf_example'
|
|
31
|
); -- runtime: ~0 ("1.476 ms") @starscream
|
