Project

General

Profile

« Previous | Next » 

Revision 5998

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/SALVIAS/verify/plots.ref.sql: # locations: Fixed count to include all plotMetadata entries instead of just unique coordinates, because each plotMetadata entry now gets its own location

View differences:

inputs/SALVIAS/verify/plots.ref.sql
15 15 
;
16 16 

  		




  17
  17
  
    
SELECT '# locations' AS ___;


  		




  18
  
  
    
SELECT count(DISTINCT COALESCE("LatDec", 'NaN')||':'||COALESCE("LongDec", 'NaN')) AS count FROM "plotMetadata"


  		




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


  		




  19
  19
  
    
;


  		




  20
  20
  
    

  		




  21
  21
  
    
SELECT '# location events' AS ___;


  		












  

    
      inputs/SALVIAS/verify/plots.ref
    
  





  54
  54
  
    
___


  		




  55
  55
  
    
# locations


  		




  56
  56
  
    
count


  		




  57
  
  
    
7058


  		




  
  57
  
    
13663


  		




  58
  58
  
    
___


  		




  59
  59
  
    
# location events


  		




  60
  60
  
    
count


  		












Also available in:  Unified diff