Project

General

Profile

« Previous | Next » 

Revision 11489

inputs/SALVIAS/projects/postprocess.sql: remove institutions that we have direct data for (Madidi, VegBank)

View differences:

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