Project

General

Profile

« Previous | Next » 

Revision 11710

schemas/vegbien.sql: analytical_stem_view: added taxonomic_status. notice that PostgreSQL 9.3 puts each view column on a separate line, making it much easier to review the svn diff!

View differences:

schemas/vegbien.my.sql
814 814
    `taxonName_matched` varchar(255),
815 815
    `scientificNameAuthorship_matched` varchar(255),
816 816
    `higherPlantGroup_bien` varchar(255),
817
    taxonomic_status varchar(255),
817 818
    scrubbed_family varchar(255),
818 819
    scrubbed_genus varchar(255),
819 820
    scrubbed_morphospecies_binomial varchar(255),
schemas/vegbien.sql
1714 1714
    "taxonName_matched" text,
1715 1715
    "scientificNameAuthorship_matched" text,
1716 1716
    "higherPlantGroup_bien" higher_plant_group,
1717
    taxonomic_status text,
1717 1718
    scrubbed_family text,
1718 1719
    scrubbed_genus text,
1719 1720
    scrubbed_morphospecies_binomial text,
......
2907 2908
    taxon_scrub."matchedTaxonName" AS "taxonName_matched", 
2908 2909
    taxon_scrub."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched", 
2909 2910
    family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien", 
2911
    "TNRS".map_taxonomic_status(taxon_scrub."taxonomicStatus", taxon_scrub.scrubbed_unique_taxon_name) AS taxonomic_status, 
2910 2912
    taxon_scrub.scrubbed_family, 
2911 2913
    taxon_scrub.scrubbed_genus, 
2912 2914
    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