Revision 13511
Added by Aaron Marcuse-Kubitza over 10 years ago
vegbien.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."taxonomicStatus" AS tnrs_taxonomic_status, |
|
9395 | 9396 |
taxon_scrub.accepted_family AS tnrs_accepted_name_family, |
9396 |
taxon_scrub."taxonomicStatus" AS tnrs_taxonomic_status, |
|
9397 | 9397 |
taxon_scrub.accepted_taxon_name_no_author AS tnrs_accepted_name, |
9398 | 9398 |
taxon_scrub.accepted_author AS tnrs_accepted_name_author, |
9399 | 9399 |
taxon_scrub.accepted_morphospecies_binomial AS taxon_morphospecies |
Also available in: Unified diff
fix: schemas/public_.sql: _plots_20_tnrs_names: fixed order of tnrs_taxonomic_status, tnrs_accepted_name_family