Project

General

Profile

« Previous | Next » 

Revision 13123

Added by Aaron Marcuse-Kubitza almost 11 years ago

fix: inputs/NY/validations.sql: specimens*_of_unique_verbatim_author_taxa_with_genus: use scientificName rather than the concatenated ranks, because that is what is imported to taxonlabel.taxonomicname

View differences:

trunk/inputs/NY/validations.sql
148 148 
--
149 149 

  		




  150
  150
  
    
CREATE VIEW _specimens_08_count_of_unique_verbatim_author_taxa_with_genus AS


  		




  151
  
  
    
 SELECT count(DISTINCT btrim(concat_ws(' '::text, btrim(concat_ws(' '::text, "Ecatalog_all".genus, ifnull("Ecatalog_all"."specificEpithet", ''::text), ifnull("Ecatalog_all".subspecies, ''::text))), btrim(ifnull("Ecatalog_all"."scientificNameAuthorship", ''::text))))) AS taxon_names_with_author


  		




  
  151
  
    
 SELECT count(DISTINCT "Ecatalog_all"."scientificName") AS taxon_names_with_author


  		




  152
  152
  
    
   FROM "Ecatalog_all"


  		




  153
  153
  
    
  WHERE ("Ecatalog_all".genus IS NOT NULL);


  		




  154
  154
  
    

  		




  ......




  167
  167
  
    
--


  		




  168
  168
  
    

  		




  169
  169
  
    
CREATE VIEW _specimens_09_list_of_unique_verbatim_author_taxa_with_genus AS


  		




  170
  
  
    
 SELECT DISTINCT btrim(concat_ws(' '::text, btrim(concat_ws(' '::text, "Ecatalog_all".genus, ifnull("Ecatalog_all"."specificEpithet", ''::text), ifnull("Ecatalog_all".subspecies, ''::text))), btrim(ifnull("Ecatalog_all"."scientificNameAuthorship", ''::text)))) AS taxon_name_with_author


  		




  
  170
  
    
 SELECT DISTINCT "Ecatalog_all"."scientificName" AS taxon_name_with_author


  		




  171
  171
  
    
   FROM "Ecatalog_all"


  		




  172
  172
  
    
  WHERE ("Ecatalog_all".genus IS NOT NULL);


  		




  173
  173
  
    

  		












Also available in:  Unified diff