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