Revision 14103
Added by Aaron Marcuse-Kubitza over 10 years ago
| schema.sql | ||
|---|---|---|
| 412 | 412 |
s."*Infraspecific_epithet_score", |
| 413 | 413 |
s."identificationQualifier", |
| 414 | 414 |
s."morphospeciesSuffix", |
| 415 |
s."taxonomicStatus", |
|
| 415 |
s."*taxonomicStatus",
|
|
| 416 | 416 |
s.accepted_taxon_name_no_author, |
| 417 | 417 |
s.accepted_author, |
| 418 | 418 |
s.accepted_taxon_rank, |
| ... | ... | |
| 425 | 425 |
s."*Accepted_name_lsid", |
| 426 | 426 |
s.taxon_scrub__is_valid_match, |
| 427 | 427 |
s.scrubbed_unique_taxon_name, |
| 428 |
map_taxonomic_status(s."*taxonomicStatus", s.accepted_taxon_name_no_author) AS "taxonomicStatus", |
|
| 428 | 429 |
CASE |
| 429 | 430 |
WHEN (s.accepted_taxon_rank = 'family'::text) THEN concat_ws(' '::text, s.accepted_family, s."morphospeciesSuffix")
|
| 430 | 431 |
WHEN (s.accepted_taxon_rank = 'genus'::text) THEN concat_ws(' '::text, s.accepted_taxon_name_no_author, s."morphospeciesSuffix")
|
| ... | ... | |
| 448 | 449 |
taxon_best_match."Infraspecific_epithet_score" AS "*Infraspecific_epithet_score", |
| 449 | 450 |
taxon_best_match."Annotations" AS "identificationQualifier", |
| 450 | 451 |
taxon_best_match."Unmatched_terms" AS "morphospeciesSuffix", |
| 451 |
map_taxonomic_status(taxon_best_match."Taxonomic_status", taxon_best_match."Accepted_name") AS "taxonomicStatus",
|
|
| 452 |
taxon_best_match."Taxonomic_status" AS "*taxonomicStatus",
|
|
| 452 | 453 |
taxon_best_match."Accepted_name" AS accepted_taxon_name_no_author, |
| 453 | 454 |
taxon_best_match."Accepted_name_author" AS accepted_author, |
| 454 | 455 |
taxon_best_match."Accepted_name_rank" AS accepted_taxon_rank, |
| ... | ... | |
| 499 | 500 |
"MatchedTaxon"."*Infraspecific_epithet_score", |
| 500 | 501 |
"MatchedTaxon"."identificationQualifier", |
| 501 | 502 |
"MatchedTaxon"."morphospeciesSuffix", |
| 502 |
"MatchedTaxon"."taxonomicStatus", |
|
| 503 |
"MatchedTaxon"."*taxonomicStatus",
|
|
| 503 | 504 |
"MatchedTaxon".accepted_taxon_name_no_author, |
| 504 | 505 |
"MatchedTaxon".accepted_author, |
| 505 | 506 |
"MatchedTaxon".accepted_taxon_rank, |
| ... | ... | |
| 512 | 513 |
"MatchedTaxon"."*Accepted_name_lsid", |
| 513 | 514 |
"MatchedTaxon".taxon_scrub__is_valid_match, |
| 514 | 515 |
"MatchedTaxon".scrubbed_unique_taxon_name, |
| 516 |
"MatchedTaxon"."taxonomicStatus", |
|
| 515 | 517 |
"MatchedTaxon".accepted_morphospecies_binomial |
| 516 | 518 |
FROM "MatchedTaxon" |
| 517 | 519 |
WHERE "MatchedTaxon".taxon_scrub__is_valid_match; |
| ... | ... | |
| 761 | 763 |
"ValidMatchedTaxon"."*Infraspecific_epithet_score", |
| 762 | 764 |
"ValidMatchedTaxon"."identificationQualifier", |
| 763 | 765 |
"ValidMatchedTaxon"."morphospeciesSuffix", |
| 764 |
"ValidMatchedTaxon"."taxonomicStatus", |
|
| 766 |
"ValidMatchedTaxon"."*taxonomicStatus",
|
|
| 765 | 767 |
"ValidMatchedTaxon".accepted_taxon_name_no_author, |
| 766 | 768 |
"ValidMatchedTaxon".accepted_author, |
| 767 | 769 |
"ValidMatchedTaxon".accepted_taxon_rank, |
| ... | ... | |
| 773 | 775 |
"ValidMatchedTaxon"."*Warnings", |
| 774 | 776 |
"ValidMatchedTaxon"."*Accepted_name_lsid", |
| 775 | 777 |
"ValidMatchedTaxon".taxon_scrub__is_valid_match, |
| 778 |
"ValidMatchedTaxon"."taxonomicStatus", |
|
| 776 | 779 |
"ValidMatchedTaxon".accepted_morphospecies_binomial, |
| 777 | 780 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank, |
| 778 | 781 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_family, |
Also available in: Unified diff
inputs/.TNRS/schema.sql: MatchedTaxon: taxonomicStatus: moved outside the inner SELECT so that the inner SELECT would consist solely of renamings