Project

General

Profile

« Previous | Next » 

Revision 12911

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql: abbreviated view names longer than 63 chars to prevent them from being truncated

View differences:

trunk/validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql
46 46 
Check: should return 3335 rows
47 47 
';
48 48 

  		




  49
  
  
    
CREATE OR REPLACE VIEW _specimens_06_count_of_unique_verbatim_subsp_taxa_without_author AS


  		




  
  49
  
    
CREATE OR REPLACE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_without_author AS


  		




  50
  50
  
    
SELECT COUNT(DISTINCT CONCAT_WS(' ', genus, "specificEpithet", subspecies)) AS "specificEpithet" FROM "Ecatalog_all"


  		




  51
  51
  
    
WHERE genus IS NOT NULL AND "specificEpithet" IS NOT NULL;


  		




  52
  
  
    
COMMENT ON VIEW _specimens_06_count_of_unique_verbatim_subsp_taxa_without_author


  		




  
  52
  
    
COMMENT ON VIEW _specimens_06_count_of_unique_verb_subsp_taxa_without_author


  		




  53
  53
  
    
  IS '


  		




  54
  54
  
    
Check: should return 1 row


  		




  55
  55
  
    
';


  		












  

    
      trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
    
  





  24
  24
  
    
CREATE OR REPLACE VIEW _specimens_05_list_of_verbatim_species_excluding_author AS


  		




  25
  25
  
    
;


  		




  26
  26
  
    

  		




  27
  
  
    
CREATE OR REPLACE VIEW _specimens_06_count_of_unique_verbatim_subsp_taxa_without_author AS


  		




  
  27
  
    
CREATE OR REPLACE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_without_author AS


  		




  28
  28
  
    
;


  		




  29
  29
  
    

  		




  30
  30
  
    
CREATE OR REPLACE VIEW _specimens_07_list_of_verbatim_subspecific_taxa_without_author AS


  		












Also available in:  Unified diff