Project

General

Profile

« Previous | Next » 

Revision 1083

Added by Aaron Marcuse-Kubitza almost 13 years ago

SALVIAS verification: Updated to schema changes

View differences:

inputs/SALVIAS/verify.ref
56 56 
count
57 57 
13659
58 58 
___
59 
# location observations
59 
# location events
60 60 
count
61 61 
13659
62 62 
___
63 63 
1st methods
64 64 
project	method
65 
1	0.1 ha  transect, stems >= 2.5 cm dbh
66 
10	NULL
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	"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.
69 
10	0.1 ha  transect, stems >= 2.5 cm dbh
70 
11	20 m x 20 cover plots, all vascular plants
71 
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)
72 
13	1 ha, stems >= 10 cm dbh
73 
14	0.1 ha  transect, stems >= 2.5 cm dbh
74 
17	1 ha, stems >= 10 cm dbh
75 
___
76 
1st observation measures
77 
project	observationmeasure
65 78 
1	species (stems)
66 79 
10	individuals
67 80 
10	species (presence)
......
72 85 
17	individuals
73 86 
18	individuals
74 87 
19	individuals
75 
___
76 
1st method narratives
77 
project	method_narrative
78 
1	0.1 ha  transect, stems >= 2.5 cm dbh
79 
10	NULL
80 
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.
81 
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.
82 
10	0.1 ha  transect, stems >= 2.5 cm dbh
83 
11	20 m x 20 cover plots, all vascular plants
84 
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)
85 
13	1 ha, stems >= 10 cm dbh
86 
14	0.1 ha  transect, stems >= 2.5 cm dbh
87 
17	1 ha, stems >= 10 cm dbh
inputs/SALVIAS/verify.sql
15 15 
SELECT '# locations' AS ___;
16 16 
SELECT count(*) AS count FROM location;
17 17 

  		




  18
  
  
    
SELECT '# location observations' AS ___;


  		




  
  18
  
    
SELECT '# location events' AS ___;


  		




  19
  19
  
    
SELECT count(*) AS count FROM locationevent;


  		




  20
  20
  
    

  		




  21
  21
  
    
SELECT '1st methods' AS ___;


  		




  22
  22
  
    
SELECT DISTINCT


  		




  23
  23
  
    
    projectname AS project


  		




  24
  
  
    
    , stemSampleMethod AS method -- placeholder until we have a method field


  		




  
  24
  
    
    , plotmethod.name AS method


  		




  25
  25
  
    
FROM project


  		




  26
  26
  
    
JOIN locationevent USING (project_id)


  		




  
  27
  
    
JOIN plotmethod USING (plotmethod_id)


  		




  27
  28
  
    
ORDER BY project, method


  		




  28
  29
  
    
LIMIT 10;


  		




  29
  30
  
    

  		




  30
  
  
    
SELECT '1st method narratives' AS ___;


  		




  
  31
  
    
SELECT '1st observation measures' AS ___;


  		




  31
  32
  
    
SELECT DISTINCT


  		




  32
  33
  
    
    projectname AS project


  		




  33
  
  
    
    , methodNarrative AS method_narrative


  		




  
  34
  
    
    , method.observationmeasure AS observationmeasure


  		




  34
  35
  
    
FROM project


  		




  35
  36
  
    
JOIN locationevent USING (project_id)


  		




  36
  
  
    
ORDER BY project, method_narrative


  		




  
  37
  
    
JOIN plotmethod USING (plotmethod_id)


  		




  
  38
  
    
JOIN method USING (method_id)


  		




  
  39
  
    
ORDER BY project, observationmeasure


  		




  37
  40
  
    
LIMIT 10;


  		












  

    
      inputs/SALVIAS/verify.ref.sql
    
  





  17
  17
  
    
SELECT '# locations' AS ___;


  		




  18
  18
  
    
SELECT count(*) AS count FROM plotMetadata;


  		




  19
  19
  
    

  		




  20
  
  
    
SELECT '# location observations' AS ___;


  		




  
  20
  
    
SELECT '# location events' AS ___;


  		




  21
  21
  
    
SELECT count(*) AS count FROM plotMetadata;


  		




  22
  22
  
    

  		




  23
  23
  
    
SELECT '1st methods' AS ___;


  		




  24
  24
  
    
SELECT DISTINCT


  		




  25
  25
  
    
    CAST(projects.project_id AS char) AS project


  		




  26
  
  
    
    , lookup_MethodCode.Description AS method


  		




  
  26
  
    
    , PlotMethod AS method


  		




  27
  27
  
    
FROM projects


  		




  28
  28
  
    
JOIN plotMetadata ON plotMetadata.project_id = projects.project_id


  		




  29
  
  
    
JOIN lookup_MethodCode ON lookup_MethodCode.MethodCode = plotMetadata.MethodCode


  		




  30
  29
  
    
ORDER BY project, method


  		




  31
  30
  
    
LIMIT 10;


  		




  32
  31
  
    

  		




  33
  
  
    
SELECT '1st method narratives' AS ___;


  		




  
  32
  
    
SELECT '1st observation measures' AS ___;


  		




  34
  33
  
    
SELECT DISTINCT


  		




  35
  34
  
    
    CAST(projects.project_id AS char) AS project


  		




  36
  
  
    
    , PlotMethod AS method_narrative


  		




  
  35
  
    
    , lookup_MethodCode.Description AS observationmeasure


  		




  37
  36
  
    
FROM projects


  		




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


  		




  39
  
  
    
ORDER BY project, method_narrative


  		




  
  38
  
    
JOIN lookup_MethodCode ON lookup_MethodCode.MethodCode = plotMetadata.MethodCode


  		




  
  39
  
    
ORDER BY project, observationmeasure


  		




  40
  40
  
    
LIMIT 10;


  		




  41
  41
  
    

  		




  42
  42
  
    
/*


  		












Also available in:  Unified diff