Project

General

Profile

« Previous | Next » 

Revision 1157

Added by Aaron Marcuse-Kubitza almost 13 years ago

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

View differences:

inputs/SALVIAS/verify.ref
54 54 
___
55 55 
# locations
56 56 
count
57 
13659
57 
7053
58 58 
___
59 59 
# location events
60 60 
count
inputs/SALVIAS/verify.sql
13 13 
;
14 14 

  		




  15
  15
  
    
SELECT '# locations' AS ___;


  		




  16
  
  
    
SELECT count(*) AS count FROM location;


  		




  
  16
  
    
SELECT count(*) AS count FROM location


  		




  
  17
  
    
WHERE parent_id IS NULL -- no subplots


  		




  
  18
  
    
;


  		




  17
  19
  
    

  		




  18
  20
  
    
SELECT '# location events' AS ___;


  		




  19
  
  
    
SELECT count(*) AS count FROM locationevent;


  		




  
  21
  
    
SELECT count(*) AS count FROM locationevent


  		




  
  22
  
    
WHERE parent_id IS NULL -- no subplots


  		




  
  23
  
    
;


  		




  20
  24
  
    

  		




  21
  25
  
    
SELECT '1st methods' AS ___;


  		




  22
  26
  
    
SELECT DISTINCT


  		












  

    
      inputs/SALVIAS/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