Project

General

Profile

« Previous | Next » 

Revision 6001

Added by Aaron Marcuse-Kubitza over 11 years ago

mappings/verify.plots.sql: Added # locations, # location events, which also include subplots

View differences:

plots.ref.sql
23 23 
SELECT '# top-level location events' AS ___;
24 24 
SELECT count(*) AS count FROM "plotMetadata";
25 25 

  		




  
  26
  
    
SELECT '# locations' AS ___;


  		




  
  27
  
    
SELECT count(DISTINCT ROW ("PlotID", "Line")) AS count


  		




  
  28
  
    
FROM "plotMetadata"


  		




  
  29
  
    
LEFT JOIN "plotObservations" USING ("PlotID")


  		




  
  30
  
    
;


  		




  
  31
  
    

  		




  
  32
  
    
SELECT '# location events' AS ___;


  		




  
  33
  
    
SELECT count(DISTINCT ROW ("PlotID", "Line", census_date)) AS count


  		




  
  34
  
    
FROM "plotMetadata"


  		




  
  35
  
    
LEFT JOIN "plotObservations" USING ("PlotID")


  		




  
  36
  
    
;


  		




  
  37
  
    

  		




  26
  38
  
    
SELECT '1st methods' AS ___;


  		




  27
  39
  
    
SELECT DISTINCT


  		




  28
  40
  
    
    CAST(project_name AS text) AS projectname


  		












Also available in:  Unified diff