Project

General

Profile

« Previous | Next » 

Revision 5999

Added by Aaron Marcuse-Kubitza over 11 years ago

mappings/verify.plots.sql: Added "top-level" to # locations, # location events names because these queries do not include all locations

View differences:

plots.ref.sql
14 14 
ORDER BY projectname
15 15 
;
16 16 

  		




  17
  
  
    
SELECT '# locations' AS ___;


  		




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


  		




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


  		




  19
  19
  
    
;


  		




  20
  20
  
    

  		




  21
  
  
    
SELECT '# location events' AS ___;


  		




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


  		




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


  		




  23
  23
  
    

  		




  24
  24
  
    
SELECT '1st methods' AS ___;


  		












Also available in:  Unified diff