Revision 13534
Added by Aaron Marcuse-Kubitza over 10 years ago
public_.sql | ||
---|---|---|
6731 | 6731 |
taxon_scrub."taxonomicStatus" AS taxonomic_status, |
6732 | 6732 |
taxon_scrub.scrubbed_family, |
6733 | 6733 |
taxon_scrub.scrubbed_genus, |
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,
|
|
6734 |
taxon_scrub.scrubbed_morphospecies_binomial,
|
|
6735 | 6735 |
taxon_scrub.scrubbed_taxon_name_no_author, |
6736 | 6736 |
taxon_scrub.scrubbed_author, |
6737 | 6737 |
taxonoccurrence.growthform AS "growthForm", |
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: scrubbed_morphospecies_binomial: use new taxon_scrub.scrubbed_morphospecies_binomial