Project

General

Profile

« Previous | Next » 

Revision 13033

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
37 37 
SELECT count(DISTINCT taxonlabel.taxonomicname) AS species
38 38 
FROM taxonlabel
39 39 
WHERE taxonlabel.source_id = (SELECT source_by_shortname('NY'))
40 
AND taxonlabel.taxonomicname IS NOT NULL;
40 
AND taxonlabel.taxonomicname IS NOT NULL
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
  
    
SELECT DISTINCT taxonlabel.taxonomicname AS species


  		




  
  45
  
    
FROM taxonlabel


  		




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


  		




  
  47
  
    
AND taxonlabel.taxonomicname IS NOT NULL


  		




  48
  48
  
    
;


  		




  49
  49
  
    

  		




  50
  50
  
    
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_without_author AS


  		












Also available in:  Unified diff