Project

General

Profile

« Previous | Next » 

Revision 13502

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: _plots_20_tnrs_names: use accepted_morphospecies_binomial, which is now available directly in the TNRS results, instead of just the morphospecies_suffix, as requested in issue #915

View differences:

public_.sql
9395 9395 
    taxon_scrub.accepted_family AS tnrs_accepted_name_family,
9396 9396 
    taxon_scrub.accepted_taxon_name_no_author AS tnrs_accepted_name,
9397 9397 
    taxon_scrub.accepted_author AS tnrs_accepted_name_author,
9398 
    taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix
9398 
    taxon_scrub.accepted_morphospecies_binomial AS taxon_morphospecies
9399 9399 
   FROM ((public.taxonverbatim
9400 9400 
   JOIN public.taxonlabel USING (taxonlabel_id))
9401 9401 
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))

Also available in: Unified diff