Revision 14422
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 1490 | 1490 |
taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 1491 | 1491 |
taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
| 1492 | 1492 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 1493 |
map_taxonomic_status(taxon_best_match."*Taxonomic_status", taxon_best_match."*Accepted_name") AS "taxonomicStatus", |
|
| 1494 | 1493 |
CASE |
| 1495 |
WHEN (taxon_best_match."*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, taxon_best_match."*Accepted_name_family", taxon_best_match."*Unmatched_terms")
|
|
| 1496 |
WHEN (taxon_best_match."*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, taxon_best_match."*Accepted_name", taxon_best_match."*Unmatched_terms")
|
|
| 1497 |
ELSE taxon_best_match."*Accepted_name_species" |
|
| 1494 |
WHEN true THEN taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" |
|
| 1495 |
ELSE NULL::text |
|
| 1496 |
END AS "taxonomicStatus", |
|
| 1497 |
CASE |
|
| 1498 |
WHEN true THEN taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" |
|
| 1499 |
ELSE NULL::text |
|
| 1498 | 1500 |
END AS accepted_morphospecies_binomial |
| 1499 | 1501 |
FROM taxon_best_match; |
| 1500 | 1502 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 21412 | 21412 |
taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 21413 | 21413 |
taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
| 21414 | 21414 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 21415 |
map_taxonomic_status(taxon_best_match."*Taxonomic_status", taxon_best_match."*Accepted_name") AS "taxonomicStatus", |
|
| 21416 | 21415 |
CASE |
| 21417 |
WHEN (taxon_best_match."*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, taxon_best_match."*Accepted_name_family", taxon_best_match."*Unmatched_terms")
|
|
| 21418 |
WHEN (taxon_best_match."*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, taxon_best_match."*Accepted_name", taxon_best_match."*Unmatched_terms")
|
|
| 21419 |
ELSE taxon_best_match."*Accepted_name_species" |
|
| 21416 |
WHEN true THEN taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" |
|
| 21417 |
ELSE NULL::text |
|
| 21418 |
END AS "taxonomicStatus", |
|
| 21419 |
CASE |
|
| 21420 |
WHEN true THEN taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" |
|
| 21421 |
ELSE NULL::text |
|
| 21420 | 21422 |
END AS accepted_morphospecies_binomial |
| 21421 | 21423 |
FROM taxon_best_match; |
| 21422 | 21424 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: MatchedTaxon: use derived columns from taxon_match. this also incorporates the fixes in the new derived columns.