Project

General

Profile

« Previous | Next » 

Revision 1083

Added by Aaron Marcuse-Kubitza almost 13 years ago

SALVIAS verification: Updated to schema changes

View differences:

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