Project

General

Profile

« Previous | Next » 

Revision 13510

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: _plots_20_tnrs_names: added tnrs_taxonomic_status, as requested in issue #915

View differences:

trunk/schemas/public_.sql
9393 9393 
 SELECT taxonlabel.taxonomicname AS verbatim_name_with_author,
9394 9394 
    taxonlabel.taxonomicname AS tnrs_input_name,
9395 9395 
    taxon_scrub.accepted_family AS tnrs_accepted_name_family,
9396 
    taxon_scrub."taxonomicStatus" AS tnrs_taxonomic_status,
9396 9397 
    taxon_scrub.accepted_taxon_name_no_author AS tnrs_accepted_name,
9397 9398 
    taxon_scrub.accepted_author AS tnrs_accepted_name_author,
9398 9399 
    taxon_scrub.accepted_morphospecies_binomial AS taxon_morphospecies
trunk/schemas/vegbien.sql
9393 9393 
 SELECT taxonlabel.taxonomicname AS verbatim_name_with_author,
9394 9394 
    taxonlabel.taxonomicname AS tnrs_input_name,
9395 9395 
    taxon_scrub.accepted_family AS tnrs_accepted_name_family,
9396 
    taxon_scrub."taxonomicStatus" AS tnrs_taxonomic_status,
9396 9397 
    taxon_scrub.accepted_taxon_name_no_author AS tnrs_accepted_name,
9397 9398 
    taxon_scrub.accepted_author AS tnrs_accepted_name_author,
9398 9399 
    taxon_scrub.accepted_morphospecies_binomial AS taxon_morphospecies

Also available in: Unified diff