Revision 11821
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2913 | 2913 |
taxon_scrub.scrubbed_genus, |
| 2914 | 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,
|
| 2915 | 2915 |
taxon_scrub.scrubbed_taxon_name_no_author, |
| 2916 |
COALESCE(taxon_scrub.scrubbed_author) AS scrubbed_author,
|
|
| 2916 |
taxon_scrub.scrubbed_author,
|
|
| 2917 | 2917 |
taxonoccurrence.growthform AS "growthForm", |
| 2918 | 2918 |
plantobservation.reproductivecondition AS "reproductiveCondition", |
| 2919 | 2919 |
((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien, |
Also available in: Unified diff
schemas/vegbien.sql: analytical_stem_view: scrubbed_author: removed empty COALESCE around value (left over from when multiple values needed to be combined for many TNRS fields)