Project

General

Profile

« Previous | Next » 

Revision 13036

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: implemented _specimens_06_count_of_unique_verb_subsp_taxa_without_author, _specimens_07_list_of_verbatim_subspecific_taxa_without_author

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
48 48 
;
49 49 

  		




  50
  50
  
    
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_without_author AS


  		




  
  51
  
    
SELECT count(DISTINCT taxonlabel.taxonomicname) AS species


  		




  
  52
  
    
FROM taxonlabel


  		




  
  53
  
    
WHERE taxonlabel.source_id = (SELECT source_by_shortname('NY'))


  		




  
  54
  
    
AND taxonlabel.taxonomicname IS NOT NULL


  		




  51
  55
  
    
;


  		




  52
  56
  
    

  		




  53
  57
  
    
CREATE VIEW _specimens_07_list_of_verbatim_subspecific_taxa_without_author AS


  		




  
  58
  
    
SELECT DISTINCT taxonlabel.taxonomicname AS species


  		




  
  59
  
    
FROM taxonlabel


  		




  
  60
  
    
WHERE taxonlabel.source_id = (SELECT source_by_shortname('NY'))


  		




  
  61
  
    
AND taxonlabel.taxonomicname IS NOT NULL


  		




  54
  62
  
    
;


  		




  55
  63
  
    

  		




  56
  64
  
    
CREATE VIEW _specimens_08_count_of_unique_verbatim_author_taxa_with_genus AS


  		












Also available in:  Unified diff