Project

General

Profile

« Previous | Next » 

Revision 13043

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: *_of_species_binomials: switched back to the old queries that use the split-apart ranks instead of the concatenated taxon name. note that these will not work on all specimens datasources, but now that #6,7 were selected to use the concatenated taxon name, this isn't a problem.

View differences:

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

  		




  36
  36
  
    
CREATE VIEW _specimens_04_count_of_species_binomials AS


  		




  37
  
  
    
SELECT count(DISTINCT taxonlabel.taxonomicname) AS species_binomials


  		




  38
  
  
    
FROM taxonlabel


  		




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


  		




  40
  
  
    
AND taxonlabel.taxonomicname IS NOT NULL


  		




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


  		




  
  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;


  		




  41
  41
  
    
;


  		




  42
  42
  
    

  		




  43
  43
  
    
CREATE VIEW _specimens_05_list_of_species_binomials AS


  		




  44
  
  
    
SELECT DISTINCT taxonlabel.taxonomicname AS species_binomial


  		




  45
  
  
    
FROM taxonlabel


  		




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


  		




  47
  
  
    
AND taxonlabel.taxonomicname IS NOT NULL


  		




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


  		




  
  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;


  		




  48
  48
  
    
;


  		




  49
  49
  
    

  		




  50
  50
  
    
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_with_author AS


  		












Also available in:  Unified diff