Revision 13435
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, |
|
| 9396 |
taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix |
|
| 9395 |
taxon_scrub.scrubbed_family AS tnrs_accepted_name_family, |
|
| 9396 |
taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_accepted_name, |
|
| 9397 |
taxon_scrub.scrubbed_author AS tnrs_accepted_name_author, |
|
| 9398 |
taxon_scrub."morphospeciesSuffix" AS taxon_morphospecies |
|
| 9397 | 9399 |
FROM ((public.taxonverbatim |
| 9398 | 9400 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
| 9399 | 9401 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
Also available in: Unified diff
schemas/public_.sql: _plots_20_tnrs_names: changed to set of columns requested by Martha