Project

General

Profile

« Previous | Next » 

Revision 12938

Added by Aaron Marcuse-Kubitza almost 11 years ago

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

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
41 41 
;
42 42 

  		




  43
  43
  
    
CREATE VIEW _specimens_05_list_of_verbatim_species_excluding_author AS


  		




  
  44
  
    
SELECT DISTINCT concat_ws(' '::text, genus, specific_epithet) AS species


  		




  
  45
  
    
FROM taxonverbatim


  		




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


  		




  
  47
  
    
AND genus IS NOT NULL AND specific_epithet IS NOT NULL;


  		




  44
  48
  
    
;


  		




  45
  49
  
    

  		




  46
  50
  
    
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_without_author AS


  		












Also available in:  Unified diff