Revision 11921
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2896 | 2896 |
plantobservation.authorplantcode AS "recordNumber", |
| 2897 | 2897 |
COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") AS "dateCollected", |
| 2898 | 2898 |
taxonverbatim.family AS family_verbatim, |
| 2899 |
COALESCE(taxonverbatim.taxonomicname, NULLIF(concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author), ''::text), taxonlabel.taxonomicname) AS "scientificName_verbatim",
|
|
| 2899 |
COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "scientificName_verbatim",
|
|
| 2900 | 2900 |
identifiedby.fullname AS "identifiedBy", |
| 2901 | 2901 |
taxondetermination.determinationdate AS "dateIdentified", |
| 2902 | 2902 |
taxondetermination.notes AS "identificationRemarks", |
Also available in: Unified diff
schemas/vegbien.sql: analytical_stem_view: scientificName_verbatim: don't use taxonverbatim.taxonname+author as the scientificName_verbatim if only the author is provided. (this lead to weird scientificName_verbatims that contain just the author.)