Project

General

Profile

« Previous | Next » 

Revision 6000

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/SALVIAS/verify/plots.ref.sql: Standardized line wrapping to put ; on its own line in multi-line queries and at the end of the line in one-line queries

View differences:

plots.ref.sql
2 2 
SELECT count(*) AS count FROM projects;
3 3 

  		




  4
  4
  
    
SELECT 'projects' AS ___;


  		




  5
  
  
    
SELECT CAST(project_name AS text) AS projectname FROM projects ORDER BY projectname;


  		




  
  5
  
    
SELECT CAST(project_name AS text) AS projectname


  		




  
  6
  
    
FROM projects


  		




  
  7
  
    
ORDER BY projectname


  		




  
  8
  
    
;


  		




  6
  9
  
    

  		




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


  		




  8
  11
  
    
SELECT


  		




  ......




  16
  19
  
    

  		




  17
  20
  
    
SELECT '# top-level locations' AS ___;


  		




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


  		




  19
  
  
    
;


  		




  20
  22
  
    

  		




  21
  23
  
    
SELECT '# top-level location events' AS ___;


  		




  22
  24
  
    
SELECT count(*) AS count FROM "plotMetadata";


  		




  ......




  28
  30
  
    
FROM projects


  		




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


  		




  30
  32
  
    
ORDER BY projectname, method


  		




  31
  
  
    
LIMIT 10;


  		




  
  33
  
    
LIMIT 10


  		




  
  34
  
    
;


  		




  32
  35
  
    

  		




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


  		




  34
  37
  
    
SELECT DISTINCT


  		




  ......




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


  		




  39
  42
  
    
JOIN "lookup_MethodCode" ON "lookup_MethodCode"."MethodCode" = "plotMetadata"."MethodCode"


  		




  40
  43
  
    
ORDER BY projectname, observationmeasure


  		




  41
  
  
    
LIMIT 10;


  		




  
  44
  
    
LIMIT 10


  		




  
  45
  
    
;


  		




  42
  46
  
    

  		




  43
  47
  
    
/*


  		




  44
  48
  
    
SELECT p.PlotID, p.SiteCode, COUNT(*)


  		












Also available in:  Unified diff