Project

General

Profile

« Previous | Next » 

Revision 12939

Added by Aaron Marcuse-Kubitza over 10 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: implemented _specimens_08_count_of_unique_verbatim_author_taxa_with_genus

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
54 54 
;
55 55 

  		




  56
  56
  
    
CREATE VIEW _specimens_08_count_of_unique_verbatim_author_taxa_with_genus AS


  		




  
  57
  
    
SELECT count(DISTINCT taxonlabel.taxonomicname) AS "fullScientificNames"


  		




  
  58
  
    
FROM taxonverbatim


  		




  
  59
  
    
JOIN taxonlabel USING (taxonlabel_id)


  		




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


  		




  
  61
  
    
AND genus IS NOT NULL;


  		




  57
  62
  
    
;


  		




  58
  63
  
    

  		




  59
  64
  
    
CREATE VIEW _specimens_09_list_of_unique_verbatim_author_taxa_with_genus AS


  		












Also available in:  Unified diff