Project

General

Profile

« Previous | Next » 

Revision 13509

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: analytical_stem_view: taxonomic_status: don't filter with map_taxonomic_status() anymore since this is now done by "TNRS"."MatchedTaxon"

View differences:

trunk/schemas/public_.sql
6728 6728 
    taxon_scrub."matchedTaxonName" AS "taxonName_matched",
6729 6729 
    taxon_scrub."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched",
6730 6730 
    family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien",
6731 
    "TNRS".map_taxonomic_status(taxon_scrub."taxonomicStatus", taxon_scrub.accepted_taxon_name_no_author) AS taxonomic_status,
6731 
    taxon_scrub."taxonomicStatus" AS taxonomic_status,
6732 6732 
    taxon_scrub.scrubbed_family,
6733 6733 
    taxon_scrub.scrubbed_genus,
6734 6734 
    NULLIF(concat_ws(' '::text, COALESCE(taxon_scrub.scrubbed_genus, taxon_scrub.scrubbed_family), COALESCE(taxon_scrub.scrubbed_specific_epithet, taxon_scrub."morphospeciesSuffix")), ''::text) AS scrubbed_morphospecies_binomial,
trunk/schemas/vegbien.sql
6728 6728 
    taxon_scrub."matchedTaxonName" AS "taxonName_matched",
6729 6729 
    taxon_scrub."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched",
6730 6730 
    family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien",
6731 
    "TNRS".map_taxonomic_status(taxon_scrub."taxonomicStatus", taxon_scrub.accepted_taxon_name_no_author) AS taxonomic_status,
6731 
    taxon_scrub."taxonomicStatus" AS taxonomic_status,
6732 6732 
    taxon_scrub.scrubbed_family,
6733 6733 
    taxon_scrub.scrubbed_genus,
6734 6734 
    NULLIF(concat_ws(' '::text, COALESCE(taxon_scrub.scrubbed_genus, taxon_scrub.scrubbed_family), COALESCE(taxon_scrub.scrubbed_specific_epithet, taxon_scrub."morphospeciesSuffix")), ''::text) AS scrubbed_morphospecies_binomial,

Also available in: Unified diff