Revision 9541
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 100 | 100 |
, "Name_matched_url" AS "matchedScientificNameID" |
| 101 | 101 |
, "Author_score" AS "*Name_matched.Author_score" |
| 102 | 102 |
, "Family_score" AS "matchedFamilyConfidence_fraction" |
| 103 |
, "Name_matched_accepted_family" AS "matchedFamily"
|
|
| 103 |
, COALESCE("Name_matched_accepted_family", "Accepted_family") AS "matchedFamily"
|
|
| 104 | 104 |
, "Genus_matched" AS "matchedGenus" |
| 105 | 105 |
, "Genus_score" AS "matchedGenusConfidence_fraction" |
| 106 | 106 |
, "Specific_epithet_matched" AS "matchedSpecificEpithet" |
Also available in: Unified diff
inputs/.TNRS/schema.sql: MatchedTaxon: matchedFamily: use Accepted_family when the Name_matched_accepted_family is not provided, as it's omitted by the current TNRS CSV schema