Project

General

Profile

« Previous | Next » 

Revision 4470

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/SALVIAS/verify/plots.ref.sql: # locations: Fixed bug where a NULL value in LatDec or LongDec would propagate to the concatenated value, reducing its uniqueness

View differences:

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

  		




  17
  17
  
    
SELECT '# locations' AS ___;


  		




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


  		




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


  		




  19
  19
  
    
;


  		




  20
  20
  
    

  		




  21
  21
  
    
SELECT '# location events' AS ___;


  		












Also available in:  Unified diff