Project

General

Profile

« Previous | Next » 

Revision 5980

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/SALVIAS/verify/plots.ref.sql: Use project_name instead of project_id everywhere, not just as the ID to list for each project, to match the corresponding VegBIEN queries

View differences:

inputs/SALVIAS/verify/plots.ref.sql
6 6 

  		




  7
  7
  
    
SELECT 'each project''s # locations' AS ___;


  		




  8
  8
  
    
SELECT


  		




  9
  
  
    
    CAST(projects.project_id AS text) AS project


  		




  
  9
  
    
    CAST(project_name AS text) AS project


  		




  10
  10
  
    
    , count("PlotID") AS locations_count


  		




  11
  11
  
    
FROM projects


  		




  12
  12
  
    
JOIN "plotMetadata" ON "plotMetadata".project_id = projects.project_id


  		




  ......




  23
  23
  
    

  		




  24
  24
  
    
SELECT '1st methods' AS ___;


  		




  25
  25
  
    
SELECT DISTINCT


  		




  26
  
  
    
    CAST(projects.project_id AS text) AS project


  		




  
  26
  
    
    CAST(project_name AS text) AS project


  		




  27
  27
  
    
    , "PlotMethod" AS method


  		




  28
  28
  
    
FROM projects


  		




  29
  29
  
    
JOIN "plotMetadata" ON "plotMetadata".project_id = projects.project_id


  		




  ......




  32
  32
  
    

  		




  33
  33
  
    
SELECT '1st observation measures' AS ___;


  		




  34
  34
  
    
SELECT DISTINCT


  		




  35
  
  
    
    CAST(projects.project_id AS text) AS project


  		




  
  35
  
    
    CAST(project_name AS text) AS project


  		




  36
  36
  
    
    , "lookup_MethodCode"."Description" AS observationmeasure


  		




  37
  37
  
    
FROM projects


  		




  38
  38
  
    
JOIN "plotMetadata" ON "plotMetadata".project_id = projects.project_id


  		












  

    
      inputs/SALVIAS/verify/plots.ref
    
  





  30
  30
  
    
___


  		




  31
  31
  
    
each project's # locations


  		




  32
  32
  
    
project	locations_count


  		




  33
  
  
    
1	228


  		




  34
  
  
    
10	26


  		




  35
  
  
    
11	12962


  		




  36
  
  
    
12	28


  		




  37
  
  
    
13	2


  		




  38
  
  
    
14	99


  		




  39
  
  
    
17	6


  		




  40
  
  
    
18	3


  		




  41
  
  
    
19	4


  		




  42
  
  
    
2	37


  		




  43
  
  
    
21	3


  		




  44
  
  
    
22	1


  		




  45
  
  
    
23	70


  		




  46
  
  
    
24	4


  		




  47
  
  
    
25	28


  		




  48
  
  
    
3	20


  		




  49
  
  
    
5	102


  		




  50
  
  
    
6	29


  		




  51
  
  
    
7	9


  		




  52
  
  
    
8	1


  		




  53
  
  
    
9	1


  		




  
  33
  
    
ACA Amazon Forest Inventories	1


  		




  
  34
  
    
Bonifacino Forest Transects	4


  		




  
  35
  
    
Boyle Transects	37


  		




  
  36
  
    
Cam Webb Borneo Plots	28


  		




  
  37
  
    
DeWalt Bolivia forest plots	4


  		




  
  38
  
    
Enquist Lab Transect Dataset	26


  		




  
  39
  
    
Gentry Transect Dataset	228


  		




  
  40
  
    
INW Vegetation Plots	12962


  		




  
  41
  
    
Inventarios de Bosques de la Costa del Ecuador	1


  		




  
  42
  
    
Inventarios de Bosques en Ecuador	1


  		




  
  43
  
    
La Selva Secondary Forest Plots	3


  		




  
  44
  
    
Madidi Permanent Plots	6


  		




  
  45
  
    
Madidi Savana Line Transects	70


  		




  
  46
  
    
Madidi Transects	99


  		




  
  47
  
    
Noel Kempff Forest Plots	29


  		




  
  48
  
    
Noel Kempff Savanna Plots	9


  		




  
  49
  
    
OTS Transects	20


  		




  
  50
  
    
Pilon Lajas Treeplots Bolivia	2


  		




  
  51
  
    
RAINFOR - 0.1 ha Madre de Dios, Peru	102


  		




  
  52
  
    
RAINFOR - 1 ha Peru	28


  		




  
  53
  
    
SERBO Selva Seca Oaxaca	3


  		




  54
  54
  
    
___


  		




  55
  55
  
    
# locations


  		




  56
  56
  
    
count


  		




  ......




  62
  62
  
    
___


  		




  63
  63
  
    
