Project

General

Profile

« Previous | Next » 

Revision 13435

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: _plots_20_tnrs_names: changed to set of columns requested by Martha

View differences:

trunk/schemas/public_.sql
9392 9392 
CREATE VIEW _plots_20_tnrs_names AS
9393 9393 
 SELECT taxonlabel.taxonomicname AS verbatim_name_with_author,
9394 9394 
    taxonlabel.taxonomicname AS tnrs_input_name,
9395 
    taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name,
9396 
    taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix
9395 
    taxon_scrub.scrubbed_family AS tnrs_accepted_name_family,
9396 
    taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_accepted_name,
9397 
    taxon_scrub.scrubbed_author AS tnrs_accepted_name_author,
9398 
    taxon_scrub."morphospeciesSuffix" AS taxon_morphospecies
9397 9399 
   FROM ((public.taxonverbatim
9398 9400 
   JOIN public.taxonlabel USING (taxonlabel_id))
9399 9401 
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))
trunk/schemas/vegbien.sql
9392 9392 
CREATE VIEW _plots_20_tnrs_names AS
9393 9393 
 SELECT taxonlabel.taxonomicname AS verbatim_name_with_author,
9394 9394 
    taxonlabel.taxonomicname AS tnrs_input_name,
9395 
    taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name,
9396 
    taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix
9395 
    taxon_scrub.scrubbed_family AS tnrs_accepted_name_family,
9396 
    taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_accepted_name,
9397 
    taxon_scrub.scrubbed_author AS tnrs_accepted_name_author,
9398 
    taxon_scrub."morphospeciesSuffix" AS taxon_morphospecies
9397 9399 
   FROM ((public.taxonverbatim
9398 9400 
   JOIN public.taxonlabel USING (taxonlabel_id))
9399 9401 
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))

Also available in: Unified diff