Project

General

Profile

« Previous | Next » 

Revision 13532

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: taxon_scrub: added scrubbed_morphospecies_binomial, analogous to accepted_morphospecies_binomial for scrubbed_*

View differences:

trunk/inputs/.TNRS/schema.sql
576 576 
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_rank,
577 577 
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_epithet,
578 578 
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_author,
579 
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author
579 
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author,
580 
        CASE
581 
            WHEN ("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank = 'family'::text) THEN concat_ws(' '::text, "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_family, "ValidMatchedTaxon"."morphospeciesSuffix")
582 
            WHEN ("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank = 'genus'::text) THEN concat_ws(' '::text, "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author, "ValidMatchedTaxon"."morphospeciesSuffix")
583 
            ELSE (("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_genus || ' '::text) || "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_specific_epithet)
584 
        END AS scrubbed_morphospecies_binomial
580 585 
   FROM ("ValidMatchedTaxon"
581 586 
   LEFT JOIN "taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name));
582 587 

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  17382
  17382
  
    
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_rank, 


  		




  17383
  17383
  
    
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_epithet, 


  		




  17384
  17384
  
    
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_author, 


  		




  17385
  
  
    
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author


  		




  
  17385
  
    
    "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author, 


  		




  
  17386
  
    
        CASE


  		




  
  17387
  
    
            WHEN ("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank = 'family'::text) THEN concat_ws(' '::text, "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_family, "ValidMatchedTaxon"."morphospeciesSuffix")


  		




  
  17388
  
    
            WHEN ("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank = 'genus'::text) THEN concat_ws(' '::text, "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author, "ValidMatchedTaxon"."morphospeciesSuffix")


  		




  
  17389
  
    
            ELSE (("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_genus || ' '::text) || "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_specific_epithet)


  		




  
  17390
  
    
        END AS scrubbed_morphospecies_binomial


  		




  17386
  17391
  
    
   FROM ("ValidMatchedTaxon"


  		




  17387
  17392
  
    
   LEFT JOIN "taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name));


  		




  17388
  17393
  
    

  		












Also available in:  Unified diff