Revision 14106
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 395 | 395 |
|
| 396 | 396 |
CREATE VIEW "MatchedTaxon" AS |
| 397 | 397 |
SELECT s."*batch", |
| 398 |
s."concatenatedScientificName", |
|
| 399 | 398 |
s.match_num, |
| 400 | 399 |
s."Name_number", |
| 400 |
s."concatenatedScientificName", |
|
| 401 | 401 |
s."Overall_score", |
| 402 | 402 |
s."matchedTaxonName", |
| 403 | 403 |
s."matchedTaxonRank", |
| ... | ... | |
| 440 | 440 |
ELSE s.accepted_species_binomial |
| 441 | 441 |
END AS accepted_morphospecies_binomial |
| 442 | 442 |
FROM ( SELECT taxon_best_match.batch AS "*batch", |
| 443 |
taxon_best_match."Name_submitted" AS "concatenatedScientificName", |
|
| 444 | 443 |
taxon_best_match.match_num, |
| 445 | 444 |
taxon_best_match."Name_number", |
| 445 |
taxon_best_match."Name_submitted" AS "concatenatedScientificName", |
|
| 446 | 446 |
taxon_best_match."Overall_score", |
| 447 | 447 |
taxon_best_match."Name_matched" AS "matchedTaxonName", |
| 448 | 448 |
taxon_best_match."Name_matched_rank" AS "matchedTaxonRank", |
| ... | ... | |
| 499 | 499 |
|
| 500 | 500 |
CREATE VIEW "ValidMatchedTaxon" AS |
| 501 | 501 |
SELECT "MatchedTaxon"."*batch", |
| 502 |
"MatchedTaxon"."concatenatedScientificName", |
|
| 503 | 502 |
"MatchedTaxon".match_num, |
| 504 | 503 |
"MatchedTaxon"."Name_number", |
| 504 |
"MatchedTaxon"."concatenatedScientificName", |
|
| 505 | 505 |
"MatchedTaxon"."Overall_score", |
| 506 | 506 |
"MatchedTaxon"."matchedTaxonName", |
| 507 | 507 |
"MatchedTaxon"."matchedTaxonRank", |
| ... | ... | |
| 770 | 770 |
CREATE VIEW taxon_scrub AS |
| 771 | 771 |
SELECT "ValidMatchedTaxon".scrubbed_unique_taxon_name, |
| 772 | 772 |
"ValidMatchedTaxon"."*batch", |
| 773 |
"ValidMatchedTaxon"."concatenatedScientificName", |
|
| 774 | 773 |
"ValidMatchedTaxon".match_num, |
| 775 | 774 |
"ValidMatchedTaxon"."Name_number", |
| 775 |
"ValidMatchedTaxon"."concatenatedScientificName", |
|
| 776 | 776 |
"ValidMatchedTaxon"."Overall_score", |
| 777 | 777 |
"ValidMatchedTaxon"."matchedTaxonName", |
| 778 | 778 |
"ValidMatchedTaxon"."matchedTaxonRank", |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19507 | 19507 |
|
| 19508 | 19508 |
CREATE VIEW "MatchedTaxon" AS |
| 19509 | 19509 |
SELECT s."*batch", |
| 19510 |
s."concatenatedScientificName", |
|
| 19511 | 19510 |
s.match_num, |
| 19512 | 19511 |
s."Name_number", |
| 19512 |
s."concatenatedScientificName", |
|
| 19513 | 19513 |
s."Overall_score", |
| 19514 | 19514 |
s."matchedTaxonName", |
| 19515 | 19515 |
s."matchedTaxonRank", |
| ... | ... | |
| 19552 | 19552 |
ELSE s.accepted_species_binomial |
| 19553 | 19553 |
END AS accepted_morphospecies_binomial |
| 19554 | 19554 |
FROM ( SELECT taxon_best_match.batch AS "*batch", |
| 19555 |
taxon_best_match."Name_submitted" AS "concatenatedScientificName", |
|
| 19556 | 19555 |
taxon_best_match.match_num, |
| 19557 | 19556 |
taxon_best_match."Name_number", |
| 19557 |
taxon_best_match."Name_submitted" AS "concatenatedScientificName", |
|
| 19558 | 19558 |
taxon_best_match."Overall_score", |
| 19559 | 19559 |
taxon_best_match."Name_matched" AS "matchedTaxonName", |
| 19560 | 19560 |
taxon_best_match."Name_matched_rank" AS "matchedTaxonRank", |
| ... | ... | |
| 19611 | 19611 |
|
| 19612 | 19612 |
CREATE VIEW "ValidMatchedTaxon" AS |
| 19613 | 19613 |
SELECT "MatchedTaxon"."*batch", |
| 19614 |
"MatchedTaxon"."concatenatedScientificName", |
|
| 19615 | 19614 |
"MatchedTaxon".match_num, |
| 19616 | 19615 |
"MatchedTaxon"."Name_number", |
| 19616 |
"MatchedTaxon"."concatenatedScientificName", |
|
| 19617 | 19617 |
"MatchedTaxon"."Overall_score", |
| 19618 | 19618 |
"MatchedTaxon"."matchedTaxonName", |
| 19619 | 19619 |
"MatchedTaxon"."matchedTaxonRank", |
| ... | ... | |
| 19882 | 19882 |
CREATE VIEW taxon_scrub AS |
| 19883 | 19883 |
SELECT "ValidMatchedTaxon".scrubbed_unique_taxon_name, |
| 19884 | 19884 |
"ValidMatchedTaxon"."*batch", |
| 19885 |
"ValidMatchedTaxon"."concatenatedScientificName", |
|
| 19886 | 19885 |
"ValidMatchedTaxon".match_num, |
| 19887 | 19886 |
"ValidMatchedTaxon"."Name_number", |
| 19887 |
"ValidMatchedTaxon"."concatenatedScientificName", |
|
| 19888 | 19888 |
"ValidMatchedTaxon"."Overall_score", |
| 19889 | 19889 |
"ValidMatchedTaxon"."matchedTaxonName", |
| 19890 | 19890 |
"ValidMatchedTaxon"."matchedTaxonRank", |
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: reordered columns to match taxon_match