Revision 11710
Added by Aaron Marcuse-Kubitza about 11 years ago
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
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!