Revision 14104
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 402 | 402 |
s."matchedScientificNameAuthorship", |
| 403 | 403 |
s."matchedScientificNameID", |
| 404 | 404 |
s."*Author_score", |
| 405 |
s.parsed_family, |
|
| 405 | 406 |
s."matchedFamilyConfidence_fraction", |
| 406 | 407 |
s."matchedFamily", |
| 407 | 408 |
s."matchedGenus", |
| ... | ... | |
| 439 | 440 |
taxon_best_match."Name_matched_author" AS "matchedScientificNameAuthorship", |
| 440 | 441 |
taxon_best_match."Name_matched_url" AS "matchedScientificNameID", |
| 441 | 442 |
taxon_best_match."Author_score" AS "*Author_score", |
| 443 |
taxon_best_match."Family_matched" AS parsed_family, |
|
| 442 | 444 |
taxon_best_match."Family_score" AS "matchedFamilyConfidence_fraction", |
| 443 | 445 |
taxon_best_match."Name_matched_accepted_family" AS "matchedFamily", |
| 444 | 446 |
taxon_best_match."Genus_matched" AS "matchedGenus", |
| ... | ... | |
| 490 | 492 |
"MatchedTaxon"."matchedScientificNameAuthorship", |
| 491 | 493 |
"MatchedTaxon"."matchedScientificNameID", |
| 492 | 494 |
"MatchedTaxon"."*Author_score", |
| 495 |
"MatchedTaxon".parsed_family, |
|
| 493 | 496 |
"MatchedTaxon"."matchedFamilyConfidence_fraction", |
| 494 | 497 |
"MatchedTaxon"."matchedFamily", |
| 495 | 498 |
"MatchedTaxon"."matchedGenus", |
| ... | ... | |
| 753 | 756 |
"ValidMatchedTaxon"."matchedScientificNameAuthorship", |
| 754 | 757 |
"ValidMatchedTaxon"."matchedScientificNameID", |
| 755 | 758 |
"ValidMatchedTaxon"."*Author_score", |
| 759 |
"ValidMatchedTaxon".parsed_family, |
|
| 756 | 760 |
"ValidMatchedTaxon"."matchedFamilyConfidence_fraction", |
| 757 | 761 |
"ValidMatchedTaxon"."matchedFamily", |
| 758 | 762 |
"ValidMatchedTaxon"."matchedGenus", |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19514 | 19514 |
s."matchedScientificNameAuthorship", |
| 19515 | 19515 |
s."matchedScientificNameID", |
| 19516 | 19516 |
s."*Author_score", |
| 19517 |
s.parsed_family, |
|
| 19517 | 19518 |
s."matchedFamilyConfidence_fraction", |
| 19518 | 19519 |
s."matchedFamily", |
| 19519 | 19520 |
s."matchedGenus", |
| ... | ... | |
| 19551 | 19552 |
taxon_best_match."Name_matched_author" AS "matchedScientificNameAuthorship", |
| 19552 | 19553 |
taxon_best_match."Name_matched_url" AS "matchedScientificNameID", |
| 19553 | 19554 |
taxon_best_match."Author_score" AS "*Author_score", |
| 19555 |
taxon_best_match."Family_matched" AS parsed_family, |
|
| 19554 | 19556 |
taxon_best_match."Family_score" AS "matchedFamilyConfidence_fraction", |
| 19555 | 19557 |
taxon_best_match."Name_matched_accepted_family" AS "matchedFamily", |
| 19556 | 19558 |
taxon_best_match."Genus_matched" AS "matchedGenus", |
| ... | ... | |
| 19602 | 19604 |
"MatchedTaxon"."matchedScientificNameAuthorship", |
| 19603 | 19605 |
"MatchedTaxon"."matchedScientificNameID", |
| 19604 | 19606 |
"MatchedTaxon"."*Author_score", |
| 19607 |
"MatchedTaxon".parsed_family, |
|
| 19605 | 19608 |
"MatchedTaxon"."matchedFamilyConfidence_fraction", |
| 19606 | 19609 |
"MatchedTaxon"."matchedFamily", |
| 19607 | 19610 |
"MatchedTaxon"."matchedGenus", |
| ... | ... | |
| 19865 | 19868 |
"ValidMatchedTaxon"."matchedScientificNameAuthorship", |
| 19866 | 19869 |
"ValidMatchedTaxon"."matchedScientificNameID", |
| 19867 | 19870 |
"ValidMatchedTaxon"."*Author_score", |
| 19871 |
"ValidMatchedTaxon".parsed_family, |
|
| 19868 | 19872 |
"ValidMatchedTaxon"."matchedFamilyConfidence_fraction", |
| 19869 | 19873 |
"ValidMatchedTaxon"."matchedFamily", |
| 19870 | 19874 |
"ValidMatchedTaxon"."matchedGenus", |
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: added back Family_matched, which had gotten merged with Name_matched_accepted_family when TNRS temporarily stopped populating Name_matched_accepted_family