Project

General

Profile

« Previous | Next » 

Revision 616

Added by Aaron Marcuse-Kubitza about 13 years ago

inputs/SALVIAS/verify: Updated to use new names for renamed tables

View differences:

inputs/SALVIAS/verify.ref
1 1 
___
2 2 
# projects
3 3 
count
4 
23
4 
22
5 5 
___
6 6 
projects
7 7 
project
......
11 11 
12
12 12 
13
13 13 
14
14 
16
15 14 
17
16 15 
18
17 16 
19
......
29 28 
8
30 29 
9
31 30 
___
32 
each project's # plots
31 
each project's # locations
33 32 
project	plots_count
34 33 
1	228
35 34 
10	22
......
37 36 
12	28
38 37 
13	2
39 38 
14	99
40 
16	2
41 39 
17	6
42 40 
18	3
43 41 
19	4
......
54 52 
8	1
55 53 
9	1
56 54 
___
57 
# plots
55 
# locations
58 56 
count
59 
13661
57 
13659
60 58 
___
61 
# plot observations
59 
# location observations
62 60 
count
63 
13661
61 
13659
64 62 
___
65 63 
1st methods
66 64 
project	method
67 65 
1	species (stems)
68 66 
10	individuals
67 
10	species (presence)
69 68 
11	species (percent cover)
70 69 
12	individuals
71 70 
13	individuals
......
73 72 
17	individuals
74 73 
18	individuals
75 74 
19	individuals
76 
2	individuals
77 75 
___
78 76 
1st method narratives
79 77 
project	method_narrative
......
86 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)
87 85 
13	1 ha, stems >= 10 cm dbh
88 86 
14	0.1 ha  transect, stems >= 2.5 cm dbh
89 
16	NULL
87 
17	1 ha, stems >= 10 cm dbh
inputs/SALVIAS/verify.sql
4 4 
SELECT 'projects' AS ___;
5 5 
SELECT projectname AS project FROM project ORDER BY project;
6 6 

  		




  7
  
  
    
SELECT E'each project\'s # plots' AS ___;


  		




  8
  
  
    
SELECT projectname AS project, count(*) AS plots_count


  		




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


  		




  
  8
  
    
SELECT projectname AS project, count(*) AS locations_count


  		




  9
  9
  
    
FROM project


  		




  10
  
  
    
JOIN plotevent USING (project_id)


  		




  
  10
  
    
JOIN locationevent USING (project_id)


  		




  11
  11
  
    
GROUP BY project


  		




  12
  12
  
    
ORDER BY project


  		




  13
  13
  
    
;


  		




  14
  14
  
    

  		




  15
  
  
    
SELECT '# plots' AS ___;


  		




  16
  
  
    
SELECT count(*) AS count FROM plot;


  		




  
  15
  
    
SELECT '# locations' AS ___;


  		




  
  16
  
    
SELECT count(*) AS count FROM location;


  		




  17
  17
  
    

  		




  18
  
  
    
SELECT '# plot observations' AS ___;


  		




  19
  
  
    
SELECT count(*) AS count FROM plotevent;


  		




  
  18
  
    
SELECT '# location observations' AS ___;


  		




  
  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
  24
  
    
    , stemSampleMethod AS method -- placeholder until we have a method field


  		




  25
  25
  
    
FROM project


  		




  26
  
  
    
JOIN plotevent USING (project_id)


  		




  
  26
  
    
JOIN locationevent USING (project_id)


  		




  27
  27
  
    
ORDER BY project, method


  		




  28
  28
  
    
LIMIT 10;


  		




  29
  29
  
    

  		




  ......




  32
  32
  
    
    projectname AS project


  		




  33
  33
  
    
    , methodNarrative AS method_narrative


  		




  34
  34
  
    
FROM project


  		




  35
  
  
    
JOIN plotevent USING (project_id)


  		




  
  35
  
    
JOIN locationevent USING (project_id)


  		




  36
  36
  
    
ORDER BY project, method_narrative


  		




  37
  37
  
    
LIMIT 10;


  		












  

    
      inputs/SALVIAS/verify.ref.sql
    
  





  4
  4
  
    
SELECT 'projects' AS ___;


  		




  5
  5
  
    
SELECT CAST(project_id AS char) AS project FROM projects ORDER BY project;


  		




  6
  6
  
    

  		




  7
  
  
    
SELECT 'each project\'s # plots' AS ___;


  		




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


  		




  8
  8
  
    
SELECT


  		




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


  		




  10
  10
  
    
    , count(PlotID) AS plots_count


  		




  ......




  14
  14
  
    
ORDER BY project


  		




  15
  15
  
    
;


  		




  16
  16
  
    

  		




  17
  
  
    
SELECT '# plots' AS ___;


  		




  
  17
  
    
SELECT '# locations' AS ___;


  		




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


  		




  19
  19
  
    

  		




  20
  
  
    
SELECT '# plot observations' AS ___;


  		




  
  20
  
    
SELECT '# location observations' AS ___;


  		




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


  		




  22
  22
  
    

  		




  23
  23
  
    
SELECT '1st methods' AS ___;


  		












Also available in:  Unified diff