Project

General

Profile

« Previous | Next » 

Revision 13032

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: use the concatenated taxon name instead of concatenating the ranks, as decided in the 2014-03-27 conference call (wiki.vegpath.org/2014-03-27_conference_call#aggregating-validations)

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
34 34 
;
35 35 

  		




  36
  36
  
    
CREATE VIEW _specimens_04_count_of_unique_verbatim_species_without_author AS


  		




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


  		




  38
  
  
    
FROM taxonverbatim


  		




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


  		




  40
  
  
    
AND genus IS NOT NULL AND specific_epithet IS NOT NULL;


  		




  
  37
  
    
SELECT count(DISTINCT taxonlabel.taxonomicname) AS species


  		




  
  38
  
    
FROM taxonlabel


  		




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


  		




  
  40
  
    
AND taxonlabel.taxonomicname IS NOT NULL;


  		




  41
  41
  
    
;


  		




  42
  42
  
    

  		




  43
  43
  
    
CREATE VIEW _specimens_05_list_of_verbatim_species_excluding_author AS


  		












Also available in:  Unified diff