Project

General

Profile

« Previous | Next » 

Revision 1157

Added by Aaron Marcuse-Kubitza over 12 years ago

SALVIAS verifications: Fixed to exclude subplots from locations/location events and uniqify locations based on coords

View differences:

verify.ref.sql
15 15 
;
16 16 

  		




  17
  17
  
    
SELECT '# locations' AS ___;


  		




  18
  
  
    
SELECT count(*) AS count FROM plotMetadata;


  		




  
  18
  
    
SELECT count(*) AS count


  		




  
  19
  
    
FROM


  		




  
  20
  
    
(


  		




  
  21
  
    
    SELECT DISTINCT LatDec, LongDec FROM plotMetadata


  		




  
  22
  
    
) locationcoords


  		




  
  23
  
    
;


  		




  19
  24
  
    

  		




  20
  25
  
    
SELECT '# location events' AS ___;


  		




  21
  26
  
    
SELECT count(*) AS count FROM plotMetadata;


  		












Also available in:  Unified diff