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.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


  		












Also available in:  Unified diff