1st methods


  		




  64
  64
  
    
project	method


  		




  65
  
  
    
1	0.1 ha  transect, stems >= 2.5 cm dbh


  		




  66
  
  
    
10	"Pseudotransect": collection of leaf samples from species recorded in previous 0.1 ha transect. Species sampled  from same location as previous transect "Savegre1" (project "OTS Transects"); do not necessarily correspond to same individuals.


  		




  67
  
  
    
10	"Pseudotransect": collection of leaf samples from species recorded in previous 0.1 ha transect. Species sampled  from same location as previous transect "c2750-1" (project "Boyle Transects"); do not necessarily correspond to same individuals.


  		




  68
  
  
    
10	0.1 ha  transect, stems >= 2.5 cm dbh


  		




  69
  
  
    
10	Pseudotransect: collection of leaf samples from species recorded in previous 0.1 ha transect. Species sampled  from same location as previous transect "Cerro" (project "OTS Transects"); do not necessarily correspond to same individuals.


  		




  70
  
  
    
10	NULL


  		




  71
  
  
    
11	20 m x 20 cover plots, all vascular plants


  		




  72
  
  
    
12	0.01 ha, stems >= 10 cm dbh; 16 subplots of 10 x 10 m per plot, 4 rows (UU, U, S, SS), 4 columns (BB, B, T, TT)


  		




  73
  
  
    
13	1 ha, stems >= 10 cm dbh


  		




  74
  
  
    
14	0.1 ha  transect, stems >= 2.5 cm dbh


  		




  
  65
  
    
ACA Amazon Forest Inventories	1 ha, stems >= 10 cm dbh


  		




  
  66
  
    
Bonifacino Forest Transects	0.1 ha  transect, stems >= 2.5 cm dbh


  		




  
  67
  
    
Boyle Transects	0.1 ha  transect, stems >= 2.5 cm dbh


  		




  
  68
  
    
Cam Webb Borneo Plots	0.01 ha, stems >= 10 cm dbh; 16 subplots of 10 x 10 m per plot, 4 rows (UU, U, S, SS), 4 columns (BB, B, T, TT)


  		




  
  69
  
    
DeWalt Bolivia forest plots	0.1 ha  transect, stems >= 2.5 cm dbh


  		




  
  70
  
    
DeWalt Bolivia forest plots	1 ha, stems >= 10 cm dbh


  		




  
  71
  
    
Enquist Lab Transect Dataset	"Pseudotransect": collection of leaf samples from species recorded in previous 0.1 ha transect. Species sampled  from same location as previous transect "Savegre1" (project "OTS Transects"); do not necessarily correspond to same individuals.


  		




  
  72
  
    
Enquist Lab Transect Dataset	"Pseudotransect": collection of leaf samples from species recorded in previous 0.1 ha transect. Species sampled  from same location as previous transect "c2750-1" (project "Boyle Transects"); do not necessarily correspond to same individuals.


  		




  
  73
  
    
Enquist Lab Transect Dataset	0.1 ha  transect, stems >= 2.5 cm dbh


  		




  
  74
  
    
Enquist Lab Transect Dataset	Pseudotransect: collection of leaf samples from species recorded in previous 0.1 ha transect. Species sampled  from same location as previous transect "Cerro" (project "OTS Transects"); do not necessarily correspond to same individuals.


  		




  75
  75
  
    
___


  		




  76
  76
  
    
1st observation measures


  		




  77
  77
  
    
project	observationmeasure


  		




  78
  
  
    
1	species (stems)


  		




  79
  
  
    
10	individuals


  		




  80
  
  
    
10	species (presence)


  		




  81
  
  
    
11	species (percent cover)


  		




  82
  
  
    
12	individuals


  		




  83
  
  
    
13	individuals


  		




  84
  
  
    
14	individuals


  		




  85
  
  
    
17	individuals


  		




  86
  
  
    
18	individuals


  		




  87
  
  
    
19	individuals


  		




  
  78
  
    
ACA Amazon Forest Inventories	individuals


  		




  
  79
  
    
Bonifacino Forest Transects	individuals


  		




  
  80
  
    
Boyle Transects	individuals


  		




  
  81
  
    
Cam Webb Borneo Plots	individuals


  		




  
  82
  
    
DeWalt Bolivia forest plots	individuals


  		




  
  83
  
    
Enquist Lab Transect Dataset	individuals


  		




  
  84
  
    
Enquist Lab Transect Dataset	species (presence)


  		




  
  85
  
    
Gentry Transect Dataset	species (stems)


  		




  
  86
  
    
INW Vegetation Plots	species (percent cover)


  		




  
  87
  
    
Inventarios de Bosques de la Costa del Ecuador	individuals


  		












Also available in:  Unified diff