Revision 13433
Added by Aaron Marcuse-Kubitza over 10 years ago
| public_.sql | ||
|---|---|---|
| 9392 | 9392 |
CREATE VIEW _plots_20_tnrs_names AS |
| 9393 | 9393 |
SELECT taxonlabel.taxonomicname AS verbatim_name_with_author, |
| 9394 | 9394 |
taxonlabel.taxonomicname AS tnrs_input_name, |
| 9395 |
taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name |
|
| 9395 |
taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name, |
|
| 9396 |
taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix |
|
| 9396 | 9397 |
FROM ((public.taxonverbatim |
| 9397 | 9398 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
| 9398 | 9399 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
Also available in: Unified diff
schemas/public_.sql: _plots_20_tnrs_names: added morphospecies suffix in order to also validate